eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_PDOI_PARAMS

Line 276: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

272: -- blanket dist columns
273: NULL -- po_dist_id -- bug5252250
274:
275: FROM po_headers_interface
276: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
277: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
278: AND interface_header_id > p_max_intf_header_id
279: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
280: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

Line 277: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num

273: NULL -- po_dist_id -- bug5252250
274:
275: FROM po_headers_interface
276: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
277: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
278: AND interface_header_id > p_max_intf_header_id
279: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
280: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
281: ORDER by interface_header_id;

Line 645: IF (PO_PDOI_PARAMS.g_request.document_type =

641:
642: d_position := 90;
643:
644: -- derive from_header_id from from_rfq_num for QUOTATION
645: IF (PO_PDOI_PARAMS.g_request.document_type =
646: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
647: IF (PO_LOG.d_stmt) THEN
648: PO_LOG.stmt(d_module, d_position, 'derive from header id');
649: END IF;

Line 893: IF (PO_PDOI_PARAMS.g_request.document_type =

889:
890: x_headers.error_flag_tbl(i) := FND_API.g_TRUE;
891: END IF;
892:
893: IF (PO_PDOI_PARAMS.g_request.document_type =
894: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
895: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
896: x_headers.from_header_id_tbl(i) IS NULL) THEN
897: IF (PO_LOG.d_stmt) THEN

Line 1082: IF (PO_PDOI_PARAMS.g_request.document_type IN

1078:
1079:
1080:
1081: -- default created_language for Blanket and Quotation
1082: IF (PO_PDOI_PARAMS.g_request.document_type IN
1083: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1084: x_headers.created_language_tbl(i) :=
1085: NVL(x_headers.created_language_tbl(i), USERENV('LANG'));
1086: END IF;

Line 1090: NVL(x_headers.agent_id_tbl(i), PO_PDOI_PARAMS.g_request.buyer_id);

1086: END IF;
1087:
1088: -- default agent_id
1089: x_headers.agent_id_tbl(i) :=
1090: NVL(x_headers.agent_id_tbl(i), PO_PDOI_PARAMS.g_request.buyer_id);
1091:
1092: -- default document_type_code
1093: x_headers.doc_type_tbl(i) :=
1094: NVL(x_headers.doc_type_tbl(i), PO_PDOI_PARAMS.g_request.document_type);

Line 1094: NVL(x_headers.doc_type_tbl(i), PO_PDOI_PARAMS.g_request.document_type);

1090: NVL(x_headers.agent_id_tbl(i), PO_PDOI_PARAMS.g_request.buyer_id);
1091:
1092: -- default document_type_code
1093: x_headers.doc_type_tbl(i) :=
1094: NVL(x_headers.doc_type_tbl(i), PO_PDOI_PARAMS.g_request.document_type);
1095:
1096: -- default fob_lookup_code
1097: x_headers.fob_tbl(i) :=
1098: COALESCE(x_headers.fob_tbl(i), l_site_fob_tbl(i),

Line 1099: PO_PDOI_PARAMS.g_sys.fob_lookup_code);

1095:
1096: -- default fob_lookup_code
1097: x_headers.fob_tbl(i) :=
1098: COALESCE(x_headers.fob_tbl(i), l_site_fob_tbl(i),
1099: PO_PDOI_PARAMS.g_sys.fob_lookup_code);
1100:
1101: -- default freight_carrier(ship_via_lookup_code)
1102: x_headers.freight_carrier_tbl(i) :=
1103: COALESCE(x_headers.freight_carrier_tbl(i), l_site_freight_carrier_tbl(i),

Line 1104: PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);

1100:
1101: -- default freight_carrier(ship_via_lookup_code)
1102: x_headers.freight_carrier_tbl(i) :=
1103: COALESCE(x_headers.freight_carrier_tbl(i), l_site_freight_carrier_tbl(i),
1104: PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
1105:
1106: -- default freight_terms
1107: x_headers.freight_term_tbl(i) :=
1108: COALESCE(x_headers.freight_term_tbl(i), l_site_freight_term_tbl(i),

Line 1109: PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);

1105:
1106: -- default freight_terms
1107: x_headers.freight_term_tbl(i) :=
1108: COALESCE(x_headers.freight_term_tbl(i), l_site_freight_term_tbl(i),
1109: PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
1110:
1111: -- default terms_id
1112: x_headers.terms_id_tbl(i) :=
1113: COALESCE(x_headers.terms_id_tbl(i), l_site_terms_id_tbl(i),

Line 1123: PO_PDOI_PARAMS.g_sys.ship_to_location_id);

1119:
1120: -- default ship_to_location_id
1121: x_headers.ship_to_loc_id_tbl(i) :=
1122: COALESCE(x_headers.ship_to_loc_id_tbl(i), l_site_ship_to_loc_id_tbl(i),
1123: PO_PDOI_PARAMS.g_sys.ship_to_location_id);
1124:
1125: -- default bill_to_location_id
1126: x_headers.bill_to_loc_id_tbl(i) :=
1127: COALESCE(x_headers.bill_to_loc_id_tbl(i), l_site_bill_to_loc_id_tbl(i),

Line 1128: PO_PDOI_PARAMS.g_sys.bill_to_location_id);

1124:
1125: -- default bill_to_location_id
1126: x_headers.bill_to_loc_id_tbl(i) :=
1127: COALESCE(x_headers.bill_to_loc_id_tbl(i), l_site_bill_to_loc_id_tbl(i),
1128: PO_PDOI_PARAMS.g_sys.bill_to_location_id);
1129:
1130: x_headers.global_agreement_flag_tbl(i) :=
1131: NVL(x_headers.global_agreement_flag_tbl(i), PO_PDOI_PARAMS.g_request.ga_flag);
1132:

Line 1131: NVL(x_headers.global_agreement_flag_tbl(i), PO_PDOI_PARAMS.g_request.ga_flag);

1127: COALESCE(x_headers.bill_to_loc_id_tbl(i), l_site_bill_to_loc_id_tbl(i),
1128: PO_PDOI_PARAMS.g_sys.bill_to_location_id);
1129:
1130: x_headers.global_agreement_flag_tbl(i) :=
1131: NVL(x_headers.global_agreement_flag_tbl(i), PO_PDOI_PARAMS.g_request.ga_flag);
1132:
1133: -- default style_id
1134: IF (x_headers.doc_type_tbl(i) = 'QUOTATION' OR
1135: (x_headers.doc_type_tbl(i) = 'BLANKET' AND x_headers.global_agreement_flag_tbl(i) = 'N'))

Line 1148: NVL(x_headers.approval_status_tbl(i), PO_PDOI_PARAMS.g_request.approved_status);

1144: x_headers.pay_on_code_tbl(i) := l_site_pay_on_code_tbl(i);
1145:
1146: -- default approval_status
1147: x_headers.approval_status_tbl(i) :=
1148: NVL(x_headers.approval_status_tbl(i), PO_PDOI_PARAMS.g_request.approved_status);
1149:
1150: -- bug4911383
1151: -- If intended approval status = 'APPROVED', it cannot require signature
1152:

Line 1154: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */

1150: -- bug4911383
1151: -- If intended approval status = 'APPROVED', it cannot require signature
1152:
1153: x_headers.acceptance_required_flag_tbl(i) :=
1154: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */
1155:
1156:
1157: IF (x_headers.approval_status_tbl(i) = 'APPROVED' AND
1158: x_headers.acceptance_required_flag_tbl(i) = 'S') THEN

Line 1171: l_vendor_invoice_curr_code_tbl(i), PO_PDOI_PARAMS.g_sys.currency_code);

1167: -- defaulting
1168: -- default currency_code
1169: x_headers.currency_code_tbl(i) :=
1170: COALESCE(x_headers.currency_code_tbl(i), l_site_invoice_curr_code_tbl(i),
1171: l_vendor_invoice_curr_code_tbl(i), PO_PDOI_PARAMS.g_sys.currency_code);
1172:
1173: d_position := 60;
1174:
1175: -- default attributes for each document type

Line 1179: NVL(x_headers.doc_subtype_tbl(i), PO_PDOI_PARAMS.g_request.document_subtype);

1175: -- default attributes for each document type
1176: IF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1177: -- default document sub-type
1178: x_headers.doc_subtype_tbl(i) :=
1179: NVL(x_headers.doc_subtype_tbl(i), PO_PDOI_PARAMS.g_request.document_subtype);
1180:
1181: -- set quotation_class_code
1182: x_headers.quotation_class_code_tbl(i) :=
1183: PO_PDOI_MAINPROC_UTL_PVT.get_quotation_class_code

Line 1199: PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);

1195:
1196: -- default quote_warning_delay
1197: x_headers.quote_warning_delay_tbl(i) :=
1198: NVL(x_headers.quote_warning_delay_tbl(i),
1199: PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
1200:
1201: -- default approval_required_flag
1202: x_headers.approval_required_flag_tbl(i) :=
1203: NVL(x_headers.approval_required_flag_tbl(i), 'N');

Line 1248: IF (PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'AUTOMATIC') THEN

1244: -- but a temp value used to insert record into draft table
1245:
1246: -- if document num assigning method is 'AUTOMATIC', always overwrite
1247: -- user's document num input
1248: IF (PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'AUTOMATIC') THEN
1249:
1250: d_position := 80;
1251:
1252: -- bug5028275

Line 1279: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */

1275: NVL(x_headers.confirming_order_flag_tbl(i), 'N');
1276:
1277: -- default acceptance_required_flag
1278: x_headers.acceptance_required_flag_tbl(i) :=
1279: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */
1280:
1281: -- default min_release_amount
1282: x_headers.min_release_amount_tbl(i) :=
1283: NVL(x_headers.min_release_amount_tbl(i),

Line 1284: PO_PDOI_PARAMS.g_sys.min_rel_amount);

1280:
1281: -- default min_release_amount
1282: x_headers.min_release_amount_tbl(i) :=
1283: NVL(x_headers.min_release_amount_tbl(i),
1284: PO_PDOI_PARAMS.g_sys.min_rel_amount);
1285:
1286: -- default closed_code
1287: x_headers.closed_code_tbl(i) := NVL(x_headers.closed_code_tbl(i), 'OPEN');
1288:

Line 1321: IF (PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'AUTOMATIC') THEN

1317: -- but a temp value used to insert record into draft table
1318:
1319: -- if document num assigning method is 'AUTOMATIC', always overwrite
1320: -- user's document num input
1321: IF (PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'AUTOMATIC') THEN
1322:
1323: d_position := 120;
1324:
1325: -- bug5028275

Line 1349: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */

1345: NVL(x_headers.confirming_order_flag_tbl(i), 'N');
1346:
1347: -- default acceptance_required_flag
1348: x_headers.acceptance_required_flag_tbl(i) :=
1349: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */
1350:
1351: -- default closed_code
1352: x_headers.closed_code_tbl(i) := NVL(x_headers.closed_code_tbl(i), 'OPEN');
1353:

Line 1391: IF (PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'AUTOMATIC') THEN

1387: -- but a temp value used to insert record into draft table
1388:
1389: -- if document num assigning method is 'AUTOMATIC', always overwrite
1390: -- user's document num input
1391: IF (PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'AUTOMATIC') THEN
1392:
1393: -- bug5028275
1394: -- assign document number only if the user has not provided any
1395: IF (x_headers.document_num_tbl(i) IS NULL) THEN

Line 1410: IF (x_headers.currency_code_tbl(i) <> PO_PDOI_PARAMS.g_sys.currency_code) THEN

1406:
1407: d_position := 160;
1408:
1409: -- default rate info after currency is defaulted
1410: IF (x_headers.currency_code_tbl(i) <> PO_PDOI_PARAMS.g_sys.currency_code) THEN
1411: IF (PO_LOG.d_stmt) THEN
1412: PO_LOG.stmt(d_module, d_position, 'default rate info');
1413: PO_LOG.stmt(d_module, d_position, 'currency_code',
1414: x_headers.currency_code_tbl(i));

Line 1424: x_to_currency => PO_PDOI_PARAMS.g_sys.currency_code,

1420: -- default rate_type
1421: IF (GL_CURRENCY_API.is_fixed_rate
1422: (
1423: x_from_currency => x_headers.currency_code_tbl(i),
1424: x_to_currency => PO_PDOI_PARAMS.g_sys.currency_code,
1425: x_effective_date => x_headers.rate_date_tbl(i)
1426: ) = 'Y') THEN
1427: x_headers.rate_type_code_tbl(i) := 'EMU FIXED'; --bug 7653758
1428: ELSE

Line 1430: NVL(x_headers.rate_type_code_tbl(i), PO_PDOI_PARAMS.g_sys.default_rate_type); --bug 7653758

1426: ) = 'Y') THEN
1427: x_headers.rate_type_code_tbl(i) := 'EMU FIXED'; --bug 7653758
1428: ELSE
1429: x_headers.rate_type_code_tbl(i) :=
1430: NVL(x_headers.rate_type_code_tbl(i), PO_PDOI_PARAMS.g_sys.default_rate_type); --bug 7653758
1431: END IF;
1432:
1433: IF (PO_LOG.d_stmt) THEN
1434: PO_LOG.stmt(d_module, d_position, 'rate type',

Line 1445: x_set_of_books_id => PO_PDOI_PARAMS.g_sys.sob_id,

1441: IF (x_headers.rate_tbl(i) IS NULL OR
1442: x_headers.rate_type_code_tbl(i) = 'EMU FIXED') THEN --bug 7653758
1443: po_currency_sv.get_rate
1444: (
1445: x_set_of_books_id => PO_PDOI_PARAMS.g_sys.sob_id,
1446: x_currency_code => x_headers.currency_code_tbl(i),
1447: x_rate_type => x_headers.rate_type_code_tbl(i), --bug 7653758
1448: x_rate_date => x_headers.rate_date_tbl(i),
1449: x_inverse_rate_display_flag => 'N',

Line 1465: IF (PO_PDOI_PARAMS.g_request.document_type =

1461: d_position := 180;
1462:
1463: -- default the distribution related fields for a Blanket if
1464: -- encumbrance is required on this document
1465: IF (PO_PDOI_PARAMS.g_request.document_type =
1466: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1467: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1468: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1469: IF (PO_LOG.d_stmt) THEN

Line 1467: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND

1463: -- default the distribution related fields for a Blanket if
1464: -- encumbrance is required on this document
1465: IF (PO_PDOI_PARAMS.g_request.document_type =
1466: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1467: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1468: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1469: IF (PO_LOG.d_stmt) THEN
1470: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||
1471: ' since encumbrance is required');

Line 1468: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN

1464: -- encumbrance is required on this document
1465: IF (PO_PDOI_PARAMS.g_request.document_type =
1466: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1467: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1468: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1469: IF (PO_LOG.d_stmt) THEN
1470: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||
1471: ' since encumbrance is required');
1472: END IF;

Line 1602: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416

1598:
1599: l_parameter_name_tbl.EXTEND(6);
1600: l_parameter_value_tbl.EXTEND(6);
1601: l_parameter_name_tbl(1) := 'INVENTORY_ORG_ID';
1602: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
1603: l_parameter_name_tbl(2) := 'SET_OF_BOOKS_ID';
1604: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
1605: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
1606: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;

Line 1604: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;

1600: l_parameter_value_tbl.EXTEND(6);
1601: l_parameter_name_tbl(1) := 'INVENTORY_ORG_ID';
1602: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
1603: l_parameter_name_tbl(2) := 'SET_OF_BOOKS_ID';
1604: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
1605: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
1606: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
1607: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
1608: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;

Line 1606: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;

1602: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
1603: l_parameter_name_tbl(2) := 'SET_OF_BOOKS_ID';
1604: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
1605: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
1606: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
1607: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
1608: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
1609: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
1610: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;

Line 1608: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;

1604: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
1605: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
1606: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
1607: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
1608: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
1609: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
1610: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;
1611: l_parameter_name_tbl(6) := 'MANUAL_QUOTE_NUM_TYPE';
1612: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;

Line 1610: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;

1606: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
1607: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
1608: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
1609: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
1610: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;
1611: l_parameter_name_tbl(6) := 'MANUAL_QUOTE_NUM_TYPE';
1612: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;
1613:
1614: d_position := 10;

Line 1612: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;

1608: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
1609: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
1610: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;
1611: l_parameter_name_tbl(6) := 'MANUAL_QUOTE_NUM_TYPE';
1612: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;
1613:
1614: d_position := 10;
1615:
1616: PO_VALIDATIONS.validate_pdoi(p_headers => l_headers,

Line 1617: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,

1613:
1614: d_position := 10;
1615:
1616: PO_VALIDATIONS.validate_pdoi(p_headers => l_headers,
1617: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,
1618: p_parameter_name_tbl => l_parameter_name_tbl,
1619: p_parameter_value_tbl => l_parameter_value_tbl,
1620: x_result_type => l_result_type,
1621: x_results => l_results);

Line 2813: AND DECODE(PO_PDOI_PARAMS.g_request.document_type,

2809: AND x_vendor_site_id_tbl(i) IS NULL
2810: AND vendor_id = p_vendor_id_tbl(i)
2811: AND purchasing_site_flag = 'Y'
2812: AND (sysdate) < nvl(inactive_date, TRUNC(sysdate + 1))
2813: AND DECODE(PO_PDOI_PARAMS.g_request.document_type,
2814: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION, 'N',
2815: NVL(rfq_only_site_flag, 'N')) <> 'Y'
2816: GROUP BY vendor_id
2817: HAVING count(vendor_site_id) = 1;

Line 3084: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,

3080: d_position := 20;
3081:
3082: PO_PERIODS_SV.get_period_name
3083: (
3084: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
3085: x_gl_date => x_headers.gl_encumbered_date_tbl(i),
3086: x_gl_period => x_headers.gl_encumbered_period_tbl(i)
3087: );
3088:

Line 3095: p_chart_of_accounts_id => PO_PDOI_PARAMS.g_sys.coa_id,

3091: -- default budget account id
3092: IF (x_headers.budget_account_id_tbl(i) IS NULL) THEN
3093: PO_PDOI_DIST_PROCESS_PVT.derive_account_id
3094: ( p_account_number => x_headers.budget_account_tbl(i),
3095: p_chart_of_accounts_id => PO_PDOI_PARAMS.g_sys.coa_id,
3096: p_account_segment1 => x_headers.budget_account_segment1_tbl(i),
3097: p_account_segment2 => x_headers.budget_account_segment2_tbl(i),
3098: p_account_segment3 => x_headers.budget_account_segment3_tbl(i),
3099: p_account_segment4 => x_headers.budget_account_segment4_tbl(i),