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.

[Home] [Help]

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 750: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,

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

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

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

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

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

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

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

Line 794: update cz_xfr_project_bills set

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

Line 811: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

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

Line 812: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

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

Line 847: update cz_xfr_project_bills set

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

Line 873: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

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

Line 874: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

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

Line 944: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

940: AND B.ORGANIZATION_ID=Org_ID
941: AND B.CONCATENATED_SEGMENTS = sFrom ;
942:
943: xERROR BOOLEAN:=FALSE;
944: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
945: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
946: v_copy_child_models CHAR(1);
947: l_run_id NUMBER; -- sselahi: added to pass to call goSingleBill
948: BEGIN

Line 945: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

941: AND B.CONCATENATED_SEGMENTS = sFrom ;
942:
943: xERROR BOOLEAN:=FALSE;
944: nTop_ID CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
945: nOrg_ID CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
946: v_copy_child_models CHAR(1);
947: l_run_id NUMBER; -- sselahi: added to pass to call goSingleBill
948: BEGIN
949:

Line 1041: commonInvId CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

1037: retcode OUT NOCOPY NUMBER,
1038: nORG_ID IN NUMBER,
1039: nTOP_ID IN NUMBER)
1040: IS
1041: commonInvId CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
1042: commonOrgId CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
1043: xERROR BOOLEAN:=FALSE;
1044: BEGIN
1045: errbuf:='';

Line 1042: commonOrgId CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

1038: nORG_ID IN NUMBER,
1039: nTOP_ID IN NUMBER)
1040: IS
1041: commonInvId CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
1042: commonOrgId CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
1043: xERROR BOOLEAN:=FALSE;
1044: BEGIN
1045: errbuf:='';
1046: retcode:=0;