APPS.FV_AP_CANCEL_PKG dependencies on PO_LINE_LOCATIONS

Line 10: l_line_location_id po_line_locations_all.line_location_id%type;

6: P_Return_Code OUT NOCOPY VARCHAR2 ) return BOOLEAN IS
7:
8: l_module_name VARCHAR2(200) := g_module_name || 'OPEN_PO_SHIPMENT';
9: l_errbuf VARCHAR2(1024);
10: l_line_location_id po_line_locations_all.line_location_id%type;
11: l_po_line_id po_lines_all.po_line_id%type;
12: l_po_header_id po_headers_all.po_header_id%type;
13: l_po_doc_type po_headers.type_lookup_code%type;
14: l_po_sub_type po_headers.type_lookup_code%type;

Line 44: po_line_locations pll -- Bug 3706938

40: FROM po_distributions pd,
41: po_headers ph,
42: po_releases pr,
43: ap_invoice_distributions aid,
44: po_line_locations pll -- Bug 3706938
45: WHERE aid.invoice_id = P_invoice_id
46: AND aid.po_distribution_id = pd.po_distribution_id
47: AND ph.po_header_id = pd.po_header_id
48: AND ph.po_header_id = pll.po_header_id -- Bug 3706938

Line 92: p_entity_type => 'PO_LINE_LOCATIONS',

88: l_po_line_loc_tab(l_po_line_loc_tab.last) := l_line_location_id;
89:
90: PO_AP_INVOICE_MATCH_GRP.set_final_match_flag
91: (p_api_version => '1.0',
92: p_entity_type => 'PO_LINE_LOCATIONS',
93: p_entity_id_tbl => l_po_line_loc_tab,
94: p_final_match_flag => 'N',
95: p_init_msg_list => FND_API.G_FALSE ,
96: p_commit => FND_API.G_FALSE ,