APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_AUCTION_PKG

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

1321: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1322: p_userid IN pon_bid_headers.created_by%TYPE
1323: ) IS
1324: l_seq_num NUMBER;
1325: l_target_category FND_DOCUMENT_CATEGORIES.NAME%type := pon_auction_pkg.g_supplier_attachment; -- target attachment category, default 'FromSupplier'
1326: l_two_part_flag PON_AUCTION_HEADERS_ALL.TWO_PART_FLAG%type := 'N';
1327:
1328: CURSOR attachment_lines IS
1329: SELECT bli.attachment_url,

Line 1346: l_target_category := pon_auction_pkg.g_technical_attachment;

1342:
1343: -- change target attachment category for two-part RFQ.
1344: IF l_two_part_flag = 'Y' THEN -- {
1345: -- change to From Supplier: Technical
1346: l_target_category := pon_auction_pkg.g_technical_attachment;
1347: END IF; -- }
1348:
1349: IF (g_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN -- {
1350: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 2330: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

2326: from fnd_user
2327: where user_id = p_user_id;
2328:
2329: -- Set timezone variables
2330: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2331:
2332: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2333: if (l_timezone is null or l_timezone = '') then
2334: l_timezone := l_oex_timezone;

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

2328:
2329: -- Set timezone variables
2330: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2331:
2332: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2333: if (l_timezone is null or l_timezone = '') then
2334: l_timezone := l_oex_timezone;
2335: end if;
2336:

Line 2523: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;

2519: from fnd_user
2520: where user_id = p_user_id;
2521:
2522: -- Set timezone variables
2523: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2524:
2525: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2526: if (l_timezone is null or l_timezone = '') then
2527: l_timezone := l_oex_timezone;

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

2521:
2522: -- Set timezone variables
2523: l_oex_timezone := PON_AUCTION_PKG.Get_Oex_Time_Zone;
2524:
2525: l_timezone := PON_AUCTION_PKG.Get_Time_Zone(l_person_party_id);
2526: if (l_timezone is null or l_timezone = '') then
2527: l_timezone := l_oex_timezone;
2528: end if;
2529: