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

Line 58: DELETE FROM po_requisition_lines_all

54:
55: l_progress := '010';
56:
57: -- delete the lines
58: DELETE FROM po_requisition_lines_all
59: WHERE requisition_header_id = p_header_id
60: RETURNING requisition_line_id
61: BULK COLLECT INTO l_line_ids;
62:

Line 961: po_requisition_lines_all prl

957: expenditure_organization_id,
958: expenditure_type,
959: expenditure_item_date
960: from po_req_distributions_all prd,
961: po_requisition_lines_all prl
962: where prl.requisition_header_id = p_origHeaderId
963: and prl.requisition_line_id = prd.requisition_line_id;
964:
965: BEGIN

Line 1198: UPDATE po_requisition_lines_all

1194: -- update the labor req line id in expense lines for contractor requisition
1195: -- to point to the old labor req line id
1196: IF nvl(l_contractor_requisition_flag,'N') = 'Y' THEN
1197: FORALL idx IN 1..p_tempLineIds.COUNT
1198: UPDATE po_requisition_lines_all
1199: SET labor_req_line_id = (SELECT labor_req_line_id
1200: FROM po_requisition_lines_all
1201: WHERE requisition_line_id = p_origLineIds(idx))
1202: WHERE requisition_line_id = p_tempLineIds(idx)

Line 1200: FROM po_requisition_lines_all

1196: IF nvl(l_contractor_requisition_flag,'N') = 'Y' THEN
1197: FORALL idx IN 1..p_tempLineIds.COUNT
1198: UPDATE po_requisition_lines_all
1199: SET labor_req_line_id = (SELECT labor_req_line_id
1200: FROM po_requisition_lines_all
1201: WHERE requisition_line_id = p_origLineIds(idx))
1202: WHERE requisition_line_id = p_tempLineIds(idx)
1203: AND labor_req_line_id is not null;
1204: END IF;

Line 1225: UPDATE po_requisition_lines_all

1221:
1222: l_progress := '030';
1223:
1224: -- flip the header ids in lines
1225: UPDATE po_requisition_lines_all
1226: SET requisition_header_id = p_origHeaderId
1227: WHERE requisition_header_id = p_tempHeaderId;
1228:
1229: l_progress := '040';

Line 1233: UPDATE po_requisition_lines_all

1229: l_progress := '040';
1230:
1231: -- flip the line ids
1232: FORALL idx IN 1..p_tempLineIds.COUNT
1233: UPDATE po_requisition_lines_all
1234: SET requisition_line_id = p_origLineIds(idx)
1235: WHERE requisition_line_id = p_tempLineIds(idx);
1236:
1237:

Line 1239: UPDATE po_requisition_lines_all

1235: WHERE requisition_line_id = p_tempLineIds(idx);
1236:
1237:
1238: FORALL idx IN 1..p_tempLineIds.COUNT
1239: UPDATE po_requisition_lines_all
1240: SET Group_line_id = p_origLineIds(idx)
1241: WHERE Group_line_id = p_tempLineIds(idx);
1242:
1243: FORALL idx IN 1..p_tempLineIds.COUNT

Line 1244: UPDATE po_requisition_lines_all

1240: SET Group_line_id = p_origLineIds(idx)
1241: WHERE Group_line_id = p_tempLineIds(idx);
1242:
1243: FORALL idx IN 1..p_tempLineIds.COUNT
1244: UPDATE po_requisition_lines_all
1245: SET Clm_Base_line_num = p_origLineIds(idx)
1246: WHERE Clm_Base_line_num = p_tempLineIds(idx);
1247:
1248:

Line 1253: UPDATE po_requisition_lines_all

1249: l_progress := '050';
1250:
1251: -- flip the labor req line ids for contractor requisitions (Expense Lines)
1252: FORALL idx IN 1..p_tempLineIds.COUNT
1253: UPDATE po_requisition_lines_all
1254: SET labor_req_line_id = p_origLineIds(idx)
1255: WHERE labor_req_line_id = p_tempLineIds(idx)
1256: AND contractor_requisition_flag = 'Y';
1257:

Line 2454: UPDATE po_requisition_lines_all

2450: l_progress := '020';
2451:
2452: -- Update the reqs_in_pool_flag to null for all the req lines
2453: -- in the withdrawing requisition.
2454: UPDATE po_requisition_lines_all
2455: set reqs_in_pool_flag= NULL
2456: where requisition_header_id = p_headerId;
2457:
2458: IF l_item_key is NOT NULL THEN

Line 2626: FROM po_requisition_lines_all

2622: AND active_shopping_cart_flag = 'Y';
2623:
2624: CURSOR item_desc_cursor IS
2625: SELECT item_description
2626: FROM po_requisition_lines_all
2627: WHERE requisition_header_id = l_active_req_header_id
2628: ORDER BY line_num;
2629:
2630: BEGIN

Line 3097: FROM po_requisition_lines_all

3093: -- get the requisition header id from the labor line
3094: -- we assume that the expense line and labor line belong to the
3095: -- same requisition (PO will check this anyway)
3096: SELECT requisition_header_id INTO l_header_id
3097: FROM po_requisition_lines_all
3098: WHERE requisition_line_id = p_doc_level_id_tbl(1);
3099: END IF;
3100:
3101: l_progress := '030';

