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 1171: UPDATE po_requisition_lines_all

1167: -- update the labor req line id in expense lines for contractor requisition
1168: -- to point to the old labor req line id
1169: IF nvl(l_contractor_requisition_flag,'N') = 'Y' THEN
1170: FORALL idx IN 1..p_tempLineIds.COUNT
1171: UPDATE po_requisition_lines_all
1172: SET labor_req_line_id = (SELECT labor_req_line_id
1173: FROM po_requisition_lines_all
1174: WHERE requisition_line_id = p_origLineIds(idx))
1175: WHERE requisition_line_id = p_tempLineIds(idx)

Line 1173: FROM po_requisition_lines_all

1169: IF nvl(l_contractor_requisition_flag,'N') = 'Y' THEN
1170: FORALL idx IN 1..p_tempLineIds.COUNT
1171: UPDATE po_requisition_lines_all
1172: SET labor_req_line_id = (SELECT labor_req_line_id
1173: FROM po_requisition_lines_all
1174: WHERE requisition_line_id = p_origLineIds(idx))
1175: WHERE requisition_line_id = p_tempLineIds(idx)
1176: AND labor_req_line_id is not null;
1177: END IF;

Line 1196: UPDATE po_requisition_lines_all

1192:
1193: l_progress := '030';
1194:
1195: -- flip the header ids in lines
1196: UPDATE po_requisition_lines_all
1197: SET requisition_header_id = p_origHeaderId
1198: WHERE requisition_header_id = p_tempHeaderId;
1199:
1200: l_progress := '040';

Line 1204: UPDATE po_requisition_lines_all

1200: l_progress := '040';
1201:
1202: -- flip the line ids
1203: FORALL idx IN 1..p_tempLineIds.COUNT
1204: UPDATE po_requisition_lines_all
1205: SET requisition_line_id = p_origLineIds(idx)
1206: WHERE requisition_line_id = p_tempLineIds(idx);
1207:
1208: l_progress := '050';

Line 1212: UPDATE po_requisition_lines_all

1208: l_progress := '050';
1209:
1210: -- flip the labor req line ids for contractor requisitions (Expense Lines)
1211: FORALL idx IN 1..p_tempLineIds.COUNT
1212: UPDATE po_requisition_lines_all
1213: SET labor_req_line_id = p_origLineIds(idx)
1214: WHERE labor_req_line_id = p_tempLineIds(idx)
1215: AND contractor_requisition_flag = 'Y';
1216:

Line 2104: UPDATE po_requisition_lines_all

2100: l_progress := '020';
2101:
2102: -- Update the reqs_in_pool_flag to null for all the req lines
2103: -- in the withdrawing requisition.
2104: UPDATE po_requisition_lines_all
2105: set reqs_in_pool_flag= NULL
2106: where requisition_header_id = p_headerId;
2107:
2108: IF l_item_key is NOT NULL THEN

Line 2276: FROM po_requisition_lines_all

2272: AND active_shopping_cart_flag = 'Y';
2273:
2274: CURSOR item_desc_cursor IS
2275: SELECT item_description
2276: FROM po_requisition_lines_all
2277: WHERE requisition_header_id = l_active_req_header_id
2278: ORDER BY line_num;
2279:
2280: BEGIN

Line 2728: FROM po_requisition_lines_all

2724: -- get the requisition header id from the labor line
2725: -- we assume that the expense line and labor line belong to the
2726: -- same requisition (PO will check this anyway)
2727: SELECT requisition_header_id INTO l_header_id
2728: FROM po_requisition_lines_all
2729: WHERE requisition_line_id = p_doc_level_id_tbl(1);
2730: END IF;
2731:
2732: l_progress := '030';

Line 2826: FROM po_requisition_lines_all

2822: -- get the requisition header id from the labor line
2823: -- we assume that the expense line and labor line belong to the
2824: -- same requisition (PO will check this anyway)
2825: SELECT requisition_header_id INTO l_header_id
2826: FROM po_requisition_lines_all
2827: WHERE requisition_line_id = p_doc_level_id_tbl(1);
2828: END IF;
2829:
2830: l_progress := '030';

Line 3221: (select requisition_line_id from po_requisition_lines_all prl, po_requisition_headers_all prh where

3217: and pk1_value = p_req_header_id
3218: union
3219: select document_id from fnd_attached_documents where entity_name = 'REQ_LINES'
3220: and pk1_value in
3221: (select requisition_line_id from po_requisition_lines_all prl, po_requisition_headers_all prh where
3222: prl.requisition_header_id = prh.requisition_header_id and prh.requisition_header_id=p_req_header_id));
3223:
3224: l_progress := '030';
3225: