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.PON_NEG_UPDATE_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 25: FROM PON_AUCTION_HEADERS_ALL

21:
22: -- lock negotiation header
23: SELECT LAST_UPDATE_DATE, CLOSE_BIDDING_DATE
24: INTO x_temp, x_close_bidding_date
25: FROM PON_AUCTION_HEADERS_ALL
26: WHERE AUCTION_HEADER_ID = p_auction_header_id
27: FOR UPDATE;
28:
29: -- update header close date

Line 30: update pon_auction_headers_all

26: WHERE AUCTION_HEADER_ID = p_auction_header_id
27: FOR UPDATE;
28:
29: -- update header close date
30: update pon_auction_headers_all
31: set close_bidding_date = p_new_close_date,
32: original_close_bidding_date = x_close_bidding_date,
33: last_update_date = sysdate,
34: last_updated_by = p_user_id

Line 68: x_auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE;

64: x_error_code OUT NOCOPY VARCHAR2) IS
65:
66:
67: x_temp DATE;
68: x_auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
69: x_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
70:
71: BEGIN
72:

Line 69: x_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

65:
66:
67: x_temp DATE;
68: x_auction_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
69: x_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
70:
71: BEGIN
72:
73: x_error_code := 'SUCCESS';

Line 78: from pon_auction_headers_all

74:
75: -- select data from header
76: select auction_origination_code, trading_partner_contact_id
77: into x_auction_origination_code, x_trading_partner_contact_id
78: from pon_auction_headers_all
79: where auction_header_id = p_auction_header_id;
80:
81: -- lock the negotiation
82: SELECT LAST_UPDATE_DATE

Line 84: FROM PON_AUCTION_HEADERS_ALL

80:
81: -- lock the negotiation
82: SELECT LAST_UPDATE_DATE
83: INTO x_temp
84: FROM PON_AUCTION_HEADERS_ALL
85: WHERE AUCTION_HEADER_ID = p_auction_header_id
86: FOR UPDATE;
87:
88: -- update header

Line 90: update pon_auction_headers_all

86: FOR UPDATE;
87:
88: -- update header
89: -- update the pause details also.
90: update pon_auction_headers_all
91: set auction_status = 'CANCELLED',
92: cancel_date = sysdate,
93: last_update_date = sysdate,
94: last_updated_by = p_user_id,

Line 171: FROM PON_AUCTION_HEADERS_ALL

167: -- lock the negotiation header
168: SELECT LAST_UPDATE_DATE, nvl( IS_PAUSED, 'N' ), nvl( LAST_PAUSE_DATE, sysdate ), nvl(number_of_extensions, 0),
169: nvl2(staggered_closing_interval,'Y','N'), first_line_close_date
170: INTO x_update_date, v_ispaused, v_pause_date, x_num_extension_occurred, v_is_staggered, x_first_line_close_date
171: FROM PON_AUCTION_HEADERS_ALL
172: WHERE AUCTION_HEADER_ID = p_auction_header_id
173: FOR UPDATE;
174:
175:

Line 227: UPDATE PON_AUCTION_HEADERS_ALL

223: -- This extended close bidding date will be retrieved from the java layer.
224: p_extended_close_bidding_date := x_new_close_date;
225:
226: -- update header close date and reset the pause related fields.
227: UPDATE PON_AUCTION_HEADERS_ALL
228: SET CLOSE_BIDDING_DATE = x_new_close_date,
229: LAST_UPDATE_DATE= sysdate,
230: LAST_UPDATED_BY = p_user_id,
231: ORIGINAL_CLOSE_BIDDING_DATE = p_close_date,

Line 275: UPDATE PON_AUCTION_HEADERS_ALL

271: x_new_autoextend_num := UNLIMITED_INT;
272: else
273: x_new_autoextend_num := x_num_extension_occurred+p_new_autoextend_num;
274: end if;
275: UPDATE PON_AUCTION_HEADERS_ALL
276: SET AUTO_EXTEND_FLAG = 'Y',
277: AUTO_EXTEND_NUMBER = x_new_autoextend_num,
278: AUTO_EXTEND_ALL_LINES_FLAG = p_is_allExtend,
279: AUTO_EXTEND_DURATION = p_new_duration,

Line 310: update pon_auction_headers_all

306: PROCEDURE ACTIVATE_PREV_ROUND_NEG (p_prev_round_auction_header_id IN NUMBER) IS
307:
308: BEGIN
309:
310: update pon_auction_headers_all
311: set auction_status = 'ACTIVE'
312: where auction_header_id = p_prev_round_auction_header_id;
313:
314: END ACTIVATE_PREV_ROUND_NEG;

Line 340: from pon_auction_headers_all

336: BEGIN
337:
338: select auction_status, award_status, view_by_date, open_bidding_date, close_bidding_date, sysdate, NVL( is_paused, 'N')
339: into v_auction_status, v_award_status, v_view_by_date, v_open_bidding_date, v_close_bidding_date, v_sysdate, v_is_paused
340: from pon_auction_headers_all
341: where auction_header_id = p_auction_header_id_prev_doc;
342:
343: if v_is_paused <> 'Y' then
344:

Line 383: v_doc_number_prev_doc pon_auction_headers_all.document_number%TYPE;

379: x_error_msg OUT NOCOPY VARCHAR2) IS
380:
381:
382: v_temp DATE;
383: v_doc_number_prev_doc pon_auction_headers_all.document_number%TYPE;
384: v_amend_last_update_date pon_auction_headers_all.last_update_date%type;
385: v_changedesc_gen_date pon_auction_headers_all.cd_generated_date%type;
386:
387: l_back_req_exists VARCHAR2(1) := 'N';

Line 384: v_amend_last_update_date pon_auction_headers_all.last_update_date%type;

380:
381:
382: v_temp DATE;
383: v_doc_number_prev_doc pon_auction_headers_all.document_number%TYPE;
384: v_amend_last_update_date pon_auction_headers_all.last_update_date%type;
385: v_changedesc_gen_date pon_auction_headers_all.cd_generated_date%type;
386:
387: l_back_req_exists VARCHAR2(1) := 'N';
388: l_return_status varchar2(1);

Line 385: v_changedesc_gen_date pon_auction_headers_all.cd_generated_date%type;

381:
382: v_temp DATE;
383: v_doc_number_prev_doc pon_auction_headers_all.document_number%TYPE;
384: v_amend_last_update_date pon_auction_headers_all.last_update_date%type;
385: v_changedesc_gen_date pon_auction_headers_all.cd_generated_date%type;
386:
387: l_back_req_exists VARCHAR2(1) := 'N';
388: l_return_status varchar2(1);
389:

Line 398: FROM PON_AUCTION_HEADERS_ALL

394:
395: -- lock negotiation
396: SELECT LAST_UPDATE_DATE, document_number
397: INTO v_temp, v_doc_number_prev_doc
398: FROM PON_AUCTION_HEADERS_ALL
399: WHERE AUCTION_HEADER_ID = p_auction_header_id_prev_doc
400: FOR UPDATE;
401:
402: --Line Type and Structure Changes project

Line 432: FROM pon_auction_headers_all

428: IF (p_transaction_type = 'CREATE_CONFORMED_DOC') THEN
429:
430: SELECT CD_GENERATED_DATE, LAST_UPDATE_DATE
431: INTO v_changedesc_gen_date,v_amend_last_update_date
432: FROM pon_auction_headers_all
433: WHERE auction_header_id = p_auction_header_id_prev_doc;
434:
435: IF v_changedesc_gen_date IS NOT NULL AND v_amend_last_update_date IS NOT NULL THEN
436: IF( v_amend_last_update_date > v_changedesc_gen_date) then

Line 437: update pon_auction_headers_all

433: WHERE auction_header_id = p_auction_header_id_prev_doc;
434:
435: IF v_changedesc_gen_date IS NOT NULL AND v_amend_last_update_date IS NOT NULL THEN
436: IF( v_amend_last_update_date > v_changedesc_gen_date) then
437: update pon_auction_headers_all
438: set AMENDUPDATED_AFTERCDGENERATED = 'Y'
439: where auction_header_id = p_auction_header_id_prev_doc;
440: ELSE
441: update pon_auction_headers_all

Line 441: update pon_auction_headers_all

437: update pon_auction_headers_all
438: set AMENDUPDATED_AFTERCDGENERATED = 'Y'
439: where auction_header_id = p_auction_header_id_prev_doc;
440: ELSE
441: update pon_auction_headers_all
442: set AMENDUPDATED_AFTERCDGENERATED = 'N'
443: where auction_header_id = p_auction_header_id_prev_doc;
444: END IF;
445: END IF;

Line 454: update pon_auction_headers_all

450: -- update status of previous round document
451:
452: if (p_transaction_type = 'CREATE_NEW_ROUND') then
453:
454: update pon_auction_headers_all
455: set AWARD_STATUS = 'NO',
456: AUCTION_STATUS = 'AUCTION_CLOSED',
457: LAST_UPDATE_DATE = sysdate,
458: LAST_UPDATED_BY = p_user_id

Line 462: update pon_auction_headers_all

458: LAST_UPDATED_BY = p_user_id
459: where auction_header_id = p_auction_header_id_prev_doc;
460: ELSIF ( p_transaction_type = 'CREATE_CONFORMED_DOC' ) then
461:
462: update pon_auction_headers_all
463: set AWARD_STATUS = 'NO',
464: AUCTION_STATUS = 'APPLIED',
465: LAST_UPDATE_DATE = sysdate,
466: LAST_UPDATED_BY = p_user_id

Line 512: update pon_auction_headers_all

508:
509: -- update pause details also.
510: if (p_transaction_type = 'CREATE_AMENDMENT') then
511:
512: update pon_auction_headers_all
513: set AWARD_STATUS = 'NO',
514: AUCTION_STATUS = 'AMENDED',
515: is_paused = null,
516: pause_remarks = null,

Line 571: from pon_auction_headers_all

567: BEGIN
568:
569: select nvl(amendment_number, 0)
570: into v_currAmendmentNumber
571: from pon_auction_headers_all
572: where auction_header_id = p_currAuctionHeaderId;
573:
574:
575: -- first, reset the modified flag and last amendment update columns

Line 633: from pon_auction_headers_all

629: BEGIN
630:
631: select nvl(amendment_number, 0)
632: into v_currAmendmentNumber
633: from pon_auction_headers_all
634: where auction_header_id = p_currAuctionHeaderId;
635:
636:
637: -- first, reset the modified flag and last amendment update columns

Line 699: from pon_auction_headers_all

695: BEGIN
696:
697: select nvl(amendment_number, 0)
698: into v_currAmendmentNumber
699: from pon_auction_headers_all
700: where auction_header_id = p_currAuctionHeaderId;
701:
702: -- first, reset the modified flag and last amendment update columns
703: -- only if modified flag is not "P" or "S" ...

Line 781: from pon_auction_headers_all

777: BEGIN
778:
779: select nvl(amendment_number, 0)
780: into v_currAmendmentNumber
781: from pon_auction_headers_all
782: where auction_header_id = p_currAuctionHeaderId;
783:
784:
785: -- first, reset the modified flag and last amendment update columns

Line 888: from pon_auction_headers_all

884: BEGIN
885:
886: select auction_header_id_orig_amend, nvl(amendment_number, 0)
887: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
888: from pon_auction_headers_all
889: where auction_header_id = p_currAuctionHeaderId;
890:
891: insert into pon_bidding_parties
892: (auction_header_id,

Line 945: from pon_auction_headers_all pah,

941: pbp.vendor_site_id,
942: pbp.vendor_site_code,
943: pbp.modified_flag,
944: pbp.access_type
945: from pon_auction_headers_all pah,
946: pon_bidding_parties pbp
947: where pah.auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
948: pah.amendment_number < v_currAmendmentNumber and
949: pbp.auction_header_id = p_currAuctionHeaderId and

Line 972: from pon_auction_headers_all

968: BEGIN
969:
970: select auction_header_id_orig_amend, nvl(amendment_number, 0)
971: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
972: from pon_auction_headers_all
973: where auction_header_id = p_currAuctionHeaderId;
974:
975: update pon_bidding_parties pbp
976: set (ack_partner_contact_id, supp_acknowledgement, ack_note_to_auctioneer, acknowledgement_time) =

Line 983: where pbp.auction_header_id in (select auction_header_id from pon_auction_headers_all where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and amendment_number <> v_currAmendmentNumber) and

979: from pon_bidding_parties currPbp
980: where currPbp.auction_header_id = p_currAuctionHeaderId and
981: currPbp.sequence = p_sequence)
982:
983: where pbp.auction_header_id in (select auction_header_id from pon_auction_headers_all where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and amendment_number <> v_currAmendmentNumber) and
984: pbp.sequence = p_sequence ;
985:
986: END PROPAGATE_BACK_UPDATE_INVITEE;
987:

Line 1007: from pon_auction_headers_all

