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_MODIFY_REQUISITION_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 26: FROM PO_REQUISITION_LINES_ALL

22: l_uda_template NUMBER;
23: BEGIN
24: SELECT UDA_TEMPLATE_ID
25: into l_uda_template
26: FROM PO_REQUISITION_LINES_ALL
27: WHERE REQUISITION_LINE_ID=REQ_LINE_ID;
28: RETURN l_uda_template;
29: END GET_UDA_TEMPLATE_ID;
30:

Line 50: po_requisition_lines_all prla

46: INTO L_ATTR_GROUP_NAME
47: FROM PO_REQ_LINES_EXT_B prleb,
48: po_uda_ag_template_usages usages,
49: ego_attr_groups_v ags,
50: po_requisition_lines_all prla
51: WHERE prleb.requisition_line_id = p_req_line_id
52: AND prleb.attr_group_id = ags.attr_group_id
53: AND prleb.attr_group_id = usages.attribute_group_id
54: AND usages.attribute_category = 'PRICING'

Line 77: * inserts records into po_requisition_lines_all and po_req_distributions_all table.

73: * req lines, update requisition_lines table to modified_by_agent_flag = 'Y' .
74: * Also sets prevent encumbrace flag to 'Y' in the po_req_distributions table.
75: * Effects: This api split the requisition lines, into two lines with specified quantity.
76: * This api uses a global temp.table to process the input given by autocreate(HTML) and
77: * inserts records into po_requisition_lines_all and po_req_distributions_all table.
78: * This api also handles the encumbrace effect of splitting requisition lines. This
79: * api would be called from Autocreate HTML.
80: *
81: * Returns:

Line 94: * 4. Using a for loop insert two records into the po_requisition_lines_all

90: * 2. Retrieve the quantity on the given line and split using
91: * split function.
92: * 3. Calculate the maximum line number of the lines that
93: * belong to the given requisition.
94: * 4. Using a for loop insert two records into the po_requisition_lines_all
95: * table and provide the correct line number by incrementing
96: * max line number by one in each iteration.
97: * 5. Update the split req line and set the modified flag
98: * and purchasing agent flag.

Line 336: FROM po_requisition_lines_all prl_1,

332: prl_1.GROUP_LINE_ID,--add
333: prl_1.CLM_INFO_FLAG,--add
334: PRHA.FEDERAL_FLAG,
335: prl_2.LINE_NUM_DISPLAY
336: FROM po_requisition_lines_all prl_1,
337: po_requisition_lines_all prl_2,
338: Po_Requisition_Headers_All prha
339: WHERE prl_1.requisition_line_id = p_req_line_id
340: AND prha.Requisition_Header_Id = prl_1.Requisition_Header_Id

Line 337: po_requisition_lines_all prl_2,

333: prl_1.CLM_INFO_FLAG,--add
334: PRHA.FEDERAL_FLAG,
335: prl_2.LINE_NUM_DISPLAY
336: FROM po_requisition_lines_all prl_1,
337: po_requisition_lines_all prl_2,
338: Po_Requisition_Headers_All prha
339: WHERE prl_1.requisition_line_id = p_req_line_id
340: AND prha.Requisition_Header_Id = prl_1.Requisition_Header_Id
341: AND prl_2.Requisition_Line_Id = NVL(prl_1.GROUP_LINE_ID,p_req_line_id)

Line 461: FROM po_requisition_lines_all prl

457: -- the new requisition lines
458:
459: SELECT MAX(prl.line_num)
460: INTO l_max_line_num
461: FROM po_requisition_lines_all prl
462: WHERE prl.requisition_header_id =
463: (SELECT requisition_header_id
464: FROM po_requisition_lines_all
465: WHERE requisition_line_id = p_req_Line_id);

Line 464: FROM po_requisition_lines_all

460: INTO l_max_line_num
461: FROM po_requisition_lines_all prl
462: WHERE prl.requisition_header_id =
463: (SELECT requisition_header_id
464: FROM po_requisition_lines_all
465: WHERE requisition_line_id = p_req_Line_id);
466:
467: IF PO_LOG.d_stmt THEN
468: PO_LOG.stmt(d_module_base,d_progress,'l_max_line_num',l_max_line_num);

Line 499: -- FROM po_requisition_lines_all prl

495: -- IF l_group_id_temp is not NULL
496: -- then
497: -- SELECT Line_Num_Display
498: -- INTO l_parent_clin_number
499: -- FROM po_requisition_lines_all prl
500: -- WHERE Prl.Requisition_Line_Id = L_Group_Id_Temp;
501: -- END IF;
502:
503: -- retrieve the number of SLins associated with Requisition Line

Line 505: FROM po_requisition_lines_all

501: -- END IF;
502:
503: -- retrieve the number of SLins associated with Requisition Line
504: SELECT COUNT(*) INTO l_number_of_slins
505: FROM po_requisition_lines_all
506: WHERE Group_Line_Id=L_Requisition_Line_Id AND Requisition_Header_Id=L_Temp_Req_Header_Id;
507:
508: -- for Standalone Clins and Priced Slins l_number_of_slins=0
509: -- for Priced CLins with Info Slins l_number_of_slins!=0

Line 530: FROM po_requisition_lines_all

