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_HEADERS_ALL

Line 46: * PO_REQUISITION_HEADERS_ALL

42: * the temp table with field altered, old value and new value.
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

Line 105: IF p_table_name = 'PO_REQUISITION_HEADERS_ALL' then

101:
102: -- SQL What: Querying the archive table for the given revision_num and previous revision_num
103: -- SQL Why: Need to compare the values for each column
104:
105: IF p_table_name = 'PO_REQUISITION_HEADERS_ALL' then
106:
107: sql_stmt1:='SELECT REQUISITION_HEADER_ID,
108: SEGMENT1,
109: nvl(CANCEL_FLAG,''N'') CANCEL_FLAG,

Line 119: FROM po_requisition_headers_all

115: REVISION_NUM,
116: CLM_MIPR_TYPE,
117: CLM_MIPR_PREPARED_DATE,
118: CLM_MIPR_REF_NUM
119: FROM po_requisition_headers_all
120: WHERE conformed_header_id='||p_confirmed_id||
121: ' AND revision_num='||(p_revision_num -1);
122:
123:

Line 136: FROM po_requisition_headers_all

132: REVISION_NUM,
133: CLM_MIPR_TYPE,
134: CLM_MIPR_PREPARED_DATE,
135: CLM_MIPR_REF_NUM
136: FROM po_requisition_headers_all
137: WHERE conformed_header_id='||p_confirmed_id||
138: ' AND revision_num='||p_revision_num;
139:
140:

Line 157: po_requisition_headers_all prh

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)||
161: 'ORDER BY LINE_NUM';

Line 175: po_requisition_headers_all prh

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||
179: 'ORDER BY LINE_NUM';

Line 220: po_requisition_headers_all prh

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)
224: AND revision_num='||(p_revision_num -1)||

Line 262: po_requisition_headers_all prh

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)
266: AND revision_num='||p_revision_num||

Line 276: po_requisition_headers_all h,

272:
273: SELECT u.attribute_group_id, ag.attr_group_name
274: INTO g_address_attr_group_id, g_address_group_name
275: FROM po_uda_ag_template_usages u,
276: po_requisition_headers_all h,
277: ego_attr_groups_v ag
278: WHERE h.uda_template_id = u.template_id
279: AND h.requisition_header_id = p_confirmed_id
280: AND ag.attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS'

Line 292: FROM po_requisition_headers_all prh

288:
289: sql_stmt1:= 'SELECT '|| l_select_cols ||'
290: FROM po_req_headers_ext_b
291: WHERE requisition_header_id = (SELECT prh.requisition_header_id
292: FROM po_requisition_headers_all prh
293: WHERE prh.conformed_header_id= '||p_confirmed_id||
294: 'AND prh.revision_num='||(p_revision_num-1)||')
295: and attr_group_id = '|| g_address_attr_group_id ||'
296: ORDER BY C_EXT_ATTR39';

Line 302: FROM po_requisition_headers_all prh

298:
299: sql_stmt2:= 'SELECT '|| l_select_cols ||'
300: FROM po_req_headers_ext_b
301: WHERE requisition_header_id = (SELECT prh.requisition_header_id
302: FROM po_requisition_headers_all prh
303: WHERE prh.conformed_header_id= '||p_confirmed_id||
304: 'AND prh.revision_num='||(p_revision_num)||')
305: and attr_group_id = '|| g_address_attr_group_id ||'
306: ORDER BY C_EXT_ATTR39';

Line 319: FROM po_requisition_headers_all prh

315: INTO x_database_view_name,
316: x_template_id
317: FROM po_uda_ag_templates
318: WHERE template_id = (SELECT prh.uda_template_id
319: FROM po_requisition_headers_all prh
320: WHERE prh.conformed_header_id= p_confirmed_id
321: AND prh.revision_num=p_revision_num);
322:
323: -- bug 14248325 getting the org_id so that we can use the org_id as a context while deriving attribute_group_name for DOCUMENT_NUMBERING

Line 325: select prh.org_id into g_org_id from po_requisition_headers_all prh WHERE prh.conformed_header_id= p_confirmed_id

321: AND prh.revision_num=p_revision_num);
322:
323: -- bug 14248325 getting the org_id so that we can use the org_id as a context while deriving attribute_group_name for DOCUMENT_NUMBERING
324:
325: select prh.org_id into g_org_id from po_requisition_headers_all prh WHERE prh.conformed_header_id= p_confirmed_id
326: AND prh.revision_num=p_revision_num ;
327:
328: sql_stmt1:='SELECT temp.*
329: FROM '||x_database_view_name||' temp

Line 331: FROM po_requisition_headers_all prh

327:
328: sql_stmt1:='SELECT temp.*
329: FROM '||x_database_view_name||' temp
330: WHERE temp.requisition_header_id IN (SELECT prh.requisition_header_id
331: FROM po_requisition_headers_all prh
332: WHERE prh.conformed_header_id= '||p_confirmed_id||
333: 'AND prh.revision_num='||(p_revision_num-1)||')';
334:
335: sql_stmt2:='SELECT temp.*

Line 338: FROM po_requisition_headers_all prh

334:
335: sql_stmt2:='SELECT temp.*
336: FROM '||x_database_view_name||' temp
337: WHERE temp.requisition_header_id IN (SELECT prh.requisition_header_id
338: FROM po_requisition_headers_all prh
339: WHERE prh.conformed_header_id= '||p_confirmed_id||
340: 'AND prh.revision_num='||p_revision_num||')';
341:
342: p_level:= 'UDA_HEADER';

Line 350: po_requisition_headers_all prh

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);
354:

Line 362: po_requisition_headers_all prh

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)
366: AND prla.requisition_line_id = temp.requisition_line_id';

Line 374: po_requisition_headers_all prh

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)
378: AND prla.requisition_line_id = temp.requisition_line_id';

Line 524: --If there is no attribute group name fetched with the org_id from po_requisition_headers_all then go for DEFAULT

520: EXCEPTION
521:
522: WHEN No_Data_Found THEN
523:
524: --If there is no attribute group name fetched with the org_id from po_requisition_headers_all then go for DEFAULT
525:
526: SELECT ags.ATTR_GROUP_NAME
527: INTO x_doc_number_attr_group_name
528: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

Line 1002: compare_table('PO_REQUISITION_HEADERS_ALL',p_revision_num,p_confirmed_id,amend_num);

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

Line 1160: FROM po_requisition_headers_all

1156: v_comparison_flag := 'Previous';
1157:
1158: SELECT Max(revision_num)
1159: INTO v_revision_counter
1160: FROM po_requisition_headers_all
1161: WHERE conformed_header_id=p_confirmed_id;
1162:
1163: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1164: l_log_msg := v_progress||' : Getting sequence number: '||p_sequence_num;

Line 1591: * PO_REQUISITION_HEADERS_ALL

1587: * the amendment_status and amendment_type accordingly.
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

Line 1682: IF p_table_name = 'PO_REQUISITION_HEADERS_ALL' then

1678:
1679: -- SQL What: Querying the archive table for the given revision_num and previous revision_num
1680: -- SQL Why: Need to compare the values for each column
1681:
1682: IF p_table_name = 'PO_REQUISITION_HEADERS_ALL' then
1683:
1684: sql_stmt1:='SELECT REQUISITION_HEADER_ID,
1685: SEGMENT1,
1686: nvl(CANCEL_FLAG,''N'') CANCEL_FLAG,

Line 1695: FROM po_requisition_headers_all

1691: PCARD_ID,
1692: REVISION_NUM,
1693: AMENDMENT_STATUS,
1694: AMENDMENT_TYPE
1695: FROM po_requisition_headers_all
1696: WHERE conformed_header_id='||p_confirmed_id||
1697: ' AND revision_num='||(p_revision_num -1);
1698:
1699:

Line 1711: FROM po_requisition_headers_all

1707: PCARD_ID,
1708: REVISION_NUM,
1709: AMENDMENT_STATUS,
1710: AMENDMENT_TYPE
1711: FROM po_requisition_headers_all
1712: WHERE conformed_header_id='||p_confirmed_id||
1713: ' AND revision_num='||p_revision_num;
1714:
1715:

Line 1732: po_requisition_headers_all prh

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)||
1736: 'ORDER BY LINE_NUM';

Line 1750: po_requisition_headers_all prh

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||
1754: 'ORDER BY LINE_NUM';

Line 1796: po_requisition_headers_all prh

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)
1800: AND revision_num='||(p_revision_num -1)||

Line 1839: po_requisition_headers_all prh

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)
1843: AND revision_num='||p_revision_num||

Line 2041: UPDATE po_requisition_headers_all

2037: IF change_flag THEN
2038:
2039: IF NOT cancel_flag THEN
2040:
2041: UPDATE po_requisition_headers_all
2042: SET amendment_status = 'N',
2043: amendment_type = 'CHANGED'
2044: WHERE requisition_header_id=header_id;
2045:

Line 2051: UPDATE po_requisition_headers_all

2047:
2048: ELSE
2049: IF old_amend_type in ('CHANGED') THEN
2050:
2051: UPDATE po_requisition_headers_all
2052: SET amendment_type=old_amend_type,
2053: amendment_status = 'P'
2054: WHERE requisition_header_id=header_id
2055: AND amendment_status NOT IN ('A','R');

Line 2232: set_amendment_status('PO_REQUISITION_HEADERS_ALL',p_revision_num,p_confirmed_id);

2228: l_log_msg := 'p_confirmed_id: ' ||p_confirmed_id || ' p_revision_num: '||p_revision_num;
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';

Line 2269: SELECT Max(Nvl(revision_num,0))+1 FROM po_requisition_headers_all

2265: l_num NUMBER:=0;
2266: l_val VARCHAR2(3);
2267:
2268: CURSOR C(l_header_id NUMBER) IS
2269: SELECT Max(Nvl(revision_num,0))+1 FROM po_requisition_headers_all
2270: WHERE conformed_header_id = l_header_id;
2271:
2272: l_procedure_name VARCHAR2(100) := 'getAmendmentAttributes';
2273: l_log_msg VARCHAR2(2000);

Line 2324: FROM po_requisition_headers_all

2320: IS
2321: l_Cnt NUMBER:=0;
2322: BEGIN
2323: SELECT Count(*) INTO l_Cnt
2324: FROM po_requisition_headers_all
2325: WHERE conformed_header_id = l_req_header_id
2326: AND AUTHORIZATION_STATUS NOT IN ('APPROVED','REJECTED','RETURNED','CANCELLED');
2327:
2328: RETURN l_Cnt;

Line 2356: INTO po_requisition_headers_all target

2352:
2353: -- Creating the sql statement
2354:
2355: sql_stmt:='MERGE
2356: INTO po_requisition_headers_all target
2357: USING (SELECT *
2358: FROM po_requisition_headers_all
2359: WHERE conformed_header_id = '||p_confirmed_id||'
2360: AND revision_num = '||p_revision_num||') source

Line 2358: FROM po_requisition_headers_all

2354:
2355: sql_stmt:='MERGE
2356: INTO po_requisition_headers_all target
2357: USING (SELECT *
2358: FROM po_requisition_headers_all
2359: WHERE conformed_header_id = '||p_confirmed_id||'
2360: AND revision_num = '||p_revision_num||') source
2361: ON (target.requisition_header_id = '||p_confirmed_id||'
2362: AND target.revision_num IS NULL

Line 2387: FROM po_requisition_headers_all

2383: v_progress := '002';
2384:
2385: SELECT requisition_header_id
2386: INTO req_header_id
2387: FROM po_requisition_headers_all
2388: WHERE conformed_header_id = p_confirmed_id
2389: AND revision_num = p_revision_num;
2390:
2391:

Line 2722: po_requisition_headers_all prha

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);
2726:

Line 3457: l_req_header_id po_requisition_headers_all.requisition_header_id%TYPE;

3453: l_line_ids Dbms_Sql.number_table;
3454: l_conformed_line_ids Dbms_Sql.number_table;
3455: l_clm_base_line_num Dbms_Sql.number_table;
3456: l_group_line_id Dbms_Sql.number_table;
3457: l_req_header_id po_requisition_headers_all.requisition_header_id%TYPE;
3458: l_new_line_id NUMBER;
3459:
3460: BEGIN
3461:

Line 3472: FROM po_requisition_headers_all

3468: END IF;
3469:
3470: SELECT requisition_header_id
3471: INTO l_req_header_id
3472: FROM po_requisition_headers_all
3473: WHERE conformed_header_id = p_confirmed_id
3474: AND revision_num = p_revision_num;
3475:
3476: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3645: FROM po_requisition_headers_all

3641: SELECT Max(sequence_num)
3642: INTO max_seq
3643: FROM po_action_history
3644: WHERE object_id = (SELECT requisition_header_id
3645: FROM po_requisition_headers_all
3646: WHERE conformed_header_id = p_confirmed_id
3647: AND revision_num =p_revision_num)
3648: AND object_type_code = 'REQUISITION';
3649:

Line 3704: FROM po_requisition_headers_all

3700: program_date,
3701: approval_group_id
3702: FROM po_action_history
3703: WHERE object_id = (SELECT requisition_header_id
3704: FROM po_requisition_headers_all
3705: WHERE conformed_header_id = p_confirmed_id
3706: AND revision_num =p_revision_num)
3707: AND object_type_code = 'REQUISITION';
3708:

Line 3892: INSERT INTO po_requisition_headers_all (

3888: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3889: END IF;
3890:
3891:
3892: INSERT INTO po_requisition_headers_all (
3893: requisition_header_id,
3894: preparer_id,
3895: last_update_date,
3896: last_updated_by,

Line 4074: FROM po_requisition_headers_all

4070: clm_req_office,
4071: clm_mipr_acknowledged_flag,
4072: clm_assist_contact,
4073: clm_req_contact
4074: FROM po_requisition_headers_all
4075: WHERE requisition_header_id = p_from_req_header_id;
4076:
4077: v_progress := '002';
4078: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4079: l_log_msg := v_progress||' : After insert into po_requisition_headers_all';

4075: WHERE requisition_header_id = p_from_req_header_id;
4076:
4077: v_progress := '002';
4078: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4079: l_log_msg := v_progress||' : After insert into po_requisition_headers_all';
4080: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
4081: END IF;
4082:
4083:

Line 5215: FROM po_requisition_headers_all

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
5215: FROM po_requisition_headers_all
5216: WHERE requisition_header_id = l_document_id)
5217: AND awdrefs.requisition_line_id = prl.requisition_line_id
5218: AND awdrefs.requisition_header_id=prl.requisition_header_id
5219: --AND prl.line_location_id = pll.line_location_id

Line 5310: FROM po_requisition_headers_all

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
5313: AND prl.AMENDMENT_TYPE = 'CHANGED'
5314: AND prl.AMENDMENT_STATUS IN ('N','P')

Line 5473: FROM po_requisition_headers_all

5469: aname => 'REVISION_NUM');
5470:
5471: SELECT requisition_header_id
5472: INTO l_old_document_id
5473: FROM po_requisition_headers_all
5474: WHERE conformed_header_id = l_conformed_header_id
5475: AND revision_num = l_revision_num -1;
5476:
5477: OPEN req_total_csr(l_old_document_id,l_precision);

Line 5655: from po_requisition_headers_all

5651: v_progress := '001';
5652:
5653: select max(nvl(revision_num,0))
5654: into l_revision_num
5655: from po_requisition_headers_all
5656: where conformed_header_id = p_from_req_header_id;
5657:
5658:
5659: /* Call the procedure to copy the header*/

Line 5667: update po_requisition_headers_all

5663: l_log_msg := v_progress||' : Procedure copy_header: l_return_status: '||l_return_status ||' l_to_req_header_id: '||l_to_req_header_id ||' l_return_msg: '||l_return_msg;
5664: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5665: END IF;
5666:
5667: update po_requisition_headers_all
5668: set amendment_reason = p_cancel_Reason
5669: where requisition_header_id = l_to_req_header_id;
5670:
5671: v_progress := '002';

Line 5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%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;
5812: l_display_rate NUMBER;

Line 5897: FROM po_requisition_headers_all PRH,

5893: END IF;
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:

Line 6755: FROM po_requisition_headers_all prh

6751: END IF;
6752:
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:

Line 6798: FROM po_requisition_headers_all

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
6799: WHERE segment1=x_amendment_num;
6800:
6801: INSERT INTO icx_po_revisions_temp(
6802: header_id,

Line 6899: * PO_REQUISITION_HEADERS_ALL

6895: * the temp table with field altered, old value and new value.
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

Line 7184: from po_requisition_headers_all prh,

7180: AND amendment_status IN ('N','P');
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

Line 7187: from po_requisition_headers_all prh2,

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
7190: and prl2.requisition_line_id = selected_lines(i) )
7191: and prh.conformed_header_id = prl.requisition_header_id

Line 7231: from po_requisition_headers_all prh,

7227: AND amendment_status IN ('N','P');
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

Line 7234: from po_requisition_headers_all prh2,

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
7237: and prl2.requisition_line_id = selected_lines(i) )
7238: and prh.conformed_header_id = prl.requisition_header_id

Line 7427: l_amendment_num po_requisition_headers_all.segment1%TYPE;

7423: END set_amendment_related_attrib;
7424:
7425: FUNCTION getLatestAmendmentNum (p_req_header_id IN NUMBER) RETURN VARCHAR2
7426: IS
7427: l_amendment_num po_requisition_headers_all.segment1%TYPE;
7428: BEGIN
7429: SELECT segment1 INTO l_amendment_num
7430: FROM
7431: (SELECT prha.segment1,rownum rnum

Line 7432: FROM po_requisition_headers_all prha

7428: BEGIN
7429: SELECT segment1 INTO l_amendment_num
7430: FROM
7431: (SELECT prha.segment1,rownum rnum
7432: FROM po_requisition_headers_all prha
7433: WHERE conformed_header_id = p_req_header_id
7434: AND authorization_status = 'APPROVED'
7435: ORDER BY revision_num DESC)
7436: WHERE RNUM =1;

Line 7444: l_header_id po_requisition_headers_all.requisition_header_id%TYPE;

7440:
7441:
7442: FUNCTION getLatestAmendmentHdrId (p_req_header_id IN NUMBER) RETURN NUMBER
7443: IS
7444: l_header_id po_requisition_headers_all.requisition_header_id%TYPE;
7445: BEGIN
7446: SELECT requisition_header_id INTO l_header_id
7447: FROM
7448: (SELECT prha.requisition_header_id,rownum rnum

Line 7449: FROM po_requisition_headers_all prha

7445: BEGIN
7446: SELECT requisition_header_id INTO l_header_id
7447: FROM
7448: (SELECT prha.requisition_header_id,rownum rnum
7449: FROM po_requisition_headers_all prha
7450: WHERE conformed_header_id = p_req_header_id
7451: AND authorization_status = 'APPROVED'
7452: ORDER BY revision_num DESC)
7453: WHERE RNUM =1;

Line 7506: po_requisition_headers_all prha

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
7510: AND prla.requisition_header_id = prha.requisition_header_id

Line 7924: l_db_object_name := 'PO_REQUISITION_HEADERS_ALL';

7920: AND application_id = 201;
7921:
7922:
7923: IF p_lavel = 'UDA_HEADER' THEN
7924: l_db_object_name := 'PO_REQUISITION_HEADERS_ALL';
7925: l_pk1_col_name := 'REQUISITION_HEADER_ID';
7926:
7927: SELECT requisition_header_id
7928: INTO l_pk1_col_val

Line 7929: FROM PO_REQUISITION_HEADERS_ALL

7925: l_pk1_col_name := 'REQUISITION_HEADER_ID';
7926:
7927: SELECT requisition_header_id
7928: INTO l_pk1_col_val
7929: FROM PO_REQUISITION_HEADERS_ALL
7930: WHERE segment1 = amend_num;
7931:
7932: ELSIF p_lavel = 'UDA_LINES' THEN
7933:

Line 7939: FROM PO_REQUISITION_HEADERS_ALL

7935: l_pk1_col_name := 'REQUISITION_HEADER_ID';
7936:
7937: SELECT requisition_header_id
7938: INTO l_req_header_id
7939: FROM PO_REQUISITION_HEADERS_ALL
7940: WHERE segment1 = amend_num;
7941:
7942:
7943: SELECT requisition_line_id

Line 7989: l_db_object_name := 'PO_REQUISITION_HEADERS_ALL';

7985: AND attr.display_code <> 'H'
7986: AND application_id = 201;
7987:
7988:
7989: l_db_object_name := 'PO_REQUISITION_HEADERS_ALL';
7990: l_pk1_col_name := 'REQUISITION_HEADER_ID';
7991:
7992: SELECT requisition_header_id
7993: INTO l_pk1_col_val

Line 7994: FROM PO_REQUISITION_HEADERS_ALL

7990: l_pk1_col_name := 'REQUISITION_HEADER_ID';
7991:
7992: SELECT requisition_header_id
7993: INTO l_pk1_col_val
7994: FROM PO_REQUISITION_HEADERS_ALL
7995: WHERE segment1 = amend_num;
7996:
7997:
7998: l_attr_disp_value := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (

Line 8105: UPDATE po_requisition_headers_all h1 SET (h1.authorization_status,h1.approved_date) =

8101: itemkey => itemkey,
8102: aname => 'CONFORMED_HEADER_ID');
8103:
8104: --update the approval status of the main requisition with the
8105: UPDATE po_requisition_headers_all h1 SET (h1.authorization_status,h1.approved_date) =
8106: (SELECT h2.authorization_status,h2.approved_date
8107: FROM po_requisition_headers_all h2
8108: WHERE h2.requisition_header_id = l_req_header_id)
8109: WHERE requisition_header_id = l_conf_hdr_id;

Line 8107: FROM po_requisition_headers_all h2

8103:
8104: --update the approval status of the main requisition with the
8105: UPDATE po_requisition_headers_all h1 SET (h1.authorization_status,h1.approved_date) =
8106: (SELECT h2.authorization_status,h2.approved_date
8107: FROM po_requisition_headers_all h2
8108: WHERE h2.requisition_header_id = l_req_header_id)
8109: WHERE requisition_header_id = l_conf_hdr_id;
8110:
8111: --Update reqs_in_pool_flag also

Line 8127: x_amendment_reason PO_REQUISITION_HEADERS_ALL.AMENDMENT_REASON%TYPE;

8123: IS
8124:
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);

Line 8128: x_preparer_id PO_REQUISITION_HEADERS_ALL.PREPARER_ID%TYPE;

8124:
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);

Line 8153: FROM PO_REQUISITION_HEADERS_ALL

8149: fnd_profile.get('PO_GL_DATE',l_use_gl_date);
8150:
8151: SELECT AMENDMENT_REASON, PREPARER_ID, ORG_ID
8152: INTO x_amendment_reason, x_preparer_id, x_org_id
8153: FROM PO_REQUISITION_HEADERS_ALL
8154: WHERE requisition_header_id = p_req_header_id;
8155:
8156: l_req_encumbrance_on := POR_UTIL_PKG.BOOL_TO_VARCHAR(po_core_s.Is_encumbrance_on(p_doc_type => 'REQUISITION',p_org_id => x_org_id));
8157:

Line 8315: Select 'Y' into x_return_status from PO_REQUISITION_HEADERS_ALL where requisition_header_id=p_req_header_id and federal_flag='Y';

8311: x_return_status :='N';
8312:
8313: if(p_req_header_id is not null) THEN
8314:
8315: Select 'Y' into x_return_status from PO_REQUISITION_HEADERS_ALL where requisition_header_id=p_req_header_id and federal_flag='Y';
8316:
8317: END IF;
8318:
8319: EXCEPTION