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_SOURCING_PVT dependencies on PO_HEADERS_INTERFACE

Line 35: --SQL WHAT: Selects the records from the po_headers_interface table

31: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
32: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
33:
34:
35: --SQL WHAT: Selects the records from the po_headers_interface table
36: --SQL WHY: These values are used in creating a Purchase Order
37: --SQl Join:None
38:
39: CURSOR g_interface_cursor(p_interface_header_id NUMBER) IS

Line 86: FROM po_headers_interface phi

82: phi.clm_award_type,
83: phi.clm_standard_form,
84: phi.clm_document_format,
85: phi.umbrella_program_id --umbrella program
86: FROM po_headers_interface phi
87: WHERE phi.interface_header_id = p_interface_header_id;
88:
89: -- Type declaration for System Parameters structure
90: TYPE system_parameters_rec_type IS RECORD

Line 185: g_style_id PO_HEADERS_INTERFACE.style_id%TYPE;

181:
182:
183: -- CLM CPA Creation Flow
184: g_is_clm_flow VARCHAR2(1):= 'N';
185: g_style_id PO_HEADERS_INTERFACE.style_id%TYPE;
186:
187:
188: -------------------------------------------------------------------------------
189: --Start of Comments

Line 202: -- Id that uniquely identifies a row in po_headers_interface table

198: -- This procedure is called for getting the default po paramters
199: --Parameters:
200: --IN:
201: --p_interface_header_id
202: -- Id that uniquely identifies a row in po_headers_interface table
203: --OUT:
204: -- None
205: --Notes:
206: -- None

Line 212: PROCEDURE get_system_defaults(p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE) IS

208: -- None
209: --End of Comments
210: -------------------------------------------------------------------------------
211:
212: PROCEDURE get_system_defaults(p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE) IS
213: x_date date;
214: l_api_name CONSTANT VARCHAR2(30) := 'get_system_defaults';
215: BEGIN
216: IF g_debug_stmt THEN

Line 852: l_document_num PO_HEADERS_INTERFACE.document_num%TYPE;

848: x_return_status OUT NOCOPY VARCHAR2
849: ) IS
850: l_rowid VARCHAR2(30);
851: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
852: l_document_num PO_HEADERS_INTERFACE.document_num%TYPE;
853: l_current_org PO_SYSTEM_PARAMETERS.org_id%TYPE;
854: l_org_assign_rec PO_GA_ORG_ASSIGNMENTS%ROWTYPE;
855: l_org_row_id ROWID;
856: l_return_status VARCHAR2(1);

Line 1637: -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table

1633: -- Creates Contract Purchase Agreement from Sourcing document
1634: --Parameters:
1635: --IN:
1636: --p_interface_header_id
1637: -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table
1638: --p_auction_header_id
1639: -- Id of the negotiation
1640: --p_bid_number
1641: -- Bid Number for which is negotiation is awarded

Line 1669: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE,

1665: PROCEDURE create_cpa (
1666: x_return_status OUT NOCOPY VARCHAR2,
1667: x_msg_count OUT NOCOPY NUMBER,
1668: x_msg_data OUT NOCOPY VARCHAR2,
1669: p_interface_header_id IN PO_HEADERS_INTERFACE.interface_header_id%TYPE,
1670: p_auction_header_id IN PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE,
1671: p_bid_number IN PON_BID_HEADERS.bid_number%TYPE,
1672: p_sourcing_k_doc_type IN VARCHAR2,
1673: p_conterms_exist_flag IN PO_HEADERS_ALL.conterms_exist_flag%TYPE,

Line 1681: l_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;

1677: ) IS
1678: l_return_status VARCHAR2(1);
1679: l_api_name CONSTANT VARCHAR2(30) := 'create_cpa';
1680:
1681: l_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
1682: l_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
1683: l_action PO_HEADERS_INTERFACE.action%TYPE;
1684:
1685: -- CLM CPA

Line 1682: l_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;

1678: l_return_status VARCHAR2(1);
1679: l_api_name CONSTANT VARCHAR2(30) := 'create_cpa';
1680:
1681: l_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
1682: l_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
1683: l_action PO_HEADERS_INTERFACE.action%TYPE;
1684:
1685: -- CLM CPA
1686: l_clm_enabled_flag VARCHAR2(1):= 'N';

Line 1683: l_action PO_HEADERS_INTERFACE.action%TYPE;

1679: l_api_name CONSTANT VARCHAR2(30) := 'create_cpa';
1680:
1681: l_document_type PO_HEADERS_INTERFACE.document_type_code%TYPE;
1682: l_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
1683: l_action PO_HEADERS_INTERFACE.action%TYPE;
1684:
1685: -- CLM CPA
1686: l_clm_enabled_flag VARCHAR2(1):= 'N';
1687: l_change_process_type PO_DOC_STYLE_HEADERS.change_process_type%TYPE;

Line 1723: FROM po_headers_interface phi

1719: BEGIN
1720:
1721: SELECT phi.style_id
1722: INTO g_style_id
1723: FROM po_headers_interface phi
1724: WHERE phi.interface_header_id=p_interface_header_id;
1725:
1726: EXCEPTION
1727: WHEN OTHERS THEN

Line 1941: -- po_headers_interface

1937: --Name: DELETE_INTERFACE_HEADER
1938: --Pre-reqs:
1939: -- None
1940: --Modifies:
1941: -- po_headers_interface
1942: --Locks:
1943: -- None.
1944: --Function:
1945: -- This deletes the interface header row from interface table

Line 1949: -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table

1945: -- This deletes the interface header row from interface table
1946: --Parameters:
1947: --IN:
1948: --p_interface_header_id
1949: -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table
1950: --OUT:
1951: --x_return_status
1952: -- The standard OUT parameter giving return status of the API call.
1953: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

Line 1963: p_interface_header_id IN PO_HEADERS_INTERFACE.INTERFACE_HEADER_ID%TYPE,

1959: --End of Comments
1960: -------------------------------------------------------------------------------
1961:
1962: PROCEDURE DELETE_INTERFACE_HEADER (
1963: p_interface_header_id IN PO_HEADERS_INTERFACE.INTERFACE_HEADER_ID%TYPE,
1964: x_return_status OUT NOCOPY VARCHAR2
1965: ) IS
1966: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_INTERFACE_HEADER';
1967: BEGIN

Line 1971: DELETE po_headers_interface

1967: BEGIN
1968: -- Initialize API return status to success
1969: x_return_status := FND_API.G_RET_STS_SUCCESS;
1970:
1971: DELETE po_headers_interface
1972: WHERE interface_header_id = p_interface_header_id;
1973:
1974: g_progress := '600';
1975: IF g_debug_stmt THEN

Line 1978: p_message => 'No of Records deleted from PO_HEADERS_INTERFACE'||SQL%rowcount);

1974: g_progress := '600';
1975: IF g_debug_stmt THEN
1976: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1977: p_token => g_progress,
1978: p_message => 'No of Records deleted from PO_HEADERS_INTERFACE'||SQL%rowcount);
1979: END IF;
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;