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_CHANGE_REQUEST_PKG dependencies on PO_REQUISITION_LINES

Line 122: l_req_cur_code po_requisition_lines.currency_code%TYPE;

118: p_po_line_price NUMBER,
119: p_precision NUMBER ) RETURN NUMBER
120: IS
121: l_conversion_rate NUMBER := 1;
122: l_req_cur_code po_requisition_lines.currency_code%TYPE;
123: l_po_cur_code po_headers.currency_code%TYPE;
124: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
125: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
126: l_api_name VARCHAR2(30) := 'calculate_price_diff';

Line 228: l_req_cur_code po_requisition_lines.currency_code%TYPE;

224: p_po_line_amount NUMBER,
225: p_precision NUMBER ) RETURN NUMBER
226: IS
227: l_conversion_rate NUMBER := 1;
228: l_req_cur_code po_requisition_lines.currency_code%TYPE;
229: l_po_cur_code po_headers.currency_code%TYPE;
230: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
231: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
232: l_api_name VARCHAR2(30) := 'calculate_amount_diff';

Line 339: purchase_basis po_requisition_lines.purchase_basis%TYPE := '';

335: unit_price_diff NUMBER := 0;
336: amount_diff NUMBER := 0;
337: start_date_diff INTEGER := 0;
338: end_date_diff INTEGER := 0;
339: purchase_basis po_requisition_lines.purchase_basis%TYPE := '';
340: matching_basis po_requisition_lines.matching_basis%TYPE := '';
341: PRECISION NUMBER := 0;
342: ext_precision NUMBER := 0;
343: min_acct_unit NUMBER := 0;

Line 340: matching_basis po_requisition_lines.matching_basis%TYPE := '';

336: amount_diff NUMBER := 0;
337: start_date_diff INTEGER := 0;
338: end_date_diff INTEGER := 0;
339: purchase_basis po_requisition_lines.purchase_basis%TYPE := '';
340: matching_basis po_requisition_lines.matching_basis%TYPE := '';
341: PRECISION NUMBER := 0;
342: ext_precision NUMBER := 0;
343: min_acct_unit NUMBER := 0;
344: po_ou NUMBER;

Line 346: req_cur_code po_requisition_lines.currency_code%TYPE;

342: ext_precision NUMBER := 0;
343: min_acct_unit NUMBER := 0;
344: po_ou NUMBER;
345: req_ou NUMBER;
346: req_cur_code po_requisition_lines.currency_code%TYPE;
347: req_price NUMBER;
348: po_cur_code po_headers.currency_code%TYPE;
349: po_rate NUMBER;
350: po_rate_type po_headers.rate_type%TYPE;

Line 403: po_requisition_lines prl,

399: po_line_amount,
400: start_date_diff,
401: end_date_diff
402: FROM
403: po_requisition_lines prl,
404: po_req_distributions prd,
405: po_line_locations_all pll,
406: po_headers_all poh,
407: po_lines_all pol,

Line 519: po_requisition_lines

515: -- calculate req total by calculating sum of changed line totals
516: SELECT nvl(SUM(get_changed_line_total(requisition_line_id)), 0)
517: INTO req_total
518: FROM
519: po_requisition_lines
520: WHERE
521: requisition_header_id = reqheaderid AND
522: nvl(cancel_flag, 'N') = 'N' AND
523: nvl(modified_by_agent_flag, 'N') = 'N' AND

Line 552: po_requisition_lines

