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.OKC_CREATE_PO_FROM_K_PVT dependencies on STANDARD

Line 30: -- Standard API Constants

26:
27: ----------------------------------------------------------------------------
28: -- Global Constants--------------------------------------------------------
29: ----------------------------------------------------------------------------
30: -- Standard API Constants
31:
32: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXP_ERROR';
33: G_SQLCODE_TOKEN CONSTANT VARCHAR2(07) := 'SQLCODE';
34: G_SQLERRM_TOKEN CONSTANT VARCHAR2(07) := 'SQLERRM';

Line 63: g_po_hdr_document_type_code CONSTANT VARCHAR2(12) := 'STANDARD';

59: -- Other Constants
60:
61: g_po_hdr_process_code CONSTANT VARCHAR2(12) := 'PENDING';
62: g_po_hdr_action CONSTANT VARCHAR2(12) := 'ORIGINAL';
63: g_po_hdr_document_type_code CONSTANT VARCHAR2(12) := 'STANDARD';
64: g_po_hdr_approval_status CONSTANT VARCHAR2(12) := 'APPROVED';
65: g_po_hdr_interface_source_code CONSTANT VARCHAR2(03) := 'OKP';
66: g_po_hdr_accept_required_flag CONSTANT VARCHAR2(01) := 'N';
67: g_po_hdr_frozen_flag CONSTANT VARCHAR2(01) := 'N';

Line 69: g_po_ln_shipment_type CONSTANT VARCHAR2(08) := 'STANDARD';

65: g_po_hdr_interface_source_code CONSTANT VARCHAR2(03) := 'OKP';
66: g_po_hdr_accept_required_flag CONSTANT VARCHAR2(01) := 'N';
67: g_po_hdr_frozen_flag CONSTANT VARCHAR2(01) := 'N';
68: g_po_hdr_approv_required_flag CONSTANT VARCHAR2(01) := 'N';
69: g_po_ln_shipment_type CONSTANT VARCHAR2(08) := 'STANDARD';
70: g_po_dis_destination_type_code CONSTANT VARCHAR2(10) := 'INVENTORY';
71:
72: g_sts_signed CONSTANT VARCHAR2(06) := 'SIGNED';
73: g_sts_active CONSTANT VARCHAR2(06) := 'ACTIVE';

Line 169: -- document_type_code - Document type to be created. In our case Standard PO

165: -------------------------------------------------------------------------
166: -- po_header_rec_type holds the values that will be inserted in
167: -- po_headers_interface table
168: -- interface_header_id - Interface header unique identifier
169: -- document_type_code - Document type to be created. In our case Standard PO
170: -- document_num - number used to uniquely identify the PO in forms and reports
171: -- po_header_id - primary key in po_headers_all table
172: -- agent_id - buyer id
173: -------------------------------------------------------------------------

Line 417: -- standard api variables

413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2) IS
416:
417: -- standard api variables
418: l_api_version CONSTANT NUMBER := 1;
419: l_api_name CONSTANT VARCHAR2(30) := 'notify_buyer';
420: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
421: lx_msg_count NUMBER := 0;

Line 644: -- Out Parameters: x_return_status Standard return status

640: --
641: -- In Out Parameters: px_po_header_rec Record to hold po header interface data
642: -- px_po_lines_rec Record to hold po line interface data
643: --
644: -- Out Parameters: x_return_status Standard return status
645: --
646: -- Note: QA check must ensure that the occurrence of any rule does not happen
647: -- more than once per header or line.
648: -------------------------------------------------------------------------------

Line 914: -- Out Parameters: x_return_status Standard return status

910: -- level to populate po headers record, po lines table and po distributions table
911: --
912: -- In Parameters: p_chr_id Contract header id
913: --
914: -- Out Parameters: x_return_status Standard return status
915: -- x_po_header_rec Record to hold po header interface data
916: -- x_po_lines_tab Table to hold po lines interface data
917: -- x_po_dist_tab Table to hold po distributions interface data
918: --------------------------------------------------------------------------------

Line 933: l_return_status VARCHAR2(100); -- standard return status

929: e_exit exception;
930: l_idx pls_integer :=0; -- generic table index
931: po_lines_rec po_lines_rec_type; -- record to hold po line interface data
932: po_header_rec po_header_rec_type; -- record to hold po header interface data
933: l_return_status VARCHAR2(100); -- standard return status
934: l_cpr_id NUMBER; -- to hold k_party_roles id
935:
936: BEGIN
937:

Line 1252: -- Out Parameters: x_return_status Standard return status

1248: -- In Parameters:
1249: -- p_batch_id Batch id of records to be inserted
1250: -- p_po_header_rec Record to hold po header interface data
1251: --
1252: -- Out Parameters: x_return_status Standard return status
1253: -- x_po_header_id This is a temporary parameter
1254: -- that needs to be here because of a
1255: -- bug in PO (PDOI does not accept
1256: -- po_line_id). Hence the related objects

Line 1452: -- Out Parameters: x_return_status Standard return status

1448: -- related objects for lines
1449: --
1450: -- In Parameters: p_po_lines_tab Table to hold po lines interface data
1451: --
1452: -- Out Parameters: x_return_status Standard return status
1453: ----------------------------------------------------------------------------
1454:
1455: PROCEDURE insert_po_lines(p_chr_id IN okc_k_headers_b.id%TYPE
1456: ,p_po_lines_tab IN po_lines_tab

Line 1697: -- Out Parameters: x_return_status Standard return status

1693: -- Purpose: Populate purchase order distributions interface table
1694:
1695: -- In Parameters: p_po_dist_tab Table to hold po distributions interface data
1696:
1697: -- Out Parameters: x_return_status Standard return status
1698: ------------------------------------------------------------------------------------
1699:
1700: PROCEDURE insert_po_distributions(p_po_dist_tab IN po_distributions_tab
1701: ,x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 1825: -- Out Parameters: x_return_status Standard return status

1821: --
1822: -- In Parameters: p_chr_id Contract header id
1823: -- p_batch_id Batch id
1824: --
1825: -- Out Parameters: x_return_status Standard return status
1826: ----------------------------------------------------------------------------------
1827:
1828: PROCEDURE create_po_from_k(p_api_version IN NUMBER
1829: ,p_init_msg_list IN VARCHAR2

Line 1835: -- standard api variables

1831: ,x_return_status OUT NOCOPY VARCHAR2
1832: ,x_msg_count OUT NOCOPY NUMBER
1833: ,x_msg_data OUT NOCOPY VARCHAR2) IS
1834:
1835: -- standard api variables
1836:
1837: l_api_version CONSTANT NUMBER := 1;
1838: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PO_FROM_K';
1839: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1965: ,argument2 => 'Standard' -- Document type

1961: ,program => 'POXPOPDOI'
1962: ,sub_request => TRUE -- Indicates that this is a child
1963: -- of the parent request
1964: ,argument1 => null -- Default buyer
1965: ,argument2 => 'Standard' -- Document type
1966: ,argument3 => null -- Document sub type
1967: ,argument4 => 'N' -- Create or update items
1968: ,argument5 => 'N' -- Create sourcing rules
1969: ,argument6 => null -- Approval status

Line 2042: -- Out Parameters: Standard

2038: -- Purpose: See specifications (avoid dual maintenance of comments)
2039: --
2040: -- In Parameters: p_chr_id Contract header id
2041: --
2042: -- Out Parameters: Standard
2043: --------------------------------------------------------------------------------
2044:
2045: PROCEDURE tieback_related_objs_from_po(
2046: p_api_version IN NUMBER