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_PKG dependencies on CSD_PRODUCT_TRANSACTIONS

Line 135: l_ACTION_TYPE CSD_PRODUCT_TRANSACTIONS.ACTION_TYPE%TYPE;

131: l_rma varchar2(30) := 'RMA';
132: l_ship varchar2(30) := 'SHIP';
133: l_cust_prod varchar2(30) := 'CUST_PROD';
134:
135: l_ACTION_TYPE CSD_PRODUCT_TRANSACTIONS.ACTION_TYPE%TYPE;
136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;
137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;

Line 136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;

132: l_ship varchar2(30) := 'SHIP';
133: l_cust_prod varchar2(30) := 'CUST_PROD';
134:
135: l_ACTION_TYPE CSD_PRODUCT_TRANSACTIONS.ACTION_TYPE%TYPE;
136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;
137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;

Line 137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;

133: l_cust_prod varchar2(30) := 'CUST_PROD';
134:
135: l_ACTION_TYPE CSD_PRODUCT_TRANSACTIONS.ACTION_TYPE%TYPE;
136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;
137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;
141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;

Line 138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;

134:
135: l_ACTION_TYPE CSD_PRODUCT_TRANSACTIONS.ACTION_TYPE%TYPE;
136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;
137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;
141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;
142: l_PROD_TXN_CODE CSD_PRODUCT_TRANSACTIONS.PROD_TXN_CODE%TYPE;

Line 139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;

135: l_ACTION_TYPE CSD_PRODUCT_TRANSACTIONS.ACTION_TYPE%TYPE;
136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;
137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;
141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;
142: l_PROD_TXN_CODE CSD_PRODUCT_TRANSACTIONS.PROD_TXN_CODE%TYPE;
143:

Line 140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;

136: l_ACTION_CODE CSD_PRODUCT_TRANSACTIONS.ACTION_CODE%TYPE;
137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;
141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;
142: l_PROD_TXN_CODE CSD_PRODUCT_TRANSACTIONS.PROD_TXN_CODE%TYPE;
143:
144: l_repair_line_id Number;

Line 141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;

137: l_INTERFACE_TO_OM_FLAG CSD_PRODUCT_TRANSACTIONS.INTERFACE_TO_OM_FLAG%TYPE;
138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;
141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;
142: l_PROD_TXN_CODE CSD_PRODUCT_TRANSACTIONS.PROD_TXN_CODE%TYPE;
143:
144: l_repair_line_id Number;
145: l_released_status varchar2(1);

Line 142: l_PROD_TXN_CODE CSD_PRODUCT_TRANSACTIONS.PROD_TXN_CODE%TYPE;

138: l_BOOK_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.BOOK_SALES_ORDER_FLAG%TYPE;
139: l_RELEASE_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.RELEASE_SALES_ORDER_FLAG%TYPE;
140: l_SHIP_SALES_ORDER_FLAG CSD_PRODUCT_TRANSACTIONS.SHIP_SALES_ORDER_FLAG%TYPE;
141: l_PROD_TXN_STATUS CSD_PRODUCT_TRANSACTIONS.PROD_TXN_STATUS%TYPE;
142: l_PROD_TXN_CODE CSD_PRODUCT_TRANSACTIONS.PROD_TXN_CODE%TYPE;
143:
144: l_repair_line_id Number;
145: l_released_status varchar2(1);
146: l_repair_type_ref varchar2(30);

Line 172: and not exists ( select '*' from csd_product_transactions cpt

168: csd_repairs cra
169: where ced.source_id = cra.repair_line_id
170: and ced.inventory_item_id = cra.inventory_item_id
171: and ced.source_code = 'DR'
172: and not exists ( select '*' from csd_product_transactions cpt
173: where cpt.estimate_detail_id = ced.estimate_detail_id)
174: and not exists ( select '*' from csd_repair_estimate_lines crel
175: where crel.estimate_detail_id = ced.estimate_detail_id)
176: and ced.estimate_detail_id >= p_start

Line 223: -- Migrate csd_product_transactions

219: repair_type_id_mig,
220: rowid_mig
221: LIMIT MAX_BUFFER_SIZE;
222:
223: -- Migrate csd_product_transactions
224: FOR j in 1..estimate_detail_id_mig.count
225: LOOP
226: Begin
227:

Line 329: INSERT INTO CSD_PRODUCT_TRANSACTIONS(

325:
326: End If;
327:
328: Begin
329: INSERT INTO CSD_PRODUCT_TRANSACTIONS(
330: PRODUCT_TRANSACTION_ID,
331: REPAIR_LINE_ID,
332: ESTIMATE_DETAIL_ID,
333: ACTION_TYPE,

Line 366: CSD_PRODUCT_TRANSACTIONS_S1.nextval

362: ATTRIBUTE15,
363: CONTEXT,
364: OBJECT_VERSION_NUMBER
365: ) VALUES (
366: CSD_PRODUCT_TRANSACTIONS_S1.nextval
367: ,l_repair_line_id
368: ,l_estimate_detail_id
369: ,l_action_type
370: ,l_action_code

Line 420: ,'CSD_PRODUCT_TRANSACTIONS'

416: ERROR_MESSAGE,
417: MIGRATION_PHASE)
418: VALUES(
419: 'CS_ESTIMATE_DETAILS'
420: ,'CSD_PRODUCT_TRANSACTIONS'
421: ,estimate_detail_id_mig(j)
422: ,sysdate
423: ,v_error_text
424: ,'11.5.8' );

Line 428: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS table data. '|| v_error_text);

424: ,'11.5.8' );
425:
426: commit;
427:
428: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS table data. '|| v_error_text);
429:
430:
431: When others then
432: ROLLBACK to product_txn;

Line 443: ,'CSD_PRODUCT_TRANSACTIONS'

439: ERROR_MESSAGE,
440: MIGRATION_PHASE)
441: VALUES(
442: 'CS_ESTIMATE_DETAILS'
443: ,'CSD_PRODUCT_TRANSACTIONS'
444: ,estimate_detail_id_mig(j)
445: ,sysdate
446: ,v_error_text
447: ,'11.5.8' );

Line 451: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS table data. '|| v_error_text);

447: ,'11.5.8' );
448:
449: commit;
450:
451: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS table data. '|| v_error_text);
452:
453: End;
454: End Loop; --end of for loop
455:

Line 523: and not exists ( select '*' from csd_product_transactions cpt

519: and ced.estimate_detail_id >= p_min_id -- slab limits
520: and ced.estimate_detail_id <= p_max_id -- slab limits
521: and not exists ( select '*' from csd_repair_estimate cre
522: where cre.repair_line_id = ced.source_id)
523: and not exists ( select '*' from csd_product_transactions cpt
524: where cpt.estimate_detail_id = ced.estimate_detail_id);
525: -- Shiv Ragunathan, 11/19/03, Added the above 'not exists' clause to
526: -- prevent data in cs_estimate_details from being migrated,
527: -- if this was created from Depot Repair in 11.5.8. IN 11.5.7, this

Line 720: and not exists ( select '*' from csd_product_transactions cpt

716: and ced.estimate_detail_id >= p_min_id -- slab limits
717: and ced.estimate_detail_id <= p_max_id -- slab limits
718: and not exists ( select '*' from csd_repair_estimate_lines crel
719: where crel.estimate_detail_id = ced.estimate_detail_id)
720: and not exists ( select '*' from csd_product_transactions cpt
721: where cpt.estimate_detail_id = ced.estimate_detail_id);
722: -- Shiv Ragunathan, 11/19/03, Added the above 'not exists' clause to
723: -- prevent data in cs_estimate_details from being migrated,
724: -- if this was created from Depot Repair in 11.5.8. IN 11.5.7, this