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.OE_CUST_MERGE dependencies on OE_SETS

Line 3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
3600: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

Line 5556: Procedure OE_Sets_Merge (Req_Id IN NUMBER,

5552:
5553: END OE_Ship_Tolerance_Merge;
5554:
5555:
5556: Procedure OE_Sets_Merge (Req_Id IN NUMBER,
5557: Set_Num IN NUMBER,
5558: Process_Mode IN VARCHAR2)
5559: IS
5560: CURSOR SETS_MERGE IS

Line 5567: FROM RA_CUSTOMER_MERGES M, OE_SETS S

5563: PARALLEL(S,30)
5564: PARALLEL(M,30)
5565: USE_HASH(M,S) */
5566: s.set_id , s.ship_to_org_id , m.customer_merge_id
5567: FROM RA_CUSTOMER_MERGES M, OE_SETS S
5568: WHERE
5569: s.ship_to_org_id = m.duplicate_site_id
5570: and m.process_flag = 'N'
5571: and m.request_id = req_id

Line 5582: FROM RA_CUSTOMER_MERGES M, OE_SETS S

5578: PARALLEL(S,30)
5579: PARALLEL(M,30)
5580: USE_HASH(M,S) */
5581: s.set_id , s.ship_to_org_id ,m.customer_merge_id
5582: FROM RA_CUSTOMER_MERGES M, OE_SETS S
5583: WHERE
5584: s.ship_to_org_id = m.duplicate_site_id
5585: and m.process_flag = 'N'
5586: and m.request_id = req_id

Line 5597: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()+' );

5593: l_profile_val VARCHAR2(30);
5594:
5595: BEGIN
5596:
5597: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()+' );
5598:
5599: IF (process_mode = 'LOCK') THEN
5600:
5601: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 5602: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );

5598:
5599: IF (process_mode = 'LOCK') THEN
5600:
5601: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5602: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );
5603:
5604: open sets_merge;
5605: close sets_merge;
5606:

Line 5639: 'OE_SETS',

5635: LAST_UPDATE_DATE,
5636: LAST_UPDATED_BY
5637: ) VALUES (
5638: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5639: 'OE_SETS',
5640: MERGE_HEADER_ID_LIST(I),
5641: sets_set_id_tab(I),
5642: sets_ship_to_org_id_tab(I),
5643: sets_ship_to_org_id_tab(I),

Line 5657: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );

5653: end if;
5654:
5655:
5656: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5657: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );
5658:
5659: IF sets_set_id_tab.COUNT <> 0 THEN
5660: FORALL i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
5661: UPDATE OE_SETS S

Line 5661: UPDATE OE_SETS S

5657: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );
5658:
5659: IF sets_set_id_tab.COUNT <> 0 THEN
5660: FORALL i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
5661: UPDATE OE_SETS S
5662: SET ship_to_org_id = sets_ship_to_org_id_tab(i),
5663: update_date = sysdate,
5664: updated_by = arp_standard.profile.user_id,
5665: update_login = arp_standard.profile.last_update_login

Line 5687: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );

5683:
5684: CLOSE sets_merge_2;
5685:
5686: END IF;
5687: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
5688:
5689: EXCEPTION
5690: when others then
5691: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );

Line 5691: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );

5687: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
5688:
5689: EXCEPTION
5690: when others then
5691: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );
5692: raise;
5693:
5694: END OE_Sets_merge;
5695:

Line 5694: END OE_Sets_merge;

5690: when others then
5691: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );
5692: raise;
5693:
5694: END OE_Sets_merge;
5695:
5696: Procedure OE_Merge_Price_Adj_Attribs (Req_Id IN NUMBER,
5697: Set_Num IN NUMBER,
5698: Process_Mode IN VARCHAR2