[Home] [Help]
262:
263: -----------------------------------------------------------------------
264: --Start of Comments
265: --Name: reject_dup_lines_for_spo
266: --Function: standard po lines cannot be updated. So if the new line in
267: -- interface table has the same line num as existing lines in
268: -- same document, these new lines will be regarded as intention
269: -- to update existing standard po records thus rejected.
270: --Parameters:
265: --Name: reject_dup_lines_for_spo
266: --Function: standard po lines cannot be updated. So if the new line in
267: -- interface table has the same line num as existing lines in
268: -- same document, these new lines will be regarded as intention
269: -- to update existing standard po records thus rejected.
270: --Parameters:
271: --IN:
272: --IN OUT:
273: --OUT:
710: intf_lines.process_code,
711: NULL, -- parent_interface_line_id -- bug5149827
712: intf_lines.file_line_language, -- bug 5489942
713:
714: -- standard who columns
715: intf_lines.last_updated_by,
716: intf_lines.last_update_date,
717: intf_lines.last_update_login,
718: intf_lines.creation_date,
844: intf_lines.process_code,
845: NULL, -- parent_interface_line_id -- bug5149827
846: intf_lines.file_line_language, -- bug 5489942
847:
848: -- standard who columns
849: intf_lines.last_updated_by,
850: intf_lines.last_update_date,
851: intf_lines.last_update_login,
852: intf_lines.creation_date,
896: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
897: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
898: AND intf_lines.interface_line_id > p_max_intf_line_id
899: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
900: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
901: ORDER BY 1;
902: ELSIF (p_data_set_type = PO_PDOI_CONSTANTS.g_LINE_CSR_FORCE_ADD) THEN
903: d_position := 20;
904:
978: intf_lines.process_code,
979: NULL, -- parent_interface_line_id -- bug5149827
980: intf_lines.file_line_language, -- bug 5489942
981:
982: -- standard who columns
983: intf_lines.last_updated_by,
984: intf_lines.last_update_date,
985: intf_lines.last_update_login,
986: intf_lines.creation_date,
1115: intf_lines.process_code,
1116: NULL, -- parent_interface_line_id -- bug5149827
1117: intf_lines.file_line_language, -- bug 5489942
1118:
1119: -- standard who columns
1120: intf_lines.last_updated_by,
1121: intf_lines.last_update_date,
1122: intf_lines.last_update_login,
1123: intf_lines.creation_date,
1256: intf_lines.process_code,
1257: NULL, -- parent_interface_line_id -- bug5149827
1258: intf_lines.file_line_language, -- bug 5489942
1259:
1260: -- standard who columns
1261: intf_lines.last_updated_by,
1262: intf_lines.last_update_date,
1263: intf_lines.last_update_login,
1264: intf_lines.creation_date,
1445: x_lines.process_code_tbl,
1446: x_lines.parent_interface_line_id_tbl, -- bug5149827
1447: x_lines.file_line_language_tbl, -- bug 5489942
1448:
1449: -- standard who columns
1450: x_lines.last_updated_by_tbl,
1451: x_lines.last_update_date_tbl,
1452: x_lines.last_update_login_tbl,
1453: x_lines.creation_date_tbl,
2454: x_lines.from_line_id_tbl(i) := NULL;
2455:
2456: d_position := 70;
2457:
2458: -- the following default logic is for BLANKET/STANDARD only
2459: IF (PO_PDOI_PARAMS.g_request.document_type IN
2460: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2461: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
2462: d_position := 80;
2457:
2458: -- the following default logic is for BLANKET/STANDARD only
2459: IF (PO_PDOI_PARAMS.g_request.document_type IN
2460: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
2461: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
2462: d_position := 80;
2463:
2464: IF (PO_LOG.d_stmt) THEN
2465: PO_LOG.stmt(d_module, d_position, 'set default value for blanket/spo');
2593: );
2594:
2595: d_position := 110;
2596:
2597: -- call utility method to default standard who columns
2598: PO_PDOI_MAINPROC_UTL_PVT.default_who_columns
2599: (
2600: x_last_update_date_tbl => x_lines.last_update_date_tbl,
2601: x_last_updated_by_tbl => x_lines.last_updated_by_tbl,
2758: --Start of Comments
2759: --Name: match_lines
2760: --Function: perform matching logic on line num and item related info;
2761: -- This procedure is called only when the document action is
2762: -- 'ORIGINAL' or 'REPLACE' or 'UPDATE Standard PO'
2763: --Parameters:
2764: --IN:
2765: --IN OUT:
2766: -- x_lines
3023: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3024: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3025: END IF;
3026: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3027: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
3028: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR
3029: x_lines.quantity_tbl(i) > 0) THEN
3030: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3031: END IF;
6340: x_target_lines.parent_interface_line_id_tbl(l_target_index) := p_source_lines.parent_interface_line_id_tbl(l_source_index); -- bug5149827
6341:
6342: d_position := 30;
6343:
6344: -- copy standard who columns
6345: x_target_lines.last_updated_by_tbl(l_target_index) := p_source_lines.last_updated_by_tbl(l_source_index);
6346: x_target_lines.last_update_date_tbl(l_target_index) := p_source_lines.last_update_date_tbl(l_source_index);
6347: x_target_lines.last_update_login_tbl(l_target_index) := p_source_lines.last_update_login_tbl(l_source_index);
6348: x_target_lines.creation_date_tbl(l_target_index) := p_source_lines.creation_date_tbl(l_source_index);