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.CS_CH_ACCOUNT_MERGE_PKG dependencies on CS_ESTIMATE_DETAILS

Line 20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );

16: arp_message.set_line('CRM_MERGE.SR_MERGE()+');
17:
18: IF ( process_mode = 'LOCK' ) Then
19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
21: ELSE
22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
24:

Line 23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );

19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
21: ELSE
22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
24:
25: END IF;
26:
27: ----Merge the CS_ESTIMATE_DETAILS table update the account_id

Line 27: ----Merge the CS_ESTIMATE_DETAILS table update the account_id

23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
24:
25: END IF;
26:
27: ----Merge the CS_ESTIMATE_DETAILS table update the account_id
28:
29: message_text := '***-- Procedure CS_CH_MERGE_CUST_ACCOUNT_ID --**';
30: arp_message.set_line(message_text);
31:

Line 40: ---Report that the process for CS_ESTIMATE_DETAILS is complete

36: message_text := '***-- End CS_CH_MERGE_CUST_ACCOUNT_ID --**';
37: arp_message.set_line(message_text);
38:
39:
40: ---Report that the process for CS_ESTIMATE_DETAILS is complete
41:
42: IF ( process_mode = 'LOCK' ) Then
43: message_text := '** LOCKING completed for table CS_ESTIMATE_DETAILS **';
44: arp_message.set_line(message_text);

Line 43: message_text := ' LOCKING completed for table CS_ESTIMATE_DETAILS ';

39:
40: ---Report that the process for CS_ESTIMATE_DETAILS is complete
41:
42: IF ( process_mode = 'LOCK' ) Then
43: message_text := '** LOCKING completed for table CS_ESTIMATE_DETAILS **';
44: arp_message.set_line(message_text);
45: ELSE
46: message_text := '** MERGE completed for table CS_ESTIMATE_DETAILS **';
47: arp_message.set_line(message_text);

Line 46: message_text := ' MERGE completed for table CS_ESTIMATE_DETAILS ';

42: IF ( process_mode = 'LOCK' ) Then
43: message_text := '** LOCKING completed for table CS_ESTIMATE_DETAILS **';
44: arp_message.set_line(message_text);
45: ELSE
46: message_text := '** MERGE completed for table CS_ESTIMATE_DETAILS **';
47: arp_message.set_line(message_text);
48: END IF;
49:
50: arp_message.set_line('CRM_MERGE.SR_MERGE()-');

Line 54: -- The following procedure merges the following columns from CS_ESTIMATE_DETAILS

50: arp_message.set_line('CRM_MERGE.SR_MERGE()-');
51:
52: END MERGE_CUST_ACCOUNTS;
53:
54: -- The following procedure merges the following columns from CS_ESTIMATE_DETAILS
55: -- account_id
56: -- invoice_to_account_id - added for 11.5.9
57: -- ship_to_account_id - added for 11.5.9
58:

Line 70: CS_ESTIMATE_DETAILS.ESTIMATE_DETAIL_ID%TYPE

66: INDEX BY BINARY_INTEGER;
67: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
68:
69: TYPE ESTIMATE_DETAIL_ID_LIST_TYPE IS TABLE OF
70: CS_ESTIMATE_DETAILS.ESTIMATE_DETAIL_ID%TYPE
71: INDEX BY BINARY_INTEGER;
72: PRIMARY_KEY_ID_LIST ESTIMATE_DETAIL_ID_LIST_TYPE;
73:
74: TYPE INVOICE_TO_ACCT_ID_LIST_TYPE IS TABLE OF

Line 75: CS_ESTIMATE_DETAILS.INVOICE_TO_ACCOUNT_ID%TYPE

71: INDEX BY BINARY_INTEGER;
72: PRIMARY_KEY_ID_LIST ESTIMATE_DETAIL_ID_LIST_TYPE;
73:
74: TYPE INVOICE_TO_ACCT_ID_LIST_TYPE IS TABLE OF
75: CS_ESTIMATE_DETAILS.INVOICE_TO_ACCOUNT_ID%TYPE
76: INDEX BY BINARY_INTEGER;
77: NUM_COL1_ORIG_LIST INVOICE_TO_ACCT_ID_LIST_TYPE;
78: NUM_COL1_NEW_LIST INVOICE_TO_ACCT_ID_LIST_TYPE;
79:

Line 81: CS_ESTIMATE_DETAILS.SHIP_TO_ACCOUNT_ID%TYPE

77: NUM_COL1_ORIG_LIST INVOICE_TO_ACCT_ID_LIST_TYPE;
78: NUM_COL1_NEW_LIST INVOICE_TO_ACCT_ID_LIST_TYPE;
79:
80: TYPE SHIP_TO_ACCT_ID_LIST_TYPE IS TABLE OF
81: CS_ESTIMATE_DETAILS.SHIP_TO_ACCOUNT_ID%TYPE
82: INDEX BY BINARY_INTEGER;
83: NUM_COL2_ORIG_LIST SHIP_TO_ACCT_ID_LIST_TYPE;
84: NUM_COL2_NEW_LIST SHIP_TO_ACCT_ID_LIST_TYPE;
85:

Line 91: FROM CS_ESTIMATE_DETAILS yt,

87: SELECT distinct CUSTOMER_MERGE_HEADER_ID
88: ,ESTIMATE_DETAIL_ID
89: ,INVOICE_TO_ACCOUNT_ID
90: ,SHIP_TO_ACCOUNT_ID
91: FROM CS_ESTIMATE_DETAILS yt,
92: ra_customer_merges m
93: WHERE ( yt.INVOICE_TO_ACCOUNT_ID = m.DUPLICATE_ID
94: OR yt.SHIP_TO_ACCOUNT_ID = m.DUPLICATE_ID)
95: AND m.process_flag = 'N'

Line 130: ARP_MESSAGE.SET_TOKEN('TABLE_NAME',' CS_ESTIMATE_DETAILS',FALSE);

126: IF process_mode='LOCK' THEN
127: NULL;
128: ELSE
129: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
130: ARP_MESSAGE.SET_TOKEN('TABLE_NAME',' CS_ESTIMATE_DETAILS',FALSE);
131:
132: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
133: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
134:

Line 199: HZ_CUSTOMER_MERGE_LOG_s.nextval, 'CS_ESTIMATE_DETAILS',

195: CREATED_BY, CREATION_DATE,
196: LAST_UPDATE_LOGIN, LAST_UPDATE_DATE,
197: LAST_UPDATED_BY )
198: VALUES (
199: HZ_CUSTOMER_MERGE_LOG_s.nextval, 'CS_ESTIMATE_DETAILS',
200: MERGE_HEADER_ID_LIST(I), PRIMARY_KEY_ID_LIST(I),
201: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
202: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
203: 'U', req_id,

Line 211: UPDATE CS_ESTIMATE_DETAILS yt SET

207:
208: END IF;
209:
210: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
211: UPDATE CS_ESTIMATE_DETAILS yt SET
212: INVOICE_TO_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
213: , SHIP_TO_ACCOUNT_ID = NUM_COL2_NEW_LIST(I)
214: , LAST_UPDATE_DATE = SYSDATE
215: , last_updated_by = arp_standard.profile.user_id