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 4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

Line 6104: Procedure OE_Sets_Merge (Req_Id IN NUMBER,

6100:
6101: END OE_Ship_Tolerance_Merge;
6102:
6103:
6104: Procedure OE_Sets_Merge (Req_Id IN NUMBER,
6105: Set_Num IN NUMBER,
6106: Process_Mode IN VARCHAR2)
6107: IS
6108: CURSOR SETS_MERGE IS

Line 6115: FROM RA_CUSTOMER_MERGES M, OE_SETS S

6111: PARALLEL(S,30)
6112: PARALLEL(M,30)
6113: USE_HASH(M,S) */
6114: s.set_id , s.ship_to_org_id , m.customer_merge_id
6115: FROM RA_CUSTOMER_MERGES M, OE_SETS S
6116: WHERE
6117: s.ship_to_org_id = m.duplicate_site_id
6118: and m.process_flag = 'N'
6119: and m.request_id = req_id

Line 6130: FROM RA_CUSTOMER_MERGES M, OE_SETS S

6126: PARALLEL(S,30)
6127: PARALLEL(M,30)
6128: USE_HASH(M,S) */
6129: s.set_id , s.ship_to_org_id ,m.customer_merge_id
6130: FROM RA_CUSTOMER_MERGES M, OE_SETS S
6131: WHERE
6132: s.ship_to_org_id = m.duplicate_site_id
6133: and m.process_flag = 'N'
6134: and m.request_id = req_id

Line 6142: FROM RA_CUSTOMER_MERGES M, OE_SETS S

6138: CURSOR SETS_MERGE_2_NP IS
6139: SELECT s.set_id ,
6140: s.ship_to_org_id ,
6141: m.customer_merge_id
6142: FROM RA_CUSTOMER_MERGES M, OE_SETS S
6143: WHERE
6144: s.ship_to_org_id = m.duplicate_site_id
6145: and m.process_flag = 'N'
6146: and m.request_id = req_id

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

6153: l_profile_val VARCHAR2(30);
6154:
6155: BEGIN
6156:
6157: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()+' );
6158:
6159: IF (process_mode = 'LOCK') THEN
6160:
6161: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

6158:
6159: IF (process_mode = 'LOCK') THEN
6160:
6161: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6162: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );
6163:
6164: open sets_merge;
6165: close sets_merge;
6166:

Line 6212: 'OE_SETS',

6208: LAST_UPDATE_DATE,
6209: LAST_UPDATED_BY
6210: ) VALUES (
6211: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6212: 'OE_SETS',
6213: MERGE_HEADER_ID_LIST(I),
6214: sets_set_id_tab(I),
6215: sets_ship_to_org_id_tab(I),
6216: sets_ship_to_org_id_tab(I),

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

6226: end if;
6227:
6228:
6229: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6230: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );
6231:
6232: IF sets_set_id_tab.COUNT <> 0 THEN
6233: FORALL i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
6234: UPDATE OE_SETS S

Line 6234: UPDATE OE_SETS S

6230: arp_message.set_token( 'TABLE_NAME', 'oe_sets', FALSE );
6231:
6232: IF sets_set_id_tab.COUNT <> 0 THEN
6233: FORALL i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
6234: UPDATE OE_SETS S
6235: SET ship_to_org_id = sets_ship_to_org_id_tab(i),
6236: update_date = sysdate,
6237: updated_by = arp_standard.profile.user_id,
6238: update_login = arp_standard.profile.last_update_login

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

6264: CLOSE sets_merge_2_np;
6265: END IF;
6266:
6267: END IF;
6268: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
6269:
6270: EXCEPTION
6271: when others then
6272: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );

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

6268: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
6269:
6270: EXCEPTION
6271: when others then
6272: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );
6273: raise;
6274:
6275: END OE_Sets_merge;
6276:

Line 6275: END OE_Sets_merge;

6271: when others then
6272: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );
6273: raise;
6274:
6275: END OE_Sets_merge;
6276:
6277: Procedure OE_Merge_Price_Adj_Attribs (Req_Id IN NUMBER,
6278: Set_Num IN NUMBER,
6279: Process_Mode IN VARCHAR2