548:
549: SELECT nvl(SUM(get_chn_line_nonrec_tax_total(requisition_line_id)), 0)
550: INTO tax_total
551: FROM
552: po_requisition_lines
553: WHERE
554: requisition_header_id = reqheaderid
555: AND requisition_line_id NOT IN
556: (SELECT DISTINCT document_line_id

Line 573: * that value otherwise returns unit_price from po_requisition_lines *

569:
570: /**************************************************************************
571: * This function returns unit price of a given line. If there is any *
572: * unit price change exist in po_change_requests table, it returns *
573: * that value otherwise returns unit_price from po_requisition_lines *
574: **************************************************************************/
575: FUNCTION get_unit_price(reqlineid NUMBER, chgreqgrpid IN NUMBER)
576: RETURN NUMBER IS
577: unit_price NUMBER := 0;

Line 602: FROM po_requisition_lines_all

598:
599: WHEN no_data_found THEN
600: SELECT unit_price
601: INTO unit_price
602: FROM po_requisition_lines_all
603: WHERE
604: requisition_line_id = reqlineid;
605:
606: RETURN unit_price;

Line 622: matching_basis po_requisition_lines.matching_basis%TYPE := '';

618: RETURN NUMBER IS
619: changed_total NUMBER := 0;
620: grp_id NUMBER := 0;
621: amount NUMBER := 0;
622: matching_basis po_requisition_lines.matching_basis%TYPE := '';
623: line_qty NUMBER := 0;
624:
625: BEGIN
626:

Line 631: po_requisition_lines_all prl,

627:
628: SELECT MIN(pcr.change_request_group_id)
629: INTO grp_id
630: FROM
631: po_requisition_lines_all prl,
632: po_change_requests pcr
633: WHERE
634: pcr.document_header_id = prl.requisition_header_id
635: AND prl.requisition_line_id = reqlineid

Line 680: matching_basis po_requisition_lines.matching_basis%TYPE := '';

676: RETURN NUMBER IS
677: changed_total NUMBER := 0;
678: grp_id NUMBER := 0;
679: amount NUMBER := 0;
680: matching_basis po_requisition_lines.matching_basis%TYPE := '';
681: quantity NUMBER := 0;
682: BEGIN
683:
684:

Line 690: po_requisition_lines_all prl,

686:
687: SELECT MIN(pcr.change_request_group_id)
688: INTO grp_id
689: FROM
690: po_requisition_lines_all prl,
691: po_change_requests pcr
692: WHERE
693: pcr.document_header_id = prl.requisition_header_id
694: AND prl.requisition_line_id = reqlineid

Line 704: po_requisition_lines_all prl

700: -- get matching basis
701: SELECT prl.matching_basis
702: INTO matching_basis
703: FROM
704: po_requisition_lines_all prl
705: WHERE
706: prl.requisition_line_id = reqlineid;
707:
708:

Line 757: matching_basis po_requisition_lines.matching_basis%TYPE := '';

753: RETURN NUMBER IS
754: changed_total NUMBER := 0;
755: grp_id NUMBER := 0;
756: amount NUMBER := 0;
757: matching_basis po_requisition_lines.matching_basis%TYPE := '';
758: quantity NUMBER := 0;
759: unit_price NUMBER := 0;
760: BEGIN
761:

Line 765: po_requisition_lines_all prl,

761:
762: SELECT MIN(pcr.change_request_group_id)
763: INTO grp_id
764: FROM
765: po_requisition_lines_all prl,
766: po_change_requests pcr
767: WHERE
768: pcr.document_header_id = prl.requisition_header_id
769: AND prl.requisition_line_id = reqlineid

Line 776: po_requisition_lines_all prl

772: -- get matching basis
773: SELECT prl.matching_basis
774: INTO matching_basis
775: FROM
776: po_requisition_lines_all prl
777: WHERE
778: prl.requisition_line_id = reqlineid;
779:
780: -- quantity based item

Line 833: po_requisition_lines_all prl,

829: -- get old line total
830: SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount, prd.req_line_quantity * prl.unit_price))
831: INTO old_line_total
832: FROM
833: po_requisition_lines_all prl,
834: po_req_distributions prd
835: WHERE
836: prl.requisition_line_id = reqlineid AND
837: prl.requisition_line_id = prd.requisition_line_id;

Line 869: po_requisition_lines_all prl,

865: -- get old line total
866: SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount, prd.req_line_quantity * prl.unit_price))
867: INTO old_line_total
868: FROM
869: po_requisition_lines_all prl,
870: po_req_distributions_all prd
871: WHERE
872: prl.requisition_line_id = reqlineid AND
873: prl.requisition_line_id = prd.requisition_line_id;

Line 1034: po_requisition_lines_all prl,

1030:
1031: SELECT MIN(pcr.change_request_group_id)
1032: INTO grp_id
1033: FROM
1034: po_requisition_lines_all prl,
1035: po_change_requests pcr
1036: WHERE
1037: pcr.document_header_id = prl.requisition_header_id
1038: AND prl.requisition_line_id = reqlineid

Line 1043: FROM po_requisition_lines_all prl

1039: AND pcr.request_status = 'SYSTEMSAVE';
1040:
1041: SELECT nvl(po_rcotolerance_pvt.get_new_line_quantity(prl.requisition_header_id, prl.requisition_line_id, grp_id), 0)
1042: INTO changed_quantity
1043: FROM po_requisition_lines_all prl
1044: WHERE prl.requisition_line_id = reqlineid ;
1045:
1046: RETURN changed_quantity;
1047:

Line 1059: matching_basis po_requisition_lines.matching_basis%TYPE := '';

1055: * line id and change request group id. *
1056: **************************************************************************/
1057: FUNCTION get_hist_changed_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)
1058: RETURN NUMBER IS
1059: matching_basis po_requisition_lines.matching_basis%TYPE := '';
1060: BEGIN
1061:
1062: SELECT matching_basis
1063: INTO matching_basis

Line 1064: FROM po_requisition_lines_all

1060: BEGIN
1061:
1062: SELECT matching_basis
1063: INTO matching_basis
1064: FROM po_requisition_lines_all
1065: WHERE requisition_line_id = reqlineid;
1066:
1067: IF (matching_basis = 'QUANTITY') THEN
1068: RETURN (nvl(nvl(get_price_break_price(reqlineid, chgreqgrpid), get_hist_changed_line_price(reqlineid, chgreqgrpid)), nvl(get_hist_line_price(reqlineid, chgreqgrpid), 0)) *

Line 1114: matching_basis po_requisition_lines.matching_basis%TYPE := '';

1110: * it calculates the old line total for a particular change request group id
1111: **************************************************************************/
1112: FUNCTION get_hist_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)
1113: RETURN NUMBER IS
1114: matching_basis po_requisition_lines.matching_basis%TYPE := '';
1115: BEGIN
1116:
1117: SELECT matching_basis
1118: INTO matching_basis

Line 1119: FROM po_requisition_lines_all

1115: BEGIN
1116:
1117: SELECT matching_basis
1118: INTO matching_basis
1119: FROM po_requisition_lines_all
1120: WHERE requisition_line_id = reqlineid;
1121:
1122: IF (matching_basis = 'QUANTITY') THEN
1123: RETURN nvl(get_hist_line_price(reqlineid, chgreqgrpid), 0) * get_hist_line_qty(reqlineid, chgreqgrpid);

Line 1189: FROM po_requisition_lines_all

1185: EXCEPTION
1186: WHEN OTHERS THEN
1187:
1188: SELECT rate INTO l_req_rate
1189: FROM po_requisition_lines_all
1190: WHERE requisition_line_id = reqlineid;
1191:
1192: IF (l_req_rate IS NOT NULL ) THEN
1193:

Line 1236: FROM po_requisition_lines_all

1232: END IF;
1233:
1234: -- if req is created in txn currency, need to convert with rate
1235: SELECT rate INTO l_req_rate
1236: FROM po_requisition_lines_all
1237: WHERE requisition_line_id = reqlineid;
1238:
1239: IF (l_req_rate IS NOT NULL) THEN
1240: RETURN cur_line_price / l_req_rate;

Line 1276: FROM po_requisition_lines_all

1272: EXCEPTION
1273: WHEN no_data_found THEN
1274: SELECT quantity
1275: INTO line_qty
1276: FROM po_requisition_lines_all
1277: WHERE requisition_line_id = reqlineid;
1278:
1279: RETURN line_qty;
1280:

Line 1488: FROM po_requisition_lines_all

1484: EXCEPTION
1485: WHEN no_data_found THEN
1486: SELECT amount
1487: INTO amount
1488: FROM po_requisition_lines_all
1489: WHERE requisition_line_id = reqlineid;
1490:
1491: RETURN amount;
1492:

