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

Line 9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;

5: g_debug_mode CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.bidDefaultingPkg.';
7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
13: g_rtng_negotiable PON_AUCTION_HEADERS_ALL.RETAINAGE_NEGOTIABLE_FLAG%TYPE;

Line 10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;

6: g_module_prefix CONSTANT VARCHAR2(35) := 'pon.plsql.bidDefaultingPkg.';
7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
13: g_rtng_negotiable PON_AUCTION_HEADERS_ALL.RETAINAGE_NEGOTIABLE_FLAG%TYPE;
14: g_copy_only_from_auc VARCHAR2(1);

Line 11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;

7: g_bid_rate PON_BID_HEADERS.RATE%TYPE;
8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
13: g_rtng_negotiable PON_AUCTION_HEADERS_ALL.RETAINAGE_NEGOTIABLE_FLAG%TYPE;
14: g_copy_only_from_auc VARCHAR2(1);
15:

Line 12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;

8: g_curr_prec FND_CURRENCIES.PRECISION%TYPE;
9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
13: g_rtng_negotiable PON_AUCTION_HEADERS_ALL.RETAINAGE_NEGOTIABLE_FLAG%TYPE;
14: g_copy_only_from_auc VARCHAR2(1);
15:
16:

Line 13: g_rtng_negotiable PON_AUCTION_HEADERS_ALL.RETAINAGE_NEGOTIABLE_FLAG%TYPE;

9: g_advance_negotiable PON_AUCTION_HEADERS_ALL.ADVANCE_NEGOTIABLE_FLAG%TYPE;
10: g_recoupment_negotiable PON_AUCTION_HEADERS_ALL.RECOUPMENT_NEGOTIABLE_FLAG%TYPE;
11: g_prog_pymt_negotiable PON_AUCTION_HEADERS_ALL.PROGRESS_PYMT_NEGOTIABLE_FLAG%TYPE;
12: g_max_rtng_negotiable PON_AUCTION_HEADERS_ALL.MAX_RETAINAGE_NEGOTIABLE_FLAG%TYPE;
13: g_rtng_negotiable PON_AUCTION_HEADERS_ALL.RETAINAGE_NEGOTIABLE_FLAG%TYPE;
14: g_copy_only_from_auc VARCHAR2(1);
15:
16:
17: -- ======================================================================

Line 51: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

47: -- COMMENT: populate line and header display_price_factors_flag
48: -- ======================================================================
49: PROCEDURE populate_display_pf_flag
50: (
51: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_bid_number IN pon_bid_headers.bid_number%TYPE,
53: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

Line 58: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;

54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2
57: ) IS
58: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
59: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
60: l_has_pfs pon_auction_headers_all.has_price_elements%TYPE;
61: BEGIN
62:

Line 59: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;

55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2
57: ) IS
58: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
59: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
60: l_has_pfs pon_auction_headers_all.has_price_elements%TYPE;
61: BEGIN
62:
63:

Line 60: l_has_pfs pon_auction_headers_all.has_price_elements%TYPE;

56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2
57: ) IS
58: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
59: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
60: l_has_pfs pon_auction_headers_all.has_price_elements%TYPE;
61: BEGIN
62:
63:
64: -- Get the price factor type info

Line 71: FROM pon_auction_headers_all ah

67: ah.has_price_elements
68: INTO l_supplier_view,
69: l_pf_type,
70: l_has_pfs
71: FROM pon_auction_headers_all ah
72: WHERE ah.auction_header_id = p_auc_header_id;
73:
74: -- blindly set to N if pf type is NONE, there are no price factors
75: -- or the view is untransformed (BUYER pf only)

Line 163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,

159: (
160: p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
161: p_bid_number IN pon_bid_headers.bid_number%TYPE,
162: p_userid IN pon_bid_headers.created_by%TYPE,
163: p_auctpid IN pon_auction_headers_all.trading_partner_id%TYPE,
164: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
165: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
166: p_has_pe_flag IN VARCHAR2,
167: p_blanket IN VARCHAR2,

Line 873: FROM pon_auction_headers_all ah

869:
870: -- Determine the maximum line number for the negotiation
871: SELECT ah.max_internal_line_num
872: INTO l_max_line_number
873: FROM pon_auction_headers_all ah
874: WHERE ah.auction_header_id = p_auc_header_id;
875:
876: -- Define the initial batch range (line numbers are indexed from 1)
877: l_batch_start := 1;

Line 965: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

961: -- COMMENT: inserts a bid header for the new bid. Also generates the bid number
962: -- ======================================================================
963: PROCEDURE insert_into_bid_header
964: (
965: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
966: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
967: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
968: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
969: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 987: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;

983: p_prev_bid_disq IN VARCHAR2,
984: p_prev_bid_wthd IN VARCHAR2,
985: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
986: ) IS
987: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
988: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
989: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
990: ----------------------------------------------------------------
991: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;

Line 988: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;

984: p_prev_bid_wthd IN VARCHAR2,
985: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
986: ) IS
987: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
988: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
989: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
990: ----------------------------------------------------------------
991: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
992: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

