APPS.PN_CAD_IMPORT dependencies on PN_LOCATIONS_ITF

Line 94: | Property_Id to PN_LOCATIONS_ITF. Modified the

90: | MODIFICATION HISTORY
91: | Created Naga Vijayapuram 1998
92: | Modified Naga Vijayapuram 1999 Included Validations
93: | 23-APR-02 Kiran Hegde o Fixed Bug#2324687. Added columns Location_Alias,
94: | Property_Id to PN_LOCATIONS_ITF. Modified the
95: | Inserts and Updates. Added function
96: | Exists_Property_Id for validating Property_id.
97: | Added validations for Locations_Alias.
98: | 08-MAY-02 Kiran Hegde o Fixed Bug#2341761. Added column

Line 99: | Standard_Type_Lookup_Code to PN_LOCATIONS_ITF.

95: | Inserts and Updates. Added function
96: | Exists_Property_Id for validating Property_id.
97: | Added validations for Locations_Alias.
98: | 08-MAY-02 Kiran Hegde o Fixed Bug#2341761. Added column
99: | Standard_Type_Lookup_Code to PN_LOCATIONS_ITF.
100: | Modified inserts and updates appropriately.
101: | Changed the validations of Usable, Rentable,
102: | Assignable to match the validations in the form
103: | 14-MAY-02 Kiran Hegde o Added validations to Locations_Itf to behave

Line 163: FROM PN_LOCATIONS_ITF pli,

159: l_occ_status varchar2(1) := ''; /* Bug 6861678 */
160:
161: CURSOR loccur IS
162: SELECT pli.*, pli.rowid,occupancy_status_code
163: FROM PN_LOCATIONS_ITF pli,
164: PN_LOCATIONS_ALL pnl
165: WHERE pli.parent_location_id = pnl.location_id(+)
166: AND pli.batch_name = p_batch_name
167: AND pli.transferred_to_pn IS NULL

Line 1349: -- Set PN_LOCATIONS_ITF.transferred_to_pn = 'Y'

1345:
1346: END IF; -- loc.ENTRY_TYPE
1347:
1348: ------------------------------------------------
1349: -- Set PN_LOCATIONS_ITF.transferred_to_pn = 'Y'
1350: ------------------------------------------------
1351: put_log('Update ITF set transfer = Y');
1352: UPDATE pn_locations_itf
1353: SET transferred_to_pn = 'Y',

Line 1352: UPDATE pn_locations_itf

1348: ------------------------------------------------
1349: -- Set PN_LOCATIONS_ITF.transferred_to_pn = 'Y'
1350: ------------------------------------------------
1351: put_log('Update ITF set transfer = Y');
1352: UPDATE pn_locations_itf
1353: SET transferred_to_pn = 'Y',
1354: error_message = NULL
1355: WHERE rowid = loc.rowid;
1356:

Line 1371: UPDATE pn_locations_itf

1367: WHEN INVALID_RECORD THEN
1368: ROLLBACK TO S1;
1369: l_fail := l_fail + 1;
1370: -- Update ERROR_MESSAGE
1371: UPDATE pn_locations_itf
1372: SET error_message = substr(l_error_message, 1, 240)
1373: WHERE rowid = loc.rowid;
1374: -- Spool to Conc Log
1375: put_line(l_error_message);

Line 1387: UPDATE pn_locations_itf

1383: WHEN OTHERS THEN
1384: ROLLBACK TO S1;
1385: l_fail := l_fail + 1;
1386: l_error_message := substr(sqlerrm,1,250);
1387: UPDATE pn_locations_itf
1388: SET error_message = substr(l_error_message, 1, 240)
1389: WHERE rowid = loc.rowid;
1390: errbuf := l_error_message;
1391: retcode := '2';

Line 1576: | table Pn_Locations_Itf exists in Pn_Properties

1572: |
1573: | MODIFICATION HISTORY
1574: | 23-APR-02 Kiran Hegde o Created -
1575: | Bug#2324687 - Validates if the Property_Id in the
1576: | table Pn_Locations_Itf exists in Pn_Properties
1577: | 01-APR-05 piagrawa o Modified the select statements to retrieve values
1578: | from _ALL tables
1579: +===========================================================================*/
1580: