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_AMENDMENT_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 48: * PO_REQ_DISTRIBUTIONS_ALL

44: * ARGUMENTS
45: * p_table_name IN Table name, possible values:
46: * PO_REQUISITION_HEADERS_ALL
47: * PO_REQUISITION_LINES_ALL
48: * PO_REQ_DISTRIBUTIONS_ALL
49: * p_revision_num IN
50: * p_confirmed_id IN
51: * amend_num OUT
52: *

Line 183: ELSIF p_table_name = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

179: 'ORDER BY LINE_NUM';
180:
181: p_level:= 'LINES';
182:
183: ELSIF p_table_name = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
184:
185: /* Added NVL around RECOVERABLE_TAX, NONRECOVERABLE_TAX, RECOVERY_RATE
186: to disregard the difference between NULL and 0.
187: */

Line 218: FROM po_req_distributions_all prd,

214: FUNDED_VALUE,
215: QUANTITY_FUNDED,
216: AMOUNT_FUNDED,
217: ACRN
218: FROM po_req_distributions_all prd,
219: po_requisition_lines_all prl,
220: po_requisition_headers_all prh
221: WHERE prh.conformed_header_id='||p_confirmed_id||
222: 'AND prh.requisition_header_id=prl.requisition_header_id

Line 260: FROM po_req_distributions_all prd,

256: FUNDED_VALUE,
257: QUANTITY_FUNDED,
258: AMOUNT_FUNDED,
259: ACRN
260: FROM po_req_distributions_all prd,
261: po_requisition_lines_all prl,
262: po_requisition_headers_all prh
263: WHERE prh.conformed_header_id='||p_confirmed_id||
264: 'AND prh.requisition_header_id=prl.requisition_header_id

Line 1006: compare_table('PO_REQ_DISTRIBUTIONS_ALL',p_revision_num,p_confirmed_id,amend_num);

1002: compare_table('PO_REQUISITION_HEADERS_ALL',p_revision_num,p_confirmed_id,amend_num);
1003: v_progress := '002';
1004: compare_table('PO_REQUISITION_LINES_ALL',p_revision_num,p_confirmed_id,amend_num);
1005: v_progress := '003';
1006: compare_table('PO_REQ_DISTRIBUTIONS_ALL',p_revision_num,p_confirmed_id,amend_num);
1007:
1008: -- UDA related Changes
1009: -- Header
1010: v_progress := '004';

Line 1593: * PO_REQ_DISTRIBUTIONS_ALL

1589: * ARGUMENTS
1590: * p_table_name Table name, possible values:
1591: * PO_REQUISITION_HEADERS_ALL
1592: * PO_REQUISITION_LINES_ALL
1593: * PO_REQ_DISTRIBUTIONS_ALL
1594: * p_revision_num
1595: * p_confirmed_id
1596: *
1597: * NOTES

Line 1758: ELSIF p_table_name = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

1754: 'ORDER BY LINE_NUM';
1755:
1756: p_level:= 'LINES';
1757:
1758: ELSIF p_table_name = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
1759:
1760: /* Added NVL around RECOVERABLE_TAX, NONRECOVERABLE_TAX, RECOVERY_RATE
1761: to disregard the difference between NULL and 0.
1762: */

Line 1794: FROM po_req_distributions_all prd,

1790: PARTIAL_FUNDED_FLAG,
1791: FUNDED_VALUE,
1792: QUANTITY_FUNDED,
1793: AMOUNT_FUNDED
1794: FROM po_req_distributions_all prd,
1795: po_requisition_lines_all prl,
1796: po_requisition_headers_all prh
1797: WHERE prh.conformed_header_id='||p_confirmed_id||
1798: 'AND prh.requisition_header_id=prl.requisition_header_id

Line 1837: FROM po_req_distributions_all prd,

1833: PARTIAL_FUNDED_FLAG,
1834: FUNDED_VALUE,
1835: QUANTITY_FUNDED,
1836: AMOUNT_FUNDED
1837: FROM po_req_distributions_all prd,
1838: po_requisition_lines_all prl,
1839: po_requisition_headers_all prh
1840: WHERE prh.conformed_header_id='||p_confirmed_id||
1841: 'AND prh.requisition_header_id=prl.requisition_header_id

Line 2102: UPDATE po_req_distributions_all

2098: IF NOT cancel_flag THEN
2099:
2100: IF amend_type = 'CHANGED' THEN
2101:
2102: UPDATE po_req_distributions_all
2103: SET amendment_status = 'N',
2104: amendment_type = 'CHANGED'
2105: WHERE distribution_id=dist_id;
2106:

Line 2111: FROM po_req_distributions_all