1003: BEGIN
1004:
1005: select auction_header_id_orig_amend, nvl(amendment_number, 0)
1006: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
1007: from pon_auction_headers_all
1008: where auction_header_id = p_currAuctionHeaderId;
1009:
1010: insert into pon_neg_team_members
1011: (auction_header_id,

Line 1044: from pon_auction_headers_all pah,

1040: pntm.last_update_date,
1041: pntm.last_updated_by,
1042: pntm.last_amendment_update,
1043: pntm.modified_flag
1044: from pon_auction_headers_all pah,
1045: pon_neg_team_members pntm
1046: where pah.auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1047: pah.amendment_number < v_currAmendmentNumber and
1048: pntm.auction_header_id = p_currAuctionHeaderId and

Line 1077: from pon_auction_headers_all

1073: END IF;
1074:
1075: select auction_header_id_orig_amend, nvl(amendment_number, 0)
1076: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
1077: from pon_auction_headers_all
1078: where auction_header_id = p_currAuctionHeaderId;
1079:
1080: IF p_unlock_type = 'Technical' THEN
1081: update pon_auction_headers_all

Line 1081: update pon_auction_headers_all

1077: from pon_auction_headers_all
1078: where auction_header_id = p_currAuctionHeaderId;
1079:
1080: IF p_unlock_type = 'Technical' THEN
1081: update pon_auction_headers_all
1082: set technical_lock_status = 'UNLOCKED',
1083: technical_unlock_tp_contact_id = p_userId,
1084: technical_actual_unlock_date = p_unlock_date
1085: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and

Line 1088: update pon_auction_headers_all

1084: technical_actual_unlock_date = p_unlock_date
1085: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1086: amendment_number < v_currAmendmentNumber;
1087: ELSE
1088: update pon_auction_headers_all
1089: set sealed_auction_status = 'UNLOCKED',
1090: sealed_unlock_tp_contact_id = p_userId,
1091: sealed_actual_unlock_date = p_unlock_date
1092: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and

Line 1129: from pon_auction_headers_all

1125: END IF;
1126:
1127: select auction_header_id_orig_amend, nvl(amendment_number, 0), technical_lock_status
1128: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber, v_technicalLockStatus
1129: from pon_auction_headers_all
1130: where auction_header_id = p_currAuctionHeaderId;
1131:
1132: IF p_unseal_type = 'Technical' THEN
1133: update pon_auction_headers_all

Line 1133: update pon_auction_headers_all

1129: from pon_auction_headers_all
1130: where auction_header_id = p_currAuctionHeaderId;
1131:
1132: IF p_unseal_type = 'Technical' THEN
1133: update pon_auction_headers_all
1134: set technical_lock_status = 'ACTIVE',
1135: technical_unseal_tp_contact_id = p_userId,
1136: technical_actual_unseal_date = p_unseal_date
1137: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and

Line 1142: update pon_auction_headers_all

1138: amendment_number < v_currAmendmentNumber;
1139:
1140: ELSIF p_unseal_type = 'Commercial' THEN
1141: IF v_technicalLockStatus = 'ACTIVE' THEN
1142: update pon_auction_headers_all
1143: set sealed_auction_status = 'ACTIVE',
1144: sealed_unseal_tp_contact_id = p_userId,
1145: sealed_actual_unseal_date = p_unseal_date
1146: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and

Line 1149: update pon_auction_headers_all

1145: sealed_actual_unseal_date = p_unseal_date
1146: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1147: amendment_number < v_currAmendmentNumber;
1148: ELSE
1149: update pon_auction_headers_all
1150: set sealed_auction_status = 'ACTIVE',
1151: sealed_unseal_tp_contact_id = p_userId,
1152: sealed_actual_unseal_date = p_unseal_date,
1153: technical_lock_status = 'ACTIVE',

Line 1160: update pon_auction_headers_all

1156: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1157: amendment_number < v_currAmendmentNumber;
1158: END IF;
1159: ELSE
1160: update pon_auction_headers_all
1161: set sealed_auction_status = 'ACTIVE',
1162: sealed_unseal_tp_contact_id = p_userId,
1163: sealed_actual_unseal_date = p_unseal_date
1164: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and

Line 1185: FROM PON_AUCTION_HEADERS_ALL

1181: BEGIN
1182:
1183: SELECT HAS_PRICE_ELEMENTS
1184: INTO l_auction_has_price_elements
1185: FROM PON_AUCTION_HEADERS_ALL
1186: WHERE AUCTION_HEADER_ID = p_auction_header_id;
1187:
1188: IF ('Y' = l_auction_has_price_elements) THEN
1189:

Line 1279: x_temp PON_AUCTION_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;

1275: x_is_auction_closed OUT NOCOPY VARCHAR2
1276: ) IS
1277:
1278: l_module_name VARCHAR2 (30);
1279: x_temp PON_AUCTION_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
1280: x_close_bidding_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1281: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
1282: p_new_close_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1283: BEGIN

Line 1280: x_close_bidding_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;

1276: ) IS
1277:
1278: l_module_name VARCHAR2 (30);
1279: x_temp PON_AUCTION_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
1280: x_close_bidding_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1281: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
1282: p_new_close_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1283: BEGIN
1284:

Line 1282: p_new_close_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;

1278: l_module_name VARCHAR2 (30);
1279: x_temp PON_AUCTION_HEADERS_ALL.LAST_UPDATE_DATE%TYPE;
1280: x_close_bidding_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1281: v_auction_last_line_number PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
1282: p_new_close_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
1283: BEGIN
1284:
1285: l_module_name := 'MANUAL_CLOSE_LINE';
1286: x_result := FND_API.g_ret_sts_success;

Line 1299: FROM PON_AUCTION_HEADERS_ALL

1295:
1296: -- lock negotiation header
1297: SELECT LAST_UPDATE_DATE, CLOSE_BIDDING_DATE
1298: INTO x_temp, x_close_bidding_date
1299: FROM PON_AUCTION_HEADERS_ALL
1300: WHERE AUCTION_HEADER_ID = p_auction_header_id
1301: FOR UPDATE;
1302:
1303: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1310: update pon_auction_headers_all

1306: message => 'Locked the negotiation header');
1307: END IF;
1308:
1309: -- update header date
1310: update pon_auction_headers_all
1311: set last_update_date = sysdate,
1312: last_updated_by = p_user_id
1313: where auction_header_id = p_auction_header_id;
1314:

Line 1356: update pon_auction_headers_all set close_bidding_date = p_new_close_date

1352: module => g_module_prefix || l_module_name,
1353: message => 'The last line number in the auction matches with p_line_number, closing the negotiation');
1354: END IF;
1355:
1356: update pon_auction_headers_all set close_bidding_date = p_new_close_date
1357: where auction_header_id = p_auction_header_id;
1358: x_is_auction_closed := 'Y';
1359:
1360: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1413: from pon_auction_headers_all

1409: END IF;
1410:
1411: select auction_header_id_orig_amend, nvl(amendment_number, 0)
1412: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
1413: from pon_auction_headers_all
1414: where auction_header_id = p_currAuctionHeaderId;
1415:
1416: update pon_auction_headers_all
1417: set technical_evaluation_status = p_tech_eval_status

Line 1416: update pon_auction_headers_all

1412: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
1413: from pon_auction_headers_all
1414: where auction_header_id = p_currAuctionHeaderId;
1415:
1416: update pon_auction_headers_all
1417: set technical_evaluation_status = p_tech_eval_status
1418: where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1419: amendment_number < v_currAmendmentNumber;
1420:

Line 1441: l_prev_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;

1437: p_user_id IN NUMBER,
1438: x_prev_doc_number OUT NOCOPY VARCHAR2,
1439: x_error_code OUT NOCOPY VARCHAR2) IS
1440:
1441: l_prev_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
1442:
1443: --Line Type and STructute Changes Project
1444: CURSOR c_has_linked_pr_refs IS
1445: SELECT Count(*) FROM pon_backing_requisitions

Line 1456: from pon_auction_headers_all

1452: Begin
1453: --Get details of original document.
1454: select auction_header_id,document_number
1455: into l_prev_auction_header_id,x_prev_doc_number
1456: from pon_auction_headers_all
1457: where
1458: auction_header_id = (select auction_header_id_prev_amend
1459: from pon_auction_headers_all
1460: where auction_header_id=p_auction_header_id);

Line 1459: from pon_auction_headers_all

1455: into l_prev_auction_header_id,x_prev_doc_number
1456: from pon_auction_headers_all
1457: where
1458: auction_header_id = (select auction_header_id_prev_amend
1459: from pon_auction_headers_all
1460: where auction_header_id=p_auction_header_id);
1461:
1462: -- Call CANCEL_NEGOTIATION
1463: CANCEL_NEGOTIATION(l_prev_auction_header_id,

Line 1489: update pon_auction_headers_all

1485:
1486: END IF;
1487:
1488: if x_error_code = 'SUCCESS' then
1489: update pon_auction_headers_all
1490: set auction_status = 'APPLIED'
1491: where auction_header_id = p_auction_header_id;
1492: end if;
1493: