APPS.CZ_IMP_PS_NODE dependencies on CZ_XFR_PROJECT_BILLS

Line 761: COPY_CHILD_MODELS CZ_XFR_PROJECT_BILLS.COPY_ADDL_CHILD_MODELS%TYPE;

757: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
758: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
759: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
760: nExplId NUMBER;
761: COPY_CHILD_MODELS CZ_XFR_PROJECT_BILLS.COPY_ADDL_CHILD_MODELS%TYPE;
762: nModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
763: sModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
764:
765: /* Internal vars */

Line 830: FROM cz_xfr_project_bills

826:
827: BEGIN
828:
829: SELECT NVL(copy_addl_child_models,'0') INTO COPY_CHILD_MODELS
830: FROM cz_xfr_project_bills
831: WHERE model_ps_node_id = REFRESH_MODEL_ID;
832:
833: EXCEPTION
834: WHEN OTHERS THEN

Line 1335: copy_child_models cz_xfr_project_bills.copy_addl_child_models%TYPE;

1331: x_xfr_devl_project_f BOOLEAN:=FALSE;
1332: x_error BOOLEAN:=FALSE;
1333: p_xfr_devl_project c_xfr_devl_project%ROWTYPE;
1334:
1335: copy_child_models cz_xfr_project_bills.copy_addl_child_models%TYPE;
1336: server_id cz_xfr_project_bills.source_server%TYPE;
1337:
1338: dbModelType cz_devl_projects.model_type%TYPE;
1339:

Line 1336: server_id cz_xfr_project_bills.source_server%TYPE;

1332: x_error BOOLEAN:=FALSE;
1333: p_xfr_devl_project c_xfr_devl_project%ROWTYPE;
1334:
1335: copy_child_models cz_xfr_project_bills.copy_addl_child_models%TYPE;
1336: server_id cz_xfr_project_bills.source_server%TYPE;
1337:
1338: dbModelType cz_devl_projects.model_type%TYPE;
1339:
1340: -- Internal vars --

Line 1479: UPDATE CZ_XFR_PROJECT_BILLS SET

1475: (ENCLOSING_FOLDER=p_rp_folder_id AND NAME=p_xfr_devl_project.name)));
1476:
1477:
1478: IF(p_xfr_devl_project.plan_level = 0)THEN
1479: UPDATE CZ_XFR_PROJECT_BILLS SET
1480: MODEL_PS_NODE_ID=p_xfr_devl_project.devl_project_id,
1481: DESCRIPTION=p_xfr_devl_project.desc_text,
1482: COMPONENT_ITEM_ID=p_xfr_devl_project.top_item_id,
1483: LAST_IMPORT_RUN_ID=inRUN_ID,

Line 1492: INSERT INTO cz_xfr_project_bills

1488: MODEL_PS_NODE_ID = p_xfr_devl_project.model_id
1489: RETURNING copy_addl_child_models,source_server INTO copy_child_models, server_id;
1490:
1491: ELSE
1492: INSERT INTO cz_xfr_project_bills
1493: (model_ps_node_id, description, component_item_id, last_import_run_id,
1494: last_import_date, organization_id, top_item_id, explosion_type,
1495: copy_addl_child_models, source_server, deleted_flag)
1496: SELECT p_xfr_devl_project.devl_project_id, p_xfr_devl_project.desc_text,

Line 1501: (SELECT NULL FROM cz_xfr_project_bills

1497: p_xfr_devl_project.top_item_id, inRUN_ID, SYSDATE,
1498: NVL(p_xfr_devl_project.ORGANIZATION_ID, 0), NVL(p_xfr_devl_project.TOP_ITEM_ID, 0),
1499: NVL(p_xfr_devl_project.EXPLOSION_TYPE, 'GENERIC'), '0', NVL(server_id, 0), '0'
1500: FROM DUAL WHERE NOT EXISTS
1501: (SELECT NULL FROM cz_xfr_project_bills
1502: WHERE model_ps_node_id = p_xfr_devl_project.devl_project_id
1503: AND deleted_flag = '0');
1504: END IF;
1505:

Line 1558: UPDATE CZ_XFR_PROJECT_BILLS SET

1554: AND NAME=p_xfr_devl_project.name
1555: AND deleted_flag = '0');
1556: -- dbms_output.put_line ('Updating .. M : ' || p_xfr_devl_project.devl_project_id);
1557:
1558: UPDATE CZ_XFR_PROJECT_BILLS SET
1559: DESCRIPTION=DECODE(NOUPDATE_DESC_TEXT,0,p_xfr_devl_project.desc_text,description),
1560: COMPONENT_ITEM_ID=p_xfr_devl_project.top_item_id,
1561: LAST_IMPORT_RUN_ID=inRUN_ID,
1562: LAST_IMPORT_DATE=SYSDATE,