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 1168: pon_auc_doctypes doc,

1164: from pon_auction_headers_all paha,
1165: pon_bidding_parties pbp,
1166: fnd_lookup_values fl,
1167: fnd_lookups fl1,
1168: pon_auc_doctypes doc,
1169: HZ_PARTIES hz
1170: where paha.auction_header_id = p_auction_header_id
1171: and pbp.auction_header_id = paha.auction_header_id
1172: and pbp.sequence = p_supplier_sequence

Line 1416: pon_auc_doctypes doc,

1412: pon_emd_transactions petr,
1413: pon_bidding_parties pbp,
1414: fnd_lookup_values fl,
1415: fnd_lookups fl1,
1416: pon_auc_doctypes doc,
1417: HZ_PARTIES hz
1418: where paha.auction_header_id = p_auction_header_id
1419: and pbp.auction_header_id = paha.auction_header_id
1420: --Begin: Added by Chaoqun on 22-DEC-2008

Line 1634: pon_auc_doctypes doc,

1630: pon_emd_transactions petr,
1631: pon_bidding_parties pbp,
1632: fnd_lookup_values flv,
1633: HR_ALL_ORGANIZATION_UNITS_TL ou,
1634: pon_auc_doctypes doc,
1635: fnd_lookups f1,
1636: HZ_PARTIES hz
1637: where paha.auction_header_id = p_auction_header_id
1638: and petr.auction_header_id = paha.auction_header_id

Line 1843: l_prev_rnd_doctype pon_auc_doctypes.internal_name%TYPE;

1839: l_bid_rate NUMBER := 1;
1840: l_is_super_large_neg VARCHAR2(1) := 'N';
1841: -- previous round doc type, used to decide whether to display
1842: -- control "enforce supplie's previous round price as bid start price"
1843: l_prev_rnd_doctype pon_auc_doctypes.internal_name%TYPE;
1844: -- two-part RFQ
1845: l_hide_comm_part VARCHAR2(1) := 'N';
1846: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag
1847: -- commercial lock status

Line 1951: FROM pon_auction_headers_all pah, pon_auc_doctypes doctypes

1947: THEN
1948: BEGIN
1949: SELECT doctypes.internal_name
1950: INTO l_prev_rnd_doctype
1951: FROM pon_auction_headers_all pah, pon_auc_doctypes doctypes
1952: WHERE pah.auction_header_id = l_auction_header_id_prev_round
1953: and pah.doctype_id = doctypes.doctype_id;
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND

Line 2565: pon_auc_doctypes doctypes,

2561: fnd_territories_tl bill_territories_tl,
2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,
2564: fnd_currencies_tl currency_tl ,
2565: pon_auc_doctypes doctypes,
2566: hz_parties hp1,
2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
2569: hr_all_organization_units_tl entitytl,

Line 4791: pon_auc_doctypes doctypes,

4787: select substr(message_name,1,length(message_name)-2) message_name,
4788: message_text
4789: FROM
4790: pon_auction_headers_all pah,
4791: pon_auc_doctypes doctypes,
4792: fnd_new_messages msgs
4793: where pah.auction_header_id = p_auction_header_id
4794: AND doctypes.doctype_id = pah.doctype_id
4795: AND msgs.message_name in (