DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on STANDARD

Line 351: --Function: standard po lines cannot be updated. So if the new line in

347:
348: -----------------------------------------------------------------------
349: --Start of Comments
350: --Name: reject_dup_lines_for_spo
351: --Function: standard po lines cannot be updated. So if the new line in
352: -- interface table has the same line num as existing lines in
353: -- same document, these new lines will be regarded as intention
354: -- to update existing standard po records thus rejected.
355: --Parameters:

Line 354: -- to update existing standard po records thus rejected.

350: --Name: reject_dup_lines_for_spo
351: --Function: standard po lines cannot be updated. So if the new line in
352: -- interface table has the same line num as existing lines in
353: -- same document, these new lines will be regarded as intention
354: -- to update existing standard po records thus rejected.
355: --Parameters:
356: --IN:
357: --IN OUT:
358: --OUT:

Line 806: -- standard who columns

802: intf_lines.process_code,
803: NULL, -- parent_interface_line_id -- bug5149827
804: intf_lines.file_line_language, -- bug 5489942
805:
806: -- standard who columns
807: intf_lines.last_updated_by,
808: intf_lines.last_update_date,
809: intf_lines.last_update_login,
810: intf_lines.creation_date,

Line 864: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

860: intf_lines.clm_option_num,
861: intf_lines.clm_option_from_date,
862: intf_lines.clm_option_to_date,
863: Decode(PO_PDOI_PARAMS.g_request.document_type,
864: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
865: intf_lines.clm_idc_type),
866: intf_lines.line_num_display,
867: intf_lines.clm_funded_flag,
868: intf_lines.user_document_status,

Line 991: -- standard who columns

987: intf_lines.process_code,
988: NULL, -- parent_interface_line_id -- bug5149827
989: intf_lines.file_line_language, -- bug 5489942
990:
991: -- standard who columns
992: intf_lines.last_updated_by,
993: intf_lines.last_update_date,
994: intf_lines.last_update_login,
995: intf_lines.creation_date,

Line 1048: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

1044: intf_lines.clm_option_num,
1045: intf_lines.clm_option_from_date,
1046: intf_lines.clm_option_to_date,
1047: Decode(PO_PDOI_PARAMS.g_request.document_type,
1048: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1049: intf_lines.clm_idc_type),
1050: intf_lines.line_num_display,
1051: intf_lines.clm_funded_flag,
1052: intf_lines.user_document_status,

Line 1085: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

1081: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
1082: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
1083: AND intf_lines.interface_line_id > p_max_intf_line_id
1084: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
1085: AND PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
1086: --PDOI CLM Integration
1087: --Process only priced lines which in commercial flow are normal lines
1088: AND Nvl(intf_lines.clm_info_flag,'N') = 'N'
1089: ORDER BY 1;

Line 1177: -- standard who columns

1173: intf_lines.process_code,
1174: NULL, -- parent_interface_line_id -- bug5149827
1175: intf_lines.file_line_language, -- bug 5489942
1176:
1177: -- standard who columns
1178: intf_lines.last_updated_by,
1179: intf_lines.last_update_date,
1180: intf_lines.last_update_login,
1181: intf_lines.creation_date,

Line 1234: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

1230: intf_lines.clm_option_num,
1231: intf_lines.clm_option_from_date,
1232: intf_lines.clm_option_to_date,
1233: Decode(PO_PDOI_PARAMS.g_request.document_type,
1234: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1235: intf_lines.clm_idc_type),
1236: intf_lines.line_num_display,
1237: intf_lines.clm_funded_flag,
1238: intf_lines.user_document_status,

Line 1366: -- standard who columns

1362: intf_lines.process_code,
1363: NULL, -- parent_interface_line_id -- bug5149827
1364: intf_lines.file_line_language, -- bug 5489942
1365:
1366: -- standard who columns
1367: intf_lines.last_updated_by,
1368: intf_lines.last_update_date,
1369: intf_lines.last_update_login,
1370: intf_lines.creation_date,

Line 1424: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

1420: intf_lines.clm_option_num,
1421: intf_lines.clm_option_from_date,
1422: intf_lines.clm_option_to_date,
1423: Decode(PO_PDOI_PARAMS.g_request.document_type,
1424: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1425: intf_lines.clm_idc_type),
1426: intf_lines.line_num_display,
1427: intf_lines.clm_funded_flag,
1428: intf_lines.user_document_status,

Line 1560: -- standard who columns

1556: intf_lines.process_code,
1557: NULL, -- parent_interface_line_id -- bug5149827
1558: intf_lines.file_line_language, -- bug 5489942
1559:
1560: -- standard who columns
1561: intf_lines.last_updated_by,
1562: intf_lines.last_update_date,
1563: intf_lines.last_update_login,
1564: intf_lines.creation_date,

Line 1617: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),

1613: intf_lines.clm_option_num,
1614: intf_lines.clm_option_from_date,
1615: intf_lines.clm_option_to_date,
1616: Decode(PO_PDOI_PARAMS.g_request.document_type,
1617: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD, Nvl(intf_lines.clm_idc_type,'IDC_NA'),
1618: intf_lines.clm_idc_type),
1619: intf_lines.line_num_display,
1620: intf_lines.clm_funded_flag,
1621: intf_lines.user_document_status,

Line 1755: -- standard who columns

1751: intf_lines.process_code,
1752: NULL, -- parent_interface_line_id
1753: intf_lines.file_line_language,
1754:
1755: -- standard who columns
1756: intf_lines.last_updated_by,
1757: intf_lines.last_update_date,
1758: intf_lines.last_update_login,
1759: intf_lines.creation_date,

Line 1985: -- standard who columns

1981: x_lines.process_code_tbl,
1982: x_lines.parent_interface_line_id_tbl, -- bug5149827
1983: x_lines.file_line_language_tbl, -- bug 5489942
1984:
1985: -- standard who columns
1986: x_lines.last_updated_by_tbl,
1987: x_lines.last_update_date_tbl,
1988: x_lines.last_update_login_tbl,
1989: x_lines.creation_date_tbl,

Line 3298: -- the following default logic is for BLANKET/STANDARD only

3294: END IF;
3295:
3296: d_position := 70;
3297:
3298: -- the following default logic is for BLANKET/STANDARD only
3299: IF (PO_PDOI_PARAMS.g_request.document_type IN
3300: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3301: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
3302: d_position := 80;

Line 3301: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

3297:
3298: -- the following default logic is for BLANKET/STANDARD only
3299: IF (PO_PDOI_PARAMS.g_request.document_type IN
3300: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3301: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
3302: d_position := 80;
3303:
3304: IF (PO_LOG.d_stmt) THEN
3305: PO_LOG.stmt(d_module, d_position, 'set default value for blanket/spo');

Line 3313: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN -- bug 9374205

3309: IF (x_lines.list_price_per_unit_tbl(i) IS NULL) THEN
3310: IF (x_lines.item_id_tbl(i) IS NULL) THEN
3311: x_lines.list_price_per_unit_tbl(i) := x_lines.unit_price_tbl(i);
3312: IF (PO_PDOI_PARAMS.g_request.document_type =
3313: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN -- bug 9374205
3314: -- bug 9194215
3315: If x_lines.hd_currency_code_tbl(i) is not null and (x_lines.list_price_per_unit_tbl(i) is not null and x_lines.list_price_per_unit_tbl(i) <> 0) THEN
3316: fnd_currency.get_info (x_lines.hd_currency_code_tbl(i),
3317: x_precision,

Line 3450: -- call utility method to default standard who columns

3446: );
3447:
3448: d_position := 110;
3449:
3450: -- call utility method to default standard who columns
3451: PO_PDOI_MAINPROC_UTL_PVT.default_who_columns
3452: (
3453: x_last_update_date_tbl => x_lines.last_update_date_tbl,
3454: x_last_updated_by_tbl => x_lines.last_updated_by_tbl,

Line 3658: -- 'ORIGINAL' or 'REPLACE' or 'UPDATE Standard PO'

3654: --Start of Comments
3655: --Name: match_lines
3656: --Function: perform matching logic on line num and item related info;
3657: -- This procedure is called only when the document action is
3658: -- 'ORIGINAL' or 'REPLACE' or 'UPDATE Standard PO'
3659: --Parameters:
3660: --IN:
3661: --IN OUT:
3662: -- x_lines

Line 3923: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

3919: (x_lines.quantity_tbl(i) > 0 OR x_lines.shipment_num_tbl(i) IS NOT NULL)) THEN
3920: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3921: END IF;
3922: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
3923: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
3924: IF (x_lines.order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') OR
3925: x_lines.quantity_tbl(i) > 0) THEN
3926: x_lines.create_line_loc_tbl(i) := FND_API.g_TRUE;
3927: END IF;

Line 7280: -- copy standard who columns

7276: x_target_lines.clm_info_flag_tbl(l_target_index) := p_source_lines.clm_info_flag_tbl(l_source_index); /* 10354034 */
7277:
7278: d_position := 30;
7279:
7280: -- copy standard who columns
7281: x_target_lines.last_updated_by_tbl(l_target_index) := p_source_lines.last_updated_by_tbl(l_source_index);
7282: x_target_lines.last_update_date_tbl(l_target_index) := p_source_lines.last_update_date_tbl(l_source_index);
7283: x_target_lines.last_update_login_tbl(l_target_index) := p_source_lines.last_update_login_tbl(l_source_index);
7284: x_target_lines.creation_date_tbl(l_target_index) := p_source_lines.creation_date_tbl(l_source_index);