[Home] [Help]
228: intf_locs.transaction_flow_header_id, --NULL, -- txn_flow_header_id
229: --< Shared Proc 14223789 End >
230: NULL, -- tax_attribute_update_code
231:
232: -- standard who columns
233: intf_locs.last_updated_by,
234: intf_locs.last_update_date,
235: intf_locs.last_update_login,
236: intf_locs.creation_date,
413: x_line_locs.match_option_tbl,
414: x_line_locs.txn_flow_header_id_tbl,
415: x_line_locs.tax_attribute_update_code_tbl,
416:
417: -- standard who columns
418: x_line_locs.last_updated_by_tbl,
419: x_line_locs.last_update_date_tbl,
420: x_line_locs.last_update_login_tbl,
421: x_line_locs.creation_date_tbl,
612: d_position := 60;
613:
614: -- derive tax_name from tax_code_id
615: IF (PO_PDOI_PARAMS.g_request.document_type =
616: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
617: derive_tax_name
618: (
619: p_key => l_key,
620: p_index_tbl => l_index_tbl,
741: END IF;
742:
743: -- check derivation error for tax_name
744: IF (PO_PDOI_PARAMS.g_request.document_type =
745: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
746: IF (x_line_locs.tax_code_id_tbl(i) IS NOT NULL AND
747: x_line_locs.tax_name_tbl(i) IS NULL) THEN
748: IF (PO_LOG.d_stmt) THEN
749: PO_LOG.stmt(d_module, d_position, 'tax name derivation failed');
782: PO_LOG.stmt(d_module, d_position, 'x_line_locs.txn_flow_header_id_tbl(i)',
783: x_line_locs.txn_flow_header_id_tbl(i));
784: END IF;
785:
786: IF (x_line_locs.hd_doc_type_tbl(i) = 'STANDARD') AND
787: (x_line_locs.ship_to_org_id_tbl(i) IS NOT NULL) AND
788: (x_line_locs.txn_flow_header_id_tbl(i) IS NULL)
789: THEN
790: -- Validate ship-to Org, which gets txn flow header if one exists
824:
825: x_line_locs.error_flag_tbl(i) := FND_API.g_TRUE;
826: END IF;
827:
828: END IF; --
830: --< Shared Proc 14223789 End >
831:
832: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_DERIVE);
893: );
894:
895: -- handle default logic based on document types
896: IF (PO_PDOI_PARAMS.g_request.document_type =
897: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
898:
899: d_position := 10;
900:
901: default_locs_for_spo
929: END IF;
930:
931: d_position := 40;
932:
933: -- call utility method to default standard who columns
934: PO_PDOI_MAINPROC_UTL_PVT.default_who_columns
935: (
936: x_last_update_date_tbl => x_line_locs.last_update_date_tbl,
937: x_last_updated_by_tbl => x_line_locs.last_updated_by_tbl,
1198: -----------------------------------------------------------------------
1199: --Start of Comments
1200: --Name: update_amount_quantity_on_line
1201: --Function:
1202: -- Called when document type is Standard PO
1203: -- The procedure is to calculate the total of amount(quantity) of
1204: -- shipment lines for each po line, then set the total value back to
1205: -- po line record.
1206: --Parameters:
1787: -----------------------------------------------------------------------
1788: --Start of Comments
1789: --Name: default_locs_for_spo
1790: --Function:
1791: -- default logic on line location attributes for Standard PO
1792: --Parameters:
1793: --IN:
1794: --p_key
1795: -- identifier in the temp table on the derived result
1851: END IF;
1852:
1853: -- default shipment_type
1854: x_line_locs.shipment_type_tbl(i) :=
1855: NVL(x_line_locs.shipment_type_tbl(i),'STANDARD');
1856:
1857: -- default shipment_num if it is not provided or not unique
1858: IF (x_line_locs.shipment_num_tbl(i) IS NULL OR
1859: x_line_locs.shipment_num_unique_tbl(i) = 'N') THEN
1968: PO_LOG.stmt(d_module, d_position, 'second default index', i);
1969: END IF;
1970:
1971: -- default ship_to_organization_id from financial system parameter
1972: -- for STANDARD
1973: x_line_locs.ship_to_org_id_tbl(i) :=
1974: NVL(x_line_locs.ship_to_org_id_tbl(i),
1975: PO_PDOI_PARAMS.g_sys.def_inv_org_id);
1976: