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_AUCTION_ATTRIBUTES

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 422: l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE;

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;
426: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%TYPE;

Line 423: l_sequence_number_attr PON_AUCTION_ATTRIBUTES.SEQUENCE_NUMBER%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;
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';

Line 424: l_ATTR_GROUP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_GROUP_SEQ_NUMBER%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;
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;

Line 425: l_ATTR_DISP_SEQ_NUMBER PON_AUCTION_ATTRIBUTES.ATTR_DISP_SEQ_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;
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';

Line 426: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%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;
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;

Line 565: FROM pon_auction_attributes

561: /* getting the sequence number, attr group sequence number, attr display sequence number */
562: BEGIN
563: SELECT MAX(SEQUENCE_NUMBER)
564: INTO l_sequence_number_attr
565: FROM pon_auction_attributes
566: WHERE AUCTION_HEADER_ID = c_interface_attr_rec.AUCTION_HEADER_ID;
567: EXCEPTION
568: WHEN No_Data_Found THEN
569: l_sequence_number_attr:= NULL;

Line 585: FROM PON_AUCTION_ATTRIBUTES

581: END;
582: BEGIN
583: SELECT MAX(ATTR_DISP_SEQ_NUMBER)
584: INTO l_ATTR_DISP_SEQ_NUMBER
585: FROM PON_AUCTION_ATTRIBUTES
586: WHERE auction_header_id= c_interface_attr_rec.AUCTION_HEADER_ID
587: AND SECTION_NAME = c_interface_attr_rec.GROUP_NAME;
588: EXCEPTION
589: WHEN No_Data_Found THEN

Line 616: -- insertion of data into pon_auction_attributes

612: IF (l_count_acc > 0) THEN
613: c_interface_attr_rec.SCORING_METHOD:= Nvl(c_interface_attr_rec.SCORING_METHOD,'AUTOMATIC');
614: END IF;
615: END; */
616: -- insertion of data into pon_auction_attributes
617: IF (c_interface_attr_rec.SCORING_METHOD= 'AUTOMATIC') THEN
618: print_log(' Begin validating AND INSERTING acceptable VALUES');
619: BEGIN
620: SELECT COUNT(*)

Line 674: INTO pon_auction_attributes

670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672: print_log('END Validating the requirement before inserting');
673: INSERT
674: INTO pon_auction_attributes
675: (
676: ATTRIBUTE_LIST_ID ,
677: AUCTION_HEADER_ID ,
678: LINE_NUMBER ,

Line 741: FROM pon_auction_attributes

737: print_log('Begin of requirement deletion');
738: BEGIN
739: SELECT sequence_number
740: INTO c_interface_attr_rec.sequence_number
741: FROM pon_auction_attributes
742: WHERE ATTRIBUTE_NAME= c_interface_attr_rec.attribute_name;
743: EXCEPTION
744: WHEN No_Data_Found THEN
745: print_log('No record to delete');

Line 748: FROM pon_auction_attributes

744: WHEN No_Data_Found THEN
745: print_log('No record to delete');
746: END;
747: DELETE
748: FROM pon_auction_attributes
749: WHERE sequence_number = c_interface_attr_rec.sequence_number
750: AND auction_header_id = c_interface_attr_rec.auction_header_id;
751: DELETE
752: FROM pon_attribute_scores

Line 762: FROM pon_auction_attributes paa

758: END;
759: END LOOP;
760:
761: SELECT Decode(Sum(Nvl(weight,0)),100,'Y','N') INTO l_sum_wt_err
762: FROM pon_auction_attributes paa
763: WHERE paa.auction_Header_id = l_auction_header_id
764: AND Nvl(paa.scoring_METHOD,'NONE') <>'NONE'
765: AND EXISTS(SELECT 'Y' FROM PON_AUCtion_ATTRIBUTES paa,pon_auction_Headers_all pah WHERE paa.auction_Header_id = l_auction_header_id
766: AND paa.auction_Header_id = pah.auction_Header_id

Line 765: AND EXISTS(SELECT 'Y' FROM PON_AUCtion_ATTRIBUTES paa,pon_auction_Headers_all pah WHERE paa.auction_Header_id = l_auction_header_id

761: SELECT Decode(Sum(Nvl(weight,0)),100,'Y','N') INTO l_sum_wt_err
762: FROM pon_auction_attributes paa
763: WHERE paa.auction_Header_id = l_auction_header_id
764: AND Nvl(paa.scoring_METHOD,'NONE') <>'NONE'
765: AND EXISTS(SELECT 'Y' FROM PON_AUCtion_ATTRIBUTES paa,pon_auction_Headers_all pah WHERE paa.auction_Header_id = l_auction_header_id
766: AND paa.auction_Header_id = pah.auction_Header_id
767: AND Nvl(pah.HDR_ATTR_ENABLE_WEIGHTS,'N') = 'Y'
768: AND Nvl(paa.scoring_METHOD,'NONE') <>'NONE');
769:

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 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 1189: l_LAST_AMENDMENT_UPDATE PON_AUCTION_ATTRIBUTES.LAST_AMENDMENT_UPDATE%TYPE;

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;
1190: l_NEG_TEAM_ENABLED_FLAG PON_AUCTION_HEADERS_ALL.NEG_TEAM_ENABLED_FLAG%TYPE;
1191: l_user_id FND_USER.USER_ID%TYPE;
1192: l_check VARCHAR2(20);
1193: BEGIN

Line 2229: FROM pon_auction_attributes auction_attributes

2225: AND paa_int.auction_line_number = p1.auction_line_number
2226: AND paa_int.auction_LINE_NUMBER <> -1
2227: AND NOT EXISTS
2228: (SELECT 'x'
2229: FROM pon_auction_attributes auction_attributes
2230: WHERE paa_int.auction_header_id = auction_attributes.auction_header_id
2231: AND paa_int.auction_line_number = auction_attributes.line_number
2232: AND paa_int.attribute_name = auction_attributes.attribute_name
2233: )

Line 2438: FROM pon_auction_attributes

2434:
2435: BEGIN
2436: SELECT sequence_number
2437: INTO c_seq_num2
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

Line 2501: UPDATE pon_auction_attributes paa

2497:
2498: print_log('END Validating the data in scores interface table');
2499: FOR c_scored_atts_rec IN c_attributes_with_scoring
2500: LOOP
2501: UPDATE pon_auction_attributes paa
2502: SET paa.SCORING_TYPE = c_scored_atts_rec.scoring_type,
2503: paa.WEIGHT = c_scored_atts_rec.WEIGHT ,
2504: paa.ATTR_MAX_SCORE = c_scored_atts_rec.ATTR_MAX_SCORE
2505: WHERE paa.auction_header_id = c_scored_atts_rec.auction_header_id

Line 3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;

3835: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
3836: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
3837: DELETE FROM pon_auc_payments_shipments WHERE auction_header_id = l_auction_header_id;
3838: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
3839: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
3840: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
3841: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
3842: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
3843: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;

Line 7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;

7051: DELETE FROM pon_auction_item_prices_all WHERE auction_header_id = l_auction_header_id;
7052: DELETE FROM pon_price_elements WHERE auction_header_id = l_auction_header_id;
7053: DELETE FROM pon_auction_shipments_all WHERE auction_header_id = l_auction_header_id;
7054: DELETE FROM pon_neg_team_members WHERE auction_header_id = l_auction_header_id;
7055: DELETE FROM pon_auction_attributes WHERE auction_header_id = l_auction_header_id;
7056: DELETE FROM pon_bidding_parties WHERE auction_header_id = l_auction_header_id;
7057: DELETE FROM pon_attribute_scores WHERE auction_header_id = l_auction_header_id;
7058: DELETE FROM pon_auction_sections WHERE auction_header_id = l_auction_header_id;
7059: DELETE FROM pon_auction_headers_ext_b WHERE auction_header_id = l_auction_header_id;