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

Line 235: l_uda_template_id pon_auction_headers_all.uda_template_id%TYPE;

231: p_auction_header_id IN NUMBER,
232: x_return_status IN OUT NOCOPY VARCHAR2
233: )
234: IS
235: l_uda_template_id pon_auction_headers_all.uda_template_id%TYPE;
236: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
237: clm_doc_number pon_auction_headers_all.document_Number%TYPE;
238: l_return_status VARCHAR2(1);
239: l_err_msg VARCHAR2(100);

Line 236: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

232: x_return_status IN OUT NOCOPY VARCHAR2
233: )
234: IS
235: l_uda_template_id pon_auction_headers_all.uda_template_id%TYPE;
236: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
237: clm_doc_number pon_auction_headers_all.document_Number%TYPE;
238: l_return_status VARCHAR2(1);
239: l_err_msg VARCHAR2(100);
240:

Line 237: clm_doc_number pon_auction_headers_all.document_Number%TYPE;

233: )
234: IS
235: l_uda_template_id pon_auction_headers_all.uda_template_id%TYPE;
236: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
237: clm_doc_number pon_auction_headers_all.document_Number%TYPE;
238: l_return_status VARCHAR2(1);
239: l_err_msg VARCHAR2(100);
240:
241: l_delimiter VARCHAR2(4000);

Line 259: FROM pon_auction_headers_all

255: BEGIN
256:
257: SELECT doctype_id,uda_template_id
258: INTO l_doctype_id, l_uda_template_id
259: FROM pon_auction_headers_all
260: WHERE auction_header_id = p_auction_header_id;
261:
262: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id) = 1 THEN
263:

Line 339: UPDATE pon_auction_headers_all

335: ELSE
336: x_return_status := 'S';
337: END IF;
338:
339: UPDATE pon_auction_headers_all
340: SET DOCUMENT_NUMBER = l_document_number
341: WHERE AUCTION_HEADER_ID = p_auction_header_id;
342:
343: END IF;

Line 597: FROM pon_auction_headers_all

593: /* getting the amendment number */
594: BEGIN
595: SELECT MAX(amendment_number)
596: INTO l_LAST_AMENDMENT_UPDATE
597: FROM pon_auction_headers_all
598: WHERE AUCTION_HEADER_ID = c_interface_attr_rec.AUCTION_HEADER_ID;
599: EXCEPTION
600: WHEN No_Data_Found THEN
601: l_LAST_AMENDMENT_UPDATE:= NULL;

Line 765: AND EXISTS(SELECT 'Y' FROM PON_AUCtion_ATTRIBUTES paa,pon_auction_Headers_all pah WHERE paa.auction_Header_id = l_auction_header_id

761: SELECT Decode(Sum(Nvl(weight,0)),100,'Y','N') INTO l_sum_wt_err
762: FROM pon_auction_attributes paa
763: WHERE paa.auction_Header_id = l_auction_header_id
764: AND Nvl(paa.scoring_METHOD,'NONE') <>'NONE'
765: AND EXISTS(SELECT 'Y' FROM PON_AUCtion_ATTRIBUTES paa,pon_auction_Headers_all pah WHERE paa.auction_Header_id = l_auction_header_id
766: AND paa.auction_Header_id = pah.auction_Header_id
767: AND Nvl(pah.HDR_ATTR_ENABLE_WEIGHTS,'N') = 'Y'
768: AND Nvl(paa.scoring_METHOD,'NONE') <>'NONE');
769:

Line 1190: l_NEG_TEAM_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.NEG_TEAM_ENABLED_FLAG%TYPE;

1186: AND user_name <> neg_header_record_data.trading_partner_contact_name;
1187:
1188: c_interface_neg_team_rec c_interface_neg_team%ROWTYPE;
1189: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%TYPE;
1190: l_NEG_TEAM_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.NEG_TEAM_ENABLED_FLAG%TYPE;
1191: l_user_id FND_USER.USER_ID%TYPE;
1192: l_check VARCHAR2(20);
1193: BEGIN
1194: print_log('Entering procedure create_neg_team');

Line 1295: l_neg_team_enabled_flag pon_auction_headers_all.NEG_TEAM_ENABLED_FLAG%TYPE;

1291: lm_employee_id fnd_user.EMPLOYEE_ID%TYPE;
1292: lm_user_start_date fnd_user.START_DATE%TYPE;
1293: lm_user_end_date fnd_user.END_DATE%TYPE;
1294: l_auction_header_id PON_NEG_TEAM_MEMBERS.auction_header_id%TYPE;
1295: l_neg_team_enabled_flag pon_auction_headers_all.NEG_TEAM_ENABLED_FLAG%TYPE;
1296: BEGIN
1297: l_auction_header_id:=auction_header_id;
1298: print_log('create_members_in_collteam begin: auction_header_id ' || auction_header_id || ' username ' || username);
1299: IF (ispreparer ='Y') THEN

Line 1318: PON_AUCTION_HEADERS_ALL PAH ,

1314: FROM PER_ALL_ASSIGNMENTS_F ASS,
1315: FND_USER EMP ,
1316: PER_ALL_PEOPLE_F PER ,
1317: PER_ALL_POSITIONS POS ,
1318: PON_AUCTION_HEADERS_ALL PAH ,
1319: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1320: WHERE ASS.PERSON_ID = EMP.EMPLOYEE_ID
1321: AND ASS.POSITION_ID = POS.POSITION_ID(+)
1322: AND ASS.PRIMARY_FLAG = 'Y'

Line 1417: FROM pon_auction_headers_all

1413: l_member_type := 'N';
1414: BEGIN
1415: SELECT DISTINCT NEG_TEAM_ENABLED_FLAG
1416: INTO l_neg_team_enabled_flag
1417: FROM pon_auction_headers_all
1418: WHERE auction_header_id = l_auction_header_id;
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1617: L_ORG_ID PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;

1613: l_CREATED_BY PON_BID_PARTIES_INTERFACE.CREATED_BY%TYPE;
1614: l_LAST_UPDATE_DATE PON_BID_PARTIES_INTERFACE.LAST_UPDATE_DATE%TYPE;
1615: l_LAST_UPDATED_BY PON_BID_PARTIES_INTERFACE.LAST_UPDATED_BY%TYPE;
1616: l_LAST_AMENDMENT_UPDATE PON_BIDDING_PARTIES.LAST_AMENDMENT_UPDATE%TYPE;
1617: L_ORG_ID PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;
1618: l_TRADING_PARTNER_ID PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1619: l_STATUS VARCHAR2(10);
1620: BEGIN
1621: print_Log('In the invite supplier procedure');

Line 1618: l_TRADING_PARTNER_ID PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;

1614: l_LAST_UPDATE_DATE PON_BID_PARTIES_INTERFACE.LAST_UPDATE_DATE%TYPE;
1615: l_LAST_UPDATED_BY PON_BID_PARTIES_INTERFACE.LAST_UPDATED_BY%TYPE;
1616: l_LAST_AMENDMENT_UPDATE PON_BIDDING_PARTIES.LAST_AMENDMENT_UPDATE%TYPE;
1617: L_ORG_ID PON_AUCTION_HEADERS_ALL.ORG_ID%TYPE;
1618: l_TRADING_PARTNER_ID PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
1619: l_STATUS VARCHAR2(10);
1620: BEGIN
1621: print_Log('In the invite supplier procedure');
1622:

Line 1687: FROM PON_AUCTION_HEADERS_ALL

1683: END IF;
1684:
1685: /****** Get Outcome Operating Unit Id ******/
1686: SELECT ORG_ID INTO L_ORG_ID
1687: FROM PON_AUCTION_HEADERS_ALL
1688: WHERE AUCTION_HEADER_ID = l_AUCTION_HEADER_ID;
1689:
1690: -- If vendor_site_id and vendor_site_code is not null
1691: IF (L_VENDOR_SITE_ID IS NOT NULL) THEN

Line 1741: FROM pon_auction_headers_all

1737: /* getting the amendment number */
1738: BEGIN
1739: SELECT MAX(amendment_number)
1740: INTO l_LAST_AMENDMENT_UPDATE
1741: FROM pon_auction_headers_all
1742: WHERE AUCTION_HEADER_ID = l_AUCTION_HEADER_ID;
1743: EXCEPTION
1744: WHEN No_Data_Found THEN
1745: l_LAST_AMENDMENT_UPDATE:= NULL;

Line 2173: l_doctype_id pon_auction_headers_all.doctype_id%type;

2169: x_last_line_close_date DATE;
2170: x_result VARCHAR2(1);
2171: x_error_code VARCHAR2(10);
2172: x_error_message VARCHAR2(50);
2173: l_doctype_id pon_auction_headers_all.doctype_id%type;
2174: g_user_id fnd_user.user_id%type;
2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;

Line 2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;

2171: x_error_code VARCHAR2(10);
2172: x_error_message VARCHAR2(50);
2173: l_doctype_id pon_auction_headers_all.doctype_id%type;
2174: g_user_id fnd_user.user_id%type;
2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;

Line 2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;

2172: x_error_message VARCHAR2(50);
2173: l_doctype_id pon_auction_headers_all.doctype_id%type;
2174: g_user_id fnd_user.user_id%type;
2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;

Line 2177: l_contract_type pon_auction_headers_all.contract_type%type;

2173: l_doctype_id pon_auction_headers_all.doctype_id%type;
2174: g_user_id fnd_user.user_id%type;
2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;

Line 2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;

2174: g_user_id fnd_user.user_id%type;
2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;

Line 2179: l_org_id pon_auction_headers_all.org_id%type;

2175: l_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;

Line 2180: l_currency_code pon_auction_headers_all.currency_code%type;

2176: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%type;
2177: l_contract_type pon_auction_headers_all.contract_type%type;
2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;

Line 2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;

2178: l_global_flag pon_auction_headers_all.global_agreement_flag%type;
2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;
2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;
2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;

Line 2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;

2179: l_org_id pon_auction_headers_all.org_id%type;
2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;
2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;
2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;
2187: c_seq_num2 pon_auc_attributes_interface.sequence_number%TYPE;

Line 2194: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

2190: l_ext_precision NUMBER;
2191: l_minAcctUnit NUMBER;
2192: l_status VARCHAR2(1);
2193: l_is_complex VARCHAR2(1);
2194: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
2195: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
2196: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
2197: l_price_break_response pon_auction_headers_all.price_break_response%TYPE;
2198: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

Line 2195: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;

2191: l_minAcctUnit NUMBER;
2192: l_status VARCHAR2(1);
2193: l_is_complex VARCHAR2(1);
2194: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
2195: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
2196: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
2197: l_price_break_response pon_auction_headers_all.price_break_response%TYPE;
2198: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2199: --l_has_shipments VARCHAR2(1);

Line 2196: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;

2192: l_status VARCHAR2(1);
2193: l_is_complex VARCHAR2(1);
2194: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
2195: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
2196: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
2197: l_price_break_response pon_auction_headers_all.price_break_response%TYPE;
2198: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2199: --l_has_shipments VARCHAR2(1);
2200:

Line 2197: l_price_break_response pon_auction_headers_all.price_break_response%TYPE;

2193: l_is_complex VARCHAR2(1);
2194: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
2195: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
2196: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
2197: l_price_break_response pon_auction_headers_all.price_break_response%TYPE;
2198: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2199: --l_has_shipments VARCHAR2(1);
2200:
2201: CURSOR c_attributes_with_scoring

Line 2198: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

2194: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
2195: l_po_start_date pon_auction_headers_all.po_start_date%TYPE;
2196: l_po_end_date pon_auction_headers_all.po_end_date%TYPE;
2197: l_price_break_response pon_auction_headers_all.price_break_response%TYPE;
2198: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2199: --l_has_shipments VARCHAR2(1);
2200:
2201: CURSOR c_attributes_with_scoring
2202: IS

Line 2284: FROM pon_auction_headers_all

2280: l_po_start_date ,
2281: l_po_end_date ,
2282: l_price_break_response ,
2283: l_price_tiers_indicator
2284: FROM pon_auction_headers_all
2285: WHERE auction_header_id = p_auction_header_id;
2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;
2287: SELECT fnd_global.login_id,
2288: fnd_global.CURRENT_LANGUAGE

Line 2413: UPDATE pon_auction_headers_all pah

2409: FROM pon_auction_item_prices_all
2410: WHERE auction_header_id = p_auction_header_id
2411: AND parent_line_number IS NULL;
2412:
2413: UPDATE pon_auction_headers_all pah
2414: SET (MAX_INTERNAL_LINE_NUM,
2415: NUMBER_OF_LINES,
2416: last_line_number) = (SELECT Max(line_number), Count(line_number),l_last_line_num
2417: FROM pon_auction_item_prices_all paip

Line 2645: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

2641: AS
2642: TYPE numbers IS TABLE OF NUMBER;
2643: l_shipment_number numbers;
2644: l_line_number numbers;
2645: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2646: /*CURSOR price_break_with_pd_cur IS
2647: SELECT auction_header_id, auction_line_number, shipment_number
2648: FROM pon_auc_price_breaks_interface ppbi
2649: WHERE ppbi.batch_id = p_batch_id

Line 2661: FROM pon_auction_headers_all

2657: later we will insert only price breaks given in interface tables.
2658: */
2659: print_log(' Entering add_price_breaks ');
2660: SELECT price_tiers_indicator INTO l_price_tiers_indicator
2661: FROM pon_auction_headers_all
2662: WHERE auction_header_id = p_auction_header_id;
2663: BEGIN
2664: SELECT shipment_number,
2665: line_number bulk collect

Line 2808: FROM pon_auction_headers_all

2804:
2805: UPDATE pon_auc_price_breaks_interface pb_int
2806: SET org_id =
2807: (SELECT ORG_ID
2808: FROM pon_auction_headers_all
2809: WHERE auction_header_id = pb_int.auction_header_id
2810: )
2811: WHERE batch_id = p_batch_id;
2812:

Line 3768: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;

3764: dummy1 NUMBER;
3765: neg_return_status VARCHAR2(1);
3766: p_error_code VARCHAR2(1);
3767: p_error_message VARCHAR2(1000);
3768: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
3769: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
3770: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
3771: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
3772:

Line 3769: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;

3765: neg_return_status VARCHAR2(1);
3766: p_error_code VARCHAR2(1);
3767: p_error_message VARCHAR2(1000);
3768: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
3769: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
3770: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
3771: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
3772:
3773: CURSOR group_negotiations_cur IS

Line 3770: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;

3766: p_error_code VARCHAR2(1);
3767: p_error_message VARCHAR2(1000);
3768: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
3769: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
3770: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
3771: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
3772:
3773: CURSOR group_negotiations_cur IS
3774: SELECT interface_header_id FROM pon_auction_Headers_interface

Line 3833: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

3829: print_log('Negotiation creation has failed for batch id ' || l_batch_id);
3830: x_return_status := FND_API.G_RET_STS_ERROR;
3831: --ROLLBACK TO NEG_CREATION;
3832: IF ( l_auction_header_id IS NOT NULL ) THEN
3833: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
3834: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;

Line 3947: FROM pon_auction_Headers_all

3943:
3944:
3945: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id) = 1 ) THEN
3946: SELECT uda_template_id INTO l_uda_template_id
3947: FROM pon_auction_Headers_all
3948: WHERE auction_header_id = x_auction_header_id;
3949:
3950: process_uda_attributes(p_batch_id, x_auction_header_id, NULL, l_uda_template_id, 'PON_AUC_HDRS_EXT_ATTRS', x_return_status);
3951: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 4135: l_uda_template_id pon_auction_Headers_all.uda_template_id%TYPE;

4131: )
4132: IS
4133:
4134: PRAGMA autonomous_transaction;
4135: l_uda_template_id pon_auction_Headers_all.uda_template_id%TYPE;
4136: po_uda_array PO_UDA_USAGE_OBJECT_ARRAY := PO_UDA_USAGE_OBJECT_ARRAY();
4137: ego_value_pairs_table ego_col_name_value_pair_table ;
4138: l_return_status varchar2(1);
4139: l_errorcode Number;

Line 4301: INSERT INTO PON_AUCTION_HEADERS_ALL (

4297: FROM pon_auc_doctypes
4298: WHERE doctype_id = neg_header_record_data.doctype_id;
4299:
4300:
4301: INSERT INTO PON_AUCTION_HEADERS_ALL (
4302: AUCTION_HEADER_ID,
4303: DOCUMENT_NUMBER,
4304: AUCTION_HEADER_ID_ORIG_AMEND,
4305: AUCTION_HEADER_ID_ORIG_ROUND,

Line 4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;

4929:
4930: dummy1 VARCHAR2(100);
4931: l_val_err VARCHAR2(1);
4932:
4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;
4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;

Line 4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;

4930: dummy1 VARCHAR2(100);
4931: l_val_err VARCHAR2(1);
4932:
4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;
4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;

Line 4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;

4931: l_val_err VARCHAR2(1);
4932:
4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;
4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;

Line 4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;

4932:
4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;
4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;

Line 4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;

4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;
4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;
4941: l_tpc_name fnd_user.user_Name%TYPE;

Line 4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;

4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;
4941: l_tpc_name fnd_user.user_Name%TYPE;
4942:
4943: l_dummy_data VARCHAR2(100);

Line 5236: -- This record will be used to insert data in pon_auction_headers_all table

5232:
5233: print_log(' Initial set of validations done ');
5234:
5235: -- Call to populate neg_header_record_data record
5236: -- This record will be used to insert data in pon_auction_headers_all table
5237: populate_neg_header_rec(
5238: p_batch_id,
5239: 'N', -- is_amendment
5240: NULL -- src_auction_header_id

Line 5275: -- Insert data into pon_auction_headers_all table

5271: END IF;
5272:
5273: print_log(' Header validations are completed ');
5274:
5275: -- Insert data into pon_auction_headers_all table
5276: create_negotiation_header(p_batch_id,
5277: x_return_status);
5278:
5279: x_auction_header_id := neg_header_record_data.auction_header_id;

Line 5328: UPDATE pon_auction_headers_all

5324: NULL;
5325: END;
5326:
5327: IF(approval_required_flag='Y') THEN
5328: UPDATE pon_auction_headers_all
5329: SET approval_status = 'REQUIRED'
5330: WHERE auction_header_id = neg_header_record_data.auction_header_id;
5331: ELSE
5332: UPDATE pon_auction_headers_all

Line 5332: UPDATE pon_auction_headers_all

5328: UPDATE pon_auction_headers_all
5329: SET approval_status = 'REQUIRED'
5330: WHERE auction_header_id = neg_header_record_data.auction_header_id;
5331: ELSE
5332: UPDATE pon_auction_headers_all
5333: SET approval_status = 'NOT_REQUIRED'
5334: WHERE auction_header_id = neg_header_record_data.auction_header_id;
5335: END IF;
5336:

Line 6312: SELECT pon_auction_headers_all_s.NEXTVAL INTO neg_header_record_data.auction_header_id FROM dual;

6308: print_log('populate_neg_header_rec begin ');
6309:
6310: -- For amendment neg_header_record_data.auction_header_id will not be used
6311: IF ( p_is_amendment <> 'Y' ) THEN
6312: SELECT pon_auction_headers_all_s.NEXTVAL INTO neg_header_record_data.auction_header_id FROM dual;
6313: END IF;
6314:
6315: SELECT person_party_id,user_name
6316: INTO neg_header_record_data.trading_partner_contact_id,neg_header_record_data.trading_partner_contact_name

Line 6614: FROM pon_auction_headers_all

6610: SELECT org_id, doctype_id, style_id, po_style_Id, contract_type
6611: INTO neg_header_record_data.org_id, neg_header_record_data.doctype_id,
6612: neg_header_record_data.style_id, neg_header_record_data.po_style_Id,
6613: neg_header_record_data.contract_type
6614: FROM pon_auction_headers_all
6615: WHERE auction_header_id = p_src_auction_header_id;
6616: END IF;
6617:
6618: -- UDA template id and date derivation

Line 6651: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;

6647:
6648: --organization based default data
6649: l_org_default_data org_default_data;
6650: l_document_type pon_auc_doctypes.internal_name%TYPE;
6651: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
6652: -- po doc style related fields
6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;

Line 6935: l_MAX_DOCUMENT_LINE_NUM pon_auction_headers_all.MAX_DOCUMENT_LINE_NUM%TYPE;

6931: PROCEDURE publish_negotiation(p_auction_header_id in NUMBER,
6932: x_return_status IN OUT NOCOPY VARCHAR2)
6933: IS
6934:
6935: l_MAX_DOCUMENT_LINE_NUM pon_auction_headers_all.MAX_DOCUMENT_LINE_NUM%TYPE;
6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;
6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;
6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;

Line 6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;

6932: x_return_status IN OUT NOCOPY VARCHAR2)
6933: IS
6934:
6935: l_MAX_DOCUMENT_LINE_NUM pon_auction_headers_all.MAX_DOCUMENT_LINE_NUM%TYPE;
6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;
6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;
6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;
6940: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

Line 6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;

6933: IS
6934:
6935: l_MAX_DOCUMENT_LINE_NUM pon_auction_headers_all.MAX_DOCUMENT_LINE_NUM%TYPE;
6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;
6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;
6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;
6940: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
6941: x_result VARCHAR2(300);

Line 6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

6934:
6935: l_MAX_DOCUMENT_LINE_NUM pon_auction_headers_all.MAX_DOCUMENT_LINE_NUM%TYPE;
6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;
6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;
6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;
6940: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
6941: x_result VARCHAR2(300);
6942: x_error_code VARCHAR2(300);

Line 6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;

6935: l_MAX_DOCUMENT_LINE_NUM pon_auction_headers_all.MAX_DOCUMENT_LINE_NUM%TYPE;
6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;
6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;
6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;
6940: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
6941: x_result VARCHAR2(300);
6942: x_error_code VARCHAR2(300);
6943: x_error_message VARCHAR2(300);

Line 6940: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

6936: l_NUMBER_OF_LINES pon_auction_headers_all.NUMBER_OF_LINES%TYPE;
6937: l_LAST_LINE_NUMBER pon_auction_headers_all.LAST_LINE_NUMBER%TYPE;
6938: l_trading_partner_contact_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
6939: l_auction_title pon_auction_headers_all.auction_title%TYPE;
6940: l_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
6941: x_result VARCHAR2(300);
6942: x_error_code VARCHAR2(300);
6943: x_error_message VARCHAR2(300);
6944: l_disscussion_id NUMBER;

Line 6950: FROM PON_AUCTION_HEADERS_ALL

6946: BEGIN
6947:
6948: SELECT close_bidding_date
6949: INTO l_close_bidding_date
6950: FROM PON_AUCTION_HEADERS_ALL
6951: WHERE auction_header_id = p_auction_header_id;
6952:
6953:
6954: pon_negotiation_publish_pvt.update_before_publish (

Line 6964: UPDATE pon_auction_headers_all SET

6960: fnd_global.user_Id,
6961: fnd_global.login_id);
6962:
6963:
6964: UPDATE pon_auction_headers_all SET
6965: OPEN_BIDDING_DATE=neg_header_record_data.open_bidding_date,
6966: CLOSE_BIDDING_DATE=neg_header_record_data.CLOSE_BIDDING_DATE,
6967: PUBLISH_DATE=neg_header_record_data.publish_date,
6968: AUTO_EXTEND_FLAG='N'

Line 6973: FROM pon_auction_headers_all

6969: WHERE auction_header_id = p_auction_header_id;
6970:
6971: SELECT trading_partner_contact_id,auction_title
6972: INTO l_trading_partner_contact_id,l_auction_title
6973: FROM pon_auction_headers_all
6974: WHERE auction_header_id = p_auction_header_id;
6975:
6976: l_disscussion_id:=PON_THREAD_DISC_PKG.INSERT_PON_DISCUSSIONS('PON_AUCTION_HEADERS_ALL',p_auction_header_id,NULL,NULL,
6977: NULL,NULL,l_auction_title,USERENV('LANG'),l_trading_partner_contact_id,

Line 6976: l_disscussion_id:=PON_THREAD_DISC_PKG.INSERT_PON_DISCUSSIONS('PON_AUCTION_HEADERS_ALL',p_auction_header_id,NULL,NULL,

6972: INTO l_trading_partner_contact_id,l_auction_title
6973: FROM pon_auction_headers_all
6974: WHERE auction_header_id = p_auction_header_id;
6975:
6976: l_disscussion_id:=PON_THREAD_DISC_PKG.INSERT_PON_DISCUSSIONS('PON_AUCTION_HEADERS_ALL',p_auction_header_id,NULL,NULL,
6977: NULL,NULL,l_auction_title,USERENV('LANG'),l_trading_partner_contact_id,
6978: 'oracle.apps.pon.auctions.discussions.NegDiscussionValidation');
6979: print_log('Auction is published with disscussion id '||l_disscussion_id);
6980:

Line 6993: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;

6989: AS
6990: dummy1 NUMBER;
6991: p_error_code VARCHAR2(1);
6992: p_error_message VARCHAR2(1000);
6993: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
6994: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
6995: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
6996: amend_return_status VARCHAR2(1) ;
6997:

Line 6994: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;

6990: dummy1 NUMBER;
6991: p_error_code VARCHAR2(1);
6992: p_error_message VARCHAR2(1000);
6993: l_auctioN_header_id pon_auction_headers_all.auctioN_header_id%TYPE;
6994: l_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
6995: l_batch_id pon_auctioN_headers_interface.batch_id%TYPE;
6996: amend_return_status VARCHAR2(1) ;
6997:
6998: CURSOR group_amendments_cur IS

Line 7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

7046: -- return error status even if one batch fails
7047: x_return_status := FND_API.G_RET_STS_ERROR;
7048: --ROLLBACK TO NEG_CREATION;
7049: IF ( l_auction_header_id IS NOT NULL ) THEN
7050: DELETE FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;

Line 7091: l_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

7087: x_return_status IN OUT NOCOPY VARCHAR2,
7088: x_msg_count IN OUT NOCOPY NUMBER,
7089: x_msg_data IN OUT NOCOPY varchar2)
7090: IS
7091: l_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7092: l_tpc_name pon_auction_headers_all.trading_partner_contact_name%TYPE;
7093: l_username fnd_user.user_name%TYPE;
7094: l_mgr_id fnd_user.user_id%TYPE;
7095: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

Line 7092: l_tpc_name pon_auction_headers_all.trading_partner_contact_name%TYPE;

7088: x_msg_count IN OUT NOCOPY NUMBER,
7089: x_msg_data IN OUT NOCOPY varchar2)
7090: IS
7091: l_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7092: l_tpc_name pon_auction_headers_all.trading_partner_contact_name%TYPE;
7093: l_username fnd_user.user_name%TYPE;
7094: l_mgr_id fnd_user.user_id%TYPE;
7095: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
7096: P_ERROR_CODE VARCHAR2(50);

Line 7095: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;

7091: l_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7092: l_tpc_name pon_auction_headers_all.trading_partner_contact_name%TYPE;
7093: l_username fnd_user.user_name%TYPE;
7094: l_mgr_id fnd_user.user_id%TYPE;
7095: l_doctype_id pon_auction_headers_all.doctype_id%TYPE;
7096: P_ERROR_CODE VARCHAR2(50);
7097: P_ERROR_MESSAGE VARCHAR2(50);
7098: o_auction_header_id NUMBER;
7099: x_document_number VARCHAR2(50);

Line 7188: FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

7184: print_log('Ammendement can be created ' || x_return_status);
7185:
7186: SELECT doctype_id, style_id
7187: INTO l_doctype_id, l_style_id
7188: FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;
7189:
7190: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id) = 1 THEN
7191: pon_negotiation_copy_grp.FED_CREATE_AMD_COPY_NEG
7192: (1.0,'F','N',l_auction_header_id,g_trading_partner_id,l_tpc_id,USERENV('LANG'),l_tpc_id,

Line 7222: -- This record will be used to insert data in pon_auction_headers_all table

7218: RAISE FND_API.G_EXC_ERROR;
7219: END IF;
7220:
7221: -- Call to populate neg_header_record_data record
7222: -- This record will be used to insert data in pon_auction_headers_all table
7223: populate_neg_header_rec(
7224: p_batch_id,
7225: 'Y',
7226: x_auction_header_id

Line 7260: -- Insert data into pon_auction_headers_all table

7256: END IF;
7257:
7258: print_log(' Header validations are completed ');
7259:
7260: -- Insert data into pon_auction_headers_all table
7261: update_amendment_header(x_auction_header_id);
7262:
7263: print_log('Header information updated for amendment ' || x_auction_header_id );
7264:

Line 7267: FROM pon_auction_Headers_all

7263: print_log('Header information updated for amendment ' || x_auction_header_id );
7264:
7265: IF ( PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(l_doctype_id) = 1 ) THEN
7266: SELECT uda_template_id INTO l_uda_template_id
7267: FROM pon_auction_Headers_all
7268: WHERE auction_header_id = x_auction_header_id;
7269:
7270: process_uda_attributes(p_batch_id, x_auction_header_id, NULL, l_uda_template_id,'PON_AUC_HDRS_EXT_ATTRS', x_return_status);
7271: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 7364: l_CLOSE_BIDDING_DATE pon_auction_headers_all.CLOSE_BIDDING_DATE%TYPE;

7360: p_tpc_id IN NUMBER,
7361: p_auction_header_id IN NUMBER)
7362: RETURN boolean
7363: IS
7364: l_CLOSE_BIDDING_DATE pon_auction_headers_all.CLOSE_BIDDING_DATE%TYPE;
7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

Line 7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;

7361: p_auction_header_id IN NUMBER)
7362: RETURN boolean
7363: IS
7364: l_CLOSE_BIDDING_DATE pon_auction_headers_all.CLOSE_BIDDING_DATE%TYPE;
7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;

Line 7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;

7362: RETURN boolean
7363: IS
7364: l_CLOSE_BIDDING_DATE pon_auction_headers_all.CLOSE_BIDDING_DATE%TYPE;
7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;

Line 7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;

7363: IS
7364: l_CLOSE_BIDDING_DATE pon_auction_headers_all.CLOSE_BIDDING_DATE%TYPE;
7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;
7371: l_username fnd_user.user_name%TYPE;

Line 7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;

7364: l_CLOSE_BIDDING_DATE pon_auction_headers_all.CLOSE_BIDDING_DATE%TYPE;
7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;
7371: l_username fnd_user.user_name%TYPE;
7372: P_ERROR_CODE VARCHAR2(50);

Line 7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;

7365: l_view_by_DATE pon_auction_headers_all.view_by_DATE%TYPE;
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;
7371: l_username fnd_user.user_name%TYPE;
7372: P_ERROR_CODE VARCHAR2(50);
7373: P_ERROR_MESSAGE VARCHAR2(50);

Line 7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;

7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;
7371: l_username fnd_user.user_name%TYPE;
7372: P_ERROR_CODE VARCHAR2(50);
7373: P_ERROR_MESSAGE VARCHAR2(50);
7374: l_check VARCHAR(1);

Line 7385: FROM PON_AUCTION_HEADERS_ALL

7381: BEGIN
7382:
7383: SELECT CLOSE_BIDDING_DATE, view_by_DATE, OPEN_BIDDING_DATE,auction_status,trading_partner_contact_id,trading_partner_id,security_level_code
7384: INTO l_CLOSE_BIDDING_DATE,l_view_by_DATE,l_OPEN_BIDDING_DATE,l_auction_status,l_auc_tpc_id,l_auc_tp_id,l_security_level_code
7385: FROM PON_AUCTION_HEADERS_ALL
7386: WHERE auction_header_id=p_auction_header_id
7387: AND auction_status = 'ACTIVE';
7388: EXCEPTION
7389: WHEN No_Data_Found THEN

Line 7421: FROM PON_AUCTION_HEADERS_ALL AH

7417: return false;
7418: END IF;
7419:
7420: SELECT COUNT(AUCTION_HEADER_ID) INTO DRAFT_AMENDMENT_COUNT
7421: FROM PON_AUCTION_HEADERS_ALL AH
7422: WHERE AH.AUCTION_HEADER_ID_ORIG_AMEND <> AH.AUCTION_HEADER_ID
7423: AND AH.AUCTION_HEADER_ID_ORIG_AMEND = (
7424: SELECT AUCTION_HEADER_ID_ORIG_AMEND
7425: FROM PON_AUCTION_HEADERS_ALL

Line 7425: FROM PON_AUCTION_HEADERS_ALL

7421: FROM PON_AUCTION_HEADERS_ALL AH
7422: WHERE AH.AUCTION_HEADER_ID_ORIG_AMEND <> AH.AUCTION_HEADER_ID
7423: AND AH.AUCTION_HEADER_ID_ORIG_AMEND = (
7424: SELECT AUCTION_HEADER_ID_ORIG_AMEND
7425: FROM PON_AUCTION_HEADERS_ALL
7426: WHERE AUCTION_HEADER_ID = p_auction_header_id)
7427: AND AH.AUCTION_STATUS = 'DRAFT';
7428:
7429: IF (DRAFT_AMENDMENT_COUNT >0) THEN

Line 7468: UPDATE PON_AUCTION_HEADERS_ALL paha

7464: PROCEDURE update_amendment_header(p_auction_header_id IN NUMBER)
7465: AS
7466:
7467: BEGIN
7468: UPDATE PON_AUCTION_HEADERS_ALL paha
7469: SET
7470: AUCTION_TITLE = Nvl(neg_header_record_data.auction_title,paha.auction_title) ,
7471: description = Nvl(neg_header_record_data.description,paha.description),
7472: GLOBAL_AGREEMENT_FLAG=Nvl(neg_header_record_data.GLOBAL_AGREEMENT_FLAG,paha.GLOBAL_AGREEMENT_FLAG),