DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on FND_LOOKUPS

Line 39: FROM fnd_lookups

35: WHERE transaction_header_id = p_transaction_header_id
36: AND update_purchasing_docs IN ('Y','P') ;
37: SELECT meaning
38: INTO l_process_code
39: FROM fnd_lookups
40: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
41: AND lookup_code ='UPDTPO';
42: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
43: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 57: FROM fnd_lookups

53: WHERE transaction_header_id = p_transaction_header_id
54: AND update_inventory_costing IN ('Y','P') ;
55: SELECT meaning
56: INTO l_process_code
57: FROM fnd_lookups
58: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
59: AND lookup_code ='INVC';
60: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
61: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 75: FROM fnd_lookups

71: WHERE transaction_header_id = p_transaction_header_id
72: AND update_item_list_price IN ('Y','P') ;
73: SELECT meaning
74: INTO l_process_code
75: FROM fnd_lookups
76: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
77: AND lookup_code ='UPDTLP';
78: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
79: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 92: FROM fnd_lookups

88: WHERE transaction_header_id = p_transaction_header_id
89: AND supp_dist_claim_status IN ('Y','P') ;
90: SELECT meaning
91: INTO l_process_code
92: FROM fnd_lookups
93: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
94: AND lookup_code ='DSTRINVCL';
95: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
96: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 109: FROM fnd_lookups

105: WHERE transaction_header_id = p_transaction_header_id
106: AND supplier_claim_created IN ('Y','P') ;
107: SELECT meaning
108: INTO l_process_code
109: FROM fnd_lookups
110: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
111: AND lookup_code ='CUSTINVCL';
112: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
113: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 136: FROM fnd_lookups

132: AND dep.process_code = 'UPDTPO'
133: AND update_purchasing_docs IN ('N','P');
134: SELECT meaning
135: INTO l_process_code
136: FROM fnd_lookups
137: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
138: AND lookup_code ='UPDTPO';
139: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
140: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 159: FROM fnd_lookups

155: AND dep.process_code = 'NTFYPO'
156: AND notify_purchasing_docs IN ('N','P') ;
157: SELECT meaning
158: INTO l_process_code
159: FROM fnd_lookups
160: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
161: AND lookup_code ='NTFYPO';
162: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
163: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 182: FROM fnd_lookups

178: AND dep.process_code = 'INVC'
179: AND update_inventory_costing IN ('N','P') ;
180: SELECT meaning
181: INTO l_process_code
182: FROM fnd_lookups
183: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
184: AND lookup_code ='INVC';
185: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
186: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 204: FROM fnd_lookups

200: AND dep.process_code = 'UPDTLP'
201: AND update_item_list_price IN ('N','P') ;
202: SELECT meaning
203: INTO l_process_code
204: FROM fnd_lookups
205: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
206: AND lookup_code ='UPDTLP';
207: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
208: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 226: FROM fnd_lookups

222: AND dep.process_code = 'INPL'
223: AND notify_inbound_pricelist IN ('N','P') ;
224: SELECT meaning
225: INTO l_process_code
226: FROM fnd_lookups
227: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
228: AND lookup_code ='INPL';
229: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
230: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 248: FROM fnd_lookups

244: AND dep.process_code = 'OUTPL'
245: AND notify_outbound_pricelist IN ('N','P') ;
246: SELECT meaning
247: INTO l_process_code
248: FROM fnd_lookups
249: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
250: AND lookup_code ='OUTPL';
251: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
252: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 270: FROM fnd_lookups

266: AND dep.process_code = 'PROMO'
267: AND notify_promotions_pricelist IN ('N','P') ;
268: SELECT meaning
269: INTO l_process_code
270: FROM fnd_lookups
271: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
272: AND lookup_code ='PROMO';
273: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
274: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 292: FROM fnd_lookups

288: AND dep.process_code = 'DSTRINVCL'
289: AND supp_dist_claim_status IN ('N','P','D') ;
290: SELECT meaning
291: INTO l_process_code
292: FROM fnd_lookups
293: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
294: AND lookup_code ='DSTRINVCL';
295: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
296: fnd_message.set_token('PROCESS_CODE', l_process_code);

Line 314: FROM fnd_lookups

310: AND dep.process_code = 'CUSTINVCL'
311: AND supplier_claim_created IN ('N','P') ;
312: SELECT meaning
313: INTO l_process_code
314: FROM fnd_lookups
315: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
316: AND lookup_code ='CUSTINVCL';
317: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
318: fnd_message.set_token('PROCESS_CODE', l_process_code);