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.CSD_MIGRATE_FROM_115X_PKG2 dependencies on CSD_REPAIR_TYPES_B

Line 228: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_TYPES_B table data: Error while inserting into CSD_REPAIR_TYPES_SAR. '|| v_error_text);

224: '11.5.9');
225:
226: commit;
227:
228: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_TYPES_B table data: Error while inserting into CSD_REPAIR_TYPES_SAR. '|| v_error_text);
229:
230: END;
231:
232: end if;

Line 239: /* procedure name: CSD_REPAIR_TYPES_B_MIG2 */

235:
236: END insert_rep_typ_sar;
237:
238: /*-------------------------------------------------------------------------------*/
239: /* procedure name: CSD_REPAIR_TYPES_B_MIG2 */
240: /* description : procedure for migrating Material , Labor and Expense SAR */
241: /* data in CSD_REPAIR_TYPES_B table in 11.5.8 */
242: /* to CSD_REPAIR_TYPES_SAR table in 11.5.9 */
243: /*-------------------------------------------------------------------------------*/

Line 241: /* data in CSD_REPAIR_TYPES_B table in 11.5.8 */

237:
238: /*-------------------------------------------------------------------------------*/
239: /* procedure name: CSD_REPAIR_TYPES_B_MIG2 */
240: /* description : procedure for migrating Material , Labor and Expense SAR */
241: /* data in CSD_REPAIR_TYPES_B table in 11.5.8 */
242: /* to CSD_REPAIR_TYPES_SAR table in 11.5.9 */
243: /*-------------------------------------------------------------------------------*/
244:
245: PROCEDURE CSD_REPAIR_TYPES_B_MIG2 IS

Line 245: PROCEDURE CSD_REPAIR_TYPES_B_MIG2 IS

241: /* data in CSD_REPAIR_TYPES_B table in 11.5.8 */
242: /* to CSD_REPAIR_TYPES_SAR table in 11.5.9 */
243: /*-------------------------------------------------------------------------------*/
244:
245: PROCEDURE CSD_REPAIR_TYPES_B_MIG2 IS
246:
247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;
248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;

Line 247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;

243: /*-------------------------------------------------------------------------------*/
244:
245: PROCEDURE CSD_REPAIR_TYPES_B_MIG2 IS
246:
247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;
248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;
250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;
251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;

Line 248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;

244:
245: PROCEDURE CSD_REPAIR_TYPES_B_MIG2 IS
246:
247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;
248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;
250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;
251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;
252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;

Line 249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;

245: PROCEDURE CSD_REPAIR_TYPES_B_MIG2 IS
246:
247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;
248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;
250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;
251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;
252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;
253:

Line 250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;

246:
247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;
248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;
250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;
251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;
252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;
253:
254: -- select repairs types which have material or

Line 251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;

247: l_repair_type_id CSD_REPAIR_TYPES_B.REPAIR_TYPE_ID%TYPE;
248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;
250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;
251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;
252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;
253:
254: -- select repairs types which have material or
255: -- Labor or Expense SAR set up in Repair Types table

Line 252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;

248: l_mtl_txn_billing_type_id CSD_REPAIR_TYPES_B.MTL_TXN_BILLING_TYPE_ID%TYPE;
249: l_lbr_txn_billing_type_id CSD_REPAIR_TYPES_B.LBR_TXN_BILLING_TYPE_ID%TYPE;
250: l_exp_txn_billing_type_id CSD_REPAIR_TYPES_B.EXP_TXN_BILLING_TYPE_ID%TYPE;
251: l_created_by CSD_REPAIR_TYPES_B.CREATED_BY%TYPE;
252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;
253:
254: -- select repairs types which have material or
255: -- Labor or Expense SAR set up in Repair Types table
256: CURSOR csd_repair_types_b_cursor is

Line 256: CURSOR csd_repair_types_b_cursor is

252: l_creation_date CSD_REPAIR_TYPES_B.CREATION_DATE%TYPE;
253:
254: -- select repairs types which have material or
255: -- Labor or Expense SAR set up in Repair Types table
256: CURSOR csd_repair_types_b_cursor is
257: select crtb.REPAIR_TYPE_ID,
258: crtb.MTL_TXN_BILLING_TYPE_ID,
259: crtb.LBR_TXN_BILLING_TYPE_ID,
260: crtb.EXP_TXN_BILLING_TYPE_ID,

Line 263: from csd_repair_types_b crtb

259: crtb.LBR_TXN_BILLING_TYPE_ID,
260: crtb.EXP_TXN_BILLING_TYPE_ID,
261: crtb.CREATED_BY,
262: crtb.CREATION_DATE
263: from csd_repair_types_b crtb
264: where ((crtb.MTL_TXN_BILLING_TYPE_ID IS NOT NULL) OR
265: (crtb.LBR_TXN_BILLING_TYPE_ID IS NOT NULL) OR
266: (crtb.EXP_TXN_BILLING_TYPE_ID IS NOT NULL))
267: and trunc(sysdate) between nvl(trunc(crtb.start_date_active),trunc(sysdate))

Line 275: OPEN csd_repair_types_b_cursor;

271:
272: BEGIN
273:
274: -- Open the cursor and update the table
275: OPEN csd_repair_types_b_cursor;
276:
277: LOOP
278:
279: FETCH csd_repair_types_b_cursor

Line 279: FETCH csd_repair_types_b_cursor

275: OPEN csd_repair_types_b_cursor;
276:
277: LOOP
278:
279: FETCH csd_repair_types_b_cursor
280: INTO l_repair_type_id
281: ,l_mtl_txn_billing_type_id
282: ,l_lbr_txn_billing_type_id
283: ,l_exp_txn_billing_type_id

Line 287: EXIT WHEN csd_repair_types_b_cursor%NOTFOUND;

283: ,l_exp_txn_billing_type_id
284: ,l_created_by
285: ,l_creation_date;
286:
287: EXIT WHEN csd_repair_types_b_cursor%NOTFOUND;
288:
289: -- check if the repair type and billing txn type id not yet inserted in to CSD_REPAIR_TYPES_SAR
290:
291:

Line 322: END CSD_REPAIR_TYPES_B_MIG2;

318: end if;
319:
320: END LOOP;
321:
322: END CSD_REPAIR_TYPES_B_MIG2;
323:
324: END CSD_Migrate_From_115X_PKG2;
325: