eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_ALL dependencies on CZ_XFR_PROJECT_BILLS

Line 122: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

118: ------------------------------------------------------------------------------------------
119: PROCEDURE go(errbuf IN OUT NOCOPY VARCHAR2,retcode IN OUT NOCOPY NUMBER) IS
120:
121: xERROR BOOLEAN:=FALSE;
122: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_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;

Line 123: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

119: PROCEDURE go(errbuf IN OUT NOCOPY VARCHAR2,retcode IN OUT NOCOPY NUMBER) IS
120:
121: xERROR BOOLEAN:=FALSE;
122: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_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;

Line 124: sExplType CZ_XFR_PROJECT_BILLS.EXPLOSION_TYPE%TYPE;

120:
121: xERROR BOOLEAN:=FALSE;
122: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_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:

Line 125: sCopyModels CZ_XFR_PROJECT_BILLS.copy_addl_child_models%TYPE;

121: xERROR BOOLEAN:=FALSE;
122: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_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;

Line 126: nModelId CZ_XFR_PROJECT_BILLS.model_ps_node_id%TYPE;

122: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_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;

Line 129: TYPE tOrgId IS TABLE OF cz_xfr_project_bills.organization_id%TYPE INDEX BY BINARY_INTEGER;

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;
132: TYPE tCopyChildModel IS TABLE OF cz_xfr_project_bills.copy_addl_child_models%TYPE INDEX BY BINARY_INTEGER;
133: TYPE tModelId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;

Line 130: TYPE tTopItemId IS TABLE OF cz_xfr_project_bills.top_item_id%TYPE INDEX BY BINARY_INTEGER;

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;
132: TYPE tCopyChildModel IS TABLE OF cz_xfr_project_bills.copy_addl_child_models%TYPE INDEX BY BINARY_INTEGER;
133: TYPE tModelId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
134:

Line 131: TYPE tExplType IS TABLE OF cz_xfr_project_bills.explosion_type%TYPE INDEX BY BINARY_INTEGER;

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;
132: TYPE tCopyChildModel IS TABLE OF cz_xfr_project_bills.copy_addl_child_models%TYPE INDEX BY BINARY_INTEGER;
133: TYPE tModelId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
134:
135: orgId tOrgId;

Line 132: TYPE tCopyChildModel IS TABLE OF cz_xfr_project_bills.copy_addl_child_models%TYPE INDEX BY BINARY_INTEGER;

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;
132: TYPE tCopyChildModel IS TABLE OF cz_xfr_project_bills.copy_addl_child_models%TYPE INDEX BY BINARY_INTEGER;
133: TYPE tModelId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
134:
135: orgId tOrgId;
136: topItemId tTopItemId ;

Line 133: TYPE tModelId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;

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;
132: TYPE tCopyChildModel IS TABLE OF cz_xfr_project_bills.copy_addl_child_models%TYPE INDEX BY BINARY_INTEGER;
133: TYPE tModelId IS TABLE OF cz_xfr_project_bills.model_ps_node_id%TYPE INDEX BY BINARY_INTEGER;
134:
135: orgId tOrgId;
136: topItemId tTopItemId ;
137: explType tExplType;

Line 165: FROM cz_xfr_project_bills

161:
162: SELECT organization_id, top_item_id, explosion_type, NVL(copy_addl_child_models, '0'), model_ps_node_id
163: BULK COLLECT INTO
164: orgId,topItemId,explType,copyChildModel,modelId
165: FROM cz_xfr_project_bills
166: WHERE deleted_flag = '0'
167: AND source_server = nServerId;
168:
169: IF(orgId.COUNT = 0)THEN

Line 747: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,

743: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
744: RAISE;
745: END;
746:
747: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,
748: copy_addl_child_models,source_server)
749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
750: from dual where not exists
751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and

Line 749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id

745: END;
746:
747: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,
748: copy_addl_child_models,source_server)
749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
750: from dual where not exists
751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
752: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS

Line 751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and

747: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,
748: copy_addl_child_models,source_server)
749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
750: from dual where not exists
751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
752: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS
754: where organization_id=nOrg_ID and
755: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id;

Line 753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS

749: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
750: from dual where not exists
751: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
752: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
753: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS
754: where organization_id=nOrg_ID and
755: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id;
756: COMMIT;
757: EXCEPTION

Line 791: update cz_xfr_project_bills set

787: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
788: RAISE;
789: END;
790:
791: update cz_xfr_project_bills set
792: deleted_flag=DECODE(UPPER(sState),'0','1','OFF','1','NO','1','DISABLE','1',
793: '1','0','ON','0','YES','0','ENABLE','0',DELETED_FLAG)
794: where organization_id=nOrg_ID and top_item_id=nTop_ID and explosion_type='OPTIONAL' AND
795: source_server = server_id;

Line 808: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

804: PROCEDURE RemoveModel(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,sOrg_ID IN VARCHAR2,
805: dsOrg_ID IN VARCHAR2,sTop_ID IN VARCHAR2) IS
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:

Line 809: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

805: dsOrg_ID IN VARCHAR2,sTop_ID IN VARCHAR2) IS
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

Line 844: update cz_xfr_project_bills set

840: AND organization_id = nOrg_ID
841: AND concatenated_segments = sTop_ID
842: AND rownum = 1;
843:
844: update cz_xfr_project_bills set
845: deleted_flag='1'
846: where organization_id=nOrg_ID and top_item_id=nTop_ID
847: and source_server = server_id;
848:

Line 870: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

866: AND A.ORGANIZATION_ID=Org_ID
867: AND B.CONCATENATED_SEGMENTS BETWEEN sFrom AND NVL(sTo,sFrom);
868:
869: xERROR BOOLEAN:=FALSE;
870: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
871: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
872: v_copy_child_models CHAR(1);
873: l_run_id NUMBER; -- sselahi: added to pass to call goSingleBill
874: BEGIN

Line 871: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

867: AND B.CONCATENATED_SEGMENTS BETWEEN sFrom AND NVL(sTo,sFrom);
868:
869: xERROR BOOLEAN:=FALSE;
870: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
871: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
872: v_copy_child_models CHAR(1);
873: l_run_id NUMBER; -- sselahi: added to pass to call goSingleBill
874: BEGIN
875:

Line 966: commonInvId CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

962: retcode OUT NOCOPY NUMBER,
963: nORG_ID IN NUMBER,
964: nTOP_ID IN NUMBER)
965: IS
966: commonInvId CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
967: commonOrgId CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
968: xERROR BOOLEAN:=FALSE;
969: BEGIN
970: errbuf:='';

Line 967: commonOrgId CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

963: nORG_ID IN NUMBER,
964: nTOP_ID IN NUMBER)
965: IS
966: commonInvId CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
967: commonOrgId CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
968: xERROR BOOLEAN:=FALSE;
969: BEGIN
970: errbuf:='';
971: retcode:=0;