| Summary: | New Company Opening Process(Call from IT dept only) | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS FORMS AND REPORTS | Reporter: | anushree.pandey |
| Component: | IMIS FORMS AND REPORTS | Assignee: | anushree.pandey |
| Status: | RESOLVED USER TO VERIFY | ||
| Severity: | normal | CC: | mahender.singh, sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Database: | Module ID: | ||
|
Comment 13
anushree.pandey
2023-03-10 10:42:44 IST
Made new procedure for IPOS : COMPANY_OPEN_IPOS Changes made in the procedure- Company_open and PKG_CONTROLS.TPC_COMPANY_DETAIL Procedure made- COMPANY_OPEN_NEW BEGIN SELECT COUNT(*) INTO VCOUNT FROM IG$GLOBAL_DATA_COMPANY_DETAIL WHERE COMPANY = P_TARGET_COMPANY; IF NVL(VCOUNT,0)=0 THEN INSERT INTO IG$GLOBAL_DATA_COMPANY_DETAIL (TABLE_NAME, COMPANY) SELECT TABLE_NAME, P_TARGET_COMPANY FROM IG$GLOBAL_DATA_COMPANY_DETAIL WHERE COMPANY =P_SOURCE_COMPANY; END IF; END; Procedure made- PKG_CONTROLS.COMPANY_OPEN_PAYROLL Make the form of opening a new company in which no process is left.. All changes should be done.. |