2107: UPDATE po_requisition_lines_all
2108: SET amendment_status = 'N',
2109: amendment_type = 'CHANGED'
2110: WHERE requisition_line_id=(SELECT Nvl(info_line_id,requisition_line_id)
2111: FROM po_req_distributions_all
2112: WHERE distribution_id=dist_id);
2113:
2114:
2115: ELSIF amend_type = 'ADDED' THEN

Line 2117: UPDATE po_req_distributions_all

2113:
2114:
2115: ELSIF amend_type = 'ADDED' THEN
2116:
2117: UPDATE po_req_distributions_all
2118: SET amendment_status = 'N',
2119: amendment_type = 'ADDED'
2120: WHERE distribution_id=dist_id;
2121:

Line 2128: FROM po_req_distributions_all

2124: SELECT amendment_type,amendment_status
2125: INTO l_amendment_type, l_amendment_status
2126: FROM po_requisition_lines_all
2127: WHERE requisition_line_id=(SELECT Nvl(info_line_id,requisition_line_id)
2128: FROM po_req_distributions_all
2129: WHERE distribution_id=dist_id);
2130:
2131: new_amendment_type := 'CHANGED';
2132: new_amendment_status := 'N';

Line 2142: FROM po_req_distributions_all

2138: UPDATE po_requisition_lines_all
2139: SET amendment_status = new_amendment_status,
2140: amendment_type = new_amendment_type
2141: WHERE requisition_line_id=(SELECT Nvl(info_line_id,requisition_line_id)
2142: FROM po_req_distributions_all
2143: WHERE distribution_id=dist_id);
2144:
2145: END IF;
2146:

Line 2151: UPDATE po_req_distributions_all

2147: END IF;
2148:
2149: ELSE
2150: IF old_amend_type in ('ADDED','CHANGED') THEN
2151: UPDATE po_req_distributions_all
2152: SET amendment_type=old_amend_type,
2153: amendment_status = 'P'
2154: WHERE distribution_id=dist_id
2155: AND amendment_status NOT IN ('A','R');

Line 2234: set_amendment_status('PO_REQ_DISTRIBUTIONS_ALL',p_revision_num,p_confirmed_id);

2230: END IF;
2231:
2232: set_amendment_status('PO_REQUISITION_HEADERS_ALL',p_revision_num,p_confirmed_id);
2233: set_amendment_status('PO_REQUISITION_LINES_ALL',p_revision_num,p_confirmed_id);
2234: set_amendment_status('PO_REQ_DISTRIBUTIONS_ALL',p_revision_num,p_confirmed_id);
2235:
2236: v_progress:='001';
2237:
2238: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2458: INSERT INTO po_req_distributions_all

2454: SELECT po_req_distributions_s.NEXTVAL
2455: INTO x_new_dist_id
2456: FROM dual;
2457:
2458: INSERT INTO po_req_distributions_all
2459: (distribution_id,
2460: last_update_date,
2461: last_updated_by,
2462: requisition_line_id,

Line 2620: FROM po_req_distributions_all source

2616: source.clm_defence_funding,
2617: source.clm_fms_case_number,
2618: source.clm_agency_acct_identifier,
2619: source.acrn
2620: FROM po_req_distributions_all source
2621: WHERE distribution_id = p_from_dist_id;
2622:
2623: EXCEPTION
2624: WHEN OTHERS THEN

Line 2648: INTO po_req_distributions_all target

2644: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
2645: END IF;
2646:
2647: MERGE
2648: INTO po_req_distributions_all target
2649: USING (SELECT * FROM po_req_distributions_all
2650: WHERE distribution_id = p_from_dist_id) source
2651: ON ( target.distribution_id = p_to_dist_id
2652: AND source.CONFORMED_DIST_ID = target.distribution_id

Line 2649: USING (SELECT * FROM po_req_distributions_all

2645: END IF;
2646:
2647: MERGE
2648: INTO po_req_distributions_all target
2649: USING (SELECT * FROM po_req_distributions_all
2650: WHERE distribution_id = p_from_dist_id) source
2651: ON ( target.distribution_id = p_to_dist_id
2652: AND source.CONFORMED_DIST_ID = target.distribution_id
2653: )

Line 2718: FROM po_req_distributions_all

2714: END IF;
2715:
2716: SELECT distribution_id, requisition_line_id, conformed_dist_id, info_line_id
2717: BULK COLLECT INTO l_distribution_ids, l_req_line_id, l_conformed_dist_ids, l_info_line_id
2718: FROM po_req_distributions_all
2719: WHERE requisition_line_id IN
2720: (SELECT requisition_line_id
2721: FROM po_requisition_lines_all prla,
2722: po_requisition_headers_all prha

Line 4716: l_log_msg := v_progress||' : After insert into po_requisition_lines_all and po_req_distributions_all';

4712:
4713: v_progress := '007';
4714:
4715: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4716: l_log_msg := v_progress||' : After insert into po_requisition_lines_all and po_req_distributions_all';
4717: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
4718: END IF;
4719:
4720: EXCEPTION

Line 4759: INSERT INTO po_req_distributions_all (

4755: END IF;
4756:
4757: x_return_msg := NULL;
4758:
4759: INSERT INTO po_req_distributions_all (
4760: distribution_id,
4761: last_update_date,
4762: last_updated_by,
4763: requisition_line_id,

Line 4925: FROM po_req_distributions_all

4921: clm_fms_case_number,
4922: clm_agency_acct_identifier,
4923: info_line_id,
4924: acrn
4925: FROM po_req_distributions_all
4926: WHERE requisition_line_id = p_from_req_line_id;
4927:
4928: v_progress := '001';
4929:

Line 4976: UPDATE po_req_distributions_all SET amendment_status = 'A'

4972: WHERE prla1.requisition_line_id = prla.group_line_id
4973: AND prla1.conformed_line_id IS NULL
4974: AND prla1.amendment_status = 'A');
4975:
4976: UPDATE po_req_distributions_all SET amendment_status = 'A'
4977: WHERE conformed_dist_id IS NULL AND
4978: requisition_line_id IN
4979: (SELECT requisition_line_id FROM po_requisition_lines_all
4980: WHERE conformed_line_id IS NULL AND

Line 5007: UPDATE po_req_distributions_all prda SET prda.amendment_status = 'A'

5003: AND prla2.auction_header_id is NULL
5004: AND nvl(prla2.clm_info_flag,'N') = 'N');
5005:
5006:
5007: UPDATE po_req_distributions_all prda SET prda.amendment_status = 'A'
5008: WHERE prda.requisition_line_id IN
5009: (SELECT requisition_line_id FROM po_requisition_lines_all prla
5010: WHERE prla.requisition_header_id = l_requisition_header_id
5011: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1

Line 5399: po_req_distributions_all rd --

5395: CURSOR req_tax_csr(p_doc_id NUMBER)
5396: IS
5397: SELECT NVL(SUM(nonrecoverable_tax), 0)
5398: FROM po_requisition_lines rl,
5399: po_req_distributions_all rd --
5400: WHERE rl.requisition_header_id = p_doc_id
5401: AND rd.requisition_line_id = rl.requisition_line_id
5402: AND NVL(rl.cancel_flag,'N') = 'N'
5403: AND NVL(rl.modified_by_agent_flag, 'N') = 'N';

Line 6498: FROM po_req_distributions_all prd

6494: prd.amount_funded,
6495: prd.change_in_funded_value,
6496: -- <>
6497: prd.acrn
6498: FROM po_req_distributions_all prd
6499: WHERE prd.distribution_id = x_requisition_dist_id;
6500:
6501:
6502: --

Line 6548: po_req_distributions_all prd

6544:
6545: CURSOR valid_lines(req_line_id NUMBER) IS
6546: SELECT 1
6547: FROM po_requisition_lines_all prl,
6548: po_req_distributions_all prd
6549: WHERE prl.requisition_line_id = req_line_id
6550: AND prl.requisition_line_id = Nvl(prd.info_line_id,prd.requisition_line_id)
6551: AND
6552: ( (prl.amendment_type = 'ADDED' AND

Line 6785: compare_table_for_implement('PO_REQ_DISTRIBUTIONS_ALL',

6781: x_line_id,
6782: p_sequence_num,
6783: x_amendment_num);
6784:
6785: compare_table_for_implement('PO_REQ_DISTRIBUTIONS_ALL',
6786: p_conformed_req_line_id,
6787: x_line_id,
6788: p_sequence_num,
6789: x_amendment_num);

Line 6834: FROM po_req_distributions_all

6830: l_line_num_disp
6831: );
6832:
6833: SELECT Count(*) INTO l_cnt
6834: FROM po_req_distributions_all
6835: WHERE info_line_id = p_conformed_req_line_id;
6836:
6837: IF l_cnt > 0 THEN
6838: --New we need to insert the distribution value

Line 6901: * PO_REQ_DISTRIBUTIONS_ALL

6897: * ARGUMENTS
6898: * p_table_name IN Table name, possible values:
6899: * PO_REQUISITION_HEADERS_ALL
6900: * PO_REQUISITION_LINES_ALL
6901: * PO_REQ_DISTRIBUTIONS_ALL
6902: * p_revision_num IN
6903: * p_confirmed_id IN
6904: * amend_num OUT
6905: *

Line 6991: ELSIF p_table_name = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

6987:
6988:
6989: p_level:= 'LINES';
6990:
6991: ELSIF p_table_name = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
6992:
6993: /* Added NVL around RECOVERABLE_TAX, NONRECOVERABLE_TAX, RECOVERY_RATE
6994: to disregard the difference between NULL and 0.
6995: */

Line 7025: FROM po_req_distributions_all prd,

7021: PARTIAL_FUNDED_FLAG,
7022: FUNDED_VALUE,
7023: QUANTITY_FUNDED,
7024: AMOUNT_FUNDED
7025: FROM po_req_distributions_all prd,
7026: po_requisition_lines_all prl
7027: WHERE prl.requisition_line_id ='||p_to_req_line_id||
7028: 'AND prl.requisition_line_id=nvl(prd.info_line_id,prd.requisition_line_id)
7029: ORDER BY nvl(prd.info_line_id,prd.requisition_line_id),DISTRIBUTION_NUM';

Line 7063: FROM po_req_distributions_all prd,

7059: PARTIAL_FUNDED_FLAG,
7060: FUNDED_VALUE,
7061: QUANTITY_FUNDED,
7062: AMOUNT_FUNDED
7063: FROM po_req_distributions_all prd,
7064: po_requisition_lines_all prl
7065: WHERE prl.requisition_line_id ='||p_from_req_line_id||
7066: 'AND prl.requisition_line_id=nvl(prd.info_line_id,prd.requisition_line_id)
7067: ORDER BY nvl(prd.info_line_id,prd.requisition_line_id),DISTRIBUTION_NUM';

Line 7208: UPDATE po_req_distributions_all

7204: amendment_response_reason = reason
7205: WHERE requisition_line_id = l_amendment_line_id
7206: and amendment_status in ('N','P');
7207:
7208: UPDATE po_req_distributions_all
7209: SET amendment_status = 'A'
7210: WHERE requisition_line_id = selected_lines(i)
7211: AND amendment_status IN ('N','P');
7212:

Line 7213: update po_req_distributions_all

7209: SET amendment_status = 'A'
7210: WHERE requisition_line_id = selected_lines(i)
7211: AND amendment_status IN ('N','P');
7212:
7213: update po_req_distributions_all
7214: set amendment_status = 'A'
7215: where requisition_line_id = l_amendment_line_id
7216: and amendment_status in ('N', 'P');
7217:

Line 7255: UPDATE po_req_distributions_all

7251: amendment_response_reason = reason
7252: WHERE requisition_line_id = l_amendment_line_id
7253: and amendment_status in ('N','P');
7254:
7255: UPDATE po_req_distributions_all
7256: SET amendment_status = 'R'
7257: WHERE requisition_line_id = selected_lines(i)
7258: AND amendment_status IN ('N','P');
7259:

Line 7260: UPDATE po_req_distributions_all

7256: SET amendment_status = 'R'
7257: WHERE requisition_line_id = selected_lines(i)
7258: AND amendment_status IN ('N','P');
7259:
7260: UPDATE po_req_distributions_all
7261: SET amendment_status = 'R'
7262: WHERE requisition_line_id = l_amendment_line_id
7263: AND amendment_status IN ('N','P');
7264:

Line 7493: FROM po_req_distributions_all

7489: BEGIN
7490:
7491: SELECT Max(distribution_id)
7492: INTO l_dist_id
7493: FROM po_req_distributions_all
7494: WHERE ( conformed_dist_id = p_distribution_id AND amendment_status = 'A')
7495: ---Bug#14332568 : Added below condition to get the funded value for requistion line
7496: -- which is newly added after requisition1405has been autocreated.
7497: OR (distribution_id = p_distribution_id

Line 7504: FROM po_req_distributions_all prda,

7500:
7501: IF l_dist_id IS NULL THEN
7502:
7503: SELECT prda.funded_value INTO L_FUNDED_VALUE
7504: FROM po_req_distributions_all prda,
7505: po_requisition_lines_all prla,
7506: po_requisition_headers_all prha
7507: WHERE
7508: prda.conformed_dist_id = p_distribution_id

Line 7514: FROM po_req_distributions_all WHERE

7510: AND prla.requisition_header_id = prha.requisition_header_id
7511: AND prha.revision_num=0;
7512: ELSE
7513: SELECT funded_value INTO L_FUNDED_VALUE
7514: FROM po_req_distributions_all WHERE
7515: distribution_id = l_dist_id;
7516: END IF;
7517:
7518: RETURN L_FUNDED_VALUE;