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_OPEN_INTERFACE_PVT dependencies on PON_NEG_TEAM_INTERFACE

Line 1161: --Description : Warpper on PON APIs to copy the data from PON_NEG_TEAM_INTERFACE interface table to PON_NEG_TEAM_MEMBERS

1157: END;
1158: -----------------------------------------------------------------------
1159: --Start of Comments
1160: --Name: create_neg_team
1161: --Description : Warpper on PON APIs to copy the data from PON_NEG_TEAM_INTERFACE interface table to PON_NEG_TEAM_MEMBERS
1162: --Parameters:
1163: --IN:
1164: -- p_api_version
1165: -- p_init_msg_list

Line 1182: /* cursor to get the data from the PON_NEG_TEAM_INTERFACE table */

1178: batchId IN NUMBER,
1179: x_return_status IN OUT NOCOPY VARCHAR2
1180: )
1181: IS
1182: /* cursor to get the data from the PON_NEG_TEAM_INTERFACE table */
1183: CURSOR c_interface_neg_team
1184: IS
1185: SELECT * FROM PON_NEG_TEAM_INTERFACE WHERE BATCH_ID =batchId
1186: AND user_name <> neg_header_record_data.trading_partner_contact_name;

Line 1185: SELECT * FROM PON_NEG_TEAM_INTERFACE WHERE BATCH_ID =batchId

1181: IS
1182: /* cursor to get the data from the PON_NEG_TEAM_INTERFACE table */
1183: CURSOR c_interface_neg_team
1184: IS
1185: SELECT * FROM PON_NEG_TEAM_INTERFACE WHERE BATCH_ID =batchId
1186: AND user_name <> neg_header_record_data.trading_partner_contact_name;
1187:
1188: c_interface_neg_team_rec c_interface_neg_team%ROWTYPE;
1189: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%TYPE;

Line 3900: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

3896: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3897: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3898: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
3899: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3900: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
3901: update PON_AUC_PRICE_ELEMENTS_INT SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3902: BEGIN
3903: update pon_auc_payments_interface SET batch_id = p_batch_id, document_disp_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
3904: EXCEPTION

Line 4907: update PON_NEG_TEAM_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

4903: update pon_item_prices_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4904: update PON_AUC_ATTRIBUTES_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4905: update pon_attribute_scores_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4906: update pon_bid_parties_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4907: update PON_NEG_TEAM_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4908: update PON_AUC_PRICE_ELEMENTS_INT SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4909: update pon_auc_price_breaks_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4910: update pon_auc_price_differ_int SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;
4911: --x_auction_header_id := neg_header_record_data.auction_header_id;

Line 7130: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;

7126: update pon_item_prices_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7127: update PON_AUC_ATTRIBUTES_INTERFACE SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7128: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;
7129: update pon_bid_parties_interface SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7130: update PON_NEG_TEAM_INTERFACE SET batch_id = p_batch_id WHERE interface_header_id = p_batch_id;
7131: update PON_AUC_PRICE_ELEMENTS_INT SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7132: update pon_auc_price_breaks_interface SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7133: update pon_auc_price_differ_int SET batch_id = p_batch_id, auction_line_number = interface_line_id WHERE interface_header_id = p_batch_id;
7134:

Line 7210: update PON_NEG_TEAM_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

7206: update pon_item_prices_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7207: update PON_AUC_ATTRIBUTES_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7208: update pon_attribute_scores_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7209: update pon_bid_parties_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7210: update PON_NEG_TEAM_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7211: update PON_AUC_PRICE_ELEMENTS_INT SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7212: update pon_auc_price_breaks_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7213: update pon_auc_price_differ_int SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;
7214: ELSE