Line 3195: FROM po_requisition_lines_all

3191: -- get the requisition header id from the labor line
3192: -- we assume that the expense line and labor line belong to the
3193: -- same requisition (PO will check this anyway)
3194: SELECT requisition_header_id INTO l_header_id
3195: FROM po_requisition_lines_all
3196: WHERE requisition_line_id = p_doc_level_id_tbl(1);
3197: END IF;
3198:
3199: l_progress := '030';

Line 3591: FROM po_requisition_lines_all prl, po_requisition_headers_all prh

3587: UNION
3588: SELECT document_id
3589: FROM fnd_attached_documents
3590: WHERE entity_name = 'REQ_LINES' AND pk1_value IN (SELECT to_char(requisition_line_id)
3591: FROM po_requisition_lines_all prl, po_requisition_headers_all prh
3592: WHERE prl.requisition_header_id = prh.requisition_header_id AND prh.requisition_header_id=to_number(p_req_header_id));
3593:
3594: BEGIN
3595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3635: po_requisition_lines_all prl,

3631:
3632: BEGIN
3633: select count(*) into l_enc_dist_count
3634: from po_requisition_headers_all prh,
3635: po_requisition_lines_all prl,
3636: po_req_distributions_all prd
3637: where prh.requisition_header_id = p_req_header_id
3638: and prh.requisition_header_id = prl.requisition_header_id
3639: and prl.requisition_line_id = prd.requisition_line_id

Line 3815: FROM PO_REQUISITION_LINES_ALL

3811:
3812: IF(l_are_udas_already_present <> 'Y') THEN
3813: SELECT UDA_TEMPLATE_ID, BLANKET_PO_HEADER_ID, BLANKET_PO_LINE_NUM
3814: INTO l_from_template_id, l_blanket_po_header_id, l_blanket_po_line_num
3815: FROM PO_REQUISITION_LINES_ALL
3816: WHERE REQUISITION_LINE_ID = p_req_line_id;
3817:
3818: IF p_line_uda_template_id IS NULL THEN
3819: --First try to get the uda_template_id from the req line table

Line 3821: FROM PO_REQUISITION_LINES_ALL

3817:
3818: IF p_line_uda_template_id IS NULL THEN
3819: --First try to get the uda_template_id from the req line table
3820: SELECT uda_template_id INTO l_to_template_id
3821: FROM PO_REQUISITION_LINES_ALL
3822: WHERE REQUISITION_LINE_ID = p_req_line_id;
3823:
3824: IF l_to_template_id IS NULL THEN
3825: l_to_template_id := po_uda_data_util.get_template_id ('REQUISITIONS',NULL,

Line 3920: FROM po_requisition_lines_all

3916: l_line_status_display VARCHAR2(250);
3917:
3918: CURSOR c_get_req_details(p_req_line_id NUMBER) IS
3919: SELECT REQUISITION_HEADER_ID, SUGGESTED_BUYER_ID, AUCTION_HEADER_ID, LINE_LOCATION_ID
3920: FROM po_requisition_lines_all
3921: WHERE requisition_line_id = p_req_line_id;
3922:
3923: BEGIN
3924:

Line 4009: FROM po_requisition_lines_all

4005: l_count NUMBER;
4006:
4007: CURSOR c_get_req_details(p_req_header_id NUMBER) IS
4008: SELECT REQUISITION_HEADER_ID, SUGGESTED_BUYER_ID, AUCTION_HEADER_ID, LINE_LOCATION_ID, REQUISITION_LINE_ID
4009: FROM po_requisition_lines_all
4010: WHERE requisition_header_id = p_req_header_id;
4011:
4012: BEGIN
4013: l_count := 0;

Line 4229: SELECT count(*) INTO l_count FROM po_requisition_lines_all

4225: BEGIN
4226: is_any_line_place_on_po := 'N';
4227: l_progress:='010';
4228:
4229: SELECT count(*) INTO l_count FROM po_requisition_lines_all
4230: WHERE line_location_id IS NOT null
4231: AND requisition_header_id = p_req_header_id;
4232:
4233: l_progress :='020';

Line 4239: SELECT count(*) INTO l_count FROM po_requisition_lines_all

4235: IF l_count >=1 THEN
4236: is_any_line_place_on_po := 'Y';
4237: l_progress := '030';
4238: ELSE
4239: SELECT count(*) INTO l_count FROM po_requisition_lines_all
4240: WHERE REQS_IN_POOL_FLAG= 'N'
4241: AND requisition_header_id = p_req_header_id;
4242: l_progress := '040' ;
4243:

Line 5714: FROM PO_REQUISITION_LINES_ALL

5710: FROM PO_REQ_DISTRIBUTIONS_ALL
5711: WHERE REQUISITION_LINE_ID IN
5712: (
5713: SELECT REQUISITION_LINE_ID
5714: FROM PO_REQUISITION_LINES_ALL
5715: WHERE REQUISITION_HEADER_ID = x_document_id
5716: ))
5717: AND PRD.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID
5718: );