APPS.POR_AMENDMENT_PKG dependencies on ICX_PO_REVISIONS_TEMP

Line 1102: * ICX_PO_REVISIONS_TEMP table.

1098: * p_comparison_flag Indicator to compare the PO with the previous
1099: * or original revision
1100: * p_sequence_num Sequence number to identify the comparison
1101: * results for a specific record in
1102: * ICX_PO_REVISIONS_TEMP table.
1103: *
1104: * NOTES
1105: *
1106: * HISTORY

Line 1225: * Delete records from the temp table, ICX_PO_REVISIONS_TEMP, where

1221: * NAME
1222: * purge
1223: *
1224: * PURPOSE
1225: * Delete records from the temp table, ICX_PO_REVISIONS_TEMP, where
1226: * all the records for differences are stored.
1227: *
1228: * ARGUMENTS
1229: * sequenceNumber Sequence number to identify the comparison

Line 1231: * ICX_PO_REVISIONS_TEMP table.

1227: *
1228: * ARGUMENTS
1229: * sequenceNumber Sequence number to identify the comparison
1230: * results for a specific record in
1231: * ICX_PO_REVISIONS_TEMP table.
1232: *
1233: * NOTES
1234: *
1235: * HISTORY

Line 1248: DELETE FROM icx_po_revisions_temp

1244:
1245: v_progress := '000';
1246:
1247:
1248: DELETE FROM icx_po_revisions_temp
1249: WHERE line_seq = sequenceNumber;
1250:
1251: v_progress := '001';
1252:

Line 1305: icx_po_revisions_temp(

1301: END IF;
1302:
1303: FORALL i in po_num_tab.FIRST..po_num_tab.LAST
1304: INSERT INTO
1305: icx_po_revisions_temp(
1306: header_id,
1307: line_seq,
1308: creation_date,
1309: po_num,

Line 1477: * Insert a line in the ICX_PO_REVISIONS_TEMP table indicating that

1473: * NAME
1474: * verify_no_differences
1475: *
1476: * PURPOSE
1477: * Insert a line in the ICX_PO_REVISIONS_TEMP table indicating that
1478: * there are no differences between the compared records.
1479: *
1480: * ARGUMENTS
1481: * p_line_seq Sequence number to identify the comparison

Line 1518: FROM icx_po_revisions_temp

1514: END IF;
1515:
1516: SELECT COUNT(*)
1517: INTO records_exist
1518: FROM icx_po_revisions_temp
1519: WHERE line_seq = p_line_seq;
1520:
1521: v_progress := '001';
1522:

Line 1533: icx_po_revisions_temp(

1529:
1530: v_progress := '002';
1531:
1532: INSERT INTO
1533: icx_po_revisions_temp(
1534: header_id,
1535: line_seq,
1536: creation_date,
1537: po_num,

Line 6699: * ICX_PO_REVISIONS_TEMP table.

6695: * p_req_line_id Req line id of the line
6696: *
6697: * p_sequence_num Sequence number to identify the comparison
6698: * results for a specific record in
6699: * ICX_PO_REVISIONS_TEMP table.
6700: *
6701: * NOTES
6702: *
6703: * HISTORY

Line 6801: INSERT INTO icx_po_revisions_temp(

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,
6803: line_seq,
6804: creation_date,
6805: po_num,

Line 6840: INSERT INTO icx_po_revisions_temp(

6836:
6837: IF l_cnt > 0 THEN
6838: --New we need to insert the distribution value
6839: FOR i IN 1..l_cnt LOOP
6840: INSERT INTO icx_po_revisions_temp(
6841: header_id,
6842: line_seq,
6843: creation_date,
6844: po_num,