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_AUCTION_CREATE_PO_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 85: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;

81: x_responsibility_id number := null;
82: x_application_id number := null;
83:
84: x_language_code VARCHAR2(3);
85: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
86: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
87: x_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
88: x_return_code VARCHAR2(10);
89:

Line 87: x_origination_code pon_auction_headers_all.auction_origination_code%TYPE;

83:
84: x_language_code VARCHAR2(3);
85: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
86: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
87: x_origination_code pon_auction_headers_all.auction_origination_code%TYPE;
88: x_return_code VARCHAR2(10);
89:
90: l_api_name VARCHAR2(30) := ' AUTO_ALLOC_AND_SPLIT_REQ';
91: l_debug_enabled VARCHAR2(1) := 'N';

Line 170: FROM pon_auction_headers_all

166: -- Lock auction table to prevent concurrency errors
167:
168: SELECT last_update_date
169: INTO x_last_update_date
170: FROM pon_auction_headers_all
171: WHERE auction_header_id = p_auction_header_id
172: FOR UPDATE;
173:
174: -- Determine whether we are sourcing requisition lines against the

Line 180: FROM pon_auction_headers_all

176: -- not, do not automatically allocate or call po's split api
177:
178: SELECT nvl(source_reqs_flag,'N'), contract_type, nvl(auction_origination_code, 'NONE')
179: into x_source_reqs_flag, x_contract_type, x_origination_code
180: FROM pon_auction_headers_all
181: where auction_header_id = p_auction_header_id;
182:
183:
184: if(l_debug_enabled = 'Y') then

Line 282: select nvl(allow_staggered_awards, 'N') into l_allow_stag_awards from pon_auction_headers_all where auction_header_id = p_auction_header_id;

278: log_message(x_progress);
279: end if;
280:
281: --Staggered Awarding project
282: select nvl(allow_staggered_awards, 'N') into l_allow_stag_awards from pon_auction_headers_all where auction_header_id = p_auction_header_id;
283:
284: select count(DISTINCT line_number) into l_unawarded_line_count from pon_auction_item_prices_all where auction_header_id = p_auction_header_id and nvl(award_status,'NO') = 'NO';
285:
286: if (l_unawarded_line_count > 0) then

Line 336: UPDATE PON_AUCTION_HEADERS_ALL

332: -- double check the setting of alloc_error below
333:
334:
335: -- update outcome_status of auction
336: UPDATE PON_AUCTION_HEADERS_ALL
337: SET OUTCOME_STATUS = 'ALLOCATION_FAILED'
338: WHERE AUCTION_HEADER_ID = p_auction_header_id;
339:
340: if(l_exception_enabled = 'Y') then

Line 377: UPDATE PON_AUCTION_HEADERS_ALL

373: log_error(x_progress);
374: end if;
375:
376: -- update outcome_status of auction
377: UPDATE PON_AUCTION_HEADERS_ALL
378: SET OUTCOME_STATUS = 'ALLOCATION_FAILED'
379: WHERE AUCTION_HEADER_ID = p_auction_header_id;
380:
381: if(l_exception_enabled = 'Y') then

Line 968: l_contract_type pon_auction_headers_all.contract_type%TYPE;

964: l_login_id NUMBER;
965: l_bid_price_col dbms_sql.number_table;
966: l_order_type_lookup_code pon_auction_item_prices_all.order_type_lookup_code%TYPE;
967: l_purchase_basis pon_auction_item_prices_all.purchase_basis%TYPE;
968: l_contract_type pon_auction_headers_all.contract_type%TYPE;
969:
970:
971: l_api_name VARCHAR2(30) := ' AUTO_REQ_ALLOCATION ';
972: l_debug_enabled VARCHAR2(1) := 'N';

Line 1019: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah

1015: l_clm_info_flag := l_empty_table;
1016:
1017: SELECT paip.order_type_lookup_code, paip.purchase_basis, pah.contract_type
1018: INTO l_order_type_lookup_code, l_purchase_basis, l_contract_type
1019: FROM pon_auction_item_prices_all paip, pon_auction_headers_all pah
1020: WHERE paip.auction_header_id = pah.auction_header_id
1021: AND paip.auction_header_id = p_auctionid
1022: AND paip.line_number = p_line_number;
1023:

Line 1050: pon_auction_headers_all pah

1046: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col , l_clm_info_flag
1047: FROM pon_auction_item_prices_all itm,
1048: pon_bid_item_prices bl,
1049: pon_bid_headers bh,
1050: pon_auction_headers_all pah
1051: WHERE itm.auction_header_id = p_auctionID AND
1052: itm.line_number = p_line_number AND
1053: bl.line_number = itm.line_number AND
1054: bl.auction_header_id = itm.auction_header_id AND

Line 1219: x_doctype_id pon_auction_headers_all.doctype_id%TYPE;

1215: x_progress VARCHAR2(4000);
1216: x_language_code VARCHAR2(3);
1217: x_msg_suffix VARCHAR2(3) := '';
1218: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;
1219: x_doctype_id pon_auction_headers_all.doctype_id%TYPE;
1220: x_responsibility_id NUMBER;
1221: x_application_id NUMBER;
1222: x_doc_number_dsp VARCHAR2(60);
1223: x_contract_type pon_auction_headers_all.contract_type%TYPE;

Line 1223: x_contract_type pon_auction_headers_all.contract_type%TYPE;

1219: x_doctype_id pon_auction_headers_all.doctype_id%TYPE;
1220: x_responsibility_id NUMBER;
1221: x_application_id NUMBER;
1222: x_doc_number_dsp VARCHAR2(60);
1223: x_contract_type pon_auction_headers_all.contract_type%TYPE;
1224: x_current_round NUMBER;
1225:
1226: x_timezone VARCHAR2(80);
1227: x_newstarttime DATE;

Line 1239: p_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

1235: x_award_summary_url_buyer VARCHAR2(2000);
1236: x_alloc_summary_url_buyer VARCHAR2(2000);
1237: x_alloc_byitem_url_buyer VARCHAR2(2000);
1238: x_po_summary_url_buyer VARCHAR2(2000);
1239: p_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1240: p_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
1241: p_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1242: x_purchase_order VARCHAR2(30);
1243: x_purchase_orders VARCHAR2(30);

Line 1240: p_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

1236: x_alloc_summary_url_buyer VARCHAR2(2000);
1237: x_alloc_byitem_url_buyer VARCHAR2(2000);
1238: x_po_summary_url_buyer VARCHAR2(2000);
1239: p_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1240: p_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
1241: p_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1242: x_purchase_order VARCHAR2(30);
1243: x_purchase_orders VARCHAR2(30);
1244: p_preview_date DATE;

Line 1241: p_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

1237: x_alloc_byitem_url_buyer VARCHAR2(2000);
1238: x_po_summary_url_buyer VARCHAR2(2000);
1239: p_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1240: p_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
1241: p_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1242: x_purchase_order VARCHAR2(30);
1243: x_purchase_orders VARCHAR2(30);
1244: p_preview_date DATE;
1245: x_requistion_based VARCHAR2(12);

Line 1246: x_has_items PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

1242: x_purchase_order VARCHAR2(30);
1243: x_purchase_orders VARCHAR2(30);
1244: p_preview_date DATE;
1245: x_requistion_based VARCHAR2(12);
1246: x_has_items PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
1247:
1248:
1249: l_api_name VARCHAR2(30) := ' START_PO_WORKFLOW ';
1250: l_debug_enabled VARCHAR2(1) := 'N';

Line 1272: from pon_auction_headers_all

1268: p_doctype_id,
1269: p_trading_partner_name,
1270: p_trading_partner_contact_name,
1271: x_has_items
1272: from pon_auction_headers_all
1273: where auction_header_id = p_auction_header_id;
1274:
1275: x_itemkey := p_itemkey;
1276: x_itemtype:= 'PONCOMPL';

Line 1525: FROM pon_auction_headers_all auh, pon_auc_doctypes dt

1521: dt.doctype_group_name, auh.contract_type,
1522: nvl(auh.wf_poncompl_current_round, 0), auh.doctype_id
1523: INTO x_doc_number_dsp, x_doctype_group_name, x_contract_type,
1524: x_current_round, x_doctype_id
1525: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
1526: WHERE auh.auction_header_id = p_auction_header_id and
1527: auh.doctype_id = dt.doctype_id;
1528:
1529: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

Line 1754: x_hasBackingReqs pon_auction_headers_all.auction_origination_code%TYPE;

1750: x_quantity NUMBER;
1751: x_amount NUMBER;
1752: x_pdoi_header PDOIheader;
1753: x_pdoi_line PDOIline;
1754: x_hasBackingReqs pon_auction_headers_all.auction_origination_code%TYPE;
1755: x_source_reqs_flag VARCHAR2(1);
1756: x_sum_requisitions NUMBER;
1757: sum_of_alloc_quantities sumOfReqLineAllocQuantities;
1758:

Line 1876: FROM pon_auction_headers_all pah,

1872: pbh.idv_header_id, -- CLM Order off IDV Project
1873: pbh.external_idv,
1874: pah.umbrella_program_id,
1875: pah.fair_opp_notice_flag
1876: FROM pon_auction_headers_all pah,
1877: pon_bid_headers pbh,
1878: fnd_currencies fc
1879: WHERE pah.auction_header_id = p_auction_header_id and
1880: pbh.auction_header_id = pah.auction_header_id and

Line 2044: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;

2040: AND nvl(PAA.orig_req_line_id(+), -999) <> -999
2041: GROUP BY PAIP.line_number;
2042:
2043: --Unsolicited Lines Project
2044: l_allow_unsol_lines pon_auction_headers_all.ALLOW_UNSOL_OFFER_LINES%TYPE;
2045:
2046: --Bug : 14134092
2047: l_is_line_type_enabled VARCHAR2(1);
2048:

Line 2059: FROM pon_auction_headers_all

2055:
2056: --Unsolicited Lines Project : Get column ALLOW_UNSOL_OFFER_LINES
2057: SELECT doctype_id, Nvl(ALLOW_UNSOL_OFFER_LINES,'N')
2058: INTO l_doctype_id,l_allow_unsol_lines
2059: FROM pon_auction_headers_all
2060: WHERE auction_Header_id = p_auction_header_id;
2061:
2062: SELECT
2063: pon_auc_doctype_rules.DEFAULT_VALUE INTO l_is_fed

Line 3604: pon_auction_headers_all pah,

3600: fnd_global.login_id -- last_update_login
3601: FROM pon_price_differentials ppd,
3602: pon_bid_item_prices pbip,
3603: pon_bid_price_differentials pbpd,
3604: pon_auction_headers_all pah,
3605: po_lines_interface pli
3606: WHERE pbip.bid_number = p_bid_number
3607: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
3608: AND pbip.auction_header_id = ppd.auction_header_id

Line 3665: pon_auction_headers_all pah,

3661: where pbs.bid_number = p_bid_number
3662: and pbs.line_number = pbpd.line_number
3663: and pbs.shipment_number = pbpd.shipment_number) pbpd,
3664: pon_bid_shipments pbs,
3665: pon_auction_headers_all pah,
3666: po_lines_interface pli
3667: WHERE pbip.bid_number = p_bid_number
3668: AND nvl(pbip.award_status, 'NO') = 'AWARDED'
3669: AND pbip.bid_number = pbs.bid_number

Line 4065: l_language_code pon_auction_headers_all.language_code%TYPE;

4061: l_cur_item_description pon_auction_item_prices_all.item_description%TYPE;
4062: l_cur_ip_category_id NUMBER;
4063: l_cur_item_id NUMBER;
4064: l_cur_org_id NUMBER;
4065: l_language_code pon_auction_headers_all.language_code%TYPE;
4066:
4067: l_po_attr_values_stmt VARCHAR2(32767);
4068: l_po_attr_values_tlp_stmt VARCHAR2(32767);
4069:

Line 4126: from pon_auction_headers_all

4122: BEGIN
4123:
4124: select language_code
4125: into l_language_code
4126: from pon_auction_headers_all
4127: where auction_header_id = p_auction_header_id;
4128:
4129:
4130: l_cursorName := DBMS_SQL.Open_Cursor;

Line 4357: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;

4353: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4354: x_po_header_id NUMBER;
4355: x_order_number pon_bid_headers.order_number%TYPE;
4356: x_interface_header_id NUMBER;
4357: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
4358: x_auction_start_date DATE;
4359: x_auction_end_date DATE;
4360: x_tp_time_zone VARCHAR2(80);
4361: x_tp_time_zone1 VARCHAR2(80);

Line 4368: x_conterms_exist_flag pon_auction_headers_all.conterms_exist_flag%TYPE;

4364: x_allocate_item_url VARCHAR2(2000);
4365: x_auction_org_name VARCHAR2(80);
4366:
4367: x_doctype_id NUMBER;
4368: x_conterms_exist_flag pon_auction_headers_all.conterms_exist_flag%TYPE;
4369: x_contract_doc_name VARCHAR(30);
4370:
4371: /* Error code can take on the following values:
4372:

Line 4432: from pon_auction_headers_all

4428: view_by_date
4429: into x_auction_start_date,
4430: x_auction_end_date,
4431: x_preview_date
4432: from pon_auction_headers_all
4433: where auction_header_id = p_auction_header_id;
4434:
4435: /* Lock auction table to prevent concurrency errors */
4436: /* added doctype_id, conterms_exist_flag for contract terms */

Line 4440: FROM pon_auction_headers_all

4436: /* added doctype_id, conterms_exist_flag for contract terms */
4437:
4438: SELECT last_update_date, doctype_id, conterms_exist_flag
4439: INTO x_last_update_date, x_doctype_id, x_conterms_exist_flag
4440: FROM pon_auction_headers_all
4441: WHERE auction_header_id = p_auction_header_id
4442: FOR UPDATE;
4443:
4444: x_contract_doc_name := PON_CONTERMS_UTL_PVT.get_response_doc_type(x_doctype_id);

Line 4772: FROM pon_orca_cert_details pocd, po_headers_all pha, pon_auction_headers_all paha

4768: sysdate,
4769: fnd_global.user_id,
4770: sysdate,
4771: fnd_global.login_id
4772: FROM pon_orca_cert_details pocd, po_headers_all pha, pon_auction_headers_all paha
4773: WHERE pocd.document_number = paha.document_number
4774: AND paha.auction_header_id = p_auction_header_id
4775: AND pha.po_header_id = x_po_header_id
4776: AND pha.vendor_id = pocd.vendor_id

Line 5076: UPDATE PON_AUCTION_HEADERS_ALL

5072:
5073: IF (x_number_of_failed_pos > 0) THEN
5074: resultout := 'N';
5075: -- setting auction outcome status to outcome failed
5076: UPDATE PON_AUCTION_HEADERS_ALL
5077: SET OUTCOME_STATUS = 'OUTCOME_FAILED'
5078: WHERE AUCTION_HEADER_ID = x_auction_header_id;
5079: ELSE
5080: /* update auction outcome status to outcome_completed */

Line 5081: UPDATE PON_AUCTION_HEADERS_ALL

5077: SET OUTCOME_STATUS = 'OUTCOME_FAILED'
5078: WHERE AUCTION_HEADER_ID = x_auction_header_id;
5079: ELSE
5080: /* update auction outcome status to outcome_completed */
5081: UPDATE PON_AUCTION_HEADERS_ALL
5082: SET OUTCOME_STATUS = 'OUTCOME_COMPLETED'
5083: WHERE AUCTION_HEADER_ID = x_auction_header_id;
5084: resultout := 'Y';
5085:

Line 5134: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;

5130: beginBold VARCHAR2(10);
5131: endBold VARCHAR2(10);
5132: x_count NUMBER;
5133: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5134: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5135: x_purchase_orders VARCHAR2(30);
5136: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5137:
5138: /* Selects all relevant information for the first 10 successful POs of the current round*/

Line 5136: x_contract_type pon_auction_headers_all.contract_type%TYPE;

5132: x_count NUMBER;
5133: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5134: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5135: x_purchase_orders VARCHAR2(30);
5136: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5137:
5138: /* Selects all relevant information for the first 10 successful POs of the current round*/
5139:
5140: CURSOR successfulPOs is

Line 5187: FROM pon_auction_headers_all

5183: x_user_name := substr(x_substr, x_index+1);
5184:
5185: SELECT wf_poncompl_item_key, contract_type
5186: INTO itemkey, x_contract_type
5187: FROM pon_auction_headers_all
5188: WHERE auction_header_id = x_auction_header_id;
5189:
5190: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
5191: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);

Line 5304: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;

5300: beginBold VARCHAR2(10);
5301: endBold VARCHAR2(10);
5302: x_count NUMBER;
5303: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5304: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5305: x_purchase_orders VARCHAR2(30);
5306: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5307: x_error_msg pon_bid_headers.po_error_msg%type;
5308:

Line 5306: x_contract_type pon_auction_headers_all.contract_type%TYPE;

5302: x_count NUMBER;
5303: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5304: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5305: x_purchase_orders VARCHAR2(30);
5306: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5307: x_error_msg pon_bid_headers.po_error_msg%type;
5308:
5309: CURSOR failedPOs is
5310: SELECT pbh.bid_number,

Line 5354: FROM pon_auction_headers_all

5350:
5351:
5352: SELECT wf_poncompl_item_key, contract_type
5353: INTO itemkey, x_contract_type
5354: FROM pon_auction_headers_all
5355: WHERE auction_header_id = x_auction_header_id;
5356:
5357: x_progress := '20: GENERATE_PO_FAILURE_EMAIL auction id: ' || x_auction_header_id || ', ' || 'message suffix: ' || x_msg_suffix || ', ' || 'user name: ' || x_user_name;
5358:

Line 5493: x_has_items PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

5489: x_itemkey wf_items.ITEM_KEY%TYPE;
5490: x_sequence NUMBER;
5491: x_current_round NUMBER;
5492: x_requistion_based VARCHAR2(12);
5493: x_has_items PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
5494: x_number_of_failed_pos NUMBER;
5495: x_email_type VARCHAR2(240);
5496: x_allocation_error VARCHAR2(2000);
5497: x_line_number NUMBER;

Line 5509: x_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

5505:
5506: x_open_bidding_date date;
5507: x_close_bidding_date date;
5508: x_trading_partner_contact_id number;
5509: x_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
5510: x_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
5511: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
5512:
5513: l_workflow_failure VARCHAR2(1);

Line 5510: x_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

5506: x_open_bidding_date date;
5507: x_close_bidding_date date;
5508: x_trading_partner_contact_id number;
5509: x_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
5510: x_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
5511: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
5512:
5513: l_workflow_failure VARCHAR2(1);
5514:

Line 5511: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

5507: x_close_bidding_date date;
5508: x_trading_partner_contact_id number;
5509: x_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
5510: x_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
5511: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
5512:
5513: l_workflow_failure VARCHAR2(1);
5514:
5515: l_api_name VARCHAR2(30) := ' START_PO_CREATION ';

Line 5582: from pon_auction_headers_all

5578: x_trading_partner_name,
5579: x_trading_partner_contact_name,
5580: x_has_items,
5581: x_current_round
5582: from pon_auction_headers_all
5583: where auction_header_id = p_auction_header_id;
5584:
5585:
5586: if(l_debug_enabled = 'Y') then

Line 5629: -- since we havent set wf_poncompl_current_round in pon_auction_headers_all

5625: end if;
5626:
5627: BEGIN -- main try-catch block --{
5628:
5629: -- since we havent set wf_poncompl_current_round in pon_auction_headers_all
5630: -- as yet, x_current_round will be zero if there was no failure reported earlier
5631:
5632: UPDATE pon_auction_headers_all set
5633: outcome_status = decode(x_current_round, 0, 'OUTCOME_INITIATED', 'OUTCOME_REINITIATED'),

Line 5632: UPDATE pon_auction_headers_all set

5628:
5629: -- since we havent set wf_poncompl_current_round in pon_auction_headers_all
5630: -- as yet, x_current_round will be zero if there was no failure reported earlier
5631:
5632: UPDATE pon_auction_headers_all set
5633: outcome_status = decode(x_current_round, 0, 'OUTCOME_INITIATED', 'OUTCOME_REINITIATED'),
5634: last_update_date = sysdate
5635: WHERE auction_header_id = p_auction_header_id;
5636:

Line 5801: UPDATE PON_AUCTION_HEADERS_ALL

5797: || p_auction_header_id || ' initiated by ' || p_user_name || ' at '
5798: || to_char(sysdate, 'Dy DD-Mon-YYYY hh24:mi:ss'));
5799: end if;
5800:
5801: UPDATE PON_AUCTION_HEADERS_ALL
5802: SET OUTCOME_STATUS = 'OUTCOME_FAILED'
5803: WHERE AUCTION_HEADER_ID = p_auction_header_id;
5804:
5805: IF(x_requistion_based = 'REQUISITION') THEN

Line 5822: UPDATE PON_AUCTION_HEADERS_ALL

5818:
5819:
5820: log_message('70. generate_pos successful');
5821: /* update auction outcome status to outcome_completed */
5822: UPDATE PON_AUCTION_HEADERS_ALL
5823: SET OUTCOME_STATUS = 'OUTCOME_COMPLETED'
5824: WHERE AUCTION_HEADER_ID = p_auction_header_id;
5825:
5826: l_resultout := 'SUCCESS';

Line 5847: UPDATE PON_AUCTION_HEADERS_ALL

5843: rollback;
5844:
5845: l_resultout := 'FAILURE';
5846:
5847: UPDATE PON_AUCTION_HEADERS_ALL
5848: SET OUTCOME_STATUS = 'OUTCOME_FAILED'
5849: WHERE AUCTION_HEADER_ID = p_auction_header_id;
5850:
5851: x_email_type := 'PON_AUC_PO_CREATE_PO_FAIL';

Line 5888: -- update pon_auction_headers_all.wf_poncompl_current_round by incrementing by one

5884: FROM dual;
5885:
5886: x_itemkey := (to_char(p_auction_header_id)||'-'||to_char(x_sequence));
5887:
5888: -- update pon_auction_headers_all.wf_poncompl_current_round by incrementing by one
5889: -- update pon_bid_headers.po_wf_creation_rnd by incrementing by one
5890:
5891: UPDATE pon_auction_headers_all set
5892: wf_poncompl_item_key = x_itemkey,

Line 5891: UPDATE pon_auction_headers_all set

5887:
5888: -- update pon_auction_headers_all.wf_poncompl_current_round by incrementing by one
5889: -- update pon_bid_headers.po_wf_creation_rnd by incrementing by one
5890:
5891: UPDATE pon_auction_headers_all set
5892: wf_poncompl_item_key = x_itemkey,
5893: wf_poncompl_current_round = x_current_round+1,
5894: last_update_date = sysdate
5895: WHERE auction_header_id = p_auction_header_id;