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

Line 4: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';

1: PACKAGE BODY pon_auction_interface_pkg AS
2: /* $Header: PONAUCIB.pls 120.55.12020000.5 2013/02/09 06:02:15 hvutukur ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'PON_AUCTION_INTERFACE_PKG';
4: g_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE := 'NONE';
5: -- global variables added for header price break default project
6: g_price_break_type pon_auction_item_prices_all.price_break_type%type;
7: g_price_break_neg_flag pon_auction_item_prices_all.price_break_neg_flag%type;
8: /*

Line 65: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;

61: l_log_module VARCHAR2(100) := 'CREATE_DRAFT_NEGOTIATION';
62: v_debug_status VARCHAR2(100);
63: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
64: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
65: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
66: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
67: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
68: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
69: l_price_break_response pon_auction_headers_all.price_break_response%type;

Line 66: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;

62: v_debug_status VARCHAR2(100);
63: v_doctype_id pon_auc_doctypes.doctype_id%TYPE;
64: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
65: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
66: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
67: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
68: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
69: l_price_break_response pon_auction_headers_all.price_break_response%type;
70: l_style_name po_doc_style_headers.style_name%TYPE;

Line 68: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;

64: v_transaction_type pon_auc_doctypes.transaction_type%TYPE;
65: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
66: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
67: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
68: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
69: l_price_break_response pon_auction_headers_all.price_break_response%type;
70: l_style_name po_doc_style_headers.style_name%TYPE;
71: l_style_description po_doc_style_headers.style_description%TYPE;
72: l_style_type po_doc_style_headers.style_type%TYPE;

Line 69: l_price_break_response pon_auction_headers_all.price_break_response%type;

65: v_site_id pon_auction_headers_all.trading_partner_id%TYPE;
66: v_site_name pon_auction_headers_all.trading_partner_name%TYPE;
67: v_multi_org fnd_product_groups.multi_org_flag%TYPE := 'Y';
68: v_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
69: l_price_break_response pon_auction_headers_all.price_break_response%type;
70: l_style_name po_doc_style_headers.style_name%TYPE;
71: l_style_description po_doc_style_headers.style_description%TYPE;
72: l_style_type po_doc_style_headers.style_type%TYPE;
73: l_status po_doc_style_headers.status%TYPE;

Line 121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;

117: l_doc_exist VARCHAR2(1);
118: l_err_msg VARCHAR2(2000);
119: l_sol_type VARCHAR2(3);
120: clm_doc_number VARCHAR2(100);
121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;
122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;

Line 122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;

118: l_err_msg VARCHAR2(2000);
119: l_sol_type VARCHAR2(3);
120: clm_doc_number VARCHAR2(100);
121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;
122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;

Line 123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;

119: l_sol_type VARCHAR2(3);
120: clm_doc_number VARCHAR2(100);
121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;
122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
127: i_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;

Line 124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;

120: clm_doc_number VARCHAR2(100);
121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;
122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
127: i_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
128: BEGIN

Line 125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;

121: l_standard_form pon_auction_headers_all.standard_form%TYPE :=NULL;
122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
127: i_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
128: BEGIN
129: --CLM Bug : 10096343

Line 126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;

122: l_document_format pon_auction_headers_all.document_format%TYPE:=NULL;
123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
127: i_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
128: BEGIN
129: --CLM Bug : 10096343
130: g_progress_payment_type := 'NONE';

Line 127: i_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;

123: l_draft_locked pon_auction_headers_all.draft_locked%TYPE;
124: l_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
125: l_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
126: i_draft_locked_by pon_auction_headers_all.draft_locked_by%TYPE;
127: i_draft_locked_by_contact_id pon_auction_headers_all.draft_locked_by_contact_id%TYPE;
128: BEGIN
129: --CLM Bug : 10096343
130: g_progress_payment_type := 'NONE';
131: IF (P_DOCUMENT_TYPE NOT IN ('BUYER_AUCTION', 'REQUEST_FOR_QUOTE','SOLICITATION')) THEN

Line 183: FROM pon_auction_headers_all

179: draft_locked_by_contact_id
180: INTO l_draft_locked,
181: l_draft_locked_by,
182: l_draft_locked_by_contact_id
183: FROM pon_auction_headers_all
184: WHERE auction_header_id = p_document_number;
185: EXCEPTION
186: WHEN no_data_found THEN
187: P_RESULT := error;

Line 223: UPDATE PON_AUCTION_HEADERS_ALL

219:
220: logme(l_log_module, 'current user '||i_draft_locked_by|| 'user contact '||i_draft_locked_by_contact_id);
221: IF l_draft_locked_by <> i_draft_locked_by OR l_draft_locked_by_contact_id <> i_draft_locked_by_contact_id THEN
222: --Unlock the document if it locked by a different user.
223: UPDATE PON_AUCTION_HEADERS_ALL
224: SET DRAFT_LOCKED = 'N',
225: DRAFT_LOCKED_BY = NULL,
226: DRAFT_LOCKED_BY_CONTACT_ID = NULL,
227: DRAFT_LOCKED_DATE = NULL,

Line 239: UPDATE pon_auction_headers_all

235: logme(l_log_module, 'unlocked');
236: END IF;
237: END IF; -- l_draft_locked = 'Y' THEN
238:
239: UPDATE pon_auction_headers_all
240: SET AUCTION_ORIGINATION_CODE = 'REQUISITION', BUYER_ID = p_buyer_id -- bug 13640015
241: WHERE AUCTION_HEADER_ID = p_document_number; -- bug 13640015
242:
243: END IF;

Line 320: -- Insert a row into PON_AUCTION_HEADERS_ALL

316: FROM pon_auc_doctypes
317: WHERE internal_name = P_DOCUMENT_TYPE;
318: -- price break header setting
319: PON_AUCTION_PKG.get_default_hdr_pb_settings ( v_doctype_id, v_site_id, l_price_break_response);
320: -- Insert a row into PON_AUCTION_HEADERS_ALL
321: -- See NegotiationDoc.java for the majority of defaulting - setDefaults()
322: -- Get all the style related columns from PON_NEGOTIATION_STYLES table for the style id.
323: -- Populate all the style related columns in PON_AUCTION_HEADERS_ALL table.
324: -- This procedure is invoked from two flows.

Line 323: -- Populate all the style related columns in PON_AUCTION_HEADERS_ALL table.

319: PON_AUCTION_PKG.get_default_hdr_pb_settings ( v_doctype_id, v_site_id, l_price_break_response);
320: -- Insert a row into PON_AUCTION_HEADERS_ALL
321: -- See NegotiationDoc.java for the majority of defaulting - setDefaults()
322: -- Get all the style related columns from PON_NEGOTIATION_STYLES table for the style id.
323: -- Populate all the style related columns in PON_AUCTION_HEADERS_ALL table.
324: -- This procedure is invoked from two flows.
325: -- 1. HTML Autocreate : We select the syle id from the UI and the style id is passed as an arugment here.
326: -- 2. Forms based Autocreate : We will not have any option to select style from the forms and the style id wil be null here.
327: IF P_NEG_STYLE_ID IS NOT NULL THEN

Line 464: 'Inserting into pon_auction_headers_all');

460: l_standard_form :=NULL;
461: l_document_format:=NULL;
462: END;
463: logme('pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',
464: 'Inserting into pon_auction_headers_all');
465: v_debug_status := 'INSERT-PAH';
466: INSERT
467: INTO PON_AUCTION_HEADERS_ALL
468: (

Line 467: INTO PON_AUCTION_HEADERS_ALL

463: logme('pon.plsql.PON_auction_interface_pkg.Create_Draft_Negotiation',
464: 'Inserting into pon_auction_headers_all');
465: v_debug_status := 'INSERT-PAH';
466: INSERT
467: INTO PON_AUCTION_HEADERS_ALL
468: (
469: AUCTION_HEADER_ID,
470: DOCUMENT_NUMBER,
471: AUCTION_HEADER_ID_ORIG_AMEND,

Line 553: pon_auction_headers_all_s.nextval, -- AUCTION_HEADER_ID

549: FAIR_OPP_NOTICE_FLAG
550: )
551: VALUES
552: (
553: pon_auction_headers_all_s.nextval, -- AUCTION_HEADER_ID
554: pon_auction_headers_all_s.currval, -- DOCUMENT_NUMBER
555: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_AMEND,
556: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_ROUND,
557: 0, -- AMENDMENT_NUMBER

Line 554: pon_auction_headers_all_s.currval, -- DOCUMENT_NUMBER

550: )
551: VALUES
552: (
553: pon_auction_headers_all_s.nextval, -- AUCTION_HEADER_ID
554: pon_auction_headers_all_s.currval, -- DOCUMENT_NUMBER
555: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_AMEND,
556: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_ROUND,
557: 0, -- AMENDMENT_NUMBER
558: P_DOCUMENT_TITLE, -- AUCTION_TITLE

Line 555: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_AMEND,

551: VALUES
552: (
553: pon_auction_headers_all_s.nextval, -- AUCTION_HEADER_ID
554: pon_auction_headers_all_s.currval, -- DOCUMENT_NUMBER
555: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_AMEND,
556: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_ROUND,
557: 0, -- AMENDMENT_NUMBER
558: P_DOCUMENT_TITLE, -- AUCTION_TITLE
559: 'DRAFT', -- AUCTION_STATUS

Line 556: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_ROUND,

552: (
553: pon_auction_headers_all_s.nextval, -- AUCTION_HEADER_ID
554: pon_auction_headers_all_s.currval, -- DOCUMENT_NUMBER
555: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_AMEND,
556: pon_auction_headers_all_s.currval, -- AUCTION_HEADER_ID_ORIG_ROUND,
557: 0, -- AMENDMENT_NUMBER
558: P_DOCUMENT_TITLE, -- AUCTION_TITLE
559: 'DRAFT', -- AUCTION_STATUS
560: 'NO', -- AWARD_STATUS

Line 676: /* Bug 9645160 - updated clm_document_number back in PON_AUCTION_HEADERS_ALL table. */

672: P_RESULT := l_return_status;
673: P_ERROR_MESSAGE := 'Error in PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA';
674: RETURN;
675: END IF;
676: /* Bug 9645160 - updated clm_document_number back in PON_AUCTION_HEADERS_ALL table. */
677: UPDATE pon_auction_headers_all
678: SET DOCUMENT_NUMBER = clm_doc_number
679: WHERE AUCTION_HEADER_ID = p_document_number;
680: END IF;

Line 677: UPDATE pon_auction_headers_all

673: P_ERROR_MESSAGE := 'Error in PO_DOC_NUMBERING_PKG.DEFAULT_DOC_NUMBER_UDA';
674: RETURN;
675: END IF;
676: /* Bug 9645160 - updated clm_document_number back in PON_AUCTION_HEADERS_ALL table. */
677: UPDATE pon_auction_headers_all
678: SET DOCUMENT_NUMBER = clm_doc_number
679: WHERE AUCTION_HEADER_ID = p_document_number;
680: END IF;
681: -- price break line setting

Line 899: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;

895: v_debug_status VARCHAR2(100);
896: v_was_grouped VARCHAR2(1);
897: v_header_attach_count NUMBER;
898: v_item_attach_count NUMBER;
899: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
900: v_org_id pon_auction_headers_all.org_id%TYPE;
901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;

