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 543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');

539:
540: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
541: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
542: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
544: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
545: x_error BOOLEAN:=FALSE;
546:
547: ComponentSequenceId tComponentSequenceId;

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

1421:
1422: IF(genStatisticsCz = 1)THEN
1423:
1424: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1425: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1426: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1427: END IF;
1428:
1429: --AT: The calculation of maximum_selected is moved here as we do reading into memory in batches and cannot

Line 1488: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B

1484:
1485: DECLARE
1486: CURSOR c_onl_ps_node IS
1487: SELECT B.ORIG_SYS_REF, B.COMPONENT_SEQUENCE_PATH, B.ps_node_id, B.ps_node_type
1488: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B
1489: WHERE B.DEVL_PROJECT_ID=P.model_ps_node_id
1490: AND P.organization_id = nORg_ID
1491: AND P.top_item_id = nTop_ID
1492: AND P.explosion_type = sExpl_type

Line 1502: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;

1498: FOR UPDATE OF B.DELETED_FLAG;
1499:
1500: x_onl_ps_node_f BOOLEAN:=FALSE;
1501: x_imp_ps_node_f BOOLEAN:=FALSE;
1502: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1503: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1504: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1505: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1506: cDefaultChar CHAR(1);

Line 1503: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;

1499:
1500: x_onl_ps_node_f BOOLEAN:=FALSE;
1501: x_imp_ps_node_f BOOLEAN:=FALSE;
1502: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1503: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1504: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1505: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1506: cDefaultChar CHAR(1);
1507: p_out_err INTEGER;

Line 1504: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;

1500: x_onl_ps_node_f BOOLEAN:=FALSE;
1501: x_imp_ps_node_f BOOLEAN:=FALSE;
1502: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1503: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1504: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1505: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1506: cDefaultChar CHAR(1);
1507: p_out_err INTEGER;
1508:

Line 1505: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

1501: x_imp_ps_node_f BOOLEAN:=FALSE;
1502: sOnlOrigSysRef CZ_PS_NODES.ORIG_SYS_REF%TYPE;
1503: v_PsNodeId CZ_PS_NODES.PS_NODE_ID%TYPE;
1504: v_PsNodeType CZ_PS_NODES.PS_NODE_TYPE%TYPE;
1505: v_SequencePath CZ_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1506: cDefaultChar CHAR(1);
1507: p_out_err INTEGER;
1508:
1509: BEGIN

Line 1538: UPDATE CZ_PS_NODES SET

1534: CLOSE c_imp_ps_node;
1535: END;
1536:
1537: IF(NOT x_imp_ps_node_f) THEN
1538: UPDATE CZ_PS_NODES SET
1539: DELETED_FLAG='1'
1540: WHERE CURRENT OF c_onl_ps_node;
1541:
1542: --Here to call cz_refs api

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

2882: end_time := dbms_utility.get_time();
2883: d_str := inRun_Id || ' Extract item master (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2884: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2885: end if;
2886: ELSIF(lower_table_name='cz_ps_nodes') THEN
2887: if (CZ_IMP_ALL.get_time) then
2888: st_time := dbms_utility.get_time();
2889: end if;
2890: EXTR_PS_NODE(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);

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

2995: end_time := dbms_utility.get_time();
2996: d_str := inRun_Id || ' Populate items :' || (end_time-st_time)/100.00;
2997: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
2998: end if;
2999: ELSIF(lower_table_name='cz_ps_nodes') THEN
3000: if (CZ_IMP_ALL.get_time) then
3001: st_time := dbms_utility.get_time();
3002: end if;
3003: CZ_IMP_PS_NODE.MAIN_PS_NODE(inRun_ID, commit_size, max_err,

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

3342: d_str := inRunId || ' Bom Exploder (' || inTopId || ') :' || (bom_explode_end-bom_explode_st)/100.00;
3343: xERROR:=cz_utils.log_report(d_str,1,'BOM_EXPLODER',11299,inRunId);
3344: end if;
3345:
3346: extract_table(inRunId, 'CZ_PS_NODES', inOrgId, inTopId, inExplType, nModelId);
3347:
3348: l_lang := userenv('LANG');
3349:
3350: OPEN c_expl (l_lang);

Line 3471: 'CZ_PS_NODES')

3467: SELECT DST_TABLE FROM CZ_XFR_TABLES
3468: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3469: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3470: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',
3471: 'CZ_PS_NODES')
3472: ORDER BY ORDER_SEQ;
3473: CURSOR C_BILL_OF_MATERIAL IS
3474: SELECT 'F' FROM CZ_EXV_BILL_OF_MATERIALS
3475: WHERE ORGANIZATION_ID=nOrg_ID AND ASSEMBLY_ITEM_ID=nTop_ID;

Line 3932: UPDATE CZ_PS_NODES set UI_TIMESTAMP_CHANGETYPE = SYSDATE

3928: LOOP
3929: IF l_detailed_types_tbl.EXISTS( i.ps_node_id ) THEN
3930: IF l_detailed_types_tbl(i.ps_node_id) <> i.detailed_type_id THEN
3931:
3932: UPDATE CZ_PS_NODES set UI_TIMESTAMP_CHANGETYPE = SYSDATE
3933: WHERE devl_project_id = model.devl_project_id
3934: AND ps_node_id = i.ps_node_id;
3935:
3936: l_update_model_timestamp := TRUE;