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

Line 3236: /* description : procedure for migrating CSD_PRODUCT_TRANSACTIONS data */

3232:
3233:
3234: /*------------------------------------------------------------------------*/
3235: /* procedure name: CSD_PRODUCT_TRANS_MIG3(p_slab_Number Number)
3236: /* description : procedure for migrating CSD_PRODUCT_TRANSACTIONS data */
3237: /* from 11.5.9 to 11.5.10 */
3238: /* Created : saupadhy SEPT-30-2003 */
3239: /* */
3240: /* Here are the details for the migration - */

Line 3321: l_Table_Name Varchar2(30) := 'CSD_PRODUCT_TRANSACTIONS' ;

3317: l_Quantity Number ;
3318:
3319:
3320: -- Declare local variables
3321: l_Table_Name Varchar2(30) := 'CSD_PRODUCT_TRANSACTIONS' ;
3322: l_Module Varchar2(30) := 'CSD' ;
3323: l_start_slab Number ;
3324: l_End_Slab Number ;
3325: l_error_text VARCHAR2(2000);

Line 3377: From csd_product_transactions cpt ,

3373: NULL, -- quantity_received
3374: NULL, -- Quantity_shipped
3375: NULL, -- source_serial_number
3376: NULL -- non_source_serial_number
3377: From csd_product_transactions cpt ,
3378: csd_repairs cr ,
3379: csd_repair_types_b crt,
3380: cs_estimate_details ced ,
3381: oe_order_headers_all ooha,

Line 3462: -- Migration script for CSD_Product_Transactions

3458: p_module => l_Module ,
3459: p_slab_number => p_Slab_Number,
3460: x_start_slab => l_Start_Slab ,
3461: x_end_slab => l_End_Slab );
3462: -- Migration script for CSD_Product_Transactions
3463: -- Dbms_Output.Put_line('Start Slab :' || l_Start_Slab );
3464: -- Dbms_Output.Put_line('End Slab :' || l_End_Slab );
3465: -- Return if l_Start_Slab variable has null value
3466: IF l_Start_Slab IS NULL OR l_End_Slab IS NULL THEN

Line 3472: -- Migration script for CSD_Product_Transactions

3468: END IF;
3469: END;
3470: l_procedure_Event := 'After calling csd_mig_slabs_pkg.get_table_slabs procedure' ;
3471:
3472: -- Migration script for CSD_Product_Transactions
3473:
3474: OPEN Prod_txns_cur(l_Start_Slab, l_End_Slab);
3475: LOOP
3476: Begin

Line 3835: VALUES ('CSD_PRODUCT_TRANSACTIONS',

3831: ORIG_SYSTEM_REFERENCE_ID,
3832: UPGRADE_DATETIME,
3833: ERROR_MESSAGE,
3834: MIGRATION_PHASE)
3835: VALUES ('CSD_PRODUCT_TRANSACTIONS',
3836: 'CSD_PRODUCT_TRANSACTIONS',
3837: v_Product_Trans_id(j),
3838: sysdate,
3839: l_error_text,

Line 3836: 'CSD_PRODUCT_TRANSACTIONS',

3832: UPGRADE_DATETIME,
3833: ERROR_MESSAGE,
3834: MIGRATION_PHASE)
3835: VALUES ('CSD_PRODUCT_TRANSACTIONS',
3836: 'CSD_PRODUCT_TRANSACTIONS',
3837: v_Product_Trans_id(j),
3838: sysdate,
3839: l_error_text,
3840: '11.5.10');

Line 3844: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);

3840: '11.5.10');
3841:
3842: commit;
3843:
3844: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);
3845:
3846: End;
3847: End Loop; -- j IN 1..l_Array_Size.COUNT
3848: -- Now use bulck collect to update csd_product_transactions_table

Line 3848: -- Now use bulck collect to update csd_product_transactions_table

3844: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);
3845:
3846: End;
3847: End Loop; -- j IN 1..l_Array_Size.COUNT
3848: -- Now use bulck collect to update csd_product_transactions_table
3849: ForAll i in 1..v_product_trans_Id.COUNT
3850: Update Csd_Product_Transactions
3851: Set source_serial_number = v_Source_Serial_Number(i) ,
3852: source_instance_id = v_source_instance_id(i) ,

Line 3850: Update Csd_Product_Transactions

3846: End;
3847: End Loop; -- j IN 1..l_Array_Size.COUNT
3848: -- Now use bulck collect to update csd_product_transactions_table
3849: ForAll i in 1..v_product_trans_Id.COUNT
3850: Update Csd_Product_Transactions
3851: Set source_serial_number = v_Source_Serial_Number(i) ,
3852: source_instance_id = v_source_instance_id(i) ,
3853: non_source_serial_number = v_non_source_serial_number(i) ,
3854: non_source_instance_id = v_non_source_instance_id(i) ,

Line 3884: VALUES ('CSD_PRODUCT_TRANSACTIONS',

3880: ORIG_SYSTEM_REFERENCE_ID,
3881: UPGRADE_DATETIME,
3882: ERROR_MESSAGE,
3883: MIGRATION_PHASE)
3884: VALUES ('CSD_PRODUCT_TRANSACTIONS',
3885: 'CSD_PRODUCT_TRANSACTIONS',
3886: NULL,
3887: sysdate,
3888: l_error_text,

Line 3885: 'CSD_PRODUCT_TRANSACTIONS',

3881: UPGRADE_DATETIME,
3882: ERROR_MESSAGE,
3883: MIGRATION_PHASE)
3884: VALUES ('CSD_PRODUCT_TRANSACTIONS',
3885: 'CSD_PRODUCT_TRANSACTIONS',
3886: NULL,
3887: sysdate,
3888: l_error_text,
3889: '11.5.10');

Line 3893: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);

3889: '11.5.10');
3890:
3891: commit;
3892:
3893: raise_application_error( -20000, 'Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);
3894:
3895:
3896: END;
3897:

Line 3919: VALUES ('CSD_PRODUCT_TRANSACTIONS',

3915: ORIG_SYSTEM_REFERENCE_ID,
3916: UPGRADE_DATETIME,
3917: ERROR_MESSAGE,
3918: MIGRATION_PHASE)
3919: VALUES ('CSD_PRODUCT_TRANSACTIONS',
3920: 'CSD_PRODUCT_TRANSACTIONS',
3921: NULL,
3922: sysdate,
3923: l_error_text,

Line 3920: 'CSD_PRODUCT_TRANSACTIONS',

3916: UPGRADE_DATETIME,
3917: ERROR_MESSAGE,
3918: MIGRATION_PHASE)
3919: VALUES ('CSD_PRODUCT_TRANSACTIONS',
3920: 'CSD_PRODUCT_TRANSACTIONS',
3921: NULL,
3922: sysdate,
3923: l_error_text,
3924: '11.5.10');

Line 3927: raise_application_error( -20000, 'Event:' || l_Procedure_Event || '-Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);

3923: l_error_text,
3924: '11.5.10');
3925:
3926: Commit;
3927: raise_application_error( -20000, 'Event:' || l_Procedure_Event || '-Error while migrating CSD_PRODUCT_TRANSACTIONS. '|| l_error_text);
3928:
3929: END csd_product_trans_mig3;
3930:
3931: END CSD_Migrate_From_115X_PKG3;