Line 991: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;

987: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
988: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
989: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
990: ----------------------------------------------------------------
991: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
992: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
993: ----------------------------------------------------------------
994: BEGIN
995:

Line 992: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

988: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
989: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
990: ----------------------------------------------------------------
991: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
992: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
993: ----------------------------------------------------------------
994: BEGIN
995:
996: IF p_source_bid_num IS NOT NULL AND p_source_bid_num <> 0 THEN

Line 1011: FROM PON_AUCTION_HEADERS_ALL pah,

1007: -------------------------------------------------------
1008: , l_two_part_flag
1009: , l_technical_evaluation_status
1010: -------------------------------------------------------
1011: FROM PON_AUCTION_HEADERS_ALL pah,
1012: PON_BID_HEADERS pbh
1013: WHERE pah.auction_header_id = pbh.auction_header_id
1014: AND pbh.bid_number = p_source_bid_num;
1015: END IF;

Line 1136: Decode((SELECT TWO_PART_FLAG FROM pon_auction_headers_all WHERE AUCTION_HEADER_ID = bh.AUCTION_HEADER_ID),'Y',

1132: ah.note_to_bidders, -- NOTE_TO_SUPPLIER
1133: decode(p_buyer_user, 'Y', p_auctpid, null), -- SURROG_BID_CREATED_TP_ID
1134: decode(p_buyer_user, 'Y', p_auctpcid, null), -- SURROG_BID_CREATED_CONTACT_ID
1135: decode(p_buyer_user, 'Y',
1136: Decode((SELECT TWO_PART_FLAG FROM pon_auction_headers_all WHERE AUCTION_HEADER_ID = bh.AUCTION_HEADER_ID),'Y',
1137: Decode(bh.SUBMIT_STAGE,'COMMERCIAL',bh.surrog_bid_receipt_date, null),NULL),NULL),
1138: --decode(p_buyer_user, 'Y', bh.surrog_bid_receipt_date, null), -- SURROG_BID_RECEIPT_DATE
1139: decode(p_buyer_user, 'Y', sysdate, null), -- SURROG_BID_ONLINE_ENTRY_DATE
1140: p_buyer_user, -- SURROG_BID_FLAG

Line 1162: FROM pon_auction_headers_all ah, pon_bid_headers bh

1158: ---------------- Supplier Management: Supplier Evaluation ----------------
1159: ,decode(p_eval_flag, 'Y', p_evaluator_id, null) -- EVALUATOR_ID
1160: ,p_eval_flag -- EVALUATION_FLAG
1161: --------------------------------------------------------------------------
1162: FROM pon_auction_headers_all ah, pon_bid_headers bh
1163: WHERE ah.auction_header_id = p_auc_header_id
1164: AND bh.bid_number (+) = p_source_bid_num
1165: AND ah.auction_header_id >= bh.auction_header_id (+));
1166:

Line 1185: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1181: -- COMMENT: inserts lines for the new bid, defualting as necessary
1182: -- ======================================================================
1183: PROCEDURE insert_into_bid_items
1184: (
1185: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1186: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1187: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1188: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1189: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 1198: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1196: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1197: ) IS
1198: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1199: l_blanket VARCHAR2(1);
1200: l_full_qty VARCHAR2(1);
1201: l_enforce_prevrnd_price_flag VARCHAR2(1);
1202: l_prev_rnd_active_bid_number NUMBER;

Line 1206: l_is_paused pon_auction_headers_all.is_paused%TYPE;

1202: l_prev_rnd_active_bid_number NUMBER;
1203: l_auction_header_id_prev_round NUMBER;
1204: l_unit_price NUMBER;
1205: l_quantity NUMBER;
1206: l_is_paused pon_auction_headers_all.is_paused%TYPE;
1207: l_last_pause_date pon_auction_headers_all.last_pause_date%TYPE;
1208: l_closed_compare_date DATE;
1209: /***********************************************************
1210: * CLM - Complex Pricing project Changes Start.

Line 1207: l_last_pause_date pon_auction_headers_all.last_pause_date%TYPE;

1203: l_auction_header_id_prev_round NUMBER;
1204: l_unit_price NUMBER;
1205: l_quantity NUMBER;
1206: l_is_paused pon_auction_headers_all.is_paused%TYPE;
1207: l_last_pause_date pon_auction_headers_all.last_pause_date%TYPE;
1208: l_closed_compare_date DATE;
1209: /***********************************************************
1210: * CLM - Complex Pricing project Changes Start.
1211: *********************************************************/

Line 1215: l_doctype_id pon_auction_headers_all.DOCTYPE_ID%TYPE;

1211: *********************************************************/
1212: l_return_status VARCHAR2(100);
1213: l_err_msg VARCHAR2(100);
1214: l_uda_template_id NUMBER;
1215: l_doctype_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
1216: /***********************************************************
1217: * CLM - Complex Pricing project Changes End.
1218: *********************************************************/
1219: l_is_federal NUMBER; --ELIN project

Line 1220: l_org_id pon_auction_headers_all.org_id%TYPE; --ELINs project

1216: /***********************************************************
1217: * CLM - Complex Pricing project Changes End.
1218: *********************************************************/
1219: l_is_federal NUMBER; --ELIN project
1220: l_org_id pon_auction_headers_all.org_id%TYPE; --ELINs project
1221:
1222: BEGIN
1223:
1224:

Line 1234: from pon_auction_headers_all

1230:
1231: --ELINs project : Get org_id
1232: select doctype_id, org_id
1233: into l_doctype_id, l_org_id
1234: from pon_auction_headers_all
1235: where auction_header_id = p_auc_header_id;
1236:
1237: --ELIN project
1238: l_is_federal := PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => l_doctype_id);

Line 1268: FROM pon_auction_headers_all ah

1264: l_enforce_prevrnd_price_flag,
1265: l_auction_header_id_prev_round,
1266: l_is_paused,
1267: l_last_pause_date
1268: FROM pon_auction_headers_all ah
1269: WHERE ah.auction_header_id = p_auc_header_id;
1270:
1271: INSERT INTO pon_bid_item_prices
1272: (

Line 1710: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1706: -- COMMENT: inserts header attributes for the new bid, defualting as necessary
1707: -- ======================================================================
1708: PROCEDURE insert_into_header_attributes
1709: (
1710: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1711: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1712: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1713: p_userid IN pon_bid_headers.created_by%TYPE,
1714: ----------- Supplier Management: Supplier Evaluation -----------

Line 1721: l_has_scoring_teams_flag pon_auction_headers_all.has_scoring_teams_flag%TYPE;

1717: ----------------------------------------------------------------
1718: p_rebid_flag IN VARCHAR2
1719: ) IS
1720:
1721: l_has_scoring_teams_flag pon_auction_headers_all.has_scoring_teams_flag%TYPE;
1722:
1723: BEGIN
1724:
1725: -- Bug 5046909 - Determine if team scoring is enabled

Line 1738: FROM pon_auction_headers_all

1734:
1735:
1736: SELECT has_scoring_teams_flag
1737: INTO l_has_scoring_teams_flag
1738: FROM pon_auction_headers_all
1739: WHERE auction_header_id = p_auc_header_id;
1740:
1741: -- Insert header attributes
1742: INSERT INTO pon_bid_attribute_values

Line 1840: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1836: -- COMMENT: inserts line attributes for the new bid, defualting as necessary
1837: -- ======================================================================
1838: PROCEDURE insert_into_line_attributes
1839: (
1840: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1841: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1842: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1843: p_userid IN pon_bid_headers.created_by%TYPE,
1844: p_rebid_flag IN VARCHAR2,

Line 1921: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1917: -- COMMENT: insert price factors for the new bid, defualting as necessary
1918: -- ======================================================================
1919: PROCEDURE insert_into_price_factors
1920: (
1921: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1922: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1923: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,

Line 1933: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;

1929: ) IS
1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;
1932: l_rate pon_bid_headers.rate%TYPE;
1933: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1934: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1935: BEGIN
1936:
1937: -- Get bid currency precisions and rate

Line 1934: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;

1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;
1932: l_rate pon_bid_headers.rate%TYPE;
1933: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1934: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1935: BEGIN
1936:
1937: -- Get bid currency precisions and rate
1938: SELECT bh.number_price_decimals,

Line 1952: FROM pon_auction_headers_all ah

1948:
1949: -- Get the price factor type info
1950: SELECT ah.supplier_view_type, ah.pf_type_allowed
1951: INTO l_supplier_view, l_pf_type
1952: FROM pon_auction_headers_all ah
1953: WHERE ah.auction_header_id = p_auc_header_id;
1954:
1955: -- copy over all supplier price factors, including line price
1956: -- do not copy line price pf for lines with display_price_factors_flag = N

Line 2083: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2079: -- COMMENT: inserts price tiers for the new bid, defualting as necessary
2080: -- ======================================================================
2081: PROCEDURE insert_into_price_tiers
2082: (
2083: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2084: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2085: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2086: p_userid IN pon_bid_headers.created_by%TYPE,
2087: p_rebid_flag IN VARCHAR2,

Line 2258: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2254: -- COMMENT: inserts price differentials for the new bid, defualting as necessary
2255: -- ======================================================================
2256: PROCEDURE insert_into_price_diff
2257: (
2258: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2259: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2260: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2261: p_userid IN pon_bid_headers.created_by%TYPE,
2262: p_rebid_flag IN VARCHAR2,

Line 2369: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2365: -- ======================================================================
2366: -- Create and default payments
2367: PROCEDURE insert_into_payments
2368: (
2369: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2370: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2371: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2372: p_copy_only_from_auc IN VARCHAR2,
2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,

Line 2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,

2369: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2370: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2371: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2372: p_copy_only_from_auc IN VARCHAR2,
2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2374: p_userid IN pon_bid_headers.created_by%TYPE,
2375: p_rebid_flag IN VARCHAR2,
2376: p_new_round_or_amended IN VARCHAR2,
2377: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 2736: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2732: -- COMMENT: populates has_bid_flag - used when defualting from pre-release 12 draft
2733: -- ======================================================================
2734: PROCEDURE populate_has_bid_flag
2735: (
2736: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2737: p_bid_number IN pon_bid_headers.bid_number%TYPE
2738: ) IS
2739: l_full_qty_reqd VARCHAR2(1);
2740: BEGIN

Line 2745: FROM pon_auction_headers_all ah

2741:
2742: -- Determine if the auction is full quantity required
2743: SELECT decode(ah.full_quantity_bid_code, 'FULL_QTY_BIDS_REQD', 'Y', 'N')
2744: INTO l_full_qty_reqd
2745: FROM pon_auction_headers_all ah
2746: WHERE ah.auction_header_id = p_auc_header_id;
2747:
2748: -- First set has_bid_flag to N
2749: UPDATE pon_bid_item_prices bl

Line 2850: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2846: -- side tables and copies attachments
2847: -- ======================================================================
2848: PROCEDURE create_new_draft_bid
2849: (
2850: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2851: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2852: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2853: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2854: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 2875: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;

2871: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
2872: x_return_status OUT NOCOPY NUMBER,
2873: x_return_code OUT NOCOPY VARCHAR2
2874: ) IS
2875: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
2876: l_restricted_flag VARCHAR2(1);
2877: l_rel12_draft VARCHAR2(1);
2878: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2879: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

Line 2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;

2881: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2882: l_batch_start pon_bid_item_prices.line_number%TYPE;
2883: l_batch_end pon_bid_item_prices.line_number%TYPE;
2884: l_skip_pf_for_batch VARCHAR2(1);
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;

Line 2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;

2882: l_batch_start pon_bid_item_prices.line_number%TYPE;
2883: l_batch_end pon_bid_item_prices.line_number%TYPE;
2884: l_skip_pf_for_batch VARCHAR2(1);
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

Line 2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;

2883: l_batch_end pon_bid_item_prices.line_number%TYPE;
2884: l_skip_pf_for_batch VARCHAR2(1);
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2891: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

Line 2891: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2888: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2889: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2890: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2891: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2892:
2893:
2894: -- Two-part RFQ related variables
2895: l_is_new_round VARCHAR2(1) := 'N'; -- to store Y for new rounds (default N)

Line 2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD

2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;
2915: l_precision PON_BID_HEADERS.NUMBER_PRICE_DECIMALS%TYPE;
2916:
2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2919:
2920: l_unit pon_pf_supplier_formula.unit_price%TYPE;
2921: l_amount pon_pf_supplier_formula.fixed_amount%TYPE;

Line 2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;

2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;
2915: l_precision PON_BID_HEADERS.NUMBER_PRICE_DECIMALS%TYPE;
2916:
2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2919:
2920: l_unit pon_pf_supplier_formula.unit_price%TYPE;
2921: l_amount pon_pf_supplier_formula.fixed_amount%TYPE;
2922: l_percentage pon_pf_supplier_formula.percentage%TYPE;

Line 2950: l_doctype_id pon_auction_headers_all.DOCTYPE_ID%TYPE;

2946: AND LINE_NUMBER = v_line_number
2947: AND PF_TYPE <> 'BUYER';
2948:
2949: /* */
2950: l_doctype_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
2951: l_msg_count NUMBER;
2952: l_msg_data VARCHAR2(32767);
2953: l_uda_template_id pon_bid_item_prices.UDA_TEMPLATE_ID%TYPE;
2954: l_is_uda_enabled NUMBER;

Line 3026: (select nvl(two_part_flag,'N') from pon_auction_headers_all

3022:
3023: -- get value of two-part flags for current and prev rounds
3024: select decode(pah.auction_header_id_prev_round, null, 'N', 'Y'),
3025: nvl(pah.two_part_flag, 'N'),
3026: (select nvl(two_part_flag,'N') from pon_auction_headers_all
3027: where auction_header_id = pah.auction_header_id_prev_round)
3028: into l_is_new_round, l_curr_two_part, l_prev_two_part
3029: from pon_auction_headers_all pah
3030: where auction_header_id = p_auc_header_id;

Line 3029: from pon_auction_headers_all pah

3025: nvl(pah.two_part_flag, 'N'),
3026: (select nvl(two_part_flag,'N') from pon_auction_headers_all
3027: where auction_header_id = pah.auction_header_id_prev_round)
3028: into l_is_new_round, l_curr_two_part, l_prev_two_part
3029: from pon_auction_headers_all pah
3030: where auction_header_id = p_auc_header_id;
3031:
3032: log_message(l_module, 'Two-Part related variables: l_is_new_round: ' || l_is_new_round || '; l_curr_two_part: '||l_curr_two_part||'; l_prev_two_part: ' || l_prev_two_part);
3033:

Line 3099: FROM pon_auction_headers_all ah where ah.auction_header_id=p_auc_header_id;

3095: nvl(ADVANCE_NEGOTIABLE_FLAG,'N'),nvl(RECOUPMENT_NEGOTIABLE_FLAG,'N'),nvl(PROGRESS_PYMT_NEGOTIABLE_FLAG,'N'),
3096: nvl(MAX_RETAINAGE_NEGOTIABLE_FLAG,'N'),nvl(RETAINAGE_NEGOTIABLE_FLAG,'N')
3097: into l_supplier_flag, l_payment_type, l_contract_type,
3098: g_advance_negotiable,g_recoupment_negotiable,g_prog_pymt_negotiable,g_max_rtng_negotiable,g_rtng_negotiable
3099: FROM pon_auction_headers_all ah where ah.auction_header_id=p_auc_header_id;
3100: IF (g_debug_mode = 'Y') THEN
3101: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3102: FND_LOG.string(log_level => FND_LOG.level_statement,
3103: module => g_module_prefix || l_module,

Line 3137: FROM pon_auction_headers_all oldah

3133: -- then if previous neg had SUPPLIER_ENTERABLE_PYMT_FLAG as Y then
3134: -- we need to default payments from neg and not from bid.
3135: select decode(oldah.SUPPLIER_ENTERABLE_PYMT_FLAG, 'Y','Y', 'N')
3136: into g_copy_only_from_auc
3137: FROM pon_auction_headers_all oldah
3138: WHERE oldah.auction_header_id = l_source_header_id;
3139:
3140: IF (g_debug_mode = 'Y') THEN
3141: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 3162: from pon_auction_headers_all

3158: /* If UDA is enabled Copy UDA's */
3159: BEGIN
3160: select doctype_id
3161: into l_doctype_id
3162: from pon_auction_headers_all
3163: where auction_header_id = p_auc_header_id;
3164:
3165: l_is_uda_enabled := PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id);
3166: IF l_is_uda_enabled = 1 THEN

Line 3184: FROM pon_auction_headers_all ah

3180:
3181: -- Determine the maximum line number for the negotiation
3182: SELECT ah.max_internal_line_num ,ah.price_tiers_indicator, Nvl(ALLOW_UNSOL_OFFER_LINES,'N') --Unsolicited Lines Project
3183: INTO l_max_line_number,l_price_tiers_indicator,l_allow_unsol_lines --Unsolicited Lines Project
3184: FROM pon_auction_headers_all ah
3185: WHERE ah.auction_header_id = p_auc_header_id;
3186:
3187: -- Define the initial range (line numbers are indexed from 1)
3188: l_batch_start := 1;

Line 3345: FROM PON_AUCTION_HEADERS_ALL

3341: AND BID_STATUS = 'DRAFT';
3342:
3343: SELECT decode(full_quantity_bid_code, 'FULL_QTY_BIDS_REQD', 'Y', 'N'), supplier_view_type
3344: INTO l_full_quan_req, l_supplier_view
3345: FROM PON_AUCTION_HEADERS_ALL
3346: WHERE AUCTION_HEADER_ID = p_auc_header_id;
3347:
3348: --Loop through the bid lines and re calculate the price based on current price factors
3349: FOR bid_values_rec IN bid_values

Line 3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

3619: x_rebid_flag OUT NOCOPY VARCHAR2
3620: ) IS
3621: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3622:
3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3624: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3625: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3626: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3627: l_userid pon_bid_headers.created_by%TYPE;

Line 3624: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

3620: ) IS
3621: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3622:
3623: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3624: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3625: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3626: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3627: l_userid pon_bid_headers.created_by%TYPE;
3628: l_vensid pon_bid_headers.vendor_site_id%TYPE;

Line 3668: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu

3664: l_userid,
3665: l_rate,
3666: l_price_prec,
3667: l_curr_prec
3668: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu
3669: WHERE bh.bid_number = p_bid_number
3670: AND ah.auction_header_id = bh.auction_header_id
3671: AND cu.currency_code = bh.bid_currency_code;
3672:

Line 3719: FROM pon_auction_headers_all ah

3715:
3716: -- Determine the maximum line number for the negotiation
3717: SELECT ah.max_internal_line_num
3718: INTO l_max_line_number
3719: FROM pon_auction_headers_all ah
3720: WHERE ah.auction_header_id = l_auc_header_id;
3721:
3722: -- Define the initial range (line numbers are indexed from 1)
3723: l_batch_start := 1;

Line 3865: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

3861: -- COMMENT: Determines if all amendments on the current round have been acknowledged
3862: -- ======================================================================
3863: PROCEDURE check_amendments_acked
3864: (
3865: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3866: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
3867: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3868: x_return_status OUT NOCOPY NUMBER,
3869: x_return_code OUT NOCOPY VARCHAR2

Line 3866: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

3862: -- ======================================================================
3863: PROCEDURE check_amendments_acked
3864: (
3865: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3866: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
3867: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3868: x_return_status OUT NOCOPY NUMBER,
3869: x_return_code OUT NOCOPY VARCHAR2
3870: ) IS

Line 3867: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,

3863: PROCEDURE check_amendments_acked
3864: (
3865: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3866: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
3867: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3868: x_return_status OUT NOCOPY NUMBER,
3869: x_return_code OUT NOCOPY VARCHAR2
3870: ) IS
3871: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%TYPE;

Line 3871: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%TYPE;

3867: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3868: x_return_status OUT NOCOPY NUMBER,
3869: x_return_code OUT NOCOPY VARCHAR2
3870: ) IS
3871: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%TYPE;
3872: l_amend_not_acked VARCHAR2(1);
3873: BEGIN
3874:
3875: -- Get the original amendments auction header id

Line 3878: FROM pon_auction_headers_all ah

3874:
3875: -- Get the original amendments auction header id
3876: SELECT ah.auction_header_id_orig_amend
3877: INTO l_orig_amend_id
3878: FROM pon_auction_headers_all ah
3879: WHERE ah.auction_header_id = p_auc_header_id;
3880:
3881: -- There must be as many acknowledgements as amendments
3882: SELECT decode(count(rownum), 0, 'N', 'Y')

Line 3884: FROM pon_auction_headers_all ah, pon_acknowledgements ac

3880:
3881: -- There must be as many acknowledgements as amendments
3882: SELECT decode(count(rownum), 0, 'N', 'Y')
3883: INTO l_amend_not_acked
3884: FROM pon_auction_headers_all ah, pon_acknowledgements ac
3885: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
3886: AND ah.auction_status IN ('AMENDED', 'ACTIVE')
3887: -- ignore the original amendment
3888: AND ah.amendment_number > 0

Line 3989: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

3985: -- be completed at this time.
3986: -- ======================================================================
3987: PROCEDURE is_bidding_allowed
3988: (
3989: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3990: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3991: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3992: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3993: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 4005: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;

4001: x_return_code OUT NOCOPY VARCHAR2
4002: ) IS
4003: l_current_date TIMESTAMP;
4004: l_bid_number NUMBER;
4005: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;

Line 4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;

4002: ) IS
4003: l_current_date TIMESTAMP;
4004: l_bid_number NUMBER;
4005: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;
4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;

Line 4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;

4003: l_current_date TIMESTAMP;
4004: l_bid_number NUMBER;
4005: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;
4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
4011: l_invited_flag VARCHAR2(1);

Line 4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;

4004: l_bid_number NUMBER;
4005: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;
4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
4011: l_invited_flag VARCHAR2(1);
4012: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;

Line 4009: l_award_status pon_auction_headers_all.award_status%TYPE;

4005: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;
4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
4011: l_invited_flag VARCHAR2(1);
4012: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;
4013: l_has_draft_flag VARCHAR2(1);

Line 4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;

4006: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
4007: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;
4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
4011: l_invited_flag VARCHAR2(1);
4012: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;
4013: l_has_draft_flag VARCHAR2(1);
4014: l_has_bid_flag VARCHAR2(1);

Line 4012: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;

4008: l_auction_status pon_auction_headers_all.auction_status%TYPE;
4009: l_award_status pon_auction_headers_all.award_status%TYPE;
4010: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
4011: l_invited_flag VARCHAR2(1);
4012: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;
4013: l_has_draft_flag VARCHAR2(1);
4014: l_has_bid_flag VARCHAR2(1);
4015: l_has_surrog_flag VARCHAR2(1);
4016: l_auction_paused VARCHAR2(1);

Line 4017: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

4013: l_has_draft_flag VARCHAR2(1);
4014: l_has_bid_flag VARCHAR2(1);
4015: l_has_surrog_flag VARCHAR2(1);
4016: l_auction_paused VARCHAR2(1);
4017: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
4018: l_supp_end_date TIMESTAMP;
4019: l_eval_flag pon_bid_headers.evaluation_flag%TYPE := nvl(p_eval_flag,'N');
4020:
4021: BEGIN

Line 4060: FROM pon_auction_headers_all ah

4056: l_bid_list_type,
4057: l_bid_freq_code,
4058: l_orig_amend_id,
4059: l_auction_paused
4060: FROM pon_auction_headers_all ah
4061: WHERE auction_header_id = p_auc_header_id;
4062:
4063: EXCEPTION
4064: WHEN NO_DATA_FOUND THEN

Line 4322: FROM pon_bid_headers bh, pon_auction_headers_all ah

4318: -- Check if a buyer/supplier has already placed a bid on the round
4319: -- I.e. check for surrog bid if supplier, or a supplier bid if buyer
4320: SELECT decode(count(bh.auction_header_id), 0, 'N', 'Y')
4321: INTO l_has_surrog_flag
4322: FROM pon_bid_headers bh, pon_auction_headers_all ah
4323: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
4324: AND bh.auction_header_id = ah.auction_header_id
4325: AND bh.trading_partner_id = p_tpid
4326: AND bh.trading_partner_contact_id = p_tpcid

Line 4376: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

4372: -- Also checks if another user has a draft on the current amendment.
4373: -- ======================================================================
4374: PROCEDURE get_source_bid
4375: (
4376: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4377: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4378: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4379: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
4380: ---------- Supplier Management: Supplier Evaluation ----------

Line 4398: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;

4394: x_withdraw_reason OUT NOCOPY VARCHAR2,
4395: x_return_status OUT NOCOPY NUMBER,
4396: x_return_code OUT NOCOPY VARCHAR2
4397: ) IS
4398: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
4399: l_status_order NUMBER;
4400: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4401:
4402: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;

Line 4402: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;

4398: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
4399: l_status_order NUMBER;
4400: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4401:
4402: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
4403: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
4404:
4405: l_terms_cond_apply VARCHAR2(1);
4406:

Line 4403: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

4399: l_status_order NUMBER;
4400: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4401:
4402: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
4403: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
4404:
4405: l_terms_cond_apply VARCHAR2(1);
4406:
4407: l_ignored_return pon_bid_headers.bid_number%TYPE;

Line 4411: l_org_id pon_auction_headers_all.org_id%TYPE;

4407: l_ignored_return pon_bid_headers.bid_number%TYPE;
4408: -- for the bug 13984944
4409: l_org_contract_status pon_contracts.contract_status%TYPE;
4410: l_enabled_flag pon_contracts.enabled_flag%TYPE;
4411: l_org_id pon_auction_headers_all.org_id%TYPE;
4412: l_count_org NUMBER;
4413:
4414: -- select bids on all amendments/previous round by the current user for the current site
4415: CURSOR current_users_bids_byr IS

Line 4430: FROM pon_bid_headers bh, pon_auction_headers_all ah

4426: decode(bh.bid_status, 'DISQUALIFIED', 'Y', 'N') prev_bid_disq,
4427: nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag,
4428: decode(bh.bid_status,'ARCHIVED',decode(bh.withdraw_reason,null,'N','Y'),'N') prev_bid_wthd,
4429: bh.withdraw_reason
4430: FROM pon_bid_headers bh, pon_auction_headers_all ah
4431: WHERE
4432: -- look at all amendments on the current round
4433: (ah.auction_header_id_orig_amend = l_orig_amend_id
4434: -- look at all amendments on the previous round

Line 4470: FROM pon_bid_headers bh, pon_auction_headers_all ah

4466: nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag,
4467:
4468: decode(bh.bid_status,'ARCHIVED',decode(bh.withdraw_reason,null,'N','Y'),'N') prev_bid_wthd,
4469: bh.withdraw_reason
4470: FROM pon_bid_headers bh, pon_auction_headers_all ah
4471: WHERE
4472: -- look at all amendments on the current round
4473: (ah.auction_header_id_orig_amend = l_orig_amend_id
4474: -- look at all amendments on the previous round

Line 4504: FROM pon_bid_headers bh, pon_auction_headers_all ah

4500: 'ACTIVE', 'SINGLE_BEST_BID'),
4501: decode(bh.bid_status, 'DRAFT', 'OTHER_USERS_DRAFT',
4502: 'ACTIVE', 'OTHER_USERS_ACTIVE')),
4503: 'OTHER_USERS_PREV_ROUND') return_code
4504: FROM pon_bid_headers bh, pon_auction_headers_all ah
4505: WHERE
4506: -- look at the current amendment, remove DRAFT status as part of Offer Enhancement ER
4507: -- Offer Enhancement : We need to consider draft bids
4508: (ah.auction_header_id = p_auc_header_id

Line 4533: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2

4529: -- Also check if contracts have been installed
4530: SELECT ah.auction_header_id_orig_amend, ah2.auction_header_id_orig_amend,
4531: nvl2(ah.contract_id, 'Y', 'N'), ah.org_id
4532: INTO l_orig_amend_id, l_prev_round_id, l_terms_cond_apply,l_org_id
4533: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2
4534: WHERE ah.auction_header_id = p_auc_header_id
4535: and ah2.auction_header_id (+) = ah.auction_header_id_prev_round;
4536:
4537: -- Retrieve the backing bid info from the cursor

Line 4723: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

4719: -- p_source_bid
4720: -- ======================================================================
4721: PROCEDURE create_defaulted_draft
4722: (
4723: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4724: p_source_bid IN pon_bid_headers.bid_number%TYPE,
4725: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
4726: ) IS
4727: l_tpid pon_bid_headers.trading_partner_id%TYPE;

Line 4876: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

4872: -- is to be created. Or whether a draft already exists
4873: -- ======================================================================
4874: PROCEDURE check_and_load_bid
4875: (
4876: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4877: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4878: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4879: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4880: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 4913: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%type;

4909: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
4910: l_new_round_or_amended VARCHAR2(1);
4911:
4912: l_temp_num NUMBER;
4913: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%type;
4914: L_SURROGATE_BID_FLAG VARCHAR2(1);
4915: l_eval_flag pon_bid_headers.evaluation_flag%TYPE := nvl(p_eval_flag,'N');
4916: BEGIN
4917:

Line 5290: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

5286: -- from previous round
5287: -- ======================================================================
5288: FUNCTION get_source_bid_for_spreadsheet
5289: (
5290: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,

Line 5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,

5287: -- ======================================================================
5288: FUNCTION get_source_bid_for_spreadsheet
5289: (
5290: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,

Line 5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,

5290: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
5296: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
5297:
5298: ) RETURN NUMBER IS

Line 5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,

5291: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
5292: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
5293: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
5294: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
5295: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
5296: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
5297:
5298: ) RETURN NUMBER IS
5299:

Line 5316: pon_auction_headers_all ah

5312: CURSOR previous_amendments_bids IS
5313: select bh.bid_number
5314: from
5315: pon_bid_headers bh,
5316: pon_auction_headers_all ah
5317: where
5318: bh.auction_header_id = ah.auction_header_id
5319: and ah.auction_header_id_orig_amend = p_auc_header_id_orig_amend
5320: and bh.trading_partner_id = p_tpid

Line 5356: pon_auction_headers_all ah,

5352:
5353: select max(bid_number) prev_round_bid
5354: into x_prev_bid_number
5355: from pon_bid_headers bh,
5356: pon_auction_headers_all ah,
5357: pon_auction_headers_all ah2
5358: where bh.auction_header_id = ah.auction_header_id
5359: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
5360: and ah2.auction_header_id = p_prev_round_auc_header_id

Line 5357: pon_auction_headers_all ah2

5353: select max(bid_number) prev_round_bid
5354: into x_prev_bid_number
5355: from pon_bid_headers bh,
5356: pon_auction_headers_all ah,
5357: pon_auction_headers_all ah2
5358: where bh.auction_header_id = ah.auction_header_id
5359: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
5360: and ah2.auction_header_id = p_prev_round_auc_header_id
5361: and bh.trading_partner_id = p_tpid

Line 5431: PON_AUCTION_HEADERS_ALL pah

5427: FROM dual
5428: WHERE EXISTS (SELECT 1
5429: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
5430: PON_BID_ITEM_PRICES pbi,
5431: PON_AUCTION_HEADERS_ALL pah
5432: WHERE pai.auction_header_id = p_auction_header_id
5433: AND pai.group_type NOT IN ('GROUP','LOT_LINE')
5434: AND pbi.auction_header_id = pai.auction_header_id
5435: AND pbi.line_number = pai.line_number

Line 5487: l_contract_type pon_auction_headers_all.contract_type%TYPE;

5483: l_total_price NUMBER;
5484: l_bid_line_pf_unit_price NUMBER;
5485: l_auc_pf_unit_price NUMBER;
5486:
5487: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5488: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5489:
5490: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5491: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

Line 5488: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

5484: l_bid_line_pf_unit_price NUMBER;
5485: l_auc_pf_unit_price NUMBER;
5486:
5487: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5488: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5489:
5490: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5491: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
5492:

Line 5505: FROM pon_auction_headers_all

5501: SELECT contract_type,
5502: supplier_view_type
5503: INTO l_contract_type,
5504: l_supplier_view_type
5505: FROM pon_auction_headers_all
5506: WHERE auction_header_id = p_auction_header_id;
5507:
5508:
5509:

Line 5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;

5793:
5794: l_contract_type po_lines_all.contract_type%TYPE;
5795: l_unit_price po_lines_all.unit_price%TYPE;
5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;
5799: l_quantity po_lines_all.quantity%TYPE;
5800: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;
5801:

Line 5918: from pon_auction_headers_all

5914:
5915: BEGIN
5916: select doctype_id
5917: into l_doctype_id
5918: from pon_auction_headers_all
5919: WHERE auction_header_id = p_auction_header_id;
5920:
5921: l_is_uda_enabled := PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id);
5922: IF l_is_uda_enabled = 1 THEN

Line 5967: from pon_auction_headers_all

5963:
5964: BEGIN
5965: select doctype_id
5966: into l_doctype_id
5967: from pon_auction_headers_all
5968: where auction_header_id = p_auction_header_id;
5969:
5970: l_is_uda_enabled := PON_CLM_UTIL_PKG.IS_UDA_ENABLED(l_doctype_id);
5971: IF l_is_uda_enabled = 1 THEN

Line 6045: pon_auction_headers_all

6041: l_number_of_lines
6042: --x_max_internal_line_num,
6043: --x_max_document_line_num
6044: FROM
6045: pon_auction_headers_all
6046: WHERE
6047: auction_header_id = p_auction_header_id;
6048:
6049: IF (l_number_of_lines > 0) THEN

Line 6146: FROM pon_auction_headers_all

6142: END;
6143:
6144: SELECT Decode(bid_frequency_code, 'SINGLE_BID_ONLY', 'Y', 'N' ), Decode (BID_LIST_TYPE ,'PUBLIC_BID_LIST', 'Y', 'N')
6145: INTO is_single_bid_freq, is_public
6146: FROM pon_auction_headers_all
6147: WHERE auction_header_id = p_auction_header_id;
6148:
6149: IF(is_single_bid_freq = 'Y') THEN
6150: