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

Line 162: FROM PON_AUCTION_HEADERS_ALL

158: END IF;
159:
160: SELECT REQUEST_ID
161: INTO x_request_id
162: FROM PON_AUCTION_HEADERS_ALL
163: WHERE AUCTION_HEADER_ID = p_auction_header_id;
164:
165: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
166: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 385: pon_auction_headers_all

381: l_number_of_lines,
382: x_max_internal_line_num,
383: x_max_document_line_num
384: FROM
385: pon_auction_headers_all
386: WHERE
387: auction_header_id = p_auction_header_id;
388:
389: IF (l_number_of_lines > 0) THEN

Line 1303: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;

1299: l_batch_start NUMBER;
1300: l_batch_end NUMBER;
1301:
1302: -- Auction Header Information
1303: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;

Line 1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;

1300: l_batch_end NUMBER;
1301:
1302: -- Auction Header Information
1303: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;

Line 1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;

1302: -- Auction Header Information
1303: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;

Line 1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;

1303: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;

Line 1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;

1304: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;

Line 1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;

1305: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;

Line 1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;

1306: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1314:

Line 1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;

1307: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1314:
1315: -- Federal Fields project

Line 1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;

1308: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1314:
1315: -- Federal Fields project
1316: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

Line 1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;

1309: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1310: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1311: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1314:
1315: -- Federal Fields project
1316: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1317:

Line 1316: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

1312: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1313: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1314:
1315: -- Federal Fields project
1316: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1317:
1318: BEGIN
1319:
1320: l_module_name := 'delete_all_lines';

Line 1368: pon_auction_headers_all paha,

1364: l_progress_payment_type,
1365: l_price_tiers_indicator,
1366: l_doctype_id
1367: FROM
1368: pon_auction_headers_all paha,
1369: pon_auc_doctypes pad
1370: WHERE
1371: paha.auction_header_id = p_auction_header_id AND
1372: paha.doctype_id = pad.doctype_id;

Line 1833: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;

1829: l_header_max_document_line_num NUMBER;
1830: l_line_number NUMBER;
1831:
1832: -- Auction Header Information
1833: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;

Line 1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;

1830: l_line_number NUMBER;
1831:
1832: -- Auction Header Information
1833: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;

Line 1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;

1832: -- Auction Header Information
1833: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;

Line 1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;

1833: l_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;

Line 1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;

1834: l_line_attribute_enabled_flag PON_AUCTION_HEADERS_ALL.LINE_ATTRIBUTE_ENABLED_FLAG%TYPE;
1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;

Line 1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;

1835: l_doctype_group_name PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE;
1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;

Line 1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;

1836: l_rfi_line_enabled_flag PON_AUCTION_HEADERS_ALL.RFI_LINE_ENABLED_FLAG%TYPE;
1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
1844: l_is_multi_round VARCHAR2(2);

Line 1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;

1837: l_pf_type_allowed PON_AUCTION_HEADERS_ALL.PF_TYPE_ALLOWED%TYPE;
1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
1844: l_is_multi_round VARCHAR2(2);
1845: l_is_amendment VARCHAR2(2);

Line 1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;

1838: l_contract_type PON_AUCTION_HEADERS_ALL.CONTRACT_TYPE%TYPE;
1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
1844: l_is_multi_round VARCHAR2(2);
1845: l_is_amendment VARCHAR2(2);
1846: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;

Line 1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;

1839: l_global_agreement_flag PON_AUCTION_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%TYPE;
1840: l_large_neg_enabled_flag PON_AUCTION_HEADERS_ALL.LARGE_NEG_ENABLED_FLAG%TYPE;
1841: l_auction_origination_code PON_AUCTION_HEADERS_ALL.AUCTION_ORIGINATION_CODE%TYPE;
1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
1844: l_is_multi_round VARCHAR2(2);
1845: l_is_amendment VARCHAR2(2);
1846: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1847: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;

Line 1846: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;

1842: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
1844: l_is_multi_round VARCHAR2(2);
1845: l_is_amendment VARCHAR2(2);
1846: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1847: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1848:
1849: -- Federal Fields Project
1850: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

Line 1847: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;

1843: l_auction_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
1844: l_is_multi_round VARCHAR2(2);
1845: l_is_amendment VARCHAR2(2);
1846: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1847: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1848:
1849: -- Federal Fields Project
1850: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1851: l_exhibit_number PON_AUCTION_ITEM_PRICES_ALL.EXHIBIT_NUMBER%TYPE;

Line 1850: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

1846: l_progress_payment_type PON_AUCTION_HEADERS_ALL.PROGRESS_PAYMENT_TYPE%TYPE;
1847: l_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
1848:
1849: -- Federal Fields Project
1850: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
1851: l_exhibit_number PON_AUCTION_ITEM_PRICES_ALL.EXHIBIT_NUMBER%TYPE;
1852: l_exhibits NUMBER;
1853: -- Cursor to find out lines that have attachments
1854: -- within a lot/group

Line 1955: pon_auction_headers_all paha,

1951: l_progress_payment_type,
1952: l_price_tiers_indicator,
1953: l_doctype_id
1954: FROM
1955: pon_auction_headers_all paha,
1956: pon_auc_doctypes pad
1957: WHERE
1958: paha.auction_header_id = p_auction_header_id AND
1959: paha.doctype_id = pad.doctype_id;

Line 1970: pon_auction_headers_all

1966: max_document_line_num
1967: INTO
1968: l_header_max_document_line_num
1969: FROM
1970: pon_auction_headers_all
1971: WHERE
1972: auction_header_id = p_auction_header_id;
1973:
1974: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2179: message => 'Deleted the entry in pon_auction_headers_all');

2175:
2176: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2177: FND_LOG.string (log_level => FND_LOG.level_statement,
2178: module => g_module_prefix || l_module_name,
2179: message => 'Deleted the entry in pon_auction_headers_all');
2180: END IF;
2181:
2182: /*
2183: Deleting Exhibit Details whenever an ELIN is deleted.

Line 2845: PON_AUCTION_HEADERS_ALL

2841: NVL(MAX_DOCUMENT_LINE_NUM,0)
2842: INTO
2843: l_max_document_line_num
2844: FROM
2845: PON_AUCTION_HEADERS_ALL
2846: WHERE
2847: AUCTION_HEADER_ID = p_auction_header_id;
2848:
2849: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 4020: l_prev_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;

4016: l_batch_start NUMBER;
4017: l_batch_end NUMBER;
4018: l_parent_auc_max_line_number NUMBER;
4019:
4020: l_prev_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
4021: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
4022: l_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
4023:
4024:

Line 4021: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;

4017: l_batch_end NUMBER;
4018: l_parent_auc_max_line_number NUMBER;
4019:
4020: l_prev_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
4021: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
4022: l_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
4023:
4024:
4025: l_is_new_amendment BOOLEAN;

Line 4022: l_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;

4018: l_parent_auc_max_line_number NUMBER;
4019:
4020: l_prev_price_tiers_indicator PON_AUCTION_HEADERS_ALL.PRICE_TIERS_INDICATOR%TYPE;
4021: l_amendment_number PON_AUCTION_HEADERS_ALL.AMENDMENT_NUMBER%TYPE;
4022: l_round_number PON_AUCTION_HEADERS_ALL.AUCTION_ROUND_NUMBER%TYPE;
4023:
4024:
4025: l_is_new_amendment BOOLEAN;
4026: l_is_amendment BOOLEAN;

Line 4048: FROM pon_auction_headers_all

4044: auction_round_number
4045: INTO l_prev_price_tiers_indicator,
4046: l_amendment_number,
4047: l_round_number
4048: FROM pon_auction_headers_all
4049: WHERE auction_header_id = p_auction_header_id;
4050:
4051: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4052: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 4085: FROM pon_auction_headers_all

4081: --this is an amendment
4082: l_is_amendment := true;
4083: SELECT max_internal_line_num
4084: INTO l_parent_auc_max_line_number
4085: FROM pon_auction_headers_all
4086: WHERE auction_header_id =
4087: (SELECT auction_header_id_prev_amend
4088: FROM pon_auction_headers_all
4089: WHERE auction_header_id = p_auction_header_id);

Line 4088: FROM pon_auction_headers_all

4084: INTO l_parent_auc_max_line_number
4085: FROM pon_auction_headers_all
4086: WHERE auction_header_id =
4087: (SELECT auction_header_id_prev_amend
4088: FROM pon_auction_headers_all
4089: WHERE auction_header_id = p_auction_header_id);
4090:
4091: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4092: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 4103: FROM pon_auction_headers_all

4099: --this is an new round
4100: l_is_new_round := true;
4101: SELECT max_internal_line_num
4102: INTO l_parent_auc_max_line_number
4103: FROM pon_auction_headers_all
4104: WHERE auction_header_id =
4105: (SELECT auction_header_id_prev_round
4106: FROM pon_auction_headers_all
4107: WHERE auction_header_id = p_auction_header_id);

Line 4106: FROM pon_auction_headers_all

4102: INTO l_parent_auc_max_line_number
4103: FROM pon_auction_headers_all
4104: WHERE auction_header_id =
4105: (SELECT auction_header_id_prev_round
4106: FROM pon_auction_headers_all
4107: WHERE auction_header_id = p_auction_header_id);
4108:
4109: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
4110: FND_LOG.string(log_level => FND_LOG.level_statement,