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 723: server_id cz_servers.server_local_id%TYPE;

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

Line 732: FROM cz_servers

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

Line 767: server_id cz_servers.server_local_id%TYPE;

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

Line 776: FROM cz_servers

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

Line 810: server_id cz_servers.server_local_id%TYPE;

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

Line 819: FROM cz_servers

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