APPS.PN_EXP_TO_CAD_ITF dependencies on PN_EMP_SPACE_ASSIGN_ITF

Line 846: -- ( PN_SPACE_ALLOCATIONS --> PN_EMP_SPACE_ASSIGN_ITF )

842:
843: -----------------------------------------------------------------------------
844: -- For loading Space Allocations Info into the Interface Table ( FOR CAFM )
845: -- ( Run AS a Conc Process )
846: -- ( PN_SPACE_ALLOCATIONS --> PN_EMP_SPACE_ASSIGN_ITF )
847: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced PN_LOCATIONS with _ALL table.
848: -- 04-OCT-05 Hareesha o ATG mandated changes for SQL literals using dbms_sql
849: -- 28-AUG-06 Shabda o Bug 5449595 - Added changes to accomodate
850: -- project_id and task_id

Line 1114: FROM PN_EMP_SPACE_ASSIGN_ITF

1110:
1111: BEGIN
1112: SELECT 1
1113: INTO exists_in_itf
1114: FROM PN_EMP_SPACE_ASSIGN_ITF
1115: WHERE emp_space_assign_id = V_EMP_SPACE_ASSIGN_ID;
1116: EXCEPTION
1117: WHEN NO_DATA_FOUND THEN
1118: NULL;

Line 1128: -- Insert the fetched data INTO PN_EMP_SPACE_ASSIGN_ITF table.

1124: -- Insert if data does not exist in ITF table, else Update
1125:
1126: IF (exists_in_itf = 0) THEN
1127:
1128: -- Insert the fetched data INTO PN_EMP_SPACE_ASSIGN_ITF table.
1129:
1130: pnp_debug_pkg.log(' bfore insert ');
1131:
1132: INSERT INTO PN_EMP_SPACE_ASSIGN_ITF (

Line 1132: INSERT INTO PN_EMP_SPACE_ASSIGN_ITF (

1128: -- Insert the fetched data INTO PN_EMP_SPACE_ASSIGN_ITF table.
1129:
1130: pnp_debug_pkg.log(' bfore insert ');
1131:
1132: INSERT INTO PN_EMP_SPACE_ASSIGN_ITF (
1133: BATCH_NAME,
1134: ENTRY_TYPE,
1135: EMP_SPACE_ASSIGN_ID,
1136: LOCATION_ID,

Line 1216: UPDATE PN_EMP_SPACE_ASSIGN_ITF SET

1212: -- Update data in ITF table
1213:
1214: IF (exists_in_itf = 1) THEN
1215:
1216: UPDATE PN_EMP_SPACE_ASSIGN_ITF SET
1217: BATCH_NAME = p_batch_name,
1218: ENTRY_TYPE = 'U',
1219: EMP_SPACE_ASSIGN_ID = v_emp_space_assign_id,
1220: LOCATION_ID = v_location_id,