APPS.PO_RELGEN_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 6: PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE

2: /* $Header: porelgeb.pls 120.16.12010000.7 2009/01/20 12:39:39 rakchakr ship $ */
3:
4: --
5: g_dest_type_code_SHOP_FLOOR CONSTANT
6: PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE
7: := 'SHOP FLOOR'
8: ;
9:
10: -- Bug 2701147 START

Line 367: UPDATE po_distributions_all pda

363: plla.lcm_flag = NULL
364: WHERE plla.po_release_id = x_po_release_id
365: AND plla.lcm_flag = 'Y';
366:
367: UPDATE po_distributions_all pda
368: SET pda.lcm_flag = NULL
369: WHERE pda.line_location_id = x_line_location_id
370: AND pda.lcm_flag = 'Y';
371:

Line 624: UPDATE po_distributions_all pda

620: plla.lcm_flag = NULL
621: WHERE plla.po_release_id = x_po_release_id
622: AND plla.lcm_flag = 'Y';
623:
624: UPDATE po_distributions_all pda
625: SET pda.lcm_flag = NULL
626: WHERE pda.line_location_id = x_line_location_id
627: AND pda.lcm_flag = 'Y';
628: