..

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