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_SINGLE dependencies on CZ_PS_NODES

Line 567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');

563:
564: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
569: x_error BOOLEAN:=FALSE;
570:
571: ComponentSequenceId tComponentSequenceId;

Line 1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');

1475: czGatherStatsCnt := 0;
1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);
1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then

Line 1550: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B

1546:
1547: DECLARE
1548: CURSOR c_onl_ps_node IS
1549: SELECT B.ORIG_SYS_REF, B.COMPONENT_SEQUENCE_PATH, B.ps_node_id, B.ps_node_type
1550: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B
1551: WHERE B.DEVL_PROJECT_ID=P.model_ps_node_id
1552: AND P.organization_id = nORg_ID
1553: AND P.top_item_id = nTop_ID
1554: AND P.explosion_type = sExpl_type

Line 1564: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;

1560: FOR UPDATE OF B.DELETED_FLAG;
1561:
1562: x_onl_ps_node_f BOOLEAN:=FALSE;
1563: x_imp_ps_node_f BOOLEAN:=FALSE;
1564: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1565: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1566: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1567: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1568: cDefaultChar CHAR(1);

Line 1565: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;

1561:
1562: x_onl_ps_node_f BOOLEAN:=FALSE;
1563: x_imp_ps_node_f BOOLEAN:=FALSE;
1564: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1565: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1566: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1567: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1568: cDefaultChar CHAR(1);
1569: p_out_err INTEGER;

Line 1566: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;

1562: x_onl_ps_node_f BOOLEAN:=FALSE;
1563: x_imp_ps_node_f BOOLEAN:=FALSE;
1564: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1565: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1566: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1567: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1568: cDefaultChar CHAR(1);
1569: p_out_err INTEGER;
1570:

Line 1567: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

1563: x_imp_ps_node_f BOOLEAN:=FALSE;
1564: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1565: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1566: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1567: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1568: cDefaultChar CHAR(1);
1569: p_out_err INTEGER;
1570:
1571: BEGIN

Line 1600: UPDATE CZ_PS_NODES SET

1596: CLOSE c_imp_ps_node;
1597: END;
1598:
1599: IF(NOT x_imp_ps_node_f) THEN
1600: UPDATE CZ_PS_NODES SET
1601: DELETED_FLAG='1'
1602: WHERE CURRENT OF c_onl_ps_node;
1603:
1604: --Here to call cz_refs api

Line 2956: ELSIF(lower_table_name='cz_ps_nodes') THEN

2952: end_time := dbms_utility.get_time();
2953: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2954: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2955: end if;
2956: ELSIF(lower_table_name='cz_ps_nodes') THEN
2957: if (CZ_IMP_ALL.get_time) then
2958: st_time := dbms_utility.get_time();
2959: end if;
2960: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);

Line 3070: ELSIF(lower_table_name='cz_ps_nodes') THEN

3066: end_time := dbms_utility.get_time();
3067: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
3068: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3069: end if;
3070: ELSIF(lower_table_name='cz_ps_nodes') THEN
3071: if (CZ_IMP_ALL.get_time) then
3072: st_time := dbms_utility.get_time();
3073: end if;
3074: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,

Line 3574: extract_table(inRunId, 'CZ_PS_NODES', inOrgId, inTopId, inExplType, nModelId);

3570: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3571: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3572: end if;
3573:
3574: extract_table(inRunId, 'CZ_PS_NODES', inOrgId, inTopId, inExplType, nModelId);
3575:
3576: --LA 9595142
3577: --After adding the data to import table check for the references that'll be imported
3578: --against import enabled models

Line 3592: SELECT reference_id INTO l_curr_ref_id FROM cz_ps_nodes

3588:
3589: nImpEnabledModelId := -1;
3590:
3591: BEGIN
3592: SELECT reference_id INTO l_curr_ref_id FROM cz_ps_nodes
3593: WHERE devl_project_id = nModelId
3594: AND deleted_flag = '0' and substr(orig_sys_ref,1,instr(orig_sys_ref,':') - 1) = lCompCode
3595: AND component_sequence_id = lCompSeqId
3596: AND component_sequence_path = lCompSeqPath ; -- 14544881 Added CompSeqId and CompSeqPath

Line 3778: 'CZ_PS_NODES')

3774: SELECT DST_TABLE FROM CZ_XFR_TABLES
3775: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3776: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3777: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',
3778: 'CZ_PS_NODES')
3779: ORDER BY ORDER_SEQ;
3780: CURSOR C_BILL_OF_MATERIAL IS
3781: SELECT 'F' FROM CZ_EXV_BILL_OF_MATERIALS
3782: WHERE ORGANIZATION_ID=nOrg_ID AND ASSEMBLY_ITEM_ID=nTop_ID;

Line 3801: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

3797: v_section_name VARCHAR2(30);
3798: v_enabled VARCHAR2(1) := '1';
3799:
3800: -- LA 13733007 : OC with No children
3801: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3802: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;
3803: lNoChildOCName tNoChildOCName ;
3804: lNoChildOCModelName tNoChildOCModelName;
3805:

Line 4264: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL

4260:
4261: BEGIN
4262: SELECT MODEL.NAME, PARENT.NAME
4263: BULK COLLECT INTO lNoChildOCModelName, lNoChildOCName
4264: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL
4265: WHERE PARENT.deleted_flag = '0'
4266: AND MODEL.deleted_flag = '0'
4267: AND PARENT.devl_project_id = MODEL.object_id
4268: AND MODEL.object_type = 'PRJ'

Line 4277: (SELECT 1 FROM cz_ps_nodes CHILD

4273: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
4274: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
4275: AND PARENT.effective_until > SYSDATE
4276: AND NOT EXISTS
4277: (SELECT 1 FROM cz_ps_nodes CHILD
4278: WHERE CHILD.deleted_flag = '0'
4279: AND CHILD.devl_project_id = PARENT.devl_project_id
4280: AND CHILD.parent_id = PARENT.ps_node_id
4281: AND CHILD.effective_until > SYSDATE);

Line 4324: UPDATE CZ_PS_NODES set UI_TIMESTAMP_CHANGETYPE = SYSDATE

4320: LOOP
4321: IF l_detailed_types_tbl.EXISTS( i.ps_node_id ) THEN
4322: IF l_detailed_types_tbl(i.ps_node_id) <> i.detailed_type_id THEN
4323:
4324: UPDATE CZ_PS_NODES set UI_TIMESTAMP_CHANGETYPE = SYSDATE
4325: WHERE devl_project_id = model.devl_project_id
4326: AND ps_node_id = i.ps_node_id;
4327:
4328: l_update_model_timestamp := TRUE;