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 857: FROM pon_auction_headers_all ah

853:
854: -- Determine the maximum line number for the negotiation
855: SELECT ah.max_internal_line_num
856: INTO l_max_line_number
857: FROM pon_auction_headers_all ah
858: WHERE ah.auction_header_id = p_auc_header_id;
859:
860: -- Define the initial batch range (line numbers are indexed from 1)
861: l_batch_start := 1;

Line 947: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

943: -- COMMENT: inserts a bid header for the new bid. Also generates the bid number
944: -- ======================================================================
945: PROCEDURE insert_into_bid_header
946: (
947: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
948: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
949: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
950: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,
951: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 964: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;

960: p_rebid_flag IN VARCHAR2,
961: p_prev_bid_disq IN VARCHAR2,
962: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
963: ) IS
964: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
965: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
966: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
967: ----------------------------------------------------------------
968: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;

Line 965: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;

961: p_prev_bid_disq IN VARCHAR2,
962: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
963: ) IS
964: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
965: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
966: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
967: ----------------------------------------------------------------
968: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
969: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

Line 968: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;

964: l_old_min_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
965: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
966: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
967: ----------------------------------------------------------------
968: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
969: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
970: ----------------------------------------------------------------
971: BEGIN
972:

Line 969: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;

965: l_old_min_bid_change pon_auction_headers_all.min_bid_decrement%TYPE;
966: -- added by Allen Yang 2009/01/06 for surrogate bid bug 7664486
967: ----------------------------------------------------------------
968: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%TYPE;
969: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%TYPE;
970: ----------------------------------------------------------------
971: BEGIN
972:
973: IF p_source_bid_num IS NOT NULL AND p_source_bid_num <> 0 THEN

Line 988: FROM PON_AUCTION_HEADERS_ALL pah,

984: -------------------------------------------------------
985: , l_two_part_flag
986: , l_technical_evaluation_status
987: -------------------------------------------------------
988: FROM PON_AUCTION_HEADERS_ALL pah,
989: PON_BID_HEADERS pbh
990: WHERE pah.auction_header_id = pbh.auction_header_id
991: AND pbh.bid_number = p_source_bid_num;
992: END IF;

Line 1125: FROM pon_auction_headers_all ah, pon_bid_headers bh

1121: decode(l_two_part_flag, 'Y',
1122: decode(p_buyer_user, 'Y',
1123: decode(l_technical_evaluation_status, 'COMPLETED', 'TECHNICAL', null), null), null), null)
1124: -----------------------------------------------------------------------------
1125: FROM pon_auction_headers_all ah, pon_bid_headers bh
1126: WHERE ah.auction_header_id = p_auc_header_id
1127: AND bh.bid_number (+) = p_source_bid_num
1128: AND ah.auction_header_id >= bh.auction_header_id (+));
1129:

Line 1148: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1144: -- COMMENT: inserts lines for the new bid, defualting as necessary
1145: -- ======================================================================
1146: PROCEDURE insert_into_bid_items
1147: (
1148: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1149: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1150: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1151: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
1152: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,

Line 1161: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1158: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1159: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1160: ) IS
1161: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1162: l_blanket VARCHAR2(1);
1163: l_full_qty VARCHAR2(1);
1164: l_enforce_prevrnd_price_flag VARCHAR2(1);
1165: l_prev_rnd_active_bid_number NUMBER;

Line 1169: l_is_paused pon_auction_headers_all.is_paused%TYPE;

1165: l_prev_rnd_active_bid_number NUMBER;
1166: l_auction_header_id_prev_round NUMBER;
1167: l_unit_price NUMBER;
1168: l_quantity NUMBER;
1169: l_is_paused pon_auction_headers_all.is_paused%TYPE;
1170: l_last_pause_date pon_auction_headers_all.last_pause_date%TYPE;
1171: l_closed_compare_date DATE;
1172: BEGIN
1173:

Line 1170: l_last_pause_date pon_auction_headers_all.last_pause_date%TYPE;

1166: l_auction_header_id_prev_round NUMBER;
1167: l_unit_price NUMBER;
1168: l_quantity NUMBER;
1169: l_is_paused pon_auction_headers_all.is_paused%TYPE;
1170: l_last_pause_date pon_auction_headers_all.last_pause_date%TYPE;
1171: l_closed_compare_date DATE;
1172: BEGIN
1173:
1174: SELECT ah.trading_partner_id,

Line 1188: FROM pon_auction_headers_all ah

1184: l_enforce_prevrnd_price_flag,
1185: l_auction_header_id_prev_round,
1186: l_is_paused,
1187: l_last_pause_date
1188: FROM pon_auction_headers_all ah
1189: WHERE ah.auction_header_id = p_auc_header_id;
1190:
1191: INSERT INTO pon_bid_item_prices
1192: (

Line 1510: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1506: -- COMMENT: inserts header attributes for the new bid, defualting as necessary
1507: -- ======================================================================
1508: PROCEDURE insert_into_header_attributes
1509: (
1510: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1511: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1512: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1513: p_userid IN pon_bid_headers.created_by%TYPE,
1514: p_rebid_flag IN VARCHAR2

Line 1517: l_has_scoring_teams_flag pon_auction_headers_all.has_scoring_teams_flag%TYPE;

1513: p_userid IN pon_bid_headers.created_by%TYPE,
1514: p_rebid_flag IN VARCHAR2
1515: ) IS
1516:
1517: l_has_scoring_teams_flag pon_auction_headers_all.has_scoring_teams_flag%TYPE;
1518:
1519: BEGIN
1520:
1521: -- Bug 5046909 - Determine if team scoring is enabled

Line 1534: FROM pon_auction_headers_all

1530:
1531:
1532: SELECT has_scoring_teams_flag
1533: INTO l_has_scoring_teams_flag
1534: FROM pon_auction_headers_all
1535: WHERE auction_header_id = p_auc_header_id;
1536:
1537: -- Insert header attributes
1538: INSERT INTO pon_bid_attribute_values

Line 1608: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1604: -- COMMENT: inserts line attributes for the new bid, defualting as necessary
1605: -- ======================================================================
1606: PROCEDURE insert_into_line_attributes
1607: (
1608: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1609: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1611: p_userid IN pon_bid_headers.created_by%TYPE,
1612: p_rebid_flag IN VARCHAR2,

Line 1689: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1685: -- COMMENT: insert price factors for the new bid, defualting as necessary
1686: -- ======================================================================
1687: PROCEDURE insert_into_price_factors
1688: (
1689: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1690: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,

Line 1701: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;

1697: ) IS
1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;
1700: l_rate pon_bid_headers.rate%TYPE;
1701: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1702: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1703: BEGIN
1704:
1705: -- Get bid currency precisions and rate

Line 1702: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;

1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;
1700: l_rate pon_bid_headers.rate%TYPE;
1701: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
1702: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;
1703: BEGIN
1704:
1705: -- Get bid currency precisions and rate
1706: SELECT bh.number_price_decimals,

Line 1720: FROM pon_auction_headers_all ah

1716:
1717: -- Get the price factor type info
1718: SELECT ah.supplier_view_type, ah.pf_type_allowed
1719: INTO l_supplier_view, l_pf_type
1720: FROM pon_auction_headers_all ah
1721: WHERE ah.auction_header_id = p_auc_header_id;
1722:
1723: -- copy over all supplier price factors, including line price
1724: -- do not copy line price pf for lines with display_price_factors_flag = N

Line 1847: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

1843: -- COMMENT: inserts price tiers for the new bid, defualting as necessary
1844: -- ======================================================================
1845: PROCEDURE insert_into_price_tiers
1846: (
1847: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1848: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1850: p_userid IN pon_bid_headers.created_by%TYPE,
1851: p_rebid_flag IN VARCHAR2,

Line 2022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2018: -- COMMENT: inserts price differentials for the new bid, defualting as necessary
2019: -- ======================================================================
2020: PROCEDURE insert_into_price_diff
2021: (
2022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2023: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2025: p_userid IN pon_bid_headers.created_by%TYPE,
2026: p_rebid_flag IN VARCHAR2,

Line 2133: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2129: -- ======================================================================
2130: -- Create and default payments
2131: PROCEDURE insert_into_payments
2132: (
2133: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2134: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2135: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2136: p_copy_only_from_auc IN VARCHAR2,
2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,

Line 2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,

2133: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2134: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2135: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2136: p_copy_only_from_auc IN VARCHAR2,
2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2138: p_userid IN pon_bid_headers.created_by%TYPE,
2139: p_rebid_flag IN VARCHAR2,
2140: p_new_round_or_amended IN VARCHAR2,
2141: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

Line 2500: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2496: -- COMMENT: populates has_bid_flag - used when defualting from pre-release 12 draft
2497: -- ======================================================================
2498: PROCEDURE populate_has_bid_flag
2499: (
2500: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2501: p_bid_number IN pon_bid_headers.bid_number%TYPE
2502: ) IS
2503: l_full_qty_reqd VARCHAR2(1);
2504: BEGIN

Line 2509: FROM pon_auction_headers_all ah

2505:
2506: -- Determine if the auction is full quantity required
2507: SELECT decode(ah.full_quantity_bid_code, 'FULL_QTY_BIDS_REQD', 'Y', 'N')
2508: INTO l_full_qty_reqd
2509: FROM pon_auction_headers_all ah
2510: WHERE ah.auction_header_id = p_auc_header_id;
2511:
2512: -- First set has_bid_flag to N
2513: UPDATE pon_bid_item_prices bl

Line 2612: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

2608: -- side tables and copies attachments
2609: -- ======================================================================
2610: PROCEDURE create_new_draft_bid
2611: (
2612: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
2613: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2614: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
2615: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
2616: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 2632: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;

2628: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
2629: x_return_status OUT NOCOPY NUMBER,
2630: x_return_code OUT NOCOPY VARCHAR2
2631: ) IS
2632: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
2633: l_restricted_flag VARCHAR2(1);
2634: l_rel12_draft VARCHAR2(1);
2635: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

Line 2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;

2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2639: l_batch_start pon_bid_item_prices.line_number%TYPE;
2640: l_batch_end pon_bid_item_prices.line_number%TYPE;
2641: l_skip_pf_for_batch VARCHAR2(1);
2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2645: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;

Line 2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;

2639: l_batch_start pon_bid_item_prices.line_number%TYPE;
2640: l_batch_end pon_bid_item_prices.line_number%TYPE;
2641: l_skip_pf_for_batch VARCHAR2(1);
2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2645: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2647: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

Line 2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;

2640: l_batch_end pon_bid_item_prices.line_number%TYPE;
2641: l_skip_pf_for_batch VARCHAR2(1);
2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2645: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2647: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2648: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

Line 2648: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;

2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;
2645: l_module CONSTANT VARCHAR2(35) := 'create_new_draft_bid';
2646: l_other_draft_bid_number pon_bid_headers.bid_number%TYPE;
2647: l_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
2648: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%TYPE;
2649:
2650:
2651: -- Two-part RFQ related variables
2652: l_is_new_round VARCHAR2(1) := 'N'; -- to store Y for new rounds (default N)

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

2709:
2710: -- get value of two-part flags for current and prev rounds
2711: select decode(pah.auction_header_id_prev_round, null, 'N', 'Y'),
2712: nvl(pah.two_part_flag, 'N'),
2713: (select nvl(two_part_flag,'N') from pon_auction_headers_all
2714: where auction_header_id = pah.auction_header_id_prev_round)
2715: into l_is_new_round, l_curr_two_part, l_prev_two_part
2716: from pon_auction_headers_all pah
2717: where auction_header_id = p_auc_header_id;

Line 2716: from pon_auction_headers_all pah

2712: nvl(pah.two_part_flag, 'N'),
2713: (select nvl(two_part_flag,'N') from pon_auction_headers_all
2714: where auction_header_id = pah.auction_header_id_prev_round)
2715: into l_is_new_round, l_curr_two_part, l_prev_two_part
2716: from pon_auction_headers_all pah
2717: where auction_header_id = p_auc_header_id;
2718:
2719: 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);
2720:

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

2782: nvl(ADVANCE_NEGOTIABLE_FLAG,'N'),nvl(RECOUPMENT_NEGOTIABLE_FLAG,'N'),nvl(PROGRESS_PYMT_NEGOTIABLE_FLAG,'N'),
2783: nvl(MAX_RETAINAGE_NEGOTIABLE_FLAG,'N'),nvl(RETAINAGE_NEGOTIABLE_FLAG,'N')
2784: into l_supplier_flag, l_payment_type, l_contract_type,
2785: g_advance_negotiable,g_recoupment_negotiable,g_prog_pymt_negotiable,g_max_rtng_negotiable,g_rtng_negotiable
2786: FROM pon_auction_headers_all ah where ah.auction_header_id=p_auc_header_id;
2787: IF (g_debug_mode = 'Y') THEN
2788: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2789: FND_LOG.string(log_level => FND_LOG.level_statement,
2790: module => g_module_prefix || l_module,

Line 2824: FROM pon_auction_headers_all oldah

2820: -- then if previous neg had SUPPLIER_ENTERABLE_PYMT_FLAG as Y then
2821: -- we need to default payments from neg and not from bid.
2822: select decode(oldah.SUPPLIER_ENTERABLE_PYMT_FLAG, 'Y','Y', 'N')
2823: into g_copy_only_from_auc
2824: FROM pon_auction_headers_all oldah
2825: WHERE oldah.auction_header_id = l_source_header_id;
2826:
2827: IF (g_debug_mode = 'Y') THEN
2828: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2850: FROM pon_auction_headers_all ah

2846:
2847: -- Determine the maximum line number for the negotiation
2848: SELECT ah.max_internal_line_num ,ah.price_tiers_indicator
2849: INTO l_max_line_number,l_price_tiers_indicator
2850: FROM pon_auction_headers_all ah
2851: WHERE ah.auction_header_id = p_auc_header_id;
2852:
2853: -- Define the initial range (line numbers are indexed from 1)
2854: l_batch_start := 1;

Line 3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;

3049: x_rebid_flag OUT NOCOPY VARCHAR2
3050: ) IS
3051: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3052:
3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;

Line 3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

3050: ) IS
3051: l_source_bid_num pon_bid_headers.bid_number%TYPE;
3052:
3053: l_auc_header_id pon_auction_headers_all.auction_header_id%TYPE;
3054: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
3055: l_tpid pon_bid_headers.trading_partner_id%TYPE;
3056: l_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3057: l_userid pon_bid_headers.created_by%TYPE;
3058: l_vensid pon_bid_headers.vendor_site_id%TYPE;

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

3094: l_userid,
3095: l_rate,
3096: l_price_prec,
3097: l_curr_prec
3098: FROM pon_bid_headers bh, pon_auction_headers_all ah, fnd_currencies cu
3099: WHERE bh.bid_number = p_bid_number
3100: AND ah.auction_header_id = bh.auction_header_id
3101: AND cu.currency_code = bh.bid_currency_code;
3102:

Line 3149: FROM pon_auction_headers_all ah

3145:
3146: -- Determine the maximum line number for the negotiation
3147: SELECT ah.max_internal_line_num
3148: INTO l_max_line_number
3149: FROM pon_auction_headers_all ah
3150: WHERE ah.auction_header_id = l_auc_header_id;
3151:
3152: -- Define the initial range (line numbers are indexed from 1)
3153: l_batch_start := 1;

Line 3295: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

3291: -- COMMENT: Determines if all amendments on the current round have been acknowledged
3292: -- ======================================================================
3293: PROCEDURE check_amendments_acked
3294: (
3295: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3296: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
3297: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3298: x_return_status OUT NOCOPY NUMBER,
3299: x_return_code OUT NOCOPY VARCHAR2

Line 3296: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,

3292: -- ======================================================================
3293: PROCEDURE check_amendments_acked
3294: (
3295: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3296: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
3297: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3298: x_return_status OUT NOCOPY NUMBER,
3299: x_return_code OUT NOCOPY VARCHAR2
3300: ) IS

Line 3297: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,

3293: PROCEDURE check_amendments_acked
3294: (
3295: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3296: p_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
3297: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3298: x_return_status OUT NOCOPY NUMBER,
3299: x_return_code OUT NOCOPY VARCHAR2
3300: ) IS
3301: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%TYPE;

Line 3301: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%TYPE;

3297: p_tpcid IN pon_auction_headers_all.trading_partner_contact_id%TYPE,
3298: x_return_status OUT NOCOPY NUMBER,
3299: x_return_code OUT NOCOPY VARCHAR2
3300: ) IS
3301: l_orig_amend_id pon_auction_headers_all.auction_header_id_orig_amend%TYPE;
3302: l_amend_not_acked VARCHAR2(1);
3303: BEGIN
3304:
3305: -- Get the original amendments auction header id

Line 3308: FROM pon_auction_headers_all ah

3304:
3305: -- Get the original amendments auction header id
3306: SELECT ah.auction_header_id_orig_amend
3307: INTO l_orig_amend_id
3308: FROM pon_auction_headers_all ah
3309: WHERE ah.auction_header_id = p_auc_header_id;
3310:
3311: -- There must be as many acknowledgements as amendments
3312: SELECT decode(count(rownum), 0, 'N', 'Y')

Line 3314: FROM pon_auction_headers_all ah, pon_acknowledgements ac

3310:
3311: -- There must be as many acknowledgements as amendments
3312: SELECT decode(count(rownum), 0, 'N', 'Y')
3313: INTO l_amend_not_acked
3314: FROM pon_auction_headers_all ah, pon_acknowledgements ac
3315: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
3316: AND ah.auction_status IN ('AMENDED', 'ACTIVE')
3317: -- ignore the original amendment
3318: AND ah.amendment_number > 0

Line 3417: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

3413: -- be completed at this time.
3414: -- ======================================================================
3415: PROCEDURE is_bidding_allowed
3416: (
3417: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3418: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3419: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3420: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3421: p_venscode IN pon_bid_headers.vendor_site_code%TYPE,

Line 3429: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;

3425: x_return_code OUT NOCOPY VARCHAR2
3426: ) IS
3427: l_current_date TIMESTAMP;
3428: l_bid_number NUMBER;
3429: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;

Line 3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;

3426: ) IS
3427: l_current_date TIMESTAMP;
3428: l_bid_number NUMBER;
3429: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;
3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;

Line 3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;

3427: l_current_date TIMESTAMP;
3428: l_bid_number NUMBER;
3429: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;
3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
3435: l_invited_flag VARCHAR2(1);

Line 3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;

3428: l_bid_number NUMBER;
3429: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;
3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
3435: l_invited_flag VARCHAR2(1);
3436: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;

Line 3433: l_award_status pon_auction_headers_all.award_status%TYPE;

3429: l_view_by_date pon_auction_headers_all.view_by_date%TYPE;
3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;
3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
3435: l_invited_flag VARCHAR2(1);
3436: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;
3437: l_has_draft_flag VARCHAR2(1);

Line 3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;

3430: l_open_date pon_auction_headers_all.open_bidding_date%TYPE;
3431: l_close_date pon_auction_headers_all.close_bidding_date%TYPE;
3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;
3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
3435: l_invited_flag VARCHAR2(1);
3436: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;
3437: l_has_draft_flag VARCHAR2(1);
3438: l_has_bid_flag VARCHAR2(1);

Line 3436: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;

3432: l_auction_status pon_auction_headers_all.auction_status%TYPE;
3433: l_award_status pon_auction_headers_all.award_status%TYPE;
3434: l_bid_list_type pon_auction_headers_all.bid_list_type%TYPE;
3435: l_invited_flag VARCHAR2(1);
3436: l_bid_freq_code pon_auction_headers_all.bid_frequency_code%TYPE;
3437: l_has_draft_flag VARCHAR2(1);
3438: l_has_bid_flag VARCHAR2(1);
3439: l_has_surrog_flag VARCHAR2(1);
3440: l_auction_paused VARCHAR2(1);

Line 3441: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

3437: l_has_draft_flag VARCHAR2(1);
3438: l_has_bid_flag VARCHAR2(1);
3439: l_has_surrog_flag VARCHAR2(1);
3440: l_auction_paused VARCHAR2(1);
3441: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
3442: l_supp_end_date TIMESTAMP;
3443: BEGIN
3444:
3445: -- Verify that a valid site id has been specified if not loading a bid

Line 3478: FROM pon_auction_headers_all ah

3474: l_bid_list_type,
3475: l_bid_freq_code,
3476: l_orig_amend_id,
3477: l_auction_paused
3478: FROM pon_auction_headers_all ah
3479: WHERE auction_header_id = p_auc_header_id;
3480:
3481: EXCEPTION
3482: WHEN NO_DATA_FOUND THEN

Line 3651: FROM pon_bid_headers bh, pon_auction_headers_all ah

3647: -- Check if a buyer/supplier has already placed a bid on the round
3648: -- I.e. check for surrog bid if supplier, or a supplier bid if buyer
3649: SELECT decode(count(bh.auction_header_id), 0, 'N', 'Y')
3650: INTO l_has_surrog_flag
3651: FROM pon_bid_headers bh, pon_auction_headers_all ah
3652: WHERE ah.auction_header_id_orig_amend = l_orig_amend_id
3653: AND bh.auction_header_id = ah.auction_header_id
3654: AND bh.trading_partner_id = p_tpid
3655: AND bh.trading_partner_contact_id = p_tpcid

Line 3697: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

3693: -- Also checks if another user has a draft on the current amendment.
3694: -- ======================================================================
3695: PROCEDURE get_source_bid
3696: (
3697: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3698: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
3699: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
3700: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
3701: p_action_code IN VARCHAR2,

Line 3712: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;

3708: x_prev_bid_disq OUT NOCOPY VARCHAR2,
3709: x_return_status OUT NOCOPY NUMBER,
3710: x_return_code OUT NOCOPY VARCHAR2
3711: ) IS
3712: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
3713: l_status_order NUMBER;
3714: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
3715:
3716: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;

Line 3716: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;

3712: l_source_header_id pon_auction_headers_all.auction_header_id%TYPE;
3713: l_status_order NUMBER;
3714: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
3715:
3716: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
3717: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
3718:
3719: l_terms_cond_apply VARCHAR2(1);
3720:

Line 3717: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;

3713: l_status_order NUMBER;
3714: l_rel12_draft pon_bid_headers.rel12_draft_flag%TYPE;
3715:
3716: l_prev_round_id pon_auction_headers_all.auction_header_id%TYPE;
3717: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
3718:
3719: l_terms_cond_apply VARCHAR2(1);
3720:
3721: l_ignored_return pon_bid_headers.bid_number%TYPE;

Line 3737: FROM pon_bid_headers bh, pon_auction_headers_all ah

3733: decode(ah.auction_header_id_orig_amend, l_orig_amend_id, 'Y', 'N')) prev_amend_def,
3734:
3735: decode(bh.bid_status, 'DISQUALIFIED', 'Y', 'N') prev_bid_disq,
3736: nvl(bh.rel12_draft_flag, 'N') rel12_draft_flag
3737: FROM pon_bid_headers bh, pon_auction_headers_all ah
3738: WHERE
3739: -- look at all amendments on the current round
3740: (ah.auction_header_id_orig_amend = l_orig_amend_id
3741: -- look at all amendments on the previous round

Line 3764: FROM pon_bid_headers bh, pon_auction_headers_all ah

3760: 'ACTIVE', 'SINGLE_BEST_BID'),
3761: decode(bh.bid_status, 'DRAFT', 'OTHER_USERS_DRAFT',
3762: 'ACTIVE', 'OTHER_USERS_ACTIVE')),
3763: 'OTHER_USERS_PREV_ROUND') return_code
3764: FROM pon_bid_headers bh, pon_auction_headers_all ah
3765: WHERE
3766: -- look at the current amendment
3767: (ah.auction_header_id = p_auc_header_id
3768: AND bh.bid_status IN ('DRAFT', 'ACTIVE')

Line 3786: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2

3782: -- Also check if contracts have been installed
3783: SELECT ah.auction_header_id_orig_amend, ah2.auction_header_id_orig_amend,
3784: nvl2(ah.contract_id, 'Y', 'N')
3785: INTO l_orig_amend_id, l_prev_round_id, l_terms_cond_apply
3786: FROM pon_auction_headers_all ah, pon_auction_headers_all ah2
3787: WHERE ah.auction_header_id = p_auc_header_id
3788: and ah2.auction_header_id (+) = ah.auction_header_id_prev_round;
3789:
3790: -- Retrieve the backing bid info from the cursor

Line 3894: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

3890: -- p_source_bid
3891: -- ======================================================================
3892: PROCEDURE create_defaulted_draft
3893: (
3894: p_new_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
3895: p_source_bid IN pon_bid_headers.bid_number%TYPE,
3896: x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE
3897: ) IS
3898: l_tpid pon_bid_headers.trading_partner_id%TYPE;

Line 4022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

4018: -- is to be created. Or whether a draft already exists
4019: -- ======================================================================
4020: PROCEDURE check_and_load_bid
4021: (
4022: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4023: p_draft_number IN pon_bid_headers.bid_number%TYPE,
4024: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4025: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4026: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 4319: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

4315: -- from previous round
4316: -- ======================================================================
4317: FUNCTION get_source_bid_for_spreadsheet
4318: (
4319: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,

Line 4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,

4316: -- ======================================================================
4317: FUNCTION get_source_bid_for_spreadsheet
4318: (
4319: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,

Line 4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,

4319: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
4325: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
4326:
4327: ) RETURN NUMBER IS

Line 4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,

4320: p_prev_round_auc_header_id IN pon_auction_headers_all.auction_header_id_prev_round%TYPE,
4321: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
4322: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
4323: p_auc_header_id_orig_amend IN pon_auction_headers_all.auction_header_id_orig_amend%TYPE,
4324: p_amendment_number IN pon_auction_headers_all.amendment_number%TYPE,
4325: p_vensid IN pon_bid_headers.vendor_site_id%TYPE
4326:
4327: ) RETURN NUMBER IS
4328:

Line 4345: pon_auction_headers_all ah

4341: CURSOR previous_amendments_bids IS
4342: select bh.bid_number
4343: from
4344: pon_bid_headers bh,
4345: pon_auction_headers_all ah
4346: where
4347: bh.auction_header_id = ah.auction_header_id
4348: and ah.auction_header_id_orig_amend = p_auc_header_id_orig_amend
4349: and bh.trading_partner_id = p_tpid

Line 4385: pon_auction_headers_all ah,

4381:
4382: select max(bid_number) prev_round_bid
4383: into x_prev_bid_number
4384: from pon_bid_headers bh,
4385: pon_auction_headers_all ah,
4386: pon_auction_headers_all ah2
4387: where bh.auction_header_id = ah.auction_header_id
4388: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
4389: and ah2.auction_header_id = p_prev_round_auc_header_id

Line 4386: pon_auction_headers_all ah2

4382: select max(bid_number) prev_round_bid
4383: into x_prev_bid_number
4384: from pon_bid_headers bh,
4385: pon_auction_headers_all ah,
4386: pon_auction_headers_all ah2
4387: where bh.auction_header_id = ah.auction_header_id
4388: and ah.auction_header_id_orig_amend = ah2.auction_header_id_orig_amend
4389: and ah2.auction_header_id = p_prev_round_auc_header_id
4390: and bh.trading_partner_id = p_tpid

Line 4460: PON_AUCTION_HEADERS_ALL pah

4456: FROM dual
4457: WHERE EXISTS (SELECT 1
4458: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
4459: PON_BID_ITEM_PRICES pbi,
4460: PON_AUCTION_HEADERS_ALL pah
4461: WHERE pai.auction_header_id = p_auction_header_id
4462: AND pai.group_type NOT IN ('GROUP','LOT_LINE')
4463: AND pbi.auction_header_id = pai.auction_header_id
4464: AND pbi.line_number = pai.line_number

Line 4516: l_contract_type pon_auction_headers_all.contract_type%TYPE;

4512: l_total_price NUMBER;
4513: l_bid_line_pf_unit_price NUMBER;
4514: l_auc_pf_unit_price NUMBER;
4515:
4516: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4517: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
4518:
4519: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
4520: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

Line 4517: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

4513: l_bid_line_pf_unit_price NUMBER;
4514: l_auc_pf_unit_price NUMBER;
4515:
4516: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4517: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
4518:
4519: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
4520: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
4521:

Line 4534: FROM pon_auction_headers_all

4530: SELECT contract_type,
4531: supplier_view_type
4532: INTO l_contract_type,
4533: l_supplier_view_type
4534: FROM pon_auction_headers_all
4535: WHERE auction_header_id = p_auction_header_id;
4536:
4537:
4538: