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_SECTIONS

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 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 474: FROM PON_AUCTION_SECTIONS

470: -- Check whether the section name already exists are not
471: BEGIN
472: SELECT DISTINCT SECTION_NAME
473: INTO l_section_name_check
474: FROM PON_AUCTION_SECTIONS
475: WHERE AUCTION_HEADER_ID = c_interface_section_rec.AUCTION_HEADER_ID
476: AND SECTION_NAME = c_interface_section_rec.GROUP_NAME;
477: EXCEPTION
478: WHEN No_Data_Found THEN

Line 487: FROM PON_AUCTION_SECTIONS

483: BEGIN
484: -- get the sequence value
485: SELECT MAX(ATTR_GROUP_SEQ_NUMBER)
486: INTO l_sequence_number
487: FROM PON_AUCTION_SECTIONS
488: WHERE AUCTION_HEADER_ID = c_interface_section_rec.AUCTION_HEADER_ID;
489: EXCEPTION
490: WHEN No_Data_Found THEN
491: l_sequence_number:= NULL;

Line 494: -- insert the record in the PON_AUCTION_SECTIONS table.

490: WHEN No_Data_Found THEN
491: l_sequence_number:= NULL;
492: END;
493: l_sequence_number:=NVL(l_sequence_number,0)+10;
494: -- insert the record in the PON_AUCTION_SECTIONS table.
495: INSERT
496: INTO PON_AUCTION_SECTIONS
497: (
498: ATTRIBUTE_LIST_ID ,

Line 496: INTO PON_AUCTION_SECTIONS

492: END;
493: l_sequence_number:=NVL(l_sequence_number,0)+10;
494: -- insert the record in the PON_AUCTION_SECTIONS table.
495: INSERT
496: INTO PON_AUCTION_SECTIONS
497: (
498: ATTRIBUTE_LIST_ID ,
499: AUCTION_HEADER_ID ,
500: LINE_NUMBER ,

Line 516: PON_AUCTION_SECTIONS_S.NEXTVAL ,

512: c_interface_section_rec.AUCTION_HEADER_ID,
513: -1 ,
514: l_sequence_number ,
515: c_interface_section_rec.GROUP_NAME ,
516: PON_AUCTION_SECTIONS_S.NEXTVAL ,
517: SYSDATE ,
518: fnd_global.user_id ,
519: SYSDATE ,
520: fnd_global.user_id

Line 575: FROM PON_AUCTION_SECTIONS

571: l_sequence_number_attr:=NVL(l_sequence_number_attr,0)+10;
572: BEGIN
573: SELECT DISTINCT ATTR_GROUP_SEQ_NUMBER
574: INTO l_ATTR_GROUP_SEQ_NUMBER
575: FROM PON_AUCTION_SECTIONS
576: WHERE auction_header_id= c_interface_attr_rec.AUCTION_HEADER_ID
577: AND SECTION_NAME = c_interface_attr_rec.GROUP_NAME;
578: EXCEPTION
579: WHEN No_Data_Found THEN

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 3842: DELETE FROM pon_auction_sections 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;
3844: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
3845: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
3846: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;

Line 7058: DELETE FROM pon_auction_sections 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;
7060: DELETE FROM pon_auction_headers_ext_tl WHERE auction_header_id = l_auction_header_id;
7061: DELETE FROM pon_auction_item_prices_ext_b WHERE auction_header_id = l_auction_header_id;
7062: DELETE FROM pon_auction_item_prices_ext_tl WHERE auction_header_id = l_auction_header_id;