DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUC_PRICE_ELEMENTS_INT

Line 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;

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
3905: WHEN OTHERS THEN

Line 4908: update PON_AUC_PRICE_ELEMENTS_INT 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;
4912:

Line 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;

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:
7135:

Line 7211: update PON_AUC_PRICE_ELEMENTS_INT 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
7215: print_log('Amendment creation failed for batch ' || p_batch_id);