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_AUC_ATTRIBUTES_INTERFACE

Line 351: --Description : Warpper on PON APIs to copy the data from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS and PON_AUCTION_ATTRIBUTES

347:
348: -----------------------------------------------------------------------
349: --Start of Comments
350: --Name: create_header_attr_inter
351: --Description : Warpper on PON APIs to copy the data from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS and PON_AUCTION_ATTRIBUTES
352: --Parameters:
353: --IN:
354: -- p_api_version
355: -- p_init_msg_list

Line 381: FROM PON_AUC_ATTRIBUTES_INTERFACE

377: AUCTION_HEADER_ID ,
378: AUCTION_LINE_NUMBER ,
379: ATTR_GROUP_SEQ_NUMBER ,
380: ACTION
381: FROM PON_AUC_ATTRIBUTES_INTERFACE
382: WHERE BATCH_ID =batchId
383: AND AUCTION_HEADER_ID IN
384: (SELECT DISTINCT AUCTION_HEADER_ID FROM PON_AUC_ATTRIBUTES_INTERFACE
385: )

Line 384: (SELECT DISTINCT AUCTION_HEADER_ID FROM PON_AUC_ATTRIBUTES_INTERFACE

380: ACTION
381: FROM PON_AUC_ATTRIBUTES_INTERFACE
382: WHERE BATCH_ID =batchId
383: AND AUCTION_HEADER_ID IN
384: (SELECT DISTINCT AUCTION_HEADER_ID FROM PON_AUC_ATTRIBUTES_INTERFACE
385: )
386: AND AUCTION_LINE_NUMBER = -1;
387: -- cursor to get the values from interface tables for requirements
388: CURSOR c_interface_attr

Line 412: FROM PON_AUC_ATTRIBUTES_INTERFACE

408: INTERNAL_ATTR_FLAG ,
409: SCORING_METHOD ,
410: KNOCKOUT_SCORE ,
411: ACTION
412: FROM PON_AUC_ATTRIBUTES_INTERFACE
413: WHERE BATCH_ID =batchId
414: AND AUCTION_LINE_NUMBER = -1;
415:
416: c_interface_section_rec c_interface_section%ROWTYPE;

Line 418: l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE;

414: AND AUCTION_LINE_NUMBER = -1;
415:
416: c_interface_section_rec c_interface_section%ROWTYPE;
417: c_interface_attr_rec c_interface_attr%ROWTYPE;
418: l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE;
419: l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE;
420: l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE;
421: l_section_name_check PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE;
422: l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE;

Line 419: l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE;

415:
416: c_interface_section_rec c_interface_section%ROWTYPE;
417: c_interface_attr_rec c_interface_attr%ROWTYPE;
418: l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE;
419: l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE;
420: l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE;
421: l_section_name_check PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE;
422: l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE;
423: l_sequence_number_attr PON_AUCTION_ATTRIBUTES.SEQUENCE_NUMBER%TYPE;

Line 420: l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE;

416: c_interface_section_rec c_interface_section%ROWTYPE;
417: c_interface_attr_rec c_interface_attr%ROWTYPE;
418: l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE;
419: l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE;
420: l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE;
421: l_section_name_check PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE;
422: l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE;
423: l_sequence_number_attr PON_AUCTION_ATTRIBUTES.SEQUENCE_NUMBER%TYPE;
424: l_ATTR_GROUP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_GROUP_SEQ_NUMBER%TYPE;

Line 421: l_section_name_check PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE;

417: c_interface_attr_rec c_interface_attr%ROWTYPE;
418: l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE;
419: l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE;
420: l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE;
421: l_section_name_check PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE;
422: l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE;
423: l_sequence_number_attr PON_AUCTION_ATTRIBUTES.SEQUENCE_NUMBER%TYPE;
424: l_ATTR_GROUP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_GROUP_SEQ_NUMBER%TYPE;
425: l_ATTR_DISP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_DISP_SEQ_NUMBER%TYPE;

Line 427: l_TABLE_NAME pon_interface_errors.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';

423: l_sequence_number_attr PON_AUCTION_ATTRIBUTES.SEQUENCE_NUMBER%TYPE;
424: l_ATTR_GROUP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_GROUP_SEQ_NUMBER%TYPE;
425: l_ATTR_DISP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_DISP_SEQ_NUMBER%TYPE;
426: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%TYPE;
427: l_TABLE_NAME pon_interface_errors.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';
428: l_sequence_number_scr pon_attribute_scores_interface.sequence_number%TYPE;
429: l_status VARCHAR2(1) :='Y';
430: l_count_acc NUMBER;
431: l_sum_wt_err VARCHAR(10);

Line 461: /* Insertion of section values from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS table */

457: END IF;
458: print_log('END Validating the data in interface table');
459:
460: print_log('BEGIN of section insertion');
461: /* Insertion of section values from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS table */
462: OPEN c_interface_section;
463: LOOP
464: FETCH c_interface_section INTO c_interface_section_rec;
465: EXIT

Line 787: --Description : Warpper on PON APIs to copy the data from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS and PON_AUCTION_ATTRIBUTES

783: END create_header_attr_inter;
784: -----------------------------------------------------------------------
785: --Start of Comments
786: --Name: acceptance_values_insert
787: --Description : Warpper on PON APIs to copy the data from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS and PON_AUCTION_ATTRIBUTES
788: --Parameters:
789: --IN:
790: -- p_api_version
791: -- p_auction_header_id

Line 817: l_sequence_number_scr pon_auc_attributes_interface.sequence_number%type;

813: AND auction_header_id = p_interface_attr_rec1.l_auction_header_id
814: AND ATTRIBUTE_SEQUENCE_NUMBER= p_sequence_number_attr;
815:
816: c_attr_score_rec c_attr_score%ROWTYPE;
817: l_sequence_number_scr pon_auc_attributes_interface.sequence_number%type;
818: c_interface_attr_rec ATTRIBUTES_VALUES_VALIDATION;
819: l_value pon_auc_attributes_interface.Value%type;
820: l_from_range pon_attribute_scores_interface.from_range%type;
821: l_to_range pon_attribute_scores_interface.to_range%type;

Line 819: l_value pon_auc_attributes_interface.Value%type;

815:
816: c_attr_score_rec c_attr_score%ROWTYPE;
817: l_sequence_number_scr pon_auc_attributes_interface.sequence_number%type;
818: c_interface_attr_rec ATTRIBUTES_VALUES_VALIDATION;
819: l_value pon_auc_attributes_interface.Value%type;
820: l_from_range pon_attribute_scores_interface.from_range%type;
821: l_to_range pon_attribute_scores_interface.to_range%type;
822: BEGIN
823: /* get the sequence number for a acceptable value*/

Line 965: --Description : Warpper on PON APIs to copy the data from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS and PON_AUCTION_ATTRIBUTES

961: END;
962: -----------------------------------------------------------------------
963: --Start of Comments
964: --Name: check_range_overlap
965: --Description : Warpper on PON APIs to copy the data from PON_AUC_ATTRIBUTES_INTERFACE interface table to PON_AUCTION_SECTIONS and PON_AUCTION_ATTRIBUTES
966: --Parameters:
967: --IN:
968: -- p_attr_score_rec
969: -- p_datatype

Line 980: p_datatype IN pon_auc_attributes_interface.datatype%type ,

976: ------------------------------------------------------------------------
977: PROCEDURE check_range_overlap
978: (
979: p_attr_score_rec IN ATTRIBUTE_SCORES,
980: p_datatype IN pon_auc_attributes_interface.datatype%type ,
981: l_status OUT NOCOPY VARCHAR2
982: )
983: IS
984: CURSOR c_score_overlap

Line 2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;

2180: l_currency_code pon_auction_headers_all.currency_code%type;
2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;
2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;
2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;
2187: c_seq_num2 pon_auc_attributes_interface.sequence_number%TYPE;
2188: l_scores_absent VARCHAR2(1) := 'N';

Line 2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;

2181: l_price_precision NUMBER;
2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;
2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;
2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;
2187: c_seq_num2 pon_auc_attributes_interface.sequence_number%TYPE;
2188: l_scores_absent VARCHAR2(1) := 'N';
2189: l_precision NUMBER;

Line 2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;

2182: l_auction_round_number pon_auction_headers_all.auction_round_number%type;
2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;
2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;
2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;
2187: c_seq_num2 pon_auc_attributes_interface.sequence_number%TYPE;
2188: l_scores_absent VARCHAR2(1) := 'N';
2189: l_precision NUMBER;
2190: l_ext_precision NUMBER;

Line 2187: c_seq_num2 pon_auc_attributes_interface.sequence_number%TYPE;

2183: l_amendment_number pon_auction_headers_all.amendment_number%TYPE;
2184: c_att_name pon_auc_attributes_interface.attribute_name%TYPE;
2185: c_line_num pon_auc_attributes_interface.auction_line_number%TYPE;
2186: c_seq_num pon_auc_attributes_interface.sequence_number%TYPE;
2187: c_seq_num2 pon_auc_attributes_interface.sequence_number%TYPE;
2188: l_scores_absent VARCHAR2(1) := 'N';
2189: l_precision NUMBER;
2190: l_ext_precision NUMBER;
2191: l_minAcctUnit NUMBER;

Line 2211: FROM PON_AUC_ATTRIBUTES_INTERFACE

2207: SCORING_TYPE ,
2208: datatype ,
2209: ATTR_MAX_SCORE ,
2210: WEIGHT
2211: FROM PON_AUC_ATTRIBUTES_INTERFACE
2212: WHERE batch_id = p_batch_id
2213: AND NVL(SCORING_TYPE,'NONE') <> 'NONE'
2214: AND auction_LINE_NUMBER <> -1;
2215: CURSOR c_new_attributes

Line 2220: FROM pon_auc_attributes_interface paa_int,

2216: IS
2217: SELECT paa_int.attribute_name att_name,
2218: paa_int.auction_line_number line_num ,
2219: paa_int.sequence_number
2220: FROM pon_auc_attributes_interface paa_int,
2221: pon_item_prices_interface p1
2222: WHERE paa_int.batch_id = p_batch_id
2223: AND p1.batch_id = paa_int.batch_id
2224: AND p1.action = g_update_action

Line 2442: UPDATE pon_auc_attributes_interface

2438: FROM pon_auction_attributes
2439: WHERE auction_header_id = p_auction_HEAder_id
2440: AND line_number = c_line_num
2441: AND attribute_name = c_att_name;
2442: UPDATE pon_auc_attributes_interface
2443: SET sequence_number = c_seq_num2
2444: WHERE CURRENT OF c_new_attributes;
2445: UPDATE pon_attribute_scores_interface
2446: SET attribute_sequence_number = c_seq_num2

Line 3639: FROM PON_AUC_ATTRIBUTES_INTERFACE PAAI

3635: paai.auction_line_number line_num,
3636: paai.sequence_number seq_num ,
3637: NULL ,
3638: p_user_id
3639: FROM PON_AUC_ATTRIBUTES_INTERFACE PAAI
3640: WHERE paai.batch_id = p_batch_id
3641: AND paai.auction_header_id = p_auction_header_id
3642: AND NVL(paai.SCORING_TYPE,'NONE') <> 'NONE' ;
3643:

Line 3720: PON_AUC_ATTRIBUTES_INTERFACE paai

3716: SELECT pasi.SCORE,
3717: pasi.LINE_NUMBER,
3718: TRUNC (pasi.SCORE) sel_trunc_score
3719: FROM pon_attribute_scores_interface pasi,
3720: PON_AUC_ATTRIBUTES_INTERFACE paai
3721: WHERE pasi.batch_id = p_batch_id
3722: AND pasi.auction_header_id = p_auction_Header_id
3723: AND NVL(pasi.line_number,-1) <> -1
3724: AND pasi.batch_id = paai.batch_id

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

3893: neg_header_record_data := l_empty_header_rec;
3894:
3895: update pon_auction_headers_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;

Line 4904: update PON_AUC_ATTRIBUTES_INTERFACE SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

4900: ,neg_header_record_data.AMENDUPDATED_AFTERCDGENERATED
4901: );
4902:
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;

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

7123: x_return_status := 'S';
7124:
7125: update pon_auction_headers_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;

Line 7207: update PON_AUC_ATTRIBUTES_INTERFACE SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

7203:
7204: IF ( x_return_status = 'S' ) THEN
7205: print_log(' Updating interface tables with auction_header_id ' || x_auction_header_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;