DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on RCV_TABLE_FUNCTIONS

Line 7637: l_pol_item_id := nvl(rcv_table_functions.get_pol_row_from_id(x_cascaded_table(n).po_line_id).item_id,-999);

7633: * not during the receipt of ASN. In order to bypass item validation for ASN added the
7634: * condition ' AND rcv_roi_header.g_txn_against_asn = 'N' '
7635: */
7636: IF rcv_roi_header.g_txn_against_asn = 'Y' THEN
7637: l_pol_item_id := nvl(rcv_table_functions.get_pol_row_from_id(x_cascaded_table(n).po_line_id).item_id,-999);
7638: IF x_cascaded_table(n).item_id <> l_pol_item_id THEN
7639: l_asn_sub_item_txn := 'Y';
7640: ELSE
7641: l_asn_sub_item_txn := 'N';

Line 17196: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(x_cascaded_table(n).to_organization_id);

17192: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
17193: RETURN;
17194: END IF;
17195:
17196: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(x_cascaded_table(n).to_organization_id);
17197: l_lcm_shipment_flag := rcv_table_functions.is_lcm_shipment (x_cascaded_table(n).po_line_location_id);
17198:
17199: IF (g_asn_debug = 'Y') THEN
17200: asn_debug.put_line('x_cascaded_table(n).to_organization_id ' || x_cascaded_table(n).to_organization_id);

Line 17197: l_lcm_shipment_flag := rcv_table_functions.is_lcm_shipment (x_cascaded_table(n).po_line_location_id);

17193: RETURN;
17194: END IF;
17195:
17196: l_pre_rcv_flag := rcv_table_functions.is_pre_rcv_org(x_cascaded_table(n).to_organization_id);
17197: l_lcm_shipment_flag := rcv_table_functions.is_lcm_shipment (x_cascaded_table(n).po_line_location_id);
17198:
17199: IF (g_asn_debug = 'Y') THEN
17200: asn_debug.put_line('x_cascaded_table(n).to_organization_id ' || x_cascaded_table(n).to_organization_id);
17201: asn_debug.put_line('l_pre_rcv_flag => ' || l_pre_rcv_flag);