526: IF l_number_of_slins<>0 THEN
527: -- copy the req_line_id's of the info slins associated to the given CLIN
528: SELECT Requisition_Line_Id BULK COLLECT
529: INTO l_slin_array_TBL
530: FROM po_requisition_lines_all
531: WHERE Group_Line_Id=L_Requisition_Line_Id AND requisition_header_id=l_temp_req_header_id;
532:
533: -- copy the req_line_id of associated Info SLins into l_slin_array
534: -- copy the attribute_group_name of PRICING for the associated Info Slins and template_id to L_ATTR_GROUP_NAME

Line 693: INSERT INTO po_requisition_lines_all

689:
690: --**End************************
691:
692: SELECT po_requisition_lines_s.NEXTVAL into l_new_requisition_line_Id FROM dual;
693: INSERT INTO po_requisition_lines_all
694: (requisition_line_id,
695: requisition_header_id,
696: line_num,
697: line_type_id,

Line 1012: FROM po_requisition_lines_all prl

1008: PRL.CLM_OPTION_EXERCISED,
1009: PRL.ASSIGNMENT_NUMBER,
1010: PRL.PO_DRAFT_ID -- end of addition for clm_split
1011:
1012: FROM po_requisition_lines_all prl
1013: WHERE prl.requisition_line_id = l_req_line_id_temp);
1014:
1015: --7835635
1016:

Line 1128: -- update po_requisition_lines_all for the associated Line.. andassociated Info Slins if any.

1124: -- add P_REQ_LINE_ID to l_slin_array
1125: l_slin_array.EXTEND;
1126: l_slin_array(l_number_of_slins+1):=p_req_line_id;
1127:
1128: -- update po_requisition_lines_all for the associated Line.. andassociated Info Slins if any.
1129: FORALL l_slin_num_index IN 1 .. l_number_of_slins+1
1130: UPDATE po_requisition_lines_all
1131: SET modified_by_agent_flag = 'Y',
1132: purchasing_agent_id = p_agent_id,

Line 1130: UPDATE po_requisition_lines_all

1126: l_slin_array(l_number_of_slins+1):=p_req_line_id;
1127:
1128: -- update po_requisition_lines_all for the associated Line.. andassociated Info Slins if any.
1129: FORALL l_slin_num_index IN 1 .. l_number_of_slins+1
1130: UPDATE po_requisition_lines_all
1131: SET modified_by_agent_flag = 'Y',
1132: purchasing_agent_id = p_agent_id,
1133: reqs_in_pool_flag = NULL, --
1134: on_rfq_flag = decode(p_calling_program,

Line 1170: FROM PO_REQUISITION_LINES_ALL PRL1, PO_REQUISITION_LINES_ALL PRL2

1166: --Performance fix for bug 4930487
1167: SELECT PRL1.requisition_line_id
1168: BULK COLLECT
1169: INTO new_req_line_id_rslt_tbl
1170: FROM PO_REQUISITION_LINES_ALL PRL1, PO_REQUISITION_LINES_ALL PRL2
1171: WHERE PRL1.requisition_header_id = PRL2.requisition_header_id
1172: AND PRL1.parent_req_line_id = p_req_line_id
1173: AND PRL2.requisition_line_id = p_req_line_id;
1174:

Line 1325: FROM po_requisition_lines_all PRL1, po_requisition_lines_all PRL2

1321: -- Performance fix for bug 4930487
1322: SELECT PRL1.quantity
1323: BULK COLLECT
1324: INTO l_quantity_table
1325: FROM po_requisition_lines_all PRL1, po_requisition_lines_all PRL2
1326: WHERE PRL1.requisition_header_id = PRL2.requisition_header_id
1327: AND PRL1.parent_req_line_id = p_req_line_id
1328: AND PRL2.requisition_line_id = p_req_line_id;
1329:

Line 1376: from po_requisition_lines_all

1372: d_progress := 60;
1373: --Retrieve the value of l_requisition_header_id first
1374: select requisition_header_id
1375: into l_requisition_header_id
1376: from po_requisition_lines_all
1377: where requisition_line_id = p_req_line_id;
1378:
1379: IF PO_LOG.d_stmt THEN
1380: PO_LOG.stmt(d_module_base,d_progress,'l_requisition_header_id',l_requisition_header_id);

Line 1435: FROM PO_REQUISITION_LINES_ALL

1431: SELECT ENCUMBERED_FLAG,
1432: REQUISITION_HEADER_ID /* <> */
1433: INTO l_req_encumbered_flag,
1434: l_Req_Header_Id /* <> */
1435: FROM PO_REQUISITION_LINES_ALL
1436: WHERE requisition_line_id = p_req_line_id;
1437: exception
1438: when others then
1439: l_req_encumbered_flag :='N';

Line 1663: -- Prevented FTS on po_requisition_lines_all by adding an exists clause

1659: PO_LOG.stmt(d_module_base,d_progress,'Inserting values into po_req_split_lines_gt');
1660: END IF;
1661:
1662: -- Performance fix for bug 4930487
1663: -- Prevented FTS on po_requisition_lines_all by adding an exists clause
1664: INSERT INTO po_req_split_lines_gt
1665: (requisition_header_id,
1666: requisition_line_id,
1667: allocated_qty,

Line 1683: FROM po_requisition_lines_all PRL1

1679: WHERE (prl.requisition_line_id = p_req_line_id OR
1680: prl.parent_req_line_id = p_req_line_id)
1681: AND EXISTS(
1682: SELECT requisition_header_id
1683: FROM po_requisition_lines_all PRL1
1684: WHERE PRL1.requisition_header_id = prl.requisition_header_id
1685: AND PRL1.requisition_line_id = p_req_line_id);
1686:
1687: