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 348: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

344: clm_source_document_disp,
345: null --draft_type
346:
347: FROM po_headers_interface
348: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
349: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
350: AND interface_header_id > p_max_intf_header_id
351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

Line 349: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num

345: null --draft_type
346:
347: FROM po_headers_interface
348: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
349: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
350: AND interface_header_id > p_max_intf_header_id
351: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
352: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
353: ORDER by interface_header_id;

Line 562: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id

558: clm_source_document_disp,
559: null --draft_type
560:
561: FROM po_headers_interface
562: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
563: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
564: AND po_header_id = p_intf_po_header_id
565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)

Line 563: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num

559: null --draft_type
560:
561: FROM po_headers_interface
562: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
563: AND processing_round_num = PO_PDOI_PARAMS.g_current_round_num
564: AND po_header_id = p_intf_po_header_id
565: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
566: PO_PDOI_CONSTANTS.g_ACTION_REPLACE)
567: ORDER by interface_header_id;

Line 959: IF (PO_PDOI_PARAMS.g_request.document_type =

955:
956: d_position := 90;
957:
958: -- derive from_header_id from from_rfq_num for QUOTATION
959: IF (PO_PDOI_PARAMS.g_request.document_type =
960: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module, d_position, 'derive from header id');
963: END IF;

Line 975: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

971: );
972: END IF;
973:
974: --CLM PDOI Integration Starts
975: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
976: THEN
977:
978: derive_clm_award_type
979: (

Line 1264: IF (PO_PDOI_PARAMS.g_request.document_type =

1260:
1261: x_headers.error_flag_tbl(i) := FND_API.g_TRUE;
1262: END IF;
1263:
1264: IF (PO_PDOI_PARAMS.g_request.document_type =
1265: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1266: IF (x_headers.from_rfq_num_tbl(i) IS NOT NULL AND
1267: x_headers.from_header_id_tbl(i) IS NULL) THEN
1268: IF (PO_LOG.d_stmt) THEN

Line 1291: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

1287: END IF;
1288: END IF;
1289:
1290: --CLM PDOI Integration Starts
1291: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1292: THEN
1293:
1294: IF (x_headers.clm_award_type_disp_tbl(i) IS NOT NULL AND
1295: x_headers.clm_award_type_tbl(i) IS NULL) THEN

Line 1551: IF (PO_PDOI_PARAMS.g_request.document_type IN

1547:
1548:
1549:
1550: -- default created_language for Blanket and Quotation
1551: IF (PO_PDOI_PARAMS.g_request.document_type IN
1552: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET, PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION)) THEN
1553: x_headers.created_language_tbl(i) :=
1554: NVL(x_headers.created_language_tbl(i), USERENV('LANG'));
1555: END IF;

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

1555: END IF;
1556:
1557: -- default agent_id
1558: x_headers.agent_id_tbl(i) :=
1559: NVL(x_headers.agent_id_tbl(i), PO_PDOI_PARAMS.g_request.buyer_id);
1560:
1561: -- default document_type_code
1562: x_headers.doc_type_tbl(i) :=
1563: NVL(x_headers.doc_type_tbl(i), PO_PDOI_PARAMS.g_request.document_type);

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

1559: NVL(x_headers.agent_id_tbl(i), PO_PDOI_PARAMS.g_request.buyer_id);
1560:
1561: -- default document_type_code
1562: x_headers.doc_type_tbl(i) :=
1563: NVL(x_headers.doc_type_tbl(i), PO_PDOI_PARAMS.g_request.document_type);
1564:
1565: -- default fob_lookup_code
1566: x_headers.fob_tbl(i) :=
1567: COALESCE(x_headers.fob_tbl(i), l_site_fob_tbl(i),

Line 1568: PO_PDOI_PARAMS.g_sys.fob_lookup_code);

1564:
1565: -- default fob_lookup_code
1566: x_headers.fob_tbl(i) :=
1567: COALESCE(x_headers.fob_tbl(i), l_site_fob_tbl(i),
1568: PO_PDOI_PARAMS.g_sys.fob_lookup_code);
1569:
1570: -- default freight_carrier(ship_via_lookup_code)
1571: x_headers.freight_carrier_tbl(i) :=
1572: COALESCE(x_headers.freight_carrier_tbl(i), l_site_freight_carrier_tbl(i),

Line 1573: PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);

1569:
1570: -- default freight_carrier(ship_via_lookup_code)
1571: x_headers.freight_carrier_tbl(i) :=
1572: COALESCE(x_headers.freight_carrier_tbl(i), l_site_freight_carrier_tbl(i),
1573: PO_PDOI_PARAMS.g_sys.ship_via_lookup_code);
1574:
1575: -- default freight_terms
1576: x_headers.freight_term_tbl(i) :=
1577: COALESCE(x_headers.freight_term_tbl(i), l_site_freight_term_tbl(i),

Line 1578: PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);

1574:
1575: -- default freight_terms
1576: x_headers.freight_term_tbl(i) :=
1577: COALESCE(x_headers.freight_term_tbl(i), l_site_freight_term_tbl(i),
1578: PO_PDOI_PARAMS.g_sys.freight_terms_lookup_code);
1579:
1580: -- default terms_id
1581: x_headers.terms_id_tbl(i) :=
1582: COALESCE(x_headers.terms_id_tbl(i), l_site_terms_id_tbl(i),

Line 1592: PO_PDOI_PARAMS.g_sys.ship_to_location_id);

1588:
1589: -- default ship_to_location_id
1590: x_headers.ship_to_loc_id_tbl(i) :=
1591: COALESCE(x_headers.ship_to_loc_id_tbl(i), l_site_ship_to_loc_id_tbl(i),
1592: PO_PDOI_PARAMS.g_sys.ship_to_location_id);
1593:
1594: -- default bill_to_location_id
1595: x_headers.bill_to_loc_id_tbl(i) :=
1596: COALESCE(x_headers.bill_to_loc_id_tbl(i), l_site_bill_to_loc_id_tbl(i),

Line 1597: PO_PDOI_PARAMS.g_sys.bill_to_location_id);

1593:
1594: -- default bill_to_location_id
1595: x_headers.bill_to_loc_id_tbl(i) :=
1596: COALESCE(x_headers.bill_to_loc_id_tbl(i), l_site_bill_to_loc_id_tbl(i),
1597: PO_PDOI_PARAMS.g_sys.bill_to_location_id);
1598:
1599: x_headers.global_agreement_flag_tbl(i) :=
1600: NVL(x_headers.global_agreement_flag_tbl(i), PO_PDOI_PARAMS.g_request.ga_flag);
1601:

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

1596: COALESCE(x_headers.bill_to_loc_id_tbl(i), l_site_bill_to_loc_id_tbl(i),
1597: PO_PDOI_PARAMS.g_sys.bill_to_location_id);
1598:
1599: x_headers.global_agreement_flag_tbl(i) :=
1600: NVL(x_headers.global_agreement_flag_tbl(i), PO_PDOI_PARAMS.g_request.ga_flag);
1601:
1602: -- default style_id
1603: IF (x_headers.doc_type_tbl(i) = 'QUOTATION' OR
1604: (x_headers.doc_type_tbl(i) = 'BLANKET' AND x_headers.global_agreement_flag_tbl(i) = 'N'))

Line 1607: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

1603: IF (x_headers.doc_type_tbl(i) = 'QUOTATION' OR
1604: (x_headers.doc_type_tbl(i) = 'BLANKET' AND x_headers.global_agreement_flag_tbl(i) = 'N'))
1605: THEN
1606: --CLM PDOI Integration
1607: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1608: THEN
1609: NULL;
1610: ELSE
1611: x_headers.style_id_tbl(i) := PO_DOC_STYLE_GRP.get_standard_doc_style;

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

1619: x_headers.pay_on_code_tbl(i) := l_site_pay_on_code_tbl(i);
1620:
1621: -- default approval_status
1622: x_headers.approval_status_tbl(i) :=
1623: NVL(x_headers.approval_status_tbl(i), PO_PDOI_PARAMS.g_request.approved_status);
1624:
1625: -- bug4911383
1626: -- If intended approval status = 'APPROVED', it cannot require signature
1627:

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

1625: -- bug4911383
1626: -- If intended approval status = 'APPROVED', it cannot require signature
1627:
1628: x_headers.acceptance_required_flag_tbl(i) :=
1629: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */
1630:
1631:
1632: IF (x_headers.approval_status_tbl(i) = 'APPROVED' AND
1633: x_headers.acceptance_required_flag_tbl(i) = 'S') THEN

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

1642: -- defaulting
1643: -- default currency_code
1644: x_headers.currency_code_tbl(i) :=
1645: COALESCE(x_headers.currency_code_tbl(i), l_site_invoice_curr_code_tbl(i),
1646: l_vendor_invoice_curr_code_tbl(i), PO_PDOI_PARAMS.g_sys.currency_code);
1647:
1648: d_position := 60;
1649:
1650: -- default attributes for each document type

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

1650: -- default attributes for each document type
1651: IF (x_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1652: -- default document sub-type
1653: x_headers.doc_subtype_tbl(i) :=
1654: NVL(x_headers.doc_subtype_tbl(i), PO_PDOI_PARAMS.g_request.document_subtype);
1655:
1656: -- set quotation_class_code
1657: x_headers.quotation_class_code_tbl(i) :=
1658: PO_PDOI_MAINPROC_UTL_PVT.get_quotation_class_code

Line 1674: PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);

1670:
1671: -- default quote_warning_delay
1672: x_headers.quote_warning_delay_tbl(i) :=
1673: NVL(x_headers.quote_warning_delay_tbl(i),
1674: PO_PDOI_PARAMS.g_sys.def_quote_warning_delay);
1675:
1676: -- default approval_required_flag
1677: x_headers.approval_required_flag_tbl(i) :=
1678: NVL(x_headers.approval_required_flag_tbl(i), 'N');

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

1719: -- but a temp value used to insert record into draft table
1720:
1721: -- if document num assigning method is 'AUTOMATIC', always overwrite
1722: -- user's document num input
1723: IF (PO_PDOI_PARAMS.g_sys.user_defined_quote_num_code = 'AUTOMATIC') THEN
1724:
1725: d_position := 80;
1726:
1727: -- bug5028275

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

1750: NVL(x_headers.confirming_order_flag_tbl(i), 'N');
1751:
1752: -- default acceptance_required_flag
1753: x_headers.acceptance_required_flag_tbl(i) :=
1754: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */
1755:
1756: -- default min_release_amount
1757: x_headers.min_release_amount_tbl(i) :=
1758: NVL(x_headers.min_release_amount_tbl(i),

Line 1759: PO_PDOI_PARAMS.g_sys.min_rel_amount);

1755:
1756: -- default min_release_amount
1757: x_headers.min_release_amount_tbl(i) :=
1758: NVL(x_headers.min_release_amount_tbl(i),
1759: PO_PDOI_PARAMS.g_sys.min_rel_amount);
1760:
1761: -- default closed_code
1762: x_headers.closed_code_tbl(i) := NVL(x_headers.closed_code_tbl(i), 'OPEN');
1763:

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

1792: -- but a temp value used to insert record into draft table
1793:
1794: -- if document num assigning method is 'AUTOMATIC', always overwrite
1795: -- user's document num input
1796: IF (PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'AUTOMATIC') THEN
1797:
1798: d_position := 120;
1799:
1800: -- bug5028275

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

1820: NVL(x_headers.confirming_order_flag_tbl(i), 'N');
1821:
1822: -- default acceptance_required_flag
1823: x_headers.acceptance_required_flag_tbl(i) :=
1824: NVL(x_headers.acceptance_required_flag_tbl(i), PO_PDOI_PARAMS.g_sys.acceptance_required_flag); /* Bug 7518967 : Default Acceptance Required Check ER */
1825:
1826: -- default closed_code
1827: x_headers.closed_code_tbl(i) := NVL(x_headers.closed_code_tbl(i), 'OPEN');
1828:

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

1862: -- but a temp value used to insert record into draft table
1863:
1864: -- if document num assigning method is 'AUTOMATIC', always overwrite
1865: -- user's document num input
1866: IF (PO_PDOI_PARAMS.g_sys.user_defined_po_num_code = 'AUTOMATIC') THEN
1867:
1868: -- bug5028275
1869: -- assign document number only if the user has not provided any
1870: IF (x_headers.document_num_tbl(i) IS NULL) THEN

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

1881:
1882: d_position := 160;
1883:
1884: -- default rate info after currency is defaulted
1885: IF (x_headers.currency_code_tbl(i) <> PO_PDOI_PARAMS.g_sys.currency_code) THEN
1886: IF (PO_LOG.d_stmt) THEN
1887: PO_LOG.stmt(d_module, d_position, 'default rate info');
1888: PO_LOG.stmt(d_module, d_position, 'currency_code',
1889: x_headers.currency_code_tbl(i));

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

1897: BEGIN
1898: IF (GL_CURRENCY_API.is_fixed_rate
1899: (
1900: x_from_currency => x_headers.currency_code_tbl(i),
1901: x_to_currency => PO_PDOI_PARAMS.g_sys.currency_code,
1902: x_effective_date => x_headers.rate_date_tbl(i)
1903: ) = 'Y') THEN
1904: x_headers.rate_type_code_tbl(i) := 'EMU FIXED'; --bug 7653758
1905: ELSE

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

1903: ) = 'Y') THEN
1904: x_headers.rate_type_code_tbl(i) := 'EMU FIXED'; --bug 7653758
1905: ELSE
1906: x_headers.rate_type_code_tbl(i) :=
1907: NVL(x_headers.rate_type_code_tbl(i), PO_PDOI_PARAMS.g_sys.default_rate_type); --bug 7653758
1908: END IF;
1909: EXCEPTION
1910: WHEN OTHERS THEN
1911: IF (PO_LOG.d_stmt) THEN

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

1924: IF (x_headers.rate_tbl(i) IS NULL OR
1925: x_headers.rate_type_code_tbl(i) = 'EMU FIXED') THEN --bug 7653758
1926: po_currency_sv.get_rate
1927: (
1928: x_set_of_books_id => PO_PDOI_PARAMS.g_sys.sob_id,
1929: x_currency_code => x_headers.currency_code_tbl(i),
1930: x_rate_type => x_headers.rate_type_code_tbl(i), --bug 7653758
1931: x_rate_date => x_headers.rate_date_tbl(i),
1932: x_inverse_rate_display_flag => 'N',

Line 1948: IF (PO_PDOI_PARAMS.g_request.document_type =

1944: d_position := 180;
1945:
1946: -- default the distribution related fields for a Blanket if
1947: -- encumbrance is required on this document
1948: IF (PO_PDOI_PARAMS.g_request.document_type =
1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1950: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1951: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1952: IF (PO_LOG.d_stmt) THEN

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

1946: -- default the distribution related fields for a Blanket if
1947: -- encumbrance is required on this document
1948: IF (PO_PDOI_PARAMS.g_request.document_type =
1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1950: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1951: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1952: IF (PO_LOG.d_stmt) THEN
1953: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||
1954: ' since encumbrance is required');

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

1947: -- encumbrance is required on this document
1948: IF (PO_PDOI_PARAMS.g_request.document_type =
1949: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
1950: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
1951: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN
1952: IF (PO_LOG.d_stmt) THEN
1953: PO_LOG.stmt(d_module, d_position, 'create distribution for blanket' ||
1954: ' since encumbrance is required');
1955: END IF;

Line 1980: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'

1976: x_program_update_date_tbl => x_headers.program_update_date_tbl
1977: );
1978:
1979: --CLM PDOI Integration Starts
1980: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y'
1981: THEN
1982: default_clm_standard_format
1983: (
1984: p_key => l_key,

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

2107:
2108: l_parameter_name_tbl.EXTEND(6);
2109: l_parameter_value_tbl.EXTEND(6);
2110: l_parameter_name_tbl(1) := 'INVENTORY_ORG_ID';
2111: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
2112: l_parameter_name_tbl(2) := 'SET_OF_BOOKS_ID';
2113: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
2114: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
2115: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;

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

2109: l_parameter_value_tbl.EXTEND(6);
2110: l_parameter_name_tbl(1) := 'INVENTORY_ORG_ID';
2111: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
2112: l_parameter_name_tbl(2) := 'SET_OF_BOOKS_ID';
2113: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
2114: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
2115: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
2116: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
2117: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;

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

2111: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.def_inv_org_id; -- bug5601416
2112: l_parameter_name_tbl(2) := 'SET_OF_BOOKS_ID';
2113: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
2114: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
2115: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
2116: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
2117: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
2118: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
2119: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;

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

2113: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.sob_id;
2114: l_parameter_name_tbl(3) := 'FUNCTIONAL_CURRENCY_CODE';
2115: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
2116: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
2117: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
2118: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
2119: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;
2120: l_parameter_name_tbl(6) := 'MANUAL_QUOTE_NUM_TYPE';
2121: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;

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

2115: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_sys.currency_code;
2116: l_parameter_name_tbl(4) := 'FEDERAL_INSTANCE';
2117: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
2118: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
2119: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;
2120: l_parameter_name_tbl(6) := 'MANUAL_QUOTE_NUM_TYPE';
2121: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;
2122:
2123: d_position := 10;

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

2117: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.is_federal_instance;
2118: l_parameter_name_tbl(5) := 'MANUAL_PO_NUM_TYPE';
2119: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_sys.manual_po_num_type;
2120: l_parameter_name_tbl(6) := 'MANUAL_QUOTE_NUM_TYPE';
2121: l_parameter_value_tbl(6) := PO_PDOI_PARAMS.g_sys.manual_quote_num_type;
2122:
2123: d_position := 10;
2124:
2125: PO_VALIDATIONS.validate_pdoi(p_headers => l_headers,

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

2122:
2123: d_position := 10;
2124:
2125: PO_VALIDATIONS.validate_pdoi(p_headers => l_headers,
2126: p_doc_type => PO_PDOI_PARAMS.g_request.document_type,
2127: p_parameter_name_tbl => l_parameter_name_tbl,
2128: p_parameter_value_tbl => l_parameter_value_tbl,
2129: x_result_type => l_result_type,
2130: x_results => l_results);

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

3318: AND x_vendor_site_id_tbl(i) IS NULL
3319: AND vendor_id = p_vendor_id_tbl(i)
3320: AND purchasing_site_flag = 'Y'
3321: AND (sysdate) < nvl(inactive_date, TRUNC(sysdate + 1))
3322: AND DECODE(PO_PDOI_PARAMS.g_request.document_type,
3323: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION, 'N',
3324: NVL(rfq_only_site_flag, 'N')) <> 'Y'
3325: GROUP BY vendor_id
3326: HAVING count(vendor_site_id) = 1;

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

3592: d_position := 20;
3593:
3594: PO_PERIODS_SV.get_period_name
3595: (
3596: x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
3597: x_gl_date => x_headers.gl_encumbered_date_tbl(i),
3598: x_gl_period => x_headers.gl_encumbered_period_tbl(i)
3599: );
3600:

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

3603: -- default budget account id
3604: IF (x_headers.budget_account_id_tbl(i) IS NULL) THEN
3605: PO_PDOI_DIST_PROCESS_PVT.derive_account_id
3606: ( p_account_number => x_headers.budget_account_tbl(i),
3607: p_chart_of_accounts_id => PO_PDOI_PARAMS.g_sys.coa_id,
3608: p_account_segment1 => x_headers.budget_account_segment1_tbl(i),
3609: p_account_segment2 => x_headers.budget_account_segment2_tbl(i),
3610: p_account_segment3 => x_headers.budget_account_segment3_tbl(i),
3611: p_account_segment4 => x_headers.budget_account_segment4_tbl(i),

Line 3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS
3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3775: decode(char3,
3776: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3777: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3778: 'PO_AWARD_STD_FORM'),

Line 3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3783: ),
3784:
3785: char2 = ( SELECT document_format
3786: FROM PO_PRINT_FORM_FORMATS
3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3788: decode(char3,
3789: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3790: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3791: 'PO_AWARD_STD_FORM'),

Line 3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3804: FORALL i IN 1..p_index_tbl.COUNT
3805: UPDATE po_session_gt
3806: SET char2 = ( SELECT document_format
3807: FROM PO_PRINT_FORM_FORMATS
3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3809: decode(char3,
3810: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3811: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3812: 'PO_AWARD_STD_FORM'),

Line 3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

3815: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate +1))
3816: AND style_id = num2
3817: AND ( Nvl(default_flag,'N') = 'Y' OR 1 = (SELECT Count(document_format)
3818: FROM PO_PRINT_FORM_FORMATS
3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3820: decode(char3,
3821: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3822: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',
3823: 'PO_AWARD_STD_FORM'),