DBA Data[Home] [Help]

APPS.OE_CUST_MERGE_DATA_FIX dependencies on OE_SETS

Line 2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:

Line 3473: Procedure OE_Sets_Merge (Req_Id IN NUMBER,

3469:
3470: END OE_Ship_Tolerance_Merge;
3471:
3472:
3473: Procedure OE_Sets_Merge (Req_Id IN NUMBER,
3474: Set_Num IN NUMBER,
3475: Process_Mode IN VARCHAR2)
3476: IS
3477: CURSOR c1 is

Line 3479: from oe_sets

3475: Process_Mode IN VARCHAR2)
3476: IS
3477: CURSOR c1 is
3478: select Set_Id
3479: from oe_sets
3480: where ship_to_org_id in
3481: (select m.duplicate_site_id
3482: from ra_customer_merges m
3483: where m.process_flag = 'Y'

Line 3493: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()+' );

3489: --
3490: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3491: --
3492: BEGIN
3493: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()+' );
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3496: END IF;
3497:

Line 3495: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;

3491: --
3492: BEGIN
3493: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()+' );
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3496: END IF;
3497:
3498: /* both customer and site level */
3499:

Line 3503: -- arp_message.set_token( 'TABLE_NAME', 'OE_SETS', FALSE );

3499:
3500: IF( process_mode = 'LOCK' ) THEN
3501:
3502: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3503: -- arp_message.set_token( 'TABLE_NAME', 'OE_SETS', FALSE );
3504: IF l_debug_level > 0 THEN
3505: oe_debug_pub.add( 'LOCKING TABLE OE_SETS' ) ;
3506: END IF;
3507:

Line 3505: oe_debug_pub.add( 'LOCKING TABLE OE_SETS' ) ;

3501:
3502: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3503: -- arp_message.set_token( 'TABLE_NAME', 'OE_SETS', FALSE );
3504: IF l_debug_level > 0 THEN
3505: oe_debug_pub.add( 'LOCKING TABLE OE_SETS' ) ;
3506: END IF;
3507:
3508: open c1;
3509: close c1;

Line 3518: -- arp_message.set_token( 'TABLE_NAME', 'OE_SETS', FALSE );

3514: IF l_debug_level > 0 THEN
3515: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
3516: END IF;
3517: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3518: -- arp_message.set_token( 'TABLE_NAME', 'OE_SETS', FALSE );
3519: IF l_debug_level > 0 THEN
3520: oe_debug_pub.add( 'UPDATING OE_SETS.SHIP_TO_ORG_ID' ) ;
3521: END IF;
3522:

Line 3520: oe_debug_pub.add( 'UPDATING OE_SETS.SHIP_TO_ORG_ID' ) ;

3516: END IF;
3517: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3518: -- arp_message.set_token( 'TABLE_NAME', 'OE_SETS', FALSE );
3519: IF l_debug_level > 0 THEN
3520: oe_debug_pub.add( 'UPDATING OE_SETS.SHIP_TO_ORG_ID' ) ;
3521: END IF;
3522:
3523: UPDATE oe_sets a
3524: set ship_to_org_id = (select distinct m.customer_site_id

Line 3523: UPDATE oe_sets a

3519: IF l_debug_level > 0 THEN
3520: oe_debug_pub.add( 'UPDATING OE_SETS.SHIP_TO_ORG_ID' ) ;
3521: END IF;
3522:
3523: UPDATE oe_sets a
3524: set ship_to_org_id = (select distinct m.customer_site_id
3525: from ra_customer_merges m
3526: where a.ship_to_org_id = m.duplicate_site_id
3527: and m.request_id = req_id

Line 3548: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()-' );

3544: END IF;
3545:
3546: END IF;
3547:
3548: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()-' );
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3551: END IF;
3552:

Line 3550: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;

3546: END IF;
3547:
3548: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()-' );
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3551: END IF;
3552:
3553: EXCEPTION
3554: when others then

Line 3555: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge-' );

3551: END IF;
3552:
3553: EXCEPTION
3554: when others then
3555: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge-' );
3556: IF l_debug_level > 0 THEN
3557: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3558: END IF;
3559: IF l_debug_level > 0 THEN

Line 3557: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;

3553: EXCEPTION
3554: when others then
3555: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge-' );
3556: IF l_debug_level > 0 THEN
3557: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3558: END IF;
3559: IF l_debug_level > 0 THEN
3560: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3561: END IF;

Line 3565: END OE_Sets_merge;

3561: END IF;
3562:
3563: raise;
3564:
3565: END OE_Sets_merge;
3566:
3567:
3568:
3569: Procedure OE_Order_Merge (Req_Id IN NUMBER,