Line 1505: matching_basis po_requisition_lines.matching_basis%TYPE := '';

1501: * it calculates the old line total for a particular change request group id
1502: **************************************************************************/
1503: FUNCTION get_hist_cur_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)
1504: RETURN NUMBER IS
1505: matching_basis po_requisition_lines.matching_basis%TYPE := '';
1506: BEGIN
1507:
1508: SELECT matching_basis
1509: INTO matching_basis

Line 1510: FROM po_requisition_lines_all

1506: BEGIN
1507:
1508: SELECT matching_basis
1509: INTO matching_basis
1510: FROM po_requisition_lines_all
1511: WHERE requisition_line_id = reqlineid;
1512:
1513: IF (matching_basis = 'QUANTITY') THEN
1514: RETURN nvl(get_hist_cur_line_price(reqlineid, chgreqgrpid), 0) * get_hist_line_qty(reqlineid, chgreqgrpid);

Line 1547: FROM po_requisition_lines_all

1543: EXCEPTION
1544: WHEN no_data_found THEN
1545: SELECT nvl(currency_amount, amount)
1546: INTO amount
1547: FROM po_requisition_lines_all
1548: WHERE requisition_line_id = reqlineid;
1549:
1550: RETURN amount;
1551:

Line 1561: * from po_requisition_lines *

1557: /**************************************************************************
1558: * This function returns currency unit price of a given line. *
1559: * If there is any currency unit price change exist in po_change_requests *
1560: * table, it returns that value otherwise returns currency_unit_price *
1561: * from po_requisition_lines *
1562: **************************************************************************/
1563: FUNCTION get_currency_unit_price(reqlineid NUMBER, chgreqgrpid IN NUMBER)
1564: RETURN NUMBER IS
1565: cur_unit_price NUMBER := 0;

Line 1590: FROM po_requisition_lines_all

1586:
1587: WHEN no_data_found THEN
1588: SELECT currency_unit_price
1589: INTO cur_unit_price
1590: FROM po_requisition_lines_all
1591: WHERE
1592: requisition_line_id = reqlineid;
1593:
1594: RETURN cur_unit_price;

Line 1608: matching_basis po_requisition_lines.matching_basis%TYPE := '';

1604: * it calculates the old line total for a particular change request group id
1605: **************************************************************************/
1606: FUNCTION get_hist_chng_cur_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER)
1607: RETURN NUMBER IS
1608: matching_basis po_requisition_lines.matching_basis%TYPE := '';
1609: BEGIN
1610:
1611: SELECT matching_basis
1612: INTO matching_basis

Line 1613: FROM po_requisition_lines_all

1609: BEGIN
1610:
1611: SELECT matching_basis
1612: INTO matching_basis
1613: FROM po_requisition_lines_all
1614: WHERE requisition_line_id = reqlineid;
1615:
1616: IF (matching_basis = 'QUANTITY') THEN
1617: RETURN get_hist_chng_cur_line_price(reqlineid, chgreqgrpid) * get_hist_changed_line_qty(reqlineid, chgreqgrpid);

Line 1713: po_requisition_lines_all prl,

1709: --SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount,prd.req_line_quantity*prl.unit_price))
1710: SELECT SUM(prd.req_line_quantity * prl.unit_price)
1711: INTO old_line_total
1712: FROM
1713: po_requisition_lines_all prl,
1714: po_req_distributions prd
1715: WHERE
1716: prl.requisition_line_id = reqlineid AND
1717: prl.requisition_line_id = prd.requisition_line_id;

Line 1750: po_requisition_lines_all prl,

1746: -- SELECT SUM(decode(prl.matching_basis, 'AMOUNT', prd.req_line_amount,prd.req_line_quantity*prl.unit_price))
1747: SELECT SUM(prd.req_line_quantity * prl.unit_price)
1748: INTO old_line_total
1749: FROM
1750: po_requisition_lines_all prl,
1751: po_req_distributions_all prd
1752: WHERE
1753: prl.requisition_line_id = reqlineid AND
1754: prl.requisition_line_id = prd.requisition_line_id;