APPS.INVP_CMERGE_TXHI dependencies on MTL_UNIT_TRANSACTIONS

Line 15: FROM MTL_UNIT_TRANSACTIONS

11: procedure INV_MUT (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
13: CURSOR C1 IS
14: SELECT NULL
15: FROM MTL_UNIT_TRANSACTIONS
16: WHERE customer_id in (select racm.duplicate_id
17: from ra_customer_merges racm
18: where racm.process_flag = 'N'
19: and racm.request_id = req_id

Line 27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS

23:
24: BEGIN
25: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()+' );
26: /*Bug#5574255. Modified code in such a way that LOCKING of rows of
27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS
28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with
29: non-zero and non-null customer_id.*/
30:
31: BEGIN

Line 28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with

24: BEGIN
25: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()+' );
26: /*Bug#5574255. Modified code in such a way that LOCKING of rows of
27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS
28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with
29: non-zero and non-null customer_id.*/
30:
31: BEGIN
32: SELECT 1

Line 36: FROM mtl_unit_transactions

32: SELECT 1
33: INTO mut_cust_flag
34: FROM dual
35: WHERE EXISTS ( SELECT 1
36: FROM mtl_unit_transactions
37: WHERE customer_id <> 0);
38: EXCEPTION WHEN OTHERS THEN
39: mut_cust_flag := 0;
40: END;

Line 43: | MTL_UNIT_TRANSACTIONS |

39: mut_cust_flag := 0;
40: END;
41:
42: /*-----------------------+
43: | MTL_UNIT_TRANSACTIONS |
44: +-----------------------*/
45: /* try to lock the table first */
46: IF ( mut_cust_flag <> 0) THEN
47: IF (process_mode = 'LOCK') then

Line 49: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );

45: /* try to lock the table first */
46: IF ( mut_cust_flag <> 0) THEN
47: IF (process_mode = 'LOCK') then
48: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
49: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );
50:
51: OPEN C1;
52: CLOSE C1;
53:

Line 59: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);

55:
56: /* customer level update */
57:
58: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
60: arp_message.set_line('customer level : customer_id');
61:
62: UPDATE MTL_UNIT_TRANSACTIONS yt
63: set customer_id = (select distinct racm.customer_id

Line 62: UPDATE MTL_UNIT_TRANSACTIONS yt

58: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
60: arp_message.set_line('customer level : customer_id');
61:
62: UPDATE MTL_UNIT_TRANSACTIONS yt
63: set customer_id = (select distinct racm.customer_id
64: from ra_customer_merges racm
65: where yt.customer_id =
66: racm.duplicate_id