APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_AUCTION_PKG

Line 1524: l_target_category FND_DOCUMENT_CATEGORIES.NAME%type := pon_auction_pkg.g_supplier_attachment; -- target attachment category, default 'FromSupplier'

1520: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1521: p_userid IN pon_bid_headers.created_by%TYPE
1522: ) IS
1523: l_seq_num NUMBER;
1524: l_target_category FND_DOCUMENT_CATEGORIES.NAME%type := pon_auction_pkg.g_supplier_attachment; -- target attachment category, default 'FromSupplier'
1525: l_two_part_flag PON_AUCTION_HEADERS_ALL.TWO_PART_FLAG%type := 'N';
1526:
1527: CURSOR attachment_lines IS
1528: SELECT bli.attachment_url,

Line 1549: l_target_category := pon_auction_pkg.g_technical_attachment;

1545:
1546: -- change target attachment category for two-part RFQ.
1547: IF l_two_part_flag = 'Y' THEN -- {
1548: -- change to From Supplier: Technical
1549: l_target_category := pon_auction_pkg.g_technical_attachment;
1550: END IF; -- }
1551:
1552: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN -- {
1553: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 2543: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

2539: from fnd_user
2540: where user_id = p_user_id;
2541:
2542: -- Set timezone variables
2543: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2544:
2545: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2546: if (l_timezone is null or l_timezone = '') then
2547: l_timezone := l_oex_timezone;

Line 2545: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);

2541:
2542: -- Set timezone variables
2543: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2544:
2545: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2546: if (l_timezone is null or l_timezone = '') then
2547: l_timezone := l_oex_timezone;
2548: end if;
2549:

Line 2736: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

2732: from fnd_user
2733: where user_id = p_user_id;
2734:
2735: -- Set timezone variables
2736: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2737:
2738: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2739: if (l_timezone is null or l_timezone = '') then
2740: l_timezone := l_oex_timezone;

Line 2738: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);

2734:
2735: -- Set timezone variables
2736: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2737:
2738: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2739: if (l_timezone is null or l_timezone = '') then
2740: l_timezone := l_oex_timezone;
2741: end if;
2742: