APPS.PON_PRINTING_PKG dependencies on PON_AUC_DOCTYPES

Line 35: from pon_auc_doctypes d , pon_auction_headers_all pah

31: l_message_suffix varchar2(2);
32: BEGIN
33:
34: select d.MESSAGE_SUFFIX into l_message_suffix
35: from pon_auc_doctypes d , pon_auction_headers_all pah
36: where pah.auction_header_id = p_auction_header_id
37: and pah.DOCTYPE_ID = d.DOCTYPE_ID;
38:
39: l_message_suffix := '_'||l_message_suffix;

Line 908: l_prev_rnd_doctype pon_auc_doctypes.internal_name%TYPE;

904: l_bid_rate NUMBER := 1;
905: l_is_super_large_neg VARCHAR2(1) := 'N';
906: -- previous round doc type, used to decide whether to display
907: -- control "enforce supplie's previous round price as bid start price"
908: l_prev_rnd_doctype pon_auc_doctypes.internal_name%TYPE;
909: -- two-part RFQ
910: l_hide_comm_part VARCHAR2(1) := 'N';
911: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag
912: -- commercial lock status

Line 1004: FROM pon_auction_headers_all pah, pon_auc_doctypes doctypes

1000: THEN
1001: BEGIN
1002: SELECT doctypes.internal_name
1003: INTO l_prev_rnd_doctype
1004: FROM pon_auction_headers_all pah, pon_auc_doctypes doctypes
1005: WHERE pah.auction_header_id = l_auction_header_id_prev_round
1006: and pah.doctype_id = doctypes.doctype_id;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND

Line 3144: pon_auc_doctypes doctypes,

3140: fnd_territories_tl bill_territories_tl,
3141: hr_locations_all loc_ship,
3142: fnd_territories_tl ship_territories_tl,
3143: fnd_currencies_tl currency_tl ,
3144: pon_auc_doctypes doctypes,
3145: hz_parties hp1,
3146: hr_operating_units ou,
3147: hr_all_organization_units entity,
3148: hr_all_organization_units_tl entitytl,