APPS.PO_RELGEN_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 6: PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE

2: /* $Header: porelgeb.pls 120.30.12020000.4 2013/04/05 08:34:17 jemishra 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 368: UPDATE po_distributions_all pda

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

Line 625: UPDATE po_distributions_all pda

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