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.DPP_UIWRAPPER_PVT dependencies on DPP_UTILITY_PVT

Line 12: --Call Dpp_utility_pvt.check_txnclose

8: ,x_return_status OUT NOCOPY VARCHAR2)
9: IS
10:
11: BEGIN
12: --Call Dpp_utility_pvt.check_txnclose
13: DPP_UTILITY_PVT.check_transaction(p_transaction_header_id => p_transaction_header_id
14: ,p_status_change => p_status_change
15: ,x_rec_count => x_rec_count
16: ,x_msg_data => x_msg_data

Line 13: DPP_UTILITY_PVT.check_transaction(p_transaction_header_id => p_transaction_header_id

9: IS
10:
11: BEGIN
12: --Call Dpp_utility_pvt.check_txnclose
13: DPP_UTILITY_PVT.check_transaction(p_transaction_header_id => p_transaction_header_id
14: ,p_status_change => p_status_change
15: ,x_rec_count => x_rec_count
16: ,x_msg_data => x_msg_data
17: ,x_return_status => x_return_status);

Line 43: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

39: ,x_return_status OUT NOCOPY VARCHAR2
40: )
41: IS
42:
43: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
44: l_vendor_tbl DPP_UTILITY_PVT.vendor_tbl_type;
45:
46: BEGIN
47:

Line 44: l_vendor_tbl DPP_UTILITY_PVT.vendor_tbl_type;

40: )
41: IS
42:
43: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
44: l_vendor_tbl DPP_UTILITY_PVT.vendor_tbl_type;
45:
46: BEGIN
47:
48: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP

Line 53: DPP_UTILITY_PVT.search_vendors(

49: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
50: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
51: END LOOP;
52:
53: DPP_UTILITY_PVT.search_vendors(
54: p_search_criteria => l_search_criteria_tbl
55: ,x_vendor_tbl => l_vendor_tbl
56: ,x_rec_count => x_rec_count
57: ,x_return_status => x_return_status

Line 88: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

84: ,x_rec_count OUT NOCOPY NUMBER
85: ,x_return_status OUT NOCOPY VARCHAR2
86: )
87: IS
88: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
89: l_vendor_site_tbl DPP_UTILITY_PVT.vendor_site_tbl_type;
90: BEGIN
91: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
92: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 89: l_vendor_site_tbl DPP_UTILITY_PVT.vendor_site_tbl_type;

85: ,x_return_status OUT NOCOPY VARCHAR2
86: )
87: IS
88: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
89: l_vendor_site_tbl DPP_UTILITY_PVT.vendor_site_tbl_type;
90: BEGIN
91: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
92: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
93: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 96: DPP_UTILITY_PVT.search_vendor_sites(

92: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
93: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
94: END LOOP;
95:
96: DPP_UTILITY_PVT.search_vendor_sites(
97: p_search_criteria => l_search_criteria_tbl
98: ,x_vendor_site_tbl => l_vendor_site_tbl
99: ,x_rec_count => x_rec_count
100: ,x_return_status => x_return_status

Line 141: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

137: ,x_rec_count OUT NOCOPY NUMBER
138: ,x_return_status OUT NOCOPY VARCHAR2
139: )
140: IS
141: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
142: l_vendor_contact_tbl DPP_UTILITY_PVT.vendor_contact_tbl_type;
143: BEGIN
144: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
145: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 142: l_vendor_contact_tbl DPP_UTILITY_PVT.vendor_contact_tbl_type;

138: ,x_return_status OUT NOCOPY VARCHAR2
139: )
140: IS
141: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
142: l_vendor_contact_tbl DPP_UTILITY_PVT.vendor_contact_tbl_type;
143: BEGIN
144: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
145: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
146: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 148: DPP_UTILITY_PVT.search_vendor_contacts(

144: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
145: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
146: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
147: END LOOP;
148: DPP_UTILITY_PVT.search_vendor_contacts(
149: p_search_criteria => l_search_criteria_tbl
150: ,x_vendor_contact_tbl => l_vendor_contact_tbl
151: ,x_rec_count => x_rec_count
152: ,x_return_status => x_return_status

Line 190: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

186: ,x_rec_count OUT NOCOPY NUMBER
187: ,x_return_status OUT NOCOPY VARCHAR2
188: )
189: IS
190: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
191: l_itemnum_tbl DPP_UTILITY_PVT.itemnum_tbl_type;
192: BEGIN
193: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
194: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 191: l_itemnum_tbl DPP_UTILITY_PVT.itemnum_tbl_type;

187: ,x_return_status OUT NOCOPY VARCHAR2
188: )
189: IS
190: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
191: l_itemnum_tbl DPP_UTILITY_PVT.itemnum_tbl_type;
192: BEGIN
193: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
194: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
195: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 198: DPP_UTILITY_PVT.search_items(

194: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
195: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
196: END LOOP;
197:
198: DPP_UTILITY_PVT.search_items(
199: p_search_criteria => l_search_criteria_tbl
200: ,x_item_tbl => l_itemnum_tbl
201: ,x_rec_count => x_rec_count
202: ,x_return_status => x_return_status

Line 237: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

233: ,x_rec_count OUT NOCOPY NUMBER
234: ,x_return_status OUT NOCOPY VARCHAR2
235: )
236: IS
237: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
238: l_customer_item_tbl DPP_UTILITY_PVT.item_tbl_type;
239: BEGIN
240: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
241: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 238: l_customer_item_tbl DPP_UTILITY_PVT.item_tbl_type;

234: ,x_return_status OUT NOCOPY VARCHAR2
235: )
236: IS
237: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
238: l_customer_item_tbl DPP_UTILITY_PVT.item_tbl_type;
239: BEGIN
240: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
241: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
242: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 245: DPP_UTILITY_PVT.search_customer_items(

241: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
242: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
243: END LOOP;
244:
245: DPP_UTILITY_PVT.search_customer_items(
246: p_search_criteria => l_search_criteria_tbl
247: ,x_customer_item_tbl => l_customer_item_tbl
248: ,x_rec_count => x_rec_count
249: ,x_return_status => x_return_status

Line 284: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

280: ,x_rec_count OUT NOCOPY NUMBER
281: ,x_return_status OUT NOCOPY VARCHAR2
282: )
283: IS
284: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
285: l_customer_item_tbl DPP_UTILITY_PVT.item_tbl_type;
286: BEGIN
287: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
288: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 285: l_customer_item_tbl DPP_UTILITY_PVT.item_tbl_type;

281: ,x_return_status OUT NOCOPY VARCHAR2
282: )
283: IS
284: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
285: l_customer_item_tbl DPP_UTILITY_PVT.item_tbl_type;
286: BEGIN
287: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
288: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
289: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 292: DPP_UTILITY_PVT.search_customer_items_all(

288: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
289: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
290: END LOOP;
291:
292: DPP_UTILITY_PVT.search_customer_items_all(
293: p_search_criteria => l_search_criteria_tbl
294: ,x_customer_item_tbl => l_customer_item_tbl
295: ,x_rec_count => x_rec_count
296: ,x_return_status => x_return_status

Line 331: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

327: ,x_rec_count OUT NOCOPY NUMBER
328: ,x_return_status OUT NOCOPY VARCHAR2
329: )
330: IS
331: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
332: l_warehouse_tbl DPP_UTILITY_PVT.warehouse_tbl_type;
333: BEGIN
334: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
335: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 332: l_warehouse_tbl DPP_UTILITY_PVT.warehouse_tbl_type;

328: ,x_return_status OUT NOCOPY VARCHAR2
329: )
330: IS
331: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
332: l_warehouse_tbl DPP_UTILITY_PVT.warehouse_tbl_type;
333: BEGIN
334: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
335: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
336: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 339: DPP_UTILITY_PVT.search_warehouses(

335: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
336: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
337: END LOOP;
338:
339: DPP_UTILITY_PVT.search_warehouses(
340: p_search_criteria => l_search_criteria_tbl
341: ,x_warehouse_tbl => l_warehouse_tbl
342: ,x_rec_count => x_rec_count
343: ,x_return_status => x_return_status

Line 377: l_inventorydetails_tbl DPP_UTILITY_PVT.inventorydetails_tbl_type;

373: ,x_rec_count OUT NOCOPY NUMBER
374: ,x_return_status OUT NOCOPY VARCHAR2
375: )
376: IS
377: l_inventorydetails_tbl DPP_UTILITY_PVT.inventorydetails_tbl_type;
378: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
379:
380: BEGIN
381:

Line 378: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;

374: ,x_return_status OUT NOCOPY VARCHAR2
375: )
376: IS
377: l_inventorydetails_tbl DPP_UTILITY_PVT.inventorydetails_tbl_type;
378: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
379:
380: BEGIN
381:
382: l_hdr_rec.org_id := p_hdr_rec.org_id;

Line 393: DPP_UTILITY_PVT.Get_InventoryDetails(

389: l_inventorydetails_tbl(i).Inventory_Item_ID := p_inventorydetails_tbl(i).Inventory_Item_ID;
390:
391: END LOOP;
392:
393: DPP_UTILITY_PVT.Get_InventoryDetails(
394: p_hdr_rec => l_hdr_rec
395: ,p_inventorydetails_tbl => l_inventorydetails_tbl
396: ,x_rec_count => x_rec_count
397: ,x_return_status => x_return_status

Line 428: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;

424: ,x_rec_count OUT NOCOPY NUMBER
425: ,x_return_status OUT NOCOPY VARCHAR2
426: )
427: IS
428: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
429: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;
430: BEGIN
431: l_hdr_rec.org_id := p_hdr_rec.org_id;
432: l_hdr_rec.effective_start_date := p_hdr_rec.effective_start_date;

Line 429: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;

425: ,x_return_status OUT NOCOPY VARCHAR2
426: )
427: IS
428: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
429: l_cust_inv_tbl DPP_UTILITY_PVT.dpp_cust_inv_tbl_type;
430: BEGIN
431: l_hdr_rec.org_id := p_hdr_rec.org_id;
432: l_hdr_rec.effective_start_date := p_hdr_rec.effective_start_date;
433: l_hdr_rec.effective_end_date := p_hdr_rec.effective_end_date;

Line 443: DPP_UTILITY_PVT.Get_CustomerInventory(

439: l_cust_inv_tbl(i).UOM_Code := p_cust_inv_tbl(i).UOM_Code;
440:
441: END LOOP;
442:
443: DPP_UTILITY_PVT.Get_CustomerInventory(
444: p_hdr_rec => l_hdr_rec
445: ,p_cust_inv_tbl => l_cust_inv_tbl
446: ,x_rec_count => x_rec_count
447: ,x_return_status => x_return_status

Line 477: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

473: ,x_rec_count OUT NOCOPY NUMBER
474: ,x_return_status OUT NOCOPY VARCHAR2
475: )
476: IS
477: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
478: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;
479: BEGIN
480: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
481: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 478: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;

474: ,x_return_status OUT NOCOPY VARCHAR2
475: )
476: IS
477: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
478: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;
479: BEGIN
480: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
481: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
482: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 485: DPP_UTILITY_PVT.search_customers(

481: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
482: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
483: END LOOP;
484:
485: DPP_UTILITY_PVT.search_customers(
486: p_search_criteria => l_search_criteria_tbl
487: ,x_customer_tbl => l_customer_tbl
488: ,x_rec_count => x_rec_count
489: ,x_return_status => x_return_status

Line 523: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;

519: ,x_rec_count OUT NOCOPY NUMBER
520: ,x_return_status OUT NOCOPY VARCHAR2
521: )
522: IS
523: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
524: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;
525: BEGIN
526: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
527: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;

Line 524: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;

520: ,x_return_status OUT NOCOPY VARCHAR2
521: )
522: IS
523: l_search_criteria_tbl DPP_UTILITY_PVT.search_criteria_tbl_type;
524: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;
525: BEGIN
526: FOR i IN p_search_criteria.FIRST..p_search_criteria.LAST LOOP
527: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
528: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;

Line 531: DPP_UTILITY_PVT.search_customers_all(

527: l_search_criteria_tbl(i).search_criteria := p_search_criteria(i).search_criteria;
528: l_search_criteria_tbl(i).search_text := p_search_criteria(i).search_text;
529: END LOOP;
530:
531: DPP_UTILITY_PVT.search_customers_all(
532: p_search_criteria => l_search_criteria_tbl
533: ,x_customer_tbl => l_customer_tbl
534: ,x_rec_count => x_rec_count
535: ,x_return_status => x_return_status

Line 568: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;

564: ,x_rec_count OUT NOCOPY NUMBER
565: ,x_return_status OUT NOCOPY VARCHAR2
566: )
567: IS
568: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
569: l_cust_price_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;
570:
571: BEGIN
572: l_hdr_rec.org_id := p_hdr_rec.org_id;

Line 569: l_cust_price_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;

565: ,x_return_status OUT NOCOPY VARCHAR2
566: )
567: IS
568: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
569: l_cust_price_tbl DPP_UTILITY_PVT.dpp_cust_price_tbl_type;
570:
571: BEGIN
572: l_hdr_rec.org_id := p_hdr_rec.org_id;
573: l_hdr_rec.effective_start_date := p_hdr_rec.effective_start_date;

Line 585: DPP_UTILITY_PVT.Get_LastPrice(

581: l_cust_price_tbl(i).price_change := p_cust_price_tbl(i).price_change;
582:
583: END LOOP;
584:
585: DPP_UTILITY_PVT.Get_LastPrice(
586: p_hdr_rec => l_hdr_rec
587: ,p_cust_price_tbl => l_cust_price_tbl
588: ,x_rec_count => x_rec_count
589: ,x_return_status => x_return_status

Line 621: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;

617: ,x_rec_count OUT NOCOPY NUMBER
618: ,x_return_status OUT NOCOPY VARCHAR2
619: )
620: IS
621: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
622: l_listprice_tbl DPP_UTILITY_PVT.dpp_list_price_tbl_type;
623: BEGIN
624: l_hdr_rec.org_id := p_hdr_rec.org_id;
625: l_hdr_rec.effective_start_date := p_hdr_rec.effective_start_date;

Line 622: l_listprice_tbl DPP_UTILITY_PVT.dpp_list_price_tbl_type;

618: ,x_return_status OUT NOCOPY VARCHAR2
619: )
620: IS
621: l_hdr_rec DPP_UTILITY_PVT.dpp_inv_hdr_rec_type;
622: l_listprice_tbl DPP_UTILITY_PVT.dpp_list_price_tbl_type;
623: BEGIN
624: l_hdr_rec.org_id := p_hdr_rec.org_id;
625: l_hdr_rec.effective_start_date := p_hdr_rec.effective_start_date;
626: l_hdr_rec.effective_end_date := p_hdr_rec.effective_end_date;

Line 634: DPP_UTILITY_PVT.Get_ListPrice(

630: l_listprice_tbl(i).Inventory_Item_ID := p_listprice_tbl(i).Inventory_Item_ID;
631:
632: END LOOP;
633:
634: DPP_UTILITY_PVT.Get_ListPrice(
635: p_hdr_rec => l_hdr_rec
636: ,p_listprice_tbl => l_listprice_tbl
637: ,x_rec_count => x_rec_count
638: ,x_return_status => x_return_status

Line 665: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;

661: ,x_rec_count OUT NOCOPY NUMBER
662: ,x_return_status OUT NOCOPY VARCHAR2
663: )
664: IS
665: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
666: BEGIN
667: l_vendor_rec.vendor_id := p_vendor_rec.vendor_id;
668:
669: DPP_UTILITY_PVT.Get_Vendor(

Line 669: DPP_UTILITY_PVT.Get_Vendor(

665: l_vendor_rec DPP_UTILITY_PVT.vendor_rec_type;
666: BEGIN
667: l_vendor_rec.vendor_id := p_vendor_rec.vendor_id;
668:
669: DPP_UTILITY_PVT.Get_Vendor(
670: p_vendor_rec => l_vendor_rec
671: ,x_rec_count => x_rec_count
672: ,x_return_status => x_return_status
673: );

Line 697: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;

693: ,x_rec_count OUT NOCOPY NUMBER
694: ,x_return_status OUT NOCOPY VARCHAR2
695: )
696: IS
697: l_vendor_site_rec DPP_UTILITY_PVT.vendor_site_rec_type;
698: BEGIN
699:
700: l_vendor_site_rec.vendor_id := p_vendor_site_rec.vendor_id;
701: l_vendor_site_rec.vendor_site_id := p_vendor_site_rec.vendor_site_id;

Line 703: DPP_UTILITY_PVT.Get_Vendor_Site(

699:
700: l_vendor_site_rec.vendor_id := p_vendor_site_rec.vendor_id;
701: l_vendor_site_rec.vendor_site_id := p_vendor_site_rec.vendor_site_id;
702:
703: DPP_UTILITY_PVT.Get_Vendor_Site(
704: p_vendor_site_rec => l_vendor_site_rec
705: ,x_rec_count => x_rec_count
706: ,x_return_status => x_return_status
707: );

Line 737: l_vendor_contact_rec DPP_UTILITY_PVT.vendor_contact_rec_type;

733: ,x_rec_count OUT NOCOPY NUMBER
734: ,x_return_status OUT NOCOPY VARCHAR2
735: )
736: IS
737: l_vendor_contact_rec DPP_UTILITY_PVT.vendor_contact_rec_type;
738: BEGIN
739:
740: l_vendor_contact_rec.vendor_site_id := p_vendor_contact_rec.vendor_site_id;
741: l_vendor_contact_rec.vendor_contact_id := p_vendor_contact_rec.vendor_contact_id;

Line 743: DPP_UTILITY_PVT.Get_Vendor_Contact(

739:
740: l_vendor_contact_rec.vendor_site_id := p_vendor_contact_rec.vendor_site_id;
741: l_vendor_contact_rec.vendor_contact_id := p_vendor_contact_rec.vendor_contact_id;
742:
743: DPP_UTILITY_PVT.Get_Vendor_Contact(
744: p_vendor_contact_rec => l_vendor_contact_rec
745: ,x_rec_count => x_rec_count
746: ,x_return_status => x_return_status
747: );

Line 776: l_warehouse_tbl DPP_UTILITY_PVT.warehouse_tbl_type;

772: ,x_return_status OUT NOCOPY VARCHAR2
773: )
774: IS
775:
776: l_warehouse_tbl DPP_UTILITY_PVT.warehouse_tbl_type;
777: BEGIN
778:
779: FOR i IN p_warehouse_tbl.FIRST..p_warehouse_tbl.LAST LOOP
780: l_warehouse_tbl(i).warehouse_id := p_warehouse_tbl(i).warehouse_id;

Line 783: DPP_UTILITY_PVT.Get_Warehouse(

779: FOR i IN p_warehouse_tbl.FIRST..p_warehouse_tbl.LAST LOOP
780: l_warehouse_tbl(i).warehouse_id := p_warehouse_tbl(i).warehouse_id;
781: END LOOP;
782:
783: DPP_UTILITY_PVT.Get_Warehouse(
784: p_warehouse_tbl => l_warehouse_tbl
785: ,x_rec_count => x_rec_count
786: ,x_return_status => x_return_status
787: );

Line 815: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;

811: ,x_return_status OUT NOCOPY VARCHAR2
812: )
813: IS
814:
815: l_customer_tbl DPP_UTILITY_PVT.customer_tbl_type;
816: BEGIN
817:
818: FOR i IN p_customer_tbl.FIRST..p_customer_tbl.LAST LOOP
819: l_customer_tbl(i).customer_id := p_customer_tbl(i).customer_id;

Line 822: DPP_UTILITY_PVT.Get_Customer(

818: FOR i IN p_customer_tbl.FIRST..p_customer_tbl.LAST LOOP
819: l_customer_tbl(i).customer_id := p_customer_tbl(i).customer_id;
820: END LOOP;
821:
822: DPP_UTILITY_PVT.Get_Customer(
823: p_customer_tbl => l_customer_tbl
824: ,x_rec_count => x_rec_count
825: ,x_return_status => x_return_status
826: );

Line 855: l_item_tbl DPP_UTILITY_PVT.item_tbl_type;

851: ,x_return_status OUT NOCOPY VARCHAR2
852: )
853: IS
854:
855: l_item_tbl DPP_UTILITY_PVT.item_tbl_type;
856: BEGIN
857:
858: FOR i IN p_item_tbl.FIRST..p_item_tbl.LAST LOOP
859: l_item_tbl(i).inventory_item_id := p_item_tbl(i).inventory_item_id;

Line 862: DPP_UTILITY_PVT.Get_Product(

858: FOR i IN p_item_tbl.FIRST..p_item_tbl.LAST LOOP
859: l_item_tbl(i).inventory_item_id := p_item_tbl(i).inventory_item_id;
860: END LOOP;
861:
862: DPP_UTILITY_PVT.Get_Product(
863: p_item_tbl => l_item_tbl
864: ,p_org_id => p_org_id
865: ,x_rec_count => x_rec_count
866: ,x_return_status => x_return_status

Line 1071: --Call Dpp_utility_pvt.convert_currency

1067: BEGIN
1068: --Clearing the msg stack and Initialize the message stack.
1069: fnd_message.clear();
1070: FND_MSG_PUB.initialize;
1071: --Call Dpp_utility_pvt.convert_currency
1072: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
1073: ,p_to_currency => p_to_currency
1074: ,p_conv_type => FND_API.G_MISS_CHAR
1075: ,p_conv_rate => FND_API.G_MISS_NUM

Line 1072: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency

1068: --Clearing the msg stack and Initialize the message stack.
1069: fnd_message.clear();
1070: FND_MSG_PUB.initialize;
1071: --Call Dpp_utility_pvt.convert_currency
1072: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
1073: ,p_to_currency => p_to_currency
1074: ,p_conv_type => FND_API.G_MISS_CHAR
1075: ,p_conv_rate => FND_API.G_MISS_NUM
1076: ,p_conv_date => sysdate