Line 900: v_org_id pon_auction_headers_all.org_id%TYPE;

896: v_was_grouped VARCHAR2(1);
897: v_header_attach_count NUMBER;
898: v_item_attach_count NUMBER;
899: v_site_id pon_auction_headers_all.trading_partner_id%TYPE :=NULL;
900: v_org_id pon_auction_headers_all.org_id%TYPE;
901: v_seq_num fnd_attached_documents.seq_num%TYPE;
902: v_price pon_auction_item_prices_all.current_price%TYPE;
903: v_category_name pon_auction_item_prices_all.category_name%TYPE;
904: v_ip_category_id pon_auction_item_prices_all.ip_category_id%TYPE;

Line 921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --

917: v_blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE;
918: v_blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE;
919: v_msg_count NUMBER; --
920: v_return_status VARCHAR2(1); --
921: v_doctype_id pon_auction_headers_all.doctype_id%TYPE; --
922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;
923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;
924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;
925: --CLM Bug : 10096343

Line 926: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;

922: need_by_dt pon_auction_item_prices_all.need_by_date%TYPE;
923: pop_start_dt pon_auction_item_prices_all.need_by_date%TYPE;
924: pop_end_dt pon_auction_item_prices_all.need_by_date%TYPE;
925: --CLM Bug : 10096343
926: l_progress_payment_type pon_auction_headers_all.progress_payment_type%TYPE;
927: l_comp_pricing_grp_id po_uda_ag_template_usages.ATTRIBUTE_GROUP_ID%TYPE; -- bug 13571062
928: BEGIN
929: logme(l_log_module, 'Entered add_negotiation_line');
930: logme(l_log_module, 'P_DOCUMENT_NUMBER '||P_DOCUMENT_NUMBER);

Line 1011: FROM pon_auction_headers_all

1007: IF P_ORIGINATION_CODE = 'REQUISITION' AND P_CLM_COST_CONSTRAINT IN ('NC','NSP') THEN
1008: BEGIN
1009: SELECT progress_payment_type
1010: INTO l_progress_payment_type
1011: FROM pon_auction_headers_all
1012: WHERE auction_header_id=P_DOCUMENT_NUMBER;
1013: END;
1014: END IF;
1015: -- Amount based line?

Line 1120: FROM pon_auction_headers_all

1116: contract_type
1117: INTO v_org_id,
1118: v_doctype_id,
1119: v_contract_type
1120: FROM pon_auction_headers_all
1121: WHERE auction_header_id = P_DOCUMENT_NUMBER
1122: AND NVL(org_id, -9999) = NVL(P_ORG_ID, -9999);
1123: EXCEPTION
1124: WHEN no_data_found THEN

Line 1192: UPDATE pon_auction_headers_all

1188: -- in which case we want to update the global agreement flag at the
1189: -- header level, since temp labor line types can exist only on
1190: -- global agreements
1191: IF (v_purchase_basis = 'TEMP LABOR' AND v_contract_type = 'BLANKET' ) THEN
1192: UPDATE pon_auction_headers_all
1193: SET global_agreement_flag = 'Y'
1194: WHERE auction_header_id = p_document_number;
1195: END IF;
1196: -- Get the shopping category (ip_category_id) when creating a blanket line

Line 1700: UPDATE PON_AUCTION_HEADERS_ALL

1696: -- the newly added line. So this value can be used for the fields
1697: -- number_of_lines and last_line_number.
1698: -- The number of lines will be equal to the line number of the new line added
1699: -- The last line number will be equal to the line number of the newly added line
1700: UPDATE PON_AUCTION_HEADERS_ALL
1701: SET NUMBER_OF_LINES = P_LINE_NUMBER,
1702: LAST_LINE_NUMBER = P_LINE_NUMBER
1703: WHERE AUCTION_HEADER_ID = P_DOCUMENT_NUMBER;
1704: END IF;

Line 1952: v_contract_type pon_auction_headers_all.contract_type%TYPE;

1948: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1949: X_MSG_COUNT OUT NOCOPY NUMBER,
1950: X_MSG_DATA OUT NOCOPY VARCHAR2)
1951: IS
1952: v_contract_type pon_auction_headers_all.contract_type%TYPE;
1953: v_buyer_id NUMBER;
1954: v_ip_attr_default_option VARCHAR2(10);
1955: v_default_attr_group pon_auction_attributes.attr_group%TYPE;
1956: v_attr_group_name fnd_lookup_values.meaning%TYPE;

Line 1988: FROM pon_auction_headers_all

1984: SELECT contract_type,
1985: created_by
1986: INTO v_contract_type,
1987: v_buyer_id
1988: FROM pon_auction_headers_all
1989: WHERE auction_header_id = p_document_number;
1990:
1991: v_ip_attr_default_option := fnd_profile.value('PON_IP_ATTR_DEFAULT_OPTION');
1992: IF (v_contract_type <> 'BLANKET' OR v_ip_attr_default_option IS NULL OR

Line 2006: FROM pon_auction_headers_all

2002: WHERE ppp.app_short_name = 'PON'
2003: AND ppp.preference_name = 'LINE_ATTR_DEFAULT_GROUP'
2004: AND ppp.party_id =
2005: (SELECT trading_partner_id
2006: FROM pon_auction_headers_all
2007: WHERE auction_header_id = p_document_number
2008: )
2009: AND flv.lookup_type = 'PON_LINE_ATTRIBUTE_GROUPS'
2010: AND NVL(ppp.preference_value,'GENERAL') = flv.lookup_code

Line 2357: pon_auction_headers_all ah

2353: INTO P_OWNER_NAME,
2354: v_buyer_name
2355: FROM fnd_user u1,
2356: fnd_user u2,
2357: pon_auction_headers_all ah
2358: WHERE ah.auction_header_id = P_DOCUMENT_NUMBER
2359: AND ah.trading_partner_contact_id = u1.person_party_id(+)
2360: AND ah.buyer_id = u2.user_id(+);
2361: EXCEPTION

Line 2419: pon_auction_headers_all ah

2415: ah.document_number
2416: INTO P_DOCUMENT_ID,
2417: P_DOCUMENT_NUMBER
2418: FROM pon_bid_headers bh,
2419: pon_auction_headers_all ah
2420: WHERE bh.po_header_id = P_PO_HEADER_ID
2421: AND bh.auction_header_id = ah.auction_header_id;
2422: EXCEPTION
2423: WHEN no_data_found THEN

Line 2476: l_fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%TYPE;

2472: P_BUYER_ID IN NUMBER)
2473: IS
2474: l_api_version CONSTANT NUMBER := 1.0;
2475: l_api_name CONSTANT VARCHAR2(50):= 'add_negotiation_invitees';
2476: l_fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%TYPE;
2477: l_umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE;
2478: l_max_sequence NUMBER := 0;
2479: BEGIN
2480: -- Check for call compatibility.

Line 2477: l_umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE;

2473: IS
2474: l_api_version CONSTANT NUMBER := 1.0;
2475: l_api_name CONSTANT VARCHAR2(50):= 'add_negotiation_invitees';
2476: l_fair_opp_notice_flag pon_auction_headers_all.fair_opp_notice_flag%TYPE;
2477: l_umbrella_program_id pon_auction_headers_all.umbrella_program_id%TYPE;
2478: l_max_sequence NUMBER := 0;
2479: BEGIN
2480: -- Check for call compatibility.
2481: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2500: FROM pon_auction_headers_all

2496: SELECT NVL(fair_opp_notice_flag, 'N'),
2497: umbrella_program_id
2498: INTO l_fair_opp_notice_flag,
2499: l_umbrella_program_id
2500: FROM pon_auction_headers_all
2501: WHERE auction_header_id = p_document_number;
2502: -- Do not add suppliers if the document is and FON with umbrella program not NULL
2503: IF l_fair_opp_notice_flag = 'Y' AND l_umbrella_program_id IS NOT NULL THEN
2504: RETURN;

Line 2561: pon_auction_headers_all ponah,

2557: NVL(prl.vendor_site_id, -1) vendor_site_id,
2558: NVL(ps.vendor_site_code, -1) vendor_site_code
2559: FROM po_requisition_lines_all prl,
2560: pon_backing_requisitions ponbr,
2561: pon_auction_headers_all ponah,
2562: po_vendors pv,
2563: po_vendor_sites_all ps
2564: WHERE ponah.auction_header_id = p_document_number
2565: AND ponbr.auction_header_id = ponah.auction_header_id