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

Line 55: l_auction_header_id pon_auction_headers_all.auction_header_id%type;

51: x_msg_count OUT NOCOPY NUMBER
52: ) IS
53: l_api_version NUMBER := 1;
54: l_api_name VARCHAR2(30) := 'IS_OK_TO_COMMIT';
55: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
56: l_auction_status pon_auction_headers_all.auction_status%type;
57: BEGIN
58: -- Initialize API return status to unexpected error
59: x_update_allowed := fnd_api.g_false;

Line 56: l_auction_status pon_auction_headers_all.auction_status%type;

52: ) IS
53: l_api_version NUMBER := 1;
54: l_api_name VARCHAR2(30) := 'IS_OK_TO_COMMIT';
55: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
56: l_auction_status pon_auction_headers_all.auction_status%type;
57: BEGIN
58: -- Initialize API return status to unexpected error
59: x_update_allowed := fnd_api.g_false;
60: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 104: pon_auction_headers_all auction

100: hz_parties user_parties,
101: hz_parties company_parties,
102: hz_relationships,
103: hz_code_assignments,
104: pon_auction_headers_all auction
105: where
106: fnd_user.user_id = fnd_global.user_id()
107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id

Line 156: * pon_auction_headers_all.auction_header_id

152: * Initialize message list
153: * p_doctype_id
154: * Contracts Doc Type; one of 'RFQ', 'RFQ_RESPONSE', etc
155: * p_doc_id
156: * pon_auction_headers_all.auction_header_id
157: * IN OUT:
158: * p_sys_var_value_tbl
159: * A table of records to hold the system variable codes and values
160: * OUT:

Line 457: pon_auction_headers_all pah,

453: l_pon_sys_vars(71).variable_value_id,
454: -- ECO 4241852
455: l_pon_sys_vars(72).variable_value_id
456: from
457: pon_auction_headers_all pah,
458: pon_bid_headers pbh,
459: hr_all_organization_units ou
460: where
461: pbh.bid_number = p_doc_id and

Line 713: pon_auction_headers_all pah,

709: l_pon_sys_vars(72).variable_value_id,
710: -- ECO 4241852
711: l_pon_sys_vars(73).variable_value_id
712: from
713: pon_auction_headers_all pah,
714: hr_all_organization_units ou
715: where
716: pah.auction_header_id = p_doc_id and
717: pah.org_id = ou.organization_id(+) and

Line 827: * pon_auction_headers_all.auction_header_id

823: * Initialize message list
824: * p_doctype_id
825: * Contracts Doc Type; one of 'RFQ', 'RFQ_RESPONSE', etc
826: * p_doc_id
827: * pon_auction_headers_all.auction_header_id
828: * IN OUT:
829: * p_sys_var_tbl
830: * A table of records to hold the system variable codes which changed
831: * between the two revisions. Contracts will pass a list of all variables

Line 857: l_prev_header_id pon_auction_headers_all.auction_header_id%type;

853: x_msg_count OUT NOCOPY NUMBER
854: ) IS
855: l_api_name VARCHAR2(60) := g_package_name || '.get_changed_variables';
856: l_api_version NUMBER := 1.0;
857: l_prev_header_id pon_auction_headers_all.auction_header_id%type;
858: l_prev_round_id pon_auction_headers_all.auction_header_id%type;
859: l_prev_amend_id pon_auction_headers_all.auction_header_id%type;
860: l_pon_sys_vars OKC_TERMS_UTIL_GRP.variable_code_tbl_type;
861: l_sys_var_index BINARY_INTEGER;

Line 858: l_prev_round_id pon_auction_headers_all.auction_header_id%type;

854: ) IS
855: l_api_name VARCHAR2(60) := g_package_name || '.get_changed_variables';
856: l_api_version NUMBER := 1.0;
857: l_prev_header_id pon_auction_headers_all.auction_header_id%type;
858: l_prev_round_id pon_auction_headers_all.auction_header_id%type;
859: l_prev_amend_id pon_auction_headers_all.auction_header_id%type;
860: l_pon_sys_vars OKC_TERMS_UTIL_GRP.variable_code_tbl_type;
861: l_sys_var_index BINARY_INTEGER;
862: l_pon_var_index BINARY_INTEGER;

Line 859: l_prev_amend_id pon_auction_headers_all.auction_header_id%type;

855: l_api_name VARCHAR2(60) := g_package_name || '.get_changed_variables';
856: l_api_version NUMBER := 1.0;
857: l_prev_header_id pon_auction_headers_all.auction_header_id%type;
858: l_prev_round_id pon_auction_headers_all.auction_header_id%type;
859: l_prev_amend_id pon_auction_headers_all.auction_header_id%type;
860: l_pon_sys_vars OKC_TERMS_UTIL_GRP.variable_code_tbl_type;
861: l_sys_var_index BINARY_INTEGER;
862: l_pon_var_index BINARY_INTEGER;
863: l_progress NUMBER := 0;

Line 943: pon_auction_headers_all

939: into
940: l_prev_round_id,
941: l_prev_amend_id
942: from
943: pon_auction_headers_all
944: where
945: auction_header_id = p_doc_id;
946: exception
947: when no_data_found then

Line 1081: pon_auction_headers_all pah1,

1077: l_pon_sys_vars(42),
1078: -- ECO 4241852
1079: l_pon_sys_vars(43)
1080: from
1081: pon_auction_headers_all pah1,
1082: pon_auction_headers_all pah2,
1083: hr_all_organization_units ou1,
1084: hr_all_organization_units ou2
1085: where

Line 1082: pon_auction_headers_all pah2,

1078: -- ECO 4241852
1079: l_pon_sys_vars(43)
1080: from
1081: pon_auction_headers_all pah1,
1082: pon_auction_headers_all pah2,
1083: hr_all_organization_units ou1,
1084: hr_all_organization_units ou2
1085: where
1086: pah1.auction_header_id = p_doc_id and

Line 1210: l_auction_header_id pon_auction_headers_all.auction_header_id%type;

1206: x_msg_count OUT NOCOPY NUMBER
1207: ) IS
1208: l_api_version NUMBER := 1;
1209: l_api_name VARCHAR2(30) := 'GET_ITEM_CATEGORY';
1210: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1211: l_index NUMBER;
1212: TYPE category_tbl IS TABLE OF pon_auction_item_prices_all.category_name%TYPE;
1213: l_category_tbl category_tbl;
1214: TYPE item_tbl IS TABLE OF pon_auction_item_prices_all.item_number%TYPE;