APPS.POP_CMERGE_REQ dependencies on PO_REQUISITION_LINES

Line 9: /*--------------------------- PO_REQUISITION_LINES --------------------------*/

5: g_count NUMBER := 0;
6:
7: /*--------------------------- PRIVATE ROUTINES ------------------------------*/
8:
9: /*--------------------------- PO_REQUISITION_LINES --------------------------*/
10:
11: procedure PO_RL (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
13: CURSOR C1 IS

Line 15: FROM PO_REQUISITION_LINES

11: procedure PO_RL (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
13: CURSOR C1 IS
14: SELECT NULL
15: FROM PO_REQUISITION_LINES
16: WHERE source_type_code = 'INVENTORY'
17: and deliver_to_location_id in (select location_id
18: from po_location_associations
19: where customer_id in (select racm.duplicate_id

Line 51: FROM PO_REQUISITION_LINES yt,

47:
48: CURSOR merged_records IS
49: SELECT m.CUSTOMER_MERGE_HEADER_ID,
50: yt.REQUISITION_LINE_ID
51: FROM PO_REQUISITION_LINES yt,
52: ra_customer_merges m,
53: po_location_associations pla
54: WHERE yt.source_type_code = 'INVENTORY'
55: AND yt.deliver_to_location_id = pla.location_id

Line 71: FROM PO_REQUISITION_LINES yt, ra_customer_merges m,

67: yt.REQUISITION_LINE_ID,
68: pla1.location_id, --new
69: pla2.location_id --old
70:
71: FROM PO_REQUISITION_LINES yt, ra_customer_merges m,
72: po_location_associations pla1,po_location_associations pla2
73: WHERE yt.source_type_code = 'INVENTORY'
74: and yt.deliver_to_location_id = pla2.location_id
75: and pla2.site_use_id = m.duplicate_site_id

Line 90: PO_REQUISITION_LINES.REQUISITION_LINE_ID%TYPE

86: INDEX BY BINARY_INTEGER;
87: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
88:
89: TYPE REQUISITION_LINE_ID_LIST_TYPE IS TABLE OF
90: PO_REQUISITION_LINES.REQUISITION_LINE_ID%TYPE
91: INDEX BY BINARY_INTEGER;
92: PRIMARY_KEY_ID_LIST REQUISITION_LINE_ID_LIST_TYPE;
93:
94: TYPE DELIVER_TO_LOC_ID_LIST_TYPE IS TABLE OF

Line 95: PO_REQUISITION_LINES.DELIVER_TO_LOCATION_ID%TYPE

91: INDEX BY BINARY_INTEGER;
92: PRIMARY_KEY_ID_LIST REQUISITION_LINE_ID_LIST_TYPE;
93:
94: TYPE DELIVER_TO_LOC_ID_LIST_TYPE IS TABLE OF
95: PO_REQUISITION_LINES.DELIVER_TO_LOCATION_ID%TYPE
96: INDEX BY BINARY_INTEGER;
97: NUM_COL1_ORIG_LIST DELIVER_TO_LOC_ID_LIST_TYPE;
98: NUM_COL1_NEW_LIST DELIVER_TO_LOC_ID_LIST_TYPE;
99:

Line 100: l_deliver_to_location_id PO_REQUISITION_LINES.DELIVER_TO_LOCATION_ID%TYPE;

96: INDEX BY BINARY_INTEGER;
97: NUM_COL1_ORIG_LIST DELIVER_TO_LOC_ID_LIST_TYPE;
98: NUM_COL1_NEW_LIST DELIVER_TO_LOC_ID_LIST_TYPE;
99:
100: l_deliver_to_location_id PO_REQUISITION_LINES.DELIVER_TO_LOCATION_ID%TYPE;
101: l_profile_val VARCHAR2(30);
102: l_last_fetch BOOLEAN := FALSE;
103: /* Bug 2447478 END */
104:

Line 114: | PO_REQUISITION_LINES |

110:
111: arp_message.set_line( 'POP_CMERGE_REQ.PO_RL()+' );
112:
113: /*-----------------------------+
114: | PO_REQUISITION_LINES |
115: +-----------------------------*/
116:
117: IF (process_mode = 'LOCK') then
118:

Line 122: arp_message.set_token( 'TABLE_NAME', 'PO_REQUISITION_LINES', FALSE );

118:
119: /* try to lock the table first */
120:
121: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
122: arp_message.set_token( 'TABLE_NAME', 'PO_REQUISITION_LINES', FALSE );
123: arp_message.flush;
124:
125: OPEN C1;
126: CLOSE C1;

Line 133: arp_message.set_token('TABLE_NAME', 'PO_REQUISITION_LINES', FALSE);

129:
130: /* Modify locations for those lines for which locations are going to change */
131:
132: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
133: arp_message.set_token('TABLE_NAME', 'PO_REQUISITION_LINES', FALSE);
134: arp_message.set_line('Merging locations for merged customers/sites.');
135:
136: /* Bug 2447478 START */
137: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 149: po_requisition_lines yt

145: into l_deliver_to_location_id
146: from po_location_associations pla1,
147: po_location_associations pla2,
148: ra_customer_merges racm,
149: po_requisition_lines yt
150: where yt.deliver_to_location_id = pla2.location_id
151: and pla2.site_use_id = racm.duplicate_site_id
152: and racm.customer_site_id = pla1.site_use_id
153: and racm.process_flag = 'N'

Line 228: 'PO_REQUISITION_LINES',

224: LAST_UPDATE_DATE,
225: LAST_UPDATED_BY)
226: VALUES(
227: HZ_CUSTOMER_MERGE_LOG_s.nextval,
228: 'PO_REQUISITION_LINES',
229: MERGE_HEADER_ID_LIST(I),
230: PRIMARY_KEY_ID_LIST(I),
231: NUM_COL1_ORIG_LIST(I),
232: NUM_COL1_NEW_LIST(I),

Line 248: UPDATE PO_REQUISITION_LINES yt

244: the affected Requisitions due to merged/changed accounts
245: */
246: /* Bug 4009128 - modified deliver_to_location assignment */
247: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
248: UPDATE PO_REQUISITION_LINES yt
249: SET -- DELIVER_TO_LOCATION_ID = l_deliver_to_location_id,
250: DELIVER_TO_LOCATION_ID = NEW_DELIVER_TO_LOC_LIST(I),
251: LAST_UPDATE_DATE = SYSDATE,
252: LAST_UPDATED_BY = arp_standard.profile.user_id,