APPS.CZ_IMP_ALL dependencies on CZ_SERVERS

Line 127: nServerId cz_servers.server_local_id%TYPE;

123: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
124: sExplType CZ_XFR_PROJECT_BILLS.EXPLOSION_TYPE%TYPE;
125: sCopyModels CZ_XFR_PROJECT_BILLS.copy_addl_child_models%TYPE;
126: nModelId CZ_XFR_PROJECT_BILLS.model_ps_node_id%TYPE;
127: nServerId cz_servers.server_local_id%TYPE;
128:
129: TYPE tOrgId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;
130: TYPE tTopItemId IS TABLE OF cz_xfr_project_bills.top_item_id%TYPE INDEX BY BINARY_INTEGER;
131: TYPE tExplType IS TABLE OF cz_xfr_project_bills.explosion_type%TYPE INDEX BY BINARY_INTEGER;

Line 147: FROM cz_servers

143: BEGIN
144:
145: BEGIN
146: SELECT server_local_id INTO nServerId
147: FROM cz_servers
148: WHERE import_enabled = v_enabled;
149: EXCEPTION
150: WHEN TOO_MANY_ROWS THEN
151: retcode:=2;

Line 726: server_id cz_servers.server_local_id%TYPE;

722: ------------------------------------------------------------------------------------------
723: PROCEDURE AddBillToImport(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,
724: COPY_CHILD_MODELS IN VARCHAR2) IS
725: xERROR BOOLEAN:=FALSE;
726: server_id cz_servers.server_local_id%TYPE;
727: v_enabled VARCHAR2(1) := '1';
728:
729: BEGIN
730: retcode:=0;

Line 735: FROM cz_servers

731: errbuf:='';
732:
733: BEGIN
734: SELECT server_local_id INTO server_id
735: FROM cz_servers
736: WHERE import_enabled = v_enabled;
737: EXCEPTION
738: WHEN TOO_MANY_ROWS THEN
739: retcode:=2;

Line 770: server_id cz_servers.server_local_id%TYPE;

766: END;
767: ------------------------------------------------------------------------------------------
768: PROCEDURE SetSingleBillState(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,sState IN VARCHAR2) IS
769: xERROR BOOLEAN:=FALSE;
770: server_id cz_servers.server_local_id%TYPE;
771: v_enabled VARCHAR2(1) := '1';
772:
773: BEGIN
774: retcode:=0;

Line 779: FROM cz_servers

775: errbuf:='';
776:
777: BEGIN
778: SELECT server_local_id INTO server_id
779: FROM cz_servers
780: WHERE import_enabled = v_enabled;
781: EXCEPTION
782: WHEN TOO_MANY_ROWS THEN
783: retcode:=2;

Line 813: server_id cz_servers.server_local_id%TYPE;

809:
810: xERROR BOOLEAN:=FALSE;
811: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
812: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
813: server_id cz_servers.server_local_id%TYPE;
814: v_enabled VARCHAR2(1) := '1';
815:
816: BEGIN
817: retcode:=0;

Line 822: FROM cz_servers

818: errbuf:='';
819:
820: BEGIN
821: SELECT server_local_id INTO server_id
822: FROM cz_servers
823: WHERE import_enabled = v_enabled;
824: EXCEPTION
825: WHEN TOO_MANY_ROWS THEN
826: retcode:=2;