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.PON_CLM_CLO_UTIL_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 126: x_req_line_num po_requisition_lines_all.line_num_display%TYPE;

122: x_user_display_name VARCHAR2(240);
123: x_auction_number VARCHAR2(20);
124: x_slin_num VARCHAR2(10);
125: x_req_num VARCHAR2(20);
126: x_req_line_num po_requisition_lines_all.line_num_display%TYPE;
127: x_document_number VARCHAR2(20);
128: x_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
129: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
130: x_is_req_backed VARCHAR2(1) := 'N';

Line 128: x_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;

124: x_slin_num VARCHAR2(10);
125: x_req_num VARCHAR2(20);
126: x_req_line_num po_requisition_lines_all.line_num_display%TYPE;
127: x_document_number VARCHAR2(20);
128: x_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
129: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
130: x_is_req_backed VARCHAR2(1) := 'N';
131: l_return_status varchar2(1);
132: l_msg_count number;

Line 129: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

125: x_req_num VARCHAR2(20);
126: x_req_line_num po_requisition_lines_all.line_num_display%TYPE;
127: x_document_number VARCHAR2(20);
128: x_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
129: x_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
130: x_is_req_backed VARCHAR2(1) := 'N';
131: l_return_status varchar2(1);
132: l_msg_count number;
133: l_msg_data varchar2(200);

Line 322: FOR rec IN (SELECT requisition_line_id FROM po_requisition_lines_all prl WHERE requisition_header_id = x_req_hdr_id

318: FND_LOG.string (log_level => FND_LOG.level_procedure,
319: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
320: message => 'This is a clin.Checking previously deleted slins/options to return them to req pool ');
321: END IF;
322: FOR rec IN (SELECT requisition_line_id FROM po_requisition_lines_all prl WHERE requisition_header_id = x_req_hdr_id
323: AND (group_line_id = x_req_line_id OR clm_base_line_num = x_req_line_id)
324: AND NOT EXISTS(SELECT 'Y' FROM pon_backing_requisitions
325: WHERE requisition_header_id = x_req_hdr_id
326: AND requisition_line_id = prl.requisition_line_id)) LOOP

Line 327: update po_requisition_lines_all prla --Bug 4001965: use _all

323: AND (group_line_id = x_req_line_id OR clm_base_line_num = x_req_line_id)
324: AND NOT EXISTS(SELECT 'Y' FROM pon_backing_requisitions
325: WHERE requisition_header_id = x_req_hdr_id
326: AND requisition_line_id = prl.requisition_line_id)) LOOP
327: update po_requisition_lines_all prla --Bug 4001965: use _all
328: set auction_header_id = null,
329: auction_display_number = null,
330: auction_line_number = null,
331: at_sourcing_flag = null, --

Line 1566: l_req_line_num po_requisition_lines_all.line_num_display%TYPE;

1562: l_username VARCHAR2(100);
1563: l_user_display_name VARCHAR2(240);
1564: l_line_num_display VARCHAR2(10);
1565: l_req_num po_requisition_headers_all.segment1%type;
1566: l_req_line_num po_requisition_lines_all.line_num_display%TYPE;
1567: l_document_number VARCHAR2(100);
1568: l_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
1569: l_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
1570: l_is_req_backed VARCHAR2(1) := 'N';

Line 1568: l_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;

1564: l_line_num_display VARCHAR2(10);
1565: l_req_num po_requisition_headers_all.segment1%type;
1566: l_req_line_num po_requisition_lines_all.line_num_display%TYPE;
1567: l_document_number VARCHAR2(100);
1568: l_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
1569: l_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
1570: l_is_req_backed VARCHAR2(1) := 'N';
1571: l_module_name VARCHAR2(100) := 'SEND_LINE_DELETED_NOTIF';
1572: type l_req_lines_type is REF cursor;

Line 1569: l_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;

1565: l_req_num po_requisition_headers_all.segment1%type;
1566: l_req_line_num po_requisition_lines_all.line_num_display%TYPE;
1567: l_document_number VARCHAR2(100);
1568: l_req_hdr_id po_requisition_lines_all.requisition_header_id%TYPE;
1569: l_req_line_id po_requisition_lines_all.requisition_line_id%TYPE;
1570: l_is_req_backed VARCHAR2(1) := 'N';
1571: l_module_name VARCHAR2(100) := 'SEND_LINE_DELETED_NOTIF';
1572: type l_req_lines_type is REF cursor;
1573: l_req_lines_csr l_req_lines_type;

Line 1575: l_req_line_description po_requisition_lines_all.item_description%TYPE;

1571: l_module_name VARCHAR2(100) := 'SEND_LINE_DELETED_NOTIF';
1572: type l_req_lines_type is REF cursor;
1573: l_req_lines_csr l_req_lines_type;
1574: l_type_lookup_code VARCHAR2(100);
1575: l_req_line_description po_requisition_lines_all.item_description%TYPE;
1576: l_buyer_name VARCHAR2(200);
1577: l_buyer_id NUMBER;
1578: l_ownerName varchar2(200) := null;
1579: l_error_code varchar2(200) := null;

Line 1615: po_requisition_lines_all prl,

1611: NULL -- Buyer ID
1612: FROM pon_backing_requisitions pbr,
1613: pon_auction_item_prices_all paip,
1614: pon_auction_headers_all pah,
1615: po_requisition_lines_all prl,
1616: po_requisition_headers_all prh
1617: WHERE pbr.auction_header_id = p_document_id
1618: AND pbr.line_number = p_document_line_id
1619: AND paip.auction_header_id = pbr.auction_header_id

Line 1644: FROM po_requisition_lines_all prl,

1640: prh.preparer_id,
1641: poh.type_lookup_code,
1642: prl.item_description,
1643: poh.agent_id
1644: FROM po_requisition_lines_all prl,
1645: po_requisition_headers_all prh,
1646: po_req_distributions_all prd,
1647: po_headers_draft_all poh,
1648: po_lines_draft_all pol,

Line 1688: FROM po_requisition_lines_all prl,

1684: prh.preparer_id,
1685: poh.type_lookup_code,
1686: prl.item_description,
1687: poh.agent_id
1688: FROM po_requisition_lines_all prl,
1689: po_requisition_headers_all prh,
1690: po_headers_draft_all poh,
1691: po_lines_draft_all pol,
1692: po_drafts pd

Line 1755: update po_requisition_lines_all prla

1751:
1752: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_username, l_user_display_name);
1753:
1754: IF(p_caller ='PON') THEN
1755: update po_requisition_lines_all prla
1756: set auction_header_id = null,
1757: auction_display_number = null,
1758: auction_line_number = null,
1759: po_line_id = null,