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_REQUISITION_LINES_ALL

Line 47: * PO_REQUISITION_LINES_ALL

43: *
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

Line 143: ELSIF p_table_name = 'PO_REQUISITION_LINES_ALL' then

139:
140:
141: p_level:= 'HEADER';
142:
143: ELSIF p_table_name = 'PO_REQUISITION_LINES_ALL' then
144:
145: sql_stmt1:= 'SELECT REQUISITION_LINE_ID,LINE_NUM, LINE_NUM_DISPLAY,nvl(prl.CANCEL_FLAG,''N'') CANCEL_FLAG, nvl(prl.CLOSED_CODE,''OPEN'') CLOSED_CODE,ITEM_ID,ITEM_REVISION,
146: ITEM_DESCRIPTION, CATEGORY_ID, UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE,QUANTITY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,
147: SUGGESTED_BUYER_ID,to_char(NEED_BY_DATE,''DD-MON-YYYY HH24:MI:SS'') NEED_BY_DATE,JUSTIFICATION,NOTE_TO_AGENT,NOTE_TO_RECEIVER,CURRENCY_CODE,RATE_TYPE,to_char(RATE_DATE,''DD-MON-YYYY HH24:MI:SS'') RATE_DATE,

Line 156: FROM po_requisition_lines_all prl,

152: CURRENCY_AMOUNT,JOB_LONG_DESCRIPTION,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,CANDIDATE_FIRST_NAME,
153: CANDIDATE_LAST_NAME,to_char(ASSIGNMENT_START_DATE,''DD-MON-YYYY HH24:MI:SS'') ASSIGNMENT_START_DATE,CONTRACT_TYPE,COST_CONSTRAINT,
154: to_char(CLM_PERIOD_PERF_START_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_START_DATE,to_char(CLM_PERIOD_PERF_END_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_END_DATE,
155: nvl(CLM_OPTION_EXERCISED,''N'') CLM_OPTION_EXERCISED, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE, FUND_SOURCE_NOT_KNOWN,CLM_OPTION_INDICATOR , CLM_BASE_LINE_NUM , CLM_MIPR_OBLIGATION_TYPE
156: FROM po_requisition_lines_all prl,
157: po_requisition_headers_all prh
158: WHERE prh.conformed_header_id='||p_confirmed_id||
159: 'AND prh.requisition_header_id=prl.requisition_header_id
160: AND prh.revision_num='||(p_revision_num -1)||

Line 174: FROM po_requisition_lines_all prl,

170: CURRENCY_AMOUNT,JOB_LONG_DESCRIPTION,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,CANDIDATE_FIRST_NAME,
171: CANDIDATE_LAST_NAME,to_char(ASSIGNMENT_START_DATE,''DD-MON-YYYY HH24:MI:SS'') ASSIGNMENT_START_DATE,CONTRACT_TYPE,COST_CONSTRAINT,
172: to_char(CLM_PERIOD_PERF_START_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_START_DATE,to_char(CLM_PERIOD_PERF_END_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_END_DATE,
173: nvl(CLM_OPTION_EXERCISED,''N'') CLM_OPTION_EXERCISED, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE, FUND_SOURCE_NOT_KNOWN,CLM_OPTION_INDICATOR , CLM_BASE_LINE_NUM , CLM_MIPR_OBLIGATION_TYPE
174: FROM po_requisition_lines_all prl,
175: po_requisition_headers_all prh
176: WHERE prh.conformed_header_id='||p_confirmed_id||
177: 'AND prh.requisition_header_id=prl.requisition_header_id
178: AND prh.revision_num='||p_revision_num||

Line 219: po_requisition_lines_all prl,

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
223: AND prl.requisition_line_id=nvl(prd.info_line_id,prd.requisition_line_id)

Line 261: po_requisition_lines_all prl,

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
265: AND prl.requisition_line_id=nvl(prd.info_line_id,prd.requisition_line_id)

Line 349: FROM po_requisition_lines_all prl,

345: SELECT database_view_name
346: INTO x_database_view_name
347: FROM po_uda_ag_templates
348: WHERE template_id = (SELECT Max(prl.uda_template_id)
349: FROM po_requisition_lines_all prl,
350: po_requisition_headers_all prh
351: WHERE prh.conformed_header_id= p_confirmed_id
352: AND prh.revision_num=p_revision_num
353: AND prh.requisition_header_id=prl.requisition_header_id);

Line 359: po_requisition_lines_all prla

355:
356: sql_stmt1:='SELECT prla.line_num, prla.LINE_NUM_DISPLAY,
357: temp.*
358: FROM '||x_database_view_name||' temp,
359: po_requisition_lines_all prla
360: WHERE temp.requisition_line_id IN (SELECT prl.requisition_line_id
361: FROM po_requisition_lines_all prl,
362: po_requisition_headers_all prh
363: WHERE prh.conformed_header_id= '||p_confirmed_id||

Line 361: FROM po_requisition_lines_all prl,

357: temp.*
358: FROM '||x_database_view_name||' temp,
359: po_requisition_lines_all prla
360: WHERE temp.requisition_line_id IN (SELECT prl.requisition_line_id
361: FROM po_requisition_lines_all prl,
362: po_requisition_headers_all prh
363: WHERE prh.conformed_header_id= '||p_confirmed_id||
364: 'AND prh.revision_num='||(p_revision_num-1)||
365: 'AND prh.requisition_header_id=prl.requisition_header_id)

Line 371: po_requisition_lines_all prla

367:
368: sql_stmt2:='SELECT prla.line_num, prla.LINE_NUM_DISPLAY,
369: temp.*
370: FROM '||x_database_view_name||' temp,
371: po_requisition_lines_all prla
372: WHERE temp.requisition_line_id IN (SELECT prl.requisition_line_id
373: FROM po_requisition_lines_all prl,
374: po_requisition_headers_all prh
375: WHERE prh.conformed_header_id= '||p_confirmed_id||

Line 373: FROM po_requisition_lines_all prl,

369: temp.*
370: FROM '||x_database_view_name||' temp,
371: po_requisition_lines_all prla
372: WHERE temp.requisition_line_id IN (SELECT prl.requisition_line_id
373: FROM po_requisition_lines_all prl,
374: po_requisition_headers_all prh
375: WHERE prh.conformed_header_id= '||p_confirmed_id||
376: 'AND prh.revision_num='||p_revision_num||
377: 'AND prh.requisition_header_id=prl.requisition_header_id)

Line 1004: compare_table('PO_REQUISITION_LINES_ALL',p_revision_num,p_confirmed_id,amend_num);

1000:
1001: v_progress := '001';
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

Line 1444: SELECT line_num_display INTO id FROM po_requisition_lines_all WHERE requisition_line_id=p_id;

1440: FROM pa_tasks_expend_v
1441: WHERE task_id=p_id;
1442: ELSIF label IN ('CLM_BASE_LINE_NUM') THEN
1443:
1444: SELECT line_num_display INTO id FROM po_requisition_lines_all WHERE requisition_line_id=p_id;
1445:
1446: ELSE
1447: id:= p_id;
1448: END IF;

Line 1592: * PO_REQUISITION_LINES_ALL

1588: *
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: *

Line 1656: l_amendment_type po_requisition_lines_all.amendment_type%TYPE;

1652: header_change BOOLEAN:= FALSE;
1653: line_change BOOLEAN:= FALSE;
1654: dist_change BOOLEAN:= FALSE;
1655:
1656: l_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1657: l_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1658: new_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1659: new_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1660:

Line 1657: l_amendment_status po_requisition_lines_all.amendment_status%TYPE;

1653: line_change BOOLEAN:= FALSE;
1654: dist_change BOOLEAN:= FALSE;
1655:
1656: l_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1657: l_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1658: new_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1659: new_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1660:
1661: --Debugging purpose

Line 1658: new_amendment_type po_requisition_lines_all.amendment_type%TYPE;

1654: dist_change BOOLEAN:= FALSE;
1655:
1656: l_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1657: l_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1658: new_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1659: new_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1660:
1661: --Debugging purpose
1662: v_progress VARCHAR2(3);

Line 1659: new_amendment_status po_requisition_lines_all.amendment_status%TYPE;

1655:
1656: l_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1657: l_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1658: new_amendment_type po_requisition_lines_all.amendment_type%TYPE;
1659: new_amendment_status po_requisition_lines_all.amendment_status%TYPE;
1660:
1661: --Debugging purpose
1662: v_progress VARCHAR2(3);
1663: l_procedure_name VARCHAR2(100) := 'set_amendment_status';

Line 1718: ELSIF p_table_name = 'PO_REQUISITION_LINES_ALL' then

1714:
1715:
1716: p_level:= 'HEADER';
1717:
1718: ELSIF p_table_name = 'PO_REQUISITION_LINES_ALL' then
1719:
1720: sql_stmt1:= 'SELECT REQUISITION_LINE_ID,LINE_NUM, LINE_NUM_DISPLAY,nvl(prl.CANCEL_FLAG,''N'') CANCEL_FLAG, nvl(prl.CLOSED_CODE,''OPEN'') CLOSED_CODE,ITEM_ID,ITEM_REVISION,
1721: ITEM_DESCRIPTION, CATEGORY_ID, UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE,QUANTITY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,
1722: SUGGESTED_BUYER_ID,to_char(NEED_BY_DATE,''DD-MON-YYYY HH24:MI:SS'') NEED_BY_DATE,JUSTIFICATION,NOTE_TO_AGENT,NOTE_TO_RECEIVER,CURRENCY_CODE,RATE_TYPE,to_char(RATE_DATE,''DD-MON-YYYY HH24:MI:SS'') RATE_DATE,

Line 1731: FROM po_requisition_lines_all prl,

1727: CURRENCY_AMOUNT,JOB_LONG_DESCRIPTION,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,CANDIDATE_FIRST_NAME,
1728: CANDIDATE_LAST_NAME,to_char(ASSIGNMENT_START_DATE,''DD-MON-YYYY HH24:MI:SS'') ASSIGNMENT_START_DATE,prl.AMENDMENT_STATUS,prl.AMENDMENT_TYPE,CONTRACT_TYPE,COST_CONSTRAINT,
1729: to_char(CLM_PERIOD_PERF_START_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_START_DATE,to_char(CLM_PERIOD_PERF_END_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_END_DATE,
1730: nvl(CLM_OPTION_EXERCISED,''N'') CLM_OPTION_EXERCISED, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE, FUND_SOURCE_NOT_KNOWN,CLM_OPTION_INDICATOR,CLM_BASE_LINE_NUM
1731: FROM po_requisition_lines_all prl,
1732: po_requisition_headers_all prh
1733: WHERE prh.conformed_header_id='||p_confirmed_id||
1734: 'AND prh.requisition_header_id=prl.requisition_header_id
1735: AND prh.revision_num='||(p_revision_num -1)||

Line 1749: FROM po_requisition_lines_all prl,

1745: CURRENCY_AMOUNT,JOB_LONG_DESCRIPTION,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,CANDIDATE_FIRST_NAME,
1746: CANDIDATE_LAST_NAME,to_char(ASSIGNMENT_START_DATE,''DD-MON-YYYY HH24:MI:SS'') ASSIGNMENT_START_DATE,prl.AMENDMENT_STATUS,prl.AMENDMENT_TYPE,CONTRACT_TYPE,COST_CONSTRAINT,
1747: to_char(CLM_PERIOD_PERF_START_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_START_DATE,to_char(CLM_PERIOD_PERF_END_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_END_DATE,
1748: nvl(CLM_OPTION_EXERCISED,''N'') CLM_OPTION_EXERCISED, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE, FUND_SOURCE_NOT_KNOWN,CLM_OPTION_INDICATOR,CLM_BASE_LINE_NUM
1749: FROM po_requisition_lines_all prl,
1750: po_requisition_headers_all prh
1751: WHERE prh.conformed_header_id='||p_confirmed_id||
1752: 'AND prh.requisition_header_id=prl.requisition_header_id
1753: AND prh.revision_num='||p_revision_num||

Line 1795: po_requisition_lines_all prl,

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
1799: AND prl.requisition_line_id=nvl(prd.info_line_id,prd.requisition_line_id)

Line 1838: po_requisition_lines_all prl,

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
1842: AND prl.requisition_line_id=nvl(prd.info_line_id,prd.requisition_line_id)

Line 2068: UPDATE po_requisition_lines_all

2064: IF NOT cancel_flag THEN
2065:
2066: IF amend_type = 'CHANGED' THEN
2067:
2068: UPDATE po_requisition_lines_all
2069: SET amendment_status = 'N',
2070: amendment_type = 'CHANGED'
2071: WHERE requisition_line_id=line_id;
2072:

Line 2075: UPDATE po_requisition_lines_all

2071: WHERE requisition_line_id=line_id;
2072:
2073: ELSIF amend_type = 'ADDED' THEN
2074:
2075: UPDATE po_requisition_lines_all
2076: SET amendment_status = 'N',
2077: amendment_type = 'ADDED'
2078: WHERE requisition_line_id=line_id;
2079:

Line 2086: UPDATE po_requisition_lines_all

2082: END IF;
2083:
2084: ELSE
2085: IF old_amend_type in ('ADDED','CHANGED') THEN
2086: UPDATE po_requisition_lines_all
2087: SET amendment_type=old_amend_type,
2088: amendment_status = 'P'
2089: WHERE requisition_line_id=line_id
2090: AND amendment_status NOT IN ('A','R');

Line 2107: UPDATE po_requisition_lines_all

2103: SET amendment_status = 'N',
2104: amendment_type = 'CHANGED'
2105: WHERE distribution_id=dist_id;
2106:
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

Line 2126: FROM po_requisition_lines_all

2122: --Get the amendment_type and amendment_status of the parent
2123: --line and then change its status accordingly
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:

Line 2138: UPDATE po_requisition_lines_all

2134: IF l_amendment_type = 'ADDED' THEN
2135: new_amendment_type := 'ADDED';
2136: END IF;
2137:
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

Line 2233: set_amendment_status('PO_REQUISITION_LINES_ALL',p_revision_num,p_confirmed_id);

2229: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
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:

Line 2721: FROM po_requisition_lines_all prla,

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
2723: WHERE prha.conformed_header_id = p_confirmed_id
2724: AND prha.revision_num = p_revision_num
2725: AND prha.requisition_header_id = prla.requisition_header_id);

Line 2767: INTO po_requisition_lines_all target

2763: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
2764: END IF;
2765:
2766: MERGE
2767: INTO po_requisition_lines_all target
2768: USING
2769: (SELECT * FROM po_requisition_lines_all
2770: WHERE requisition_line_id = p_from_line_id) source
2771: ON ( target.requisition_line_id = p_to_line_id

Line 2769: (SELECT * FROM po_requisition_lines_all

2765:
2766: MERGE
2767: INTO po_requisition_lines_all target
2768: USING
2769: (SELECT * FROM po_requisition_lines_all
2770: WHERE requisition_line_id = p_from_line_id) source
2771: ON ( target.requisition_line_id = p_to_line_id
2772: AND source.conformed_line_id = target.requisition_line_id
2773: )

Line 2874: INSERT INTO po_requisition_lines_all

2870: SELECT po_requisition_lines_s.NEXTVAL
2871: INTO x_new_line_id
2872: FROM dual;
2873:
2874: INSERT INTO po_requisition_lines_all
2875: (requisition_line_id,
2876: requisition_header_id,
2877: line_num,
2878: line_type_id,

Line 3298: FROM po_requisition_lines_all source

3294: source.clm_option_exercised,
3295: source.is_line_num_display_modified,
3296: source.fund_source_not_known,
3297: source.clm_mipr_obligation_type
3298: FROM po_requisition_lines_all source
3299: WHERE source.requisition_line_id = p_from_line_id;
3300:
3301: EXCEPTION
3302: WHEN OTHERS THEN

Line 3491: FROM po_requisition_lines_all

3487: */
3488:
3489: SELECT requisition_line_id , conformed_line_id
3490: BULK COLLECT INTO l_line_ids , l_conformed_line_ids
3491: FROM po_requisition_lines_all
3492: WHERE requisition_header_id = l_req_header_id
3493: AND group_line_id IS NULL
3494: AND clm_base_line_num IS NULL;
3495:

Line 3520: FROM po_requisition_lines_all

3516: v_progress := '001';
3517: --Now pick the Option CLINs
3518: SELECT requisition_line_id , conformed_line_id, clm_base_line_num
3519: BULK COLLECT INTO l_line_ids , l_conformed_line_ids, l_clm_base_line_num
3520: FROM po_requisition_lines_all
3521: WHERE requisition_header_id = l_req_header_id
3522: AND group_line_id IS NULL
3523: AND clm_base_line_num IS NOT NULL;
3524:

Line 3551: FROM po_requisition_lines_all

3547: v_progress := '002';
3548: --Now pick the SLINs which are not option
3549: SELECT requisition_line_id , conformed_line_id, group_line_id
3550: BULK COLLECT INTO l_line_ids , l_conformed_line_ids, l_group_line_id
3551: FROM po_requisition_lines_all
3552: WHERE requisition_header_id = l_req_header_id
3553: AND group_line_id IS NOT NULL
3554: AND clm_base_line_num IS NULL;
3555:

Line 3585: FROM po_requisition_lines_all

3581: v_progress := '003';
3582: --Now pick the SLINs which are also option
3583: SELECT requisition_line_id , conformed_line_id, group_line_id, clm_base_line_num
3584: BULK COLLECT INTO l_line_ids , l_conformed_line_ids, l_group_line_id, l_clm_base_line_num
3585: FROM po_requisition_lines_all
3586: WHERE requisition_header_id = l_req_header_id
3587: AND group_line_id IS NOT NULL
3588: AND clm_base_line_num IS NOT NULL;
3589:

Line 4143: FROM po_requisition_lines_all

4139: l_log_msg VARCHAR2(2000);
4140:
4141: CURSOR line_cursor IS
4142: SELECT requisition_line_id
4143: FROM po_requisition_lines_all
4144: WHERE requisition_header_id = p_from_req_header_id;
4145:
4146: from_req_line_id NUMBER;
4147: to_req_line_id NUMBER;

Line 4175: INSERT INTO po_requisition_lines_all (

4171: INTO to_req_line_id
4172: FROM dual;
4173:
4174:
4175: INSERT INTO po_requisition_lines_all (
4176: requisition_line_id,
4177: requisition_header_id,
4178: line_num,
4179: line_type_id,

Line 4597: FROM po_requisition_lines_all prl

4593: prl.clm_option_exercised,
4594: prl.uda_template_id,
4595: prl.fund_source_not_known,
4596: clm_mipr_obligation_type
4597: FROM po_requisition_lines_all prl
4598: WHERE prl.requisition_line_id = from_req_line_id;
4599:
4600: v_progress := '002';
4601:

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 4963: UPDATE po_requisition_lines_all SET amendment_status = 'A'

4959: END IF;
4960:
4961: --First update all those lines and distribution to accepted whose
4962: --conformed_ids are null and they are CLIN
4963: UPDATE po_requisition_lines_all SET amendment_status = 'A'
4964: WHERE conformed_line_id IS NULL AND
4965: group_line_id IS NULL AND
4966: requisition_header_id = l_requisition_header_id;
4967:

Line 4969: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'

4965: group_line_id IS NULL AND
4966: requisition_header_id = l_requisition_header_id;
4967:
4968: --Update it for slins whose clin is also new
4969: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'
4970: WHERE prla.requisition_header_id = l_requisition_header_id
4971: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1
4972: WHERE prla1.requisition_line_id = prla.group_line_id
4973: AND prla1.conformed_line_id IS NULL

Line 4971: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1

4967:
4968: --Update it for slins whose clin is also new
4969: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'
4970: WHERE prla.requisition_header_id = l_requisition_header_id
4971: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1
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:

Line 4979: (SELECT requisition_line_id FROM po_requisition_lines_all

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
4981: requisition_header_id = l_requisition_header_id);
4982:
4983: --Now update those lines and distributions whose

Line 4986: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'

4982:
4983: --Now update those lines and distributions whose
4984: --conformed_ids is not null but the corresponding
4985: --line_location_id is null
4986: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'
4987: WHERE prla.requisition_header_id = l_requisition_header_id
4988: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1
4989: WHERE prla1.requisition_line_id = prla.conformed_line_id
4990: AND prla1.line_location_id IS NULL

Line 4988: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1

4984: --conformed_ids is not null but the corresponding
4985: --line_location_id is null
4986: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'
4987: WHERE prla.requisition_header_id = l_requisition_header_id
4988: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1
4989: WHERE prla1.requisition_line_id = prla.conformed_line_id
4990: AND prla1.line_location_id IS NULL
4991: AND prla1.auction_header_id is NULL
4992: AND nvl(prla1.clm_info_flag,'N') = 'N')

Line 4996: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'

4992: AND nvl(prla1.clm_info_flag,'N') = 'N')
4993: AND prla.group_line_id IS NULL;
4994:
4995: --Update slins whose clins are not placed on PO and amendment_status='A'
4996: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'
4997: WHERE prla.requisition_header_id = l_requisition_header_id
4998: AND prla.group_line_id IS NOT NULL
4999: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1,po_requisition_lines_all prla2
5000: WHERE prla1.requisition_line_id = prla.group_line_id

Line 4999: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1,po_requisition_lines_all prla2

4995: --Update slins whose clins are not placed on PO and amendment_status='A'
4996: UPDATE po_requisition_lines_all prla SET prla.amendment_status = 'A'
4997: WHERE prla.requisition_header_id = l_requisition_header_id
4998: AND prla.group_line_id IS NOT NULL
4999: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1,po_requisition_lines_all prla2
5000: WHERE prla1.requisition_line_id = prla.group_line_id
5001: AND prla2.requisition_line_id = prla1.conformed_line_id
5002: AND prla2.line_location_id IS NULL
5003: AND prla2.auction_header_id is NULL

Line 5009: (SELECT requisition_line_id FROM po_requisition_lines_all prla

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
5012: WHERE prla1.requisition_line_id = prla.conformed_line_id
5013: AND prla1.line_location_id IS NULL

Line 5011: AND EXISTS (SELECT 1 FROM po_requisition_lines_all prla1

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
5012: WHERE prla1.requisition_line_id = prla.conformed_line_id
5013: AND prla1.line_location_id IS NULL
5014: AND prla1.auction_header_id is NULL));
5015:

Line 5210: FROM po_requisition_lines_all prl,

5206: END IF;
5207:
5208: SELECT Min(awdrefs.agent_id)
5209: INTO l_buyer_id
5210: FROM po_requisition_lines_all prl,
5211: PO_CLMREQ_LINE_AWD_REFS_V awdrefs
5212: -- po_line_locations_all pll,
5213: -- po_headers_all pha
5214: WHERE prl.requisition_header_id = (SELECT conformed_header_id

Line 5308: po_requisition_lines_all prl

5304:
5305: SELECT Min(pah.trading_partner_contact_id)
5306: INTO l_sourcing_owner_id
5307: FROM pon_auction_headers_all pah,
5308: po_requisition_lines_all prl
5309: WHERE prl.requisition_header_id = (SELECT conformed_header_id
5310: FROM po_requisition_headers_all
5311: WHERE requisition_header_id = l_document_id)
5312: AND pah.auction_header_id = prl.auction_header_id

Line 5521: FROM po_requisition_lines_all

5517: l_authorization_status po_headers_all.authorization_status%TYPE;
5518: BEGIN
5519: SELECT line_location_id
5520: INTO l_line_location_id
5521: FROM po_requisition_lines_all
5522: WHERE REQUISITION_line_ID = reqLineId;
5523:
5524: IF l_line_location_id IS NOT NULL THEN
5525: IF l_line_location_id < 0 THEN

Line 5716: update po_requisition_lines_all

5712:
5713: v_progress := '001';
5714:
5715: FORALL i in 1..p_line_id_list.count
5716: update po_requisition_lines_all
5717: set amendment_type='CANCELLED',
5718: amendment_status='A',
5719: cancel_flag='Y'
5720: where requisition_header_id = p_req_header_id

Line 5778: x_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;

5774: x_po_uom varchar2(25):=null;
5775: x_req_uom varchar2(25):=null;
5776: x_uom_convert varchar2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
5777: x_conversion_rate number := 1;
5778: x_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
5779:
5780:
5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;

Line 5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

5777: x_conversion_rate number := 1;
5778: x_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
5779:
5780:
5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;
5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;

Line 5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;

5778: x_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
5779:
5780:
5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;
5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

Line 5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

5779:
5780:
5781: x_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5782: x_req_rate_date PO_REQUISITION_LINES_ALL.rate_date%TYPE;
5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

Line 5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

5783: x_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;
5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

Line 5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;

5784: x_po_currency_code PO_HEADERS_ALL.currency_code%TYPE;
5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;
5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
5792:

Line 5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;

5785: x_pcard_id PO_HEADERS_ALL.pcard_id%TYPE;
5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;
5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
5792:
5793: --

Line 5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;

5786: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;
5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
5792:
5793: --
5794:

Line 5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

5787: x_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
5788: x_req_quantity PO_REQUISITION_LINES_ALL.quantity%TYPE;
5789: x_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5790: x_req_base_unit_price PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;
5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
5792:
5793: --
5794:
5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;

Line 5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;

5791: x_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
5792:
5793: --
5794:
5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;
5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;

Line 5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;

5792:
5793: --
5794:
5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;
5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;

Line 5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;

5793: --
5794:
5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;
5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;

Line 5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;

5794:
5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;
5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;

Line 5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;

5795: x_deliver_to_location_id PO_REQUISITION_LINES_ALL.deliver_to_location_id%TYPE;
5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;
5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;

Line 5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;

5796: x_deliver_to_person_id PO_REQUISITION_LINES_ALL.to_person_id%TYPE;
5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;

Line 5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;

5797: x_destination_type_code PO_REQUISITION_LINES_ALL.destination_type_code%TYPE;
5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;

Line 5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;

5798: x_destination_organization_id PO_REQUISITION_LINES_ALL.destination_organization_id%TYPE;
5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;
5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;

Line 5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;

5799: x_destination_subinventory PO_REQUISITION_LINES_ALL.destination_subinventory%TYPE;
5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;
5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;
5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;

Line 5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;

5800: x_wip_entity_id PO_REQUISITION_LINES_ALL.wip_entity_id%TYPE;
5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;
5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;
5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;
5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;

Line 5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;

5801: x_wip_line_id PO_REQUISITION_LINES_ALL.wip_line_id%TYPE;
5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;
5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;
5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;
5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;
5809:

Line 5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;

5802: x_wip_repetitive_schedule_id PO_REQUISITION_LINES_ALL.wip_repetitive_schedule_id%TYPE;
5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;
5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;
5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;
5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;
5809:
5810: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

Line 5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;

5803: x_wip_operation_seq_num PO_REQUISITION_LINES_ALL.wip_operation_seq_num%TYPE;
5804: x_wip_resource_seq_num PO_REQUISITION_LINES_ALL.wip_resource_seq_num%TYPE;
5805: x_bom_resource_id PO_REQUISITION_LINES_ALL.bom_resource_id%TYPE;
5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;
5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;
5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;
5809:
5810: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
5811: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

Line 5885: FROM po_requisition_lines_all

5881: SELECT order_type_lookup_code
5882: INTO x_order_type_lookup_code
5883: FROM po_line_types
5884: WHERE line_type_id =(SELECT line_type_id
5885: FROM po_requisition_lines_all
5886: WHERE requisition_line_id = x_requisition_line_id);
5887:
5888:
5889: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 5898: po_Requisition_lines_all PRL

5894:
5895: SELECT PRH.org_id
5896: INTO x_requesting_ou_id
5897: FROM po_requisition_headers_all PRH,
5898: po_Requisition_lines_all PRL
5899: WHERE PRH.requisition_header_id=PRL.requisition_header_id
5900: AND PRL.requisition_line_id = x_requisition_line_id;
5901:
5902:

Line 5972: FROM po_requisition_lines_all pol --

5968:
5969: Begin
5970: SELECT KANBAN_CARD_ID
5971: INTO x_kanban_card_id
5972: FROM po_requisition_lines_all pol --
5973: WHERE pol.REQUISITION_LINE_ID = x_requisition_line_id;
5974: Exception
5975: WHEN NO_DATA_FOUND THEN
5976: /* Not all req has kanban id */

Line 6068: FROM po_requisition_lines_all prl

6064: SELECT unit_meas_lookup_code,
6065: item_id
6066: INTO x_req_uom,
6067: x_item_id
6068: FROM po_requisition_lines_all prl
6069: WHERE prl.requisition_line_id = x_requisition_line_id;
6070:
6071:
6072:

Line 6175: FROM po_requisition_lines_all PRL

6171: x_wip_resource_seq_num,
6172: x_bom_resource_id,
6173: x_destination_context,
6174: x_vendor_id
6175: FROM po_requisition_lines_all PRL
6176: WHERE PRL.requisition_line_id = x_requisition_line_id;
6177:
6178: EXCEPTION
6179: WHEN OTHERS THEN

Line 6547: FROM po_requisition_lines_all prl,

6543: l_log_msg VARCHAR2(2000);
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

Line 6636: FROM po_requisition_lines_all clin,

6632: auction_id := To_Number(dest_doc_id);
6633: ELSE
6634: SELECT clin.auction_header_id
6635: INTO auction_id
6636: FROM po_requisition_lines_all clin,
6637: po_requisition_lines_all slin
6638: WHERE slin.requisition_line_id = x_req_line_id
6639: AND slin.group_line_id = clin.requisition_line_id
6640: AND slin.amendment_type IN ('ADDED')

Line 6637: po_requisition_lines_all slin

6633: ELSE
6634: SELECT clin.auction_header_id
6635: INTO auction_id
6636: FROM po_requisition_lines_all clin,
6637: po_requisition_lines_all slin
6638: WHERE slin.requisition_line_id = x_req_line_id
6639: AND slin.group_line_id = clin.requisition_line_id
6640: AND slin.amendment_type IN ('ADDED')
6641: AND slin.amendment_status IN ('N')

Line 6757: FROM po_requisition_lines_all

6753: SELECT getLatestAmendmentNum(prh.requisition_header_id)
6754: INTO x_amendment_num
6755: FROM po_requisition_headers_all prh
6756: WHERE prh.requisition_header_id = (SELECT requisition_header_id
6757: FROM po_requisition_lines_all
6758: WHERE requisition_line_id = p_conformed_req_line_id);
6759:
6760: SELECT Max(requisition_line_id)
6761: INTO x_line_id

Line 6762: FROM po_requisition_lines_all

6758: WHERE requisition_line_id = p_conformed_req_line_id);
6759:
6760: SELECT Max(requisition_line_id)
6761: INTO x_line_id
6762: FROM po_requisition_lines_all
6763: WHERE conformed_line_id = p_conformed_req_line_id
6764: AND amendment_type = 'CHANGED'
6765: AND amendment_status IN ('A','R');
6766:

Line 6770: FROM po_requisition_lines_all

6766:
6767: IF x_line_id IS NULL THEN
6768: SELECT Min(requisition_line_id)
6769: INTO x_line_id
6770: FROM po_requisition_lines_all
6771: WHERE conformed_line_id = p_conformed_req_line_id;
6772: END IF;
6773:
6774:

Line 6779: compare_table_for_implement('PO_REQUISITION_LINES_ALL',

6775: v_progress := '005';
6776:
6777: IF x_line_id IS NOT NULL THEN
6778:
6779: compare_table_for_implement('PO_REQUISITION_LINES_ALL',
6780: p_conformed_req_line_id,
6781: x_line_id,
6782: p_sequence_num,
6783: x_amendment_num);

Line 6794: FROM po_requisition_lines_all

6790: ELSE
6791: --this means this is a new line added during amendment.
6792: SELECT line_num,line_num_display
6793: INTO l_line_num,l_line_num_disp
6794: FROM po_requisition_lines_all
6795: WHERE requisition_line_id = p_conformed_req_line_id;
6796:
6797: SELECT revision_num INTO l_revision_num
6798: FROM po_requisition_headers_all

Line 6900: * PO_REQUISITION_LINES_ALL

6896: *
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

Line 6955: IF p_table_name = 'PO_REQUISITION_LINES_ALL' THEN

6951:
6952: rec_index := 1;
6953:
6954:
6955: IF p_table_name = 'PO_REQUISITION_LINES_ALL' THEN
6956:
6957:
6958: sql_stmt1 := 'SELECT REQUISITION_LINE_ID,LINE_NUM, LINE_NUM_DISPLAY,nvl(prl.CANCEL_FLAG,''N'') CANCEL_FLAG, nvl(prl.CLOSED_CODE,''OPEN'') CLOSED_CODE,ITEM_ID,ITEM_REVISION,
6959: ITEM_DESCRIPTION, CATEGORY_ID, UNIT_MEAS_LOOKUP_CODE, UNIT_PRICE,QUANTITY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,

Line 6969: FROM po_requisition_lines_all prl

6965: CURRENCY_AMOUNT,JOB_LONG_DESCRIPTION,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,CANDIDATE_FIRST_NAME,
6966: CANDIDATE_LAST_NAME,to_char(ASSIGNMENT_START_DATE,''DD-MON-YYYY HH24:MI:SS'') ASSIGNMENT_START_DATE,CONTRACT_TYPE,COST_CONSTRAINT,
6967: to_char(CLM_PERIOD_PERF_START_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_START_DATE,to_char(CLM_PERIOD_PERF_END_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_END_DATE,
6968: nvl(CLM_OPTION_EXERCISED,''N'') CLM_OPTION_EXERCISED, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE,CLM_OPTION_INDICATOR , CLM_BASE_LINE_NUM , CLM_MIPR_OBLIGATION_TYPE
6969: FROM po_requisition_lines_all prl
6970: WHERE prl.requisition_line_id='||p_to_req_line_id||
6971: 'ORDER BY LINE_NUM';
6972:
6973: sql_stmt2 := 'SELECT REQUISITION_LINE_ID,LINE_NUM, LINE_NUM_DISPLAY,nvl(prl.CANCEL_FLAG,''N'') CANCEL_FLAG, nvl(prl.CLOSED_CODE,''OPEN'') CLOSED_CODE,ITEM_ID,ITEM_REVISION,

Line 6984: FROM po_requisition_lines_all prl

6980: CURRENCY_AMOUNT,JOB_LONG_DESCRIPTION,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,CANDIDATE_FIRST_NAME,
6981: CANDIDATE_LAST_NAME,to_char(ASSIGNMENT_START_DATE,''DD-MON-YYYY HH24:MI:SS'') ASSIGNMENT_START_DATE,CONTRACT_TYPE,COST_CONSTRAINT,
6982: to_char(CLM_PERIOD_PERF_START_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_START_DATE,to_char(CLM_PERIOD_PERF_END_DATE,''DD-MON-YYYY HH24:MI:SS'') CLM_PERIOD_PERF_END_DATE,
6983: nvl(CLM_OPTION_EXERCISED,''N'') CLM_OPTION_EXERCISED, CLM_OPTION_FROM_DATE, CLM_OPTION_TO_DATE, CLM_OPTION_INDICATOR, CLM_BASE_LINE_NUM , CLM_MIPR_OBLIGATION_TYPE
6984: FROM po_requisition_lines_all prl
6985: WHERE prl.requisition_line_id='||p_from_req_line_id||
6986: 'ORDER BY LINE_NUM';
6987:
6988:

Line 7026: po_requisition_lines_all prl

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';
7030:

Line 7064: po_requisition_lines_all prl

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';
7068:

Line 7147: l_line_num_display po_requisition_lines_all.line_num_display%type;

7143: v_progress VARCHAR2(3);
7144: l_procedure_name VARCHAR2(100) := 'accept_amendment_changes';
7145: l_log_msg VARCHAR2(2000);
7146: l_latest_amendment_hdr_id number;
7147: l_line_num_display po_requisition_lines_all.line_num_display%type;
7148: l_amendment_line_id number;
7149:
7150: BEGIN
7151:

Line 7176: UPDATE po_requisition_lines_all

7172:
7173: /* Update amendment status of the implemented lines/ distributions
7174: selected_lines is the list of line_id from conformed copy. When
7175: stamping the response, stamp it on the lastest amendment copy also */
7176: UPDATE po_requisition_lines_all
7177: SET amendment_status = 'A',
7178: amendment_response_reason = reason
7179: WHERE requisition_line_id = selected_lines(i)
7180: AND amendment_status IN ('N','P');

Line 7185: po_requisition_lines_all prl

7181:
7182: select prh.requisition_header_id
7183: into l_latest_amendment_hdr_id
7184: from po_requisition_headers_all prh,
7185: po_requisition_lines_all prl
7186: where prh.revision_num = (select max(prh2.revision_num)
7187: from po_requisition_headers_all prh2,
7188: po_requisition_lines_all prl2
7189: where prh2.conformed_header_id = prl2.requisition_header_id

Line 7188: po_requisition_lines_all prl2

7184: from po_requisition_headers_all prh,
7185: po_requisition_lines_all prl
7186: where prh.revision_num = (select max(prh2.revision_num)
7187: from po_requisition_headers_all prh2,
7188: po_requisition_lines_all prl2
7189: where prh2.conformed_header_id = prl2.requisition_header_id
7190: and prl2.requisition_line_id = selected_lines(i) )
7191: and prh.conformed_header_id = prl.requisition_header_id
7192: and prl.requisition_line_id = selected_lines(i);

Line 7196: from po_requisition_lines_all prl1,

7192: and prl.requisition_line_id = selected_lines(i);
7193:
7194: select prl2.requisition_line_id, prl2.line_num_display
7195: into l_amendment_line_id, l_line_num_display
7196: from po_requisition_lines_all prl1,
7197: po_requisition_lines_all prl2
7198: where prl1.requisition_line_id = selected_lines(i)
7199: and prl2.requisition_header_id = l_latest_amendment_hdr_id
7200: and prl1.line_num_display = prl2.line_num_display;

Line 7197: po_requisition_lines_all prl2

7193:
7194: select prl2.requisition_line_id, prl2.line_num_display
7195: into l_amendment_line_id, l_line_num_display
7196: from po_requisition_lines_all prl1,
7197: po_requisition_lines_all prl2
7198: where prl1.requisition_line_id = selected_lines(i)
7199: and prl2.requisition_header_id = l_latest_amendment_hdr_id
7200: and prl1.line_num_display = prl2.line_num_display;
7201:

Line 7202: UPDATE po_requisition_lines_all prl

7198: where prl1.requisition_line_id = selected_lines(i)
7199: and prl2.requisition_header_id = l_latest_amendment_hdr_id
7200: and prl1.line_num_display = prl2.line_num_display;
7201:
7202: UPDATE po_requisition_lines_all prl
7203: SET amendment_status = 'A',
7204: amendment_response_reason = reason
7205: WHERE requisition_line_id = l_amendment_line_id
7206: and amendment_status in ('N','P');

Line 7223: UPDATE po_requisition_lines_all

7219: ELSIF implement_mode = 'REJECT' THEN
7220: FOR i IN 1..selected_lines.count
7221: LOOP
7222: /* Update amendment status of the implemented lines/ distributions */
7223: UPDATE po_requisition_lines_all
7224: SET amendment_status = 'R',
7225: amendment_response_reason = reason
7226: WHERE requisition_line_id = selected_lines(i)
7227: AND amendment_status IN ('N','P');

Line 7232: po_requisition_lines_all prl

7228:
7229: select prh.requisition_header_id
7230: into l_latest_amendment_hdr_id
7231: from po_requisition_headers_all prh,
7232: po_requisition_lines_all prl
7233: where prh.revision_num = (select max(prh2.revision_num)
7234: from po_requisition_headers_all prh2,
7235: po_requisition_lines_all prl2
7236: where prh2.conformed_header_id = prl2.requisition_header_id

Line 7235: po_requisition_lines_all prl2

7231: from po_requisition_headers_all prh,
7232: po_requisition_lines_all prl
7233: where prh.revision_num = (select max(prh2.revision_num)
7234: from po_requisition_headers_all prh2,
7235: po_requisition_lines_all prl2
7236: where prh2.conformed_header_id = prl2.requisition_header_id
7237: and prl2.requisition_line_id = selected_lines(i) )
7238: and prh.conformed_header_id = prl.requisition_header_id
7239: and prl.requisition_line_id = selected_lines(i);

Line 7243: from po_requisition_lines_all prl1,

7239: and prl.requisition_line_id = selected_lines(i);
7240:
7241: select prl2.requisition_line_id, prl2.line_num_display
7242: into l_amendment_line_id, l_line_num_display
7243: from po_requisition_lines_all prl1,
7244: po_requisition_lines_all prl2
7245: where prl1.requisition_line_id = selected_lines(i)
7246: and prl2.requisition_header_id = l_latest_amendment_hdr_id
7247: and prl1.line_num_display = prl2.line_num_display;

Line 7244: po_requisition_lines_all prl2

7240:
7241: select prl2.requisition_line_id, prl2.line_num_display
7242: into l_amendment_line_id, l_line_num_display
7243: from po_requisition_lines_all prl1,
7244: po_requisition_lines_all prl2
7245: where prl1.requisition_line_id = selected_lines(i)
7246: and prl2.requisition_header_id = l_latest_amendment_hdr_id
7247: and prl1.line_num_display = prl2.line_num_display;
7248:

Line 7249: UPDATE po_requisition_lines_all prl

7245: where prl1.requisition_line_id = selected_lines(i)
7246: and prl2.requisition_header_id = l_latest_amendment_hdr_id
7247: and prl1.line_num_display = prl2.line_num_display;
7248:
7249: UPDATE po_requisition_lines_all prl
7250: SET amendment_status = 'R',
7251: amendment_response_reason = reason
7252: WHERE requisition_line_id = l_amendment_line_id
7253: and amendment_status in ('N','P');

Line 7300: from po_requisition_lines_all

7296: END IF;
7297:
7298: select po_line_id
7299: into l_po_line_id
7300: from po_requisition_lines_all
7301: where requisition_line_id = p_conformed_line_id;
7302:
7303: if(l_po_line_id IS NOT NULL) THEN --line is placed on PO irrespective of whether its priced/info/option
7304: ret_val := 'Y';

Line 7320: from po_requisition_lines_all

7316: ret_val VARCHAR2(1) := 'N';
7317: begin
7318: select count(*)
7319: into l_cnt
7320: from po_requisition_lines_all
7321: where requisition_line_id = p_conformed_line_id
7322: and auction_header_id is not null;
7323:
7324: if(l_cnt > 0) then

Line 7337: from po_requisition_lines_all

7333: l_option_exercised varchar2(1) := 'N';
7334: begin
7335: select nvl(CLM_OPTION_EXERCISED,'N')
7336: into l_option_exercised
7337: from po_requisition_lines_all
7338: where requisition_line_id = p_conformed_line_id;
7339:
7340: if(l_option_exercised = 'Y') then
7341: return 'Y';

Line 7505: po_requisition_lines_all prla,

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
7509: AND prda.requisition_line_id = prla.requisition_line_id

Line 7934: l_db_object_name := 'PO_REQUISITION_LINES_ALL';

7930: WHERE segment1 = amend_num;
7931:
7932: ELSIF p_lavel = 'UDA_LINES' THEN
7933:
7934: l_db_object_name := 'PO_REQUISITION_LINES_ALL';
7935: l_pk1_col_name := 'REQUISITION_HEADER_ID';
7936:
7937: SELECT requisition_header_id
7938: INTO l_req_header_id

Line 7945: FROM PO_REQUISITION_LINES_ALL

7941:
7942:
7943: SELECT requisition_line_id
7944: INTO l_pk1_col_val
7945: FROM PO_REQUISITION_LINES_ALL
7946: WHERE requisition_header_id = l_req_header_id
7947: AND line_num = line_num;
7948:
7949: END IF; -- ELSIF p_lavel = 'UDA_LINES' THEN

Line 8045: FROM po_requisition_lines_all

8041: --First of all check whether this clin itself is placed on a PO
8042: --if yes then return 1 else check for the slins
8043: BEGIN
8044: SELECT 1 INTO l_num
8045: FROM po_requisition_lines_all
8046: WHERE requisition_line_id = l_clin_line_id
8047: AND line_location_id IS NOT NULL;
8048:
8049: IF l_num IS NOT NULL THEN

Line 8058: FROM po_requisition_lines_all

8054: NULL;
8055: END;
8056:
8057: SELECT 1 INTO l_num
8058: FROM po_requisition_lines_all
8059: WHERE group_line_id = l_clin_line_id
8060: AND line_location_id IS NOT NULL
8061: AND ROWNUM=1;
8062:

Line 8129: x_req_line_id po_requisition_lines_all.REQUISITION_LINE_ID%TYPE;

8125: pragma AUTONOMOUS_TRANSACTION;
8126: l_use_gl_date VARCHAR2(1);
8127: x_amendment_reason PO_REQUISITION_HEADERS_ALL.AMENDMENT_REASON%TYPE;
8128: x_preparer_id PO_REQUISITION_HEADERS_ALL.PREPARER_ID%TYPE;
8129: x_req_line_id po_requisition_lines_all.REQUISITION_LINE_ID%TYPE;
8130: x_conf_line_id po_requisition_lines_all.CONFORMED_LINE_ID%TYPE;
8131: l_return_status VARCHAR2(1);
8132: l_po_return_code VARCHAR2(10);
8133: l_detailed_results po_fcout_type;

Line 8130: x_conf_line_id po_requisition_lines_all.CONFORMED_LINE_ID%TYPE;

8126: l_use_gl_date VARCHAR2(1);
8127: x_amendment_reason PO_REQUISITION_HEADERS_ALL.AMENDMENT_REASON%TYPE;
8128: x_preparer_id PO_REQUISITION_HEADERS_ALL.PREPARER_ID%TYPE;
8129: x_req_line_id po_requisition_lines_all.REQUISITION_LINE_ID%TYPE;
8130: x_conf_line_id po_requisition_lines_all.CONFORMED_LINE_ID%TYPE;
8131: l_return_status VARCHAR2(1);
8132: l_po_return_code VARCHAR2(10);
8133: l_detailed_results po_fcout_type;
8134: X_req_control_error_rc VARCHAR2(1) := NULL;

Line 8137: x_po_line_id po_requisition_lines_all.po_line_id%TYPE;

8133: l_detailed_results po_fcout_type;
8134: X_req_control_error_rc VARCHAR2(1) := NULL;
8135: l_req_encumbrance_on VARCHAR2(1);
8136: l_valid_cancel_action VARCHAR2(1);
8137: x_po_line_id po_requisition_lines_all.po_line_id%TYPE;
8138: x_line_loc_id po_requisition_lines_all.line_location_id%TYPE;
8139: x_org_id NUMBER;
8140:
8141: CURSOR get_cancel_lines(x_req_header_id NUMBER) IS

Line 8138: x_line_loc_id po_requisition_lines_all.line_location_id%TYPE;

8134: X_req_control_error_rc VARCHAR2(1) := NULL;
8135: l_req_encumbrance_on VARCHAR2(1);
8136: l_valid_cancel_action VARCHAR2(1);
8137: x_po_line_id po_requisition_lines_all.po_line_id%TYPE;
8138: x_line_loc_id po_requisition_lines_all.line_location_id%TYPE;
8139: x_org_id NUMBER;
8140:
8141: CURSOR get_cancel_lines(x_req_header_id NUMBER) IS
8142: SELECT REQUISITION_LINE_ID,CONFORMED_LINE_ID

Line 8143: FROM po_requisition_lines_all

8139: x_org_id NUMBER;
8140:
8141: CURSOR get_cancel_lines(x_req_header_id NUMBER) IS
8142: SELECT REQUISITION_LINE_ID,CONFORMED_LINE_ID
8143: FROM po_requisition_lines_all
8144: WHERE requisition_header_id = x_req_header_id
8145: AND AMENDMENT_TYPE = 'CANCELLED'
8146: AND AMENDMENT_STATUS = 'N';
8147:

Line 8165: FROM po_requisition_lines_all

8161: EXIT WHEN get_cancel_lines%NOTFOUND;
8162:
8163: SELECT po_line_id, line_location_id
8164: INTO x_po_line_id, x_line_loc_id
8165: FROM po_requisition_lines_all
8166: WHERE requisition_line_id = x_conf_line_id;
8167:
8168: IF x_po_line_id IS NOT NULL OR x_line_loc_id IS NOT NULL THEN
8169: l_valid_cancel_action := 'N';

Line 8179: UPDATE po_requisition_lines_all set cancel_flag = 'I'

8175: IF l_valid_cancel_action = 'Y' THEN
8176:
8177: IF l_req_encumbrance_on = 'Y' THEN
8178:
8179: UPDATE po_requisition_lines_all set cancel_flag = 'I'
8180: WHERE requisition_line_id = x_conf_line_id and nvl(cancel_flag,'N') = 'N';
8181:
8182: COMMIT;
8183:

Line 8204: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds failed. Contact Purchasing Administrator if necessary.',

8200: );
8201:
8202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL THEN
8203:
8204: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds failed. Contact Purchasing Administrator if necessary.',
8205: amendment_status = 'R',
8206: amendment_type = 'CANCELLED'
8207: WHERE requisition_line_id IN (x_conf_line_id, x_req_line_id);
8208:

Line 8209: update po_requisition_lines_all set cancel_flag = NULL

8205: amendment_status = 'R',
8206: amendment_type = 'CANCELLED'
8207: WHERE requisition_line_id IN (x_conf_line_id, x_req_line_id);
8208:
8209: update po_requisition_lines_all set cancel_flag = NULL
8210: where requisition_line_id = x_conf_line_id and nvl(cancel_flag,'N') = 'I';
8211:
8212: CONTINUE;
8213: END IF;

Line 8217: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds completed with warnings.',

8213: END IF;
8214:
8215: IF l_po_return_code = 'WARNING' THEN
8216:
8217: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds completed with warnings.',
8218: amendment_type = 'CANCELLED'
8219: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8220:
8221: ELSE IF l_po_return_code = 'FAILURE' THEN

Line 8223: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds completed with errors.',

8219: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8220:
8221: ELSE IF l_po_return_code = 'FAILURE' THEN
8222:
8223: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds completed with errors.',
8224: amendment_status = 'R',
8225: amendment_type = 'CANCELLED'
8226: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8227:

Line 8228: update po_requisition_lines_all set cancel_flag = NULL

8224: amendment_status = 'R',
8225: amendment_type = 'CANCELLED'
8226: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8227:
8228: update po_requisition_lines_all set cancel_flag = NULL
8229: where requisition_line_id = x_conf_line_id and nvl(cancel_flag,'N') = 'I';
8230:
8231: CONTINUE;
8232:

Line 8253: UPDATE po_requisition_lines_all SET amendment_status = 'A',

8249: X_req_control_error_rc);
8250:
8251: po_negotiation_req_notif.call_negotiation_wf('REQ HEADER', p_conf_hdr_id);
8252:
8253: UPDATE po_requisition_lines_all SET amendment_status = 'A',
8254: amendment_type = 'CANCELLED'
8255: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8256:
8257: ELSE

Line 8259: UPDATE po_requisition_lines_all SET amendment_status = 'R',

8255: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8256:
8257: ELSE
8258:
8259: UPDATE po_requisition_lines_all SET amendment_status = 'R',
8260: amendment_type = 'CANCELLED'
8261: WHERE requisition_line_id in (x_req_line_id, x_conf_line_id);
8262:
8263: END IF;