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_ATTRIBUTE_SCORES

Line 428: l_sequence_number_scr pon_attribute_scores_interface.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);
432: BEGIN

Line 608: FROM pon_attribute_scores_interface

604:
605: /*BEGIN
606: SELECT COUNT(*)
607: INTO l_count_acc
608: FROM pon_attribute_scores_interface
609: WHERE batch_id = c_interface_attr_rec.batch_id
610: AND auction_header_id = c_interface_attr_rec.auction_header_id
611: AND ATTRIBUTE_SEQUENCE_NUMBER = l_sequence_number_attr;
612: IF (l_count_acc > 0) THEN

Line 622: FROM pon_attribute_scores_interface

618: print_log(' Begin validating AND INSERTING acceptable VALUES');
619: BEGIN
620: SELECT COUNT(*)
621: INTO l_count_acc
622: FROM pon_attribute_scores_interface
623: WHERE batch_id = c_interface_attr_rec.batch_id
624: AND auction_header_id = c_interface_attr_rec.auction_header_id
625: AND ATTRIBUTE_SEQUENCE_NUMBER= l_sequence_number_attr;
626: IF (l_count_acc =0) THEN

Line 646: FROM pon_attribute_scores

642: print_log('End validating AND INSERTING acceptable VALUES');
643: BEGIN
644: SELECT MAX(score)
645: INTO c_interface_attr_rec.attr_max_score
646: FROM pon_attribute_scores
647: WHERE ATTRIBUTE_SEQUENCE_NUMBER=l_sequence_number_attr
648: AND auction_header_id =c_interface_attr_rec.auction_header_id;
649: EXCEPTION
650: WHEN No_Data_Found THEN

Line 752: FROM pon_attribute_scores

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
753: WHERE attribute_sequence_number= c_interface_attr_rec.sequence_number
754: AND auction_header_id = c_interface_attr_rec.auction_header_id;
755:
756: print_log('END of requirement deletion');

Line 805: p_sequence_number_attr IN pon_attribute_scores_interface.ATTRIBUTE_SEQUENCE_NUMBER%TYPE,

801: ------------------------------------------------------------------------
802: PROCEDURE acceptance_values_insert
803: (
804: p_interface_attr_rec1 IN ATTRIBUTES_VALUES_VALIDATION,
805: p_sequence_number_attr IN pon_attribute_scores_interface.ATTRIBUTE_SEQUENCE_NUMBER%TYPE,
806: l_status IN OUT NOCOPY VARCHAR2
807: ) AS
808: CURSOR c_attr_score
809: IS

Line 811: FROM pon_attribute_scores_interface

807: ) AS
808: CURSOR c_attr_score
809: IS
810: SELECT *
811: FROM pon_attribute_scores_interface
812: WHERE batch_id = p_interface_attr_rec1.l_batch_id
813: AND auction_header_id = p_interface_attr_rec1.l_auction_header_id
814: AND ATTRIBUTE_SEQUENCE_NUMBER= p_sequence_number_attr;
815:

Line 820: l_from_range pon_attribute_scores_interface.from_range%type;

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*/
824: BEGIN

Line 821: l_to_range pon_attribute_scores_interface.to_range%type;

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*/
824: BEGIN
825: SELECT MAX(SEQUENCE_NUMBER)

Line 827: FROM pon_attribute_scores

823: /* get the sequence number for a acceptable value*/
824: BEGIN
825: SELECT MAX(SEQUENCE_NUMBER)
826: INTO l_sequence_number_scr
827: FROM pon_attribute_scores
828: WHERE auction_header_id =p_interface_attr_rec1.l_auction_header_id
829: AND attribute_sequence_number=p_sequence_number_attr;
830: EXCEPTION
831: WHEN OTHERS THEN

Line 845: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD );

841: /* check if the value and score field is not null for text data type */
842: IF(p_interface_attr_rec1.l_SCORING_METHOD ='AUTOMATIC' AND p_interface_attr_rec1.l_datatype='TXT')THEN
843: IF(c_attr_score_rec.value IS NULL OR c_attr_score_rec.score IS NULL) THEN
844: print_log('score or value cannot be empty');
845: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD );
846: l_status:='N';
847: RETURN;
848: ELSE
849: /* check for the duplicate value */

Line 853: FROM pon_attribute_scores

849: /* check for the duplicate value */
850: BEGIN
851: SELECT DISTINCT Value
852: INTO l_value
853: FROM pon_attribute_scores
854: WHERE auction_header_id =p_interface_attr_rec1.l_auction_header_id
855: AND ATTRIBUTE_SEQUENCE_NUMBER= p_sequence_number_attr
856: AND Upper(Value) =upper(c_attr_score_rec.Value);
857: EXCEPTION

Line 862: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_DUP_ACC_BID_VALUES',c_attr_score_rec.value );

858: WHEN No_Data_Found THEN
859: l_value:=NULL;
860: END;
861: IF(l_value IS NOT NULL) THEN
862: pon_auc_interface_table_pkg.insert_error_interface ( c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_DUP_ACC_BID_VALUES',c_attr_score_rec.value );
863: l_status:='N';
864: RETURN;
865: END IF;
866: END IF;

Line 871: INTO pon_attribute_scores

867: --ELSE
868: l_sequence_number_scr:=NVL(l_sequence_number_scr,0)+10;
869: /* insert the score record for the text datatype*/
870: INSERT
871: INTO pon_attribute_scores
872: (
873: AUCTION_HEADER_ID ,
874: LINE_NUMBER ,
875: ATTRIBUTE_SEQUENCE_NUMBER,

Line 911: pon_auc_interface_table_pkg.insert_error_interface(c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD);

907: /* checkin the range values and score for the num and date datatype*/
908: IF(p_interface_attr_rec1.l_SCORING_METHOD='AUTOMATIC' AND (p_interface_attr_rec1.l_datatype='DAT' OR p_interface_attr_rec1.l_datatype='NUM')) THEN
909: IF((c_attr_score_rec.from_range IS NULL AND c_attr_score_rec.to_range IS NULL) OR c_attr_score_rec.score IS NULL) THEN
910: print_log('score or value cannot be empty');
911: pon_auc_interface_table_pkg.insert_error_interface(c_attr_score_rec.BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_REQUIREMENT_ERR_11',p_interface_attr_rec1.l_SCORING_METHOD);
912: l_status:='N';
913: RETURN;
914: END IF;
915: l_sequence_number_scr:=NVL(l_sequence_number_scr,0)+10;

Line 924: INTO pon_attribute_scores

920: RETURN;
921: END IF;
922: /* insert score value for NUM or DAT datatype*/
923: INSERT
924: INTO pon_attribute_scores
925: (
926: AUCTION_HEADER_ID ,
927: LINE_NUMBER ,
928: ATTRIBUTE_SEQUENCE_NUMBER,

Line 988: FROM pon_attribute_scores

984: CURSOR c_score_overlap
985: IS
986: SELECT from_range,
987: to_range
988: FROM pon_attribute_scores
989: WHERE auction_header_id =p_attr_score_rec.l_auction_header_id
990: AND attribute_sequence_number=p_attr_score_rec.l_attribute_sequence_number;
991: --l_status VARCHAR2(10):='N';
992: l_from_range pon_attribute_scores.from_range%type;

Line 992: l_from_range pon_attribute_scores.from_range%type;

988: FROM pon_attribute_scores
989: WHERE auction_header_id =p_attr_score_rec.l_auction_header_id
990: AND attribute_sequence_number=p_attr_score_rec.l_attribute_sequence_number;
991: --l_status VARCHAR2(10):='N';
992: l_from_range pon_attribute_scores.from_range%type;
993: l_to_range pon_attribute_scores.to_range%type;
994: t_from_range_num NUMBER;
995: t_to_range_num NUMBER;
996: l_from_range_num NUMBER;

Line 993: l_to_range pon_attribute_scores.to_range%type;

989: WHERE auction_header_id =p_attr_score_rec.l_auction_header_id
990: AND attribute_sequence_number=p_attr_score_rec.l_attribute_sequence_number;
991: --l_status VARCHAR2(10):='N';
992: l_from_range pon_attribute_scores.from_range%type;
993: l_to_range pon_attribute_scores.to_range%type;
994: t_from_range_num NUMBER;
995: t_to_range_num NUMBER;
996: l_from_range_num NUMBER;
997: l_to_range_num NUMBER;

Line 1022: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );

1018: l_from_range_num :=To_Number(p_attr_score_rec.l_from_range);
1019: l_to_range_num :=To_Number(p_attr_score_rec.l_to_range);
1020: IF(l_from_range_num IS NOT NULL AND l_to_range_num IS NOT NULL) THEN
1021: IF(l_from_range_num> l_to_range_num)THEN
1022: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );
1023: l_status :='N';
1024: RETURN;
1025: END IF;
1026: END IF;

Line 1030: FROM pon_attribute_scores

1026: END IF;
1027: /* if there are any score records already exists */
1028: SELECT COUNT(*)
1029: INTO l_count
1030: FROM pon_attribute_scores
1031: WHERE auction_header_id =p_attr_score_rec.l_auction_header_id
1032: AND attribute_sequence_number=p_attr_score_rec.l_attribute_sequence_number;
1033: IF(l_count < 1)THEN
1034: l_status :='Y';

Line 1048: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );

1044: t_from_range_num :=To_Number(l_from_range);
1045: t_to_range_num :=To_Number(l_to_range);
1046: IF(t_from_range_num IS NULL OR l_to_range_num IS NULL ) THEN
1047: IF(l_from_range_num <=t_to_range_num) THEN
1048: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );
1049: l_status :='N';
1050: RETURN;
1051: END IF;
1052: END IF;

Line 1055: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );

1051: END IF;
1052: END IF;
1053: IF(t_to_range_num IS NULL OR l_from_range_num IS NULL ) THEN
1054: IF(l_to_range_num >=t_from_range_num) THEN
1055: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_num );
1056: l_status :='N';
1057: RETURN;
1058: END IF;
1059: END IF;

Line 1074: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );

1070: END;
1071: END IF;
1072: l_status :=NVL(l_status,'Y');
1073: IF(l_status='N') THEN
1074: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );
1075: RETURN;
1076: END IF;
1077: END;
1078: END LOOP;

Line 1099: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );

1095: l_from_range_dat :=To_date(p_attr_score_rec.l_from_range,'dd-mm-yyyy');
1096: l_to_range_dat :=To_date(p_attr_score_rec.l_to_range,'dd-mm-yyyy');
1097: IF(l_from_range_dat IS NOT NULL AND l_to_range_dat IS NOT NULL) THEN
1098: IF(l_from_range_dat> l_to_range_dat)THEN
1099: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );
1100: l_status :='N';
1101: RETURN;
1102: END IF;
1103: END IF;

Line 1106: FROM pon_attribute_scores

1102: END IF;
1103: END IF;
1104: SELECT COUNT(*)
1105: INTO l_count
1106: FROM pon_attribute_scores
1107: WHERE auction_header_id =p_attr_score_rec.l_auction_header_id
1108: AND attribute_sequence_number=p_attr_score_rec.l_attribute_sequence_number;
1109: IF(l_count < 1)THEN
1110: l_status :='Y';

Line 1124: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );

1120: t_from_range_dat :=To_date(l_from_range,'dd-mm-yyyy');
1121: t_to_range_dat :=To_date(l_to_range,'dd-mm-yyyy');
1122: IF(t_from_range_dat IS NULL OR l_to_range_dat IS NULL ) THEN
1123: IF(l_from_range_dat <=t_to_range_dat) THEN
1124: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );
1125: l_status :='N';
1126: RETURN;
1127: END IF;
1128: END IF;

Line 1131: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );

1127: END IF;
1128: END IF;
1129: IF(t_to_range_dat IS NULL OR l_from_range_dat IS NULL ) THEN
1130: IF(l_to_range_dat >=t_from_range_dat) THEN
1131: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_FROM_TO_ERR_NUM_R',l_from_range_dat );
1132: l_status :='N';
1133: RETURN;
1134: END IF;
1135: END IF;

Line 1150: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );

1146: END;
1147: END IF;
1148: l_status :=NVL(l_status,'Y');
1149: IF(l_status='N') THEN
1150: pon_auc_interface_table_pkg.insert_error_interface ( p_attr_score_rec.l_BATCH_ID,NULL,'pon_attribute_scores_interface','PON','PON_AUC_OVERLAP_RANGES',p_attr_score_rec.l_from_range );
1151: RETURN;
1152: END IF;
1153: END;
1154: END LOOP;

Line 2445: UPDATE pon_attribute_scores_interface

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
2447: WHERE batch_id = p_batch_id
2448: AND auction_header_id = p_auction_header_id
2449: AND line_number = c_line_num

Line 2509: INTO pon_attribute_scores

2505: WHERE paa.auction_header_id = c_scored_atts_rec.auction_header_id
2506: AND paa.line_number = c_scored_atts_rec.auction_line_number
2507: AND paa.sequence_number = c_scored_atts_rec.sequence_number;
2508: INSERT
2509: INTO pon_attribute_scores
2510: (
2511: AUCTION_HEADER_ID ,
2512: LINE_NUMBER ,
2513: ATTRIBUTE_SEQUENCE_NUMBER,

Line 2538: FROM pon_attribute_scores_interface pasi

2534: SYSDATE ,
2535: g_user_id ,
2536: SYSDATE ,
2537: g_user_id
2538: FROM pon_attribute_scores_interface pasi
2539: WHERE pasi.batch_id = p_batch_id
2540: AND pasi.auction_header_id = p_auction_Header_id
2541: AND NVL(pasi.line_number,-1) <> -1
2542: AND pasi.line_number = c_scored_atts_rec.auction_line_number

Line 3583: FROM pon_attribute_scores_interface pasi

3579: END IF; --}
3580: INSERT ALL
3581: WHEN(NOT EXISTS
3582: (SELECT 'Y'
3583: FROM pon_attribute_scores_interface pasi
3584: WHERE pasi.batch_id = p_batch_id
3585: AND pasi.line_number = line_num
3586: AND pasi.attribute_sequence_number = seq_num
3587: )

Line 3592: FROM pon_attribute_scores pas

3588: -- it is possible that scores can exist from previous round/amendment
3589: -- we need not expect attribute scores in such cases.
3590: AND NOT EXISTS
3591: (SELECT 'Y'
3592: FROM pon_attribute_scores pas
3593: WHERE pas.auction_header_id = p_auction_header_id
3594: AND pas.line_number = line_num
3595: AND pas.attribute_sequence_number = seq_num
3596: )) THEN

Line 3719: FROM pon_attribute_scores_interface pasi,

3715: )
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

Line 3841: DELETE FROM pon_attribute_scores 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;
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;

Line 3898: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;

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;
3902: BEGIN

Line 4905: update pon_attribute_scores_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

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;
4909: update pon_auc_price_breaks_interface SET auction_header_id = neg_header_record_data.auction_header_id WHERE batch_id = p_batch_id;

Line 7057: DELETE FROM pon_attribute_scores 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;
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;

Line 7128: update pon_attribute_scores_interface SET batch_id = p_batch_id, LINE_NUMBER = interface_line_id WHERE interface_header_id = p_batch_id;

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

Line 7208: update pon_attribute_scores_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;

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;
7212: update pon_auc_price_breaks_interface SET auction_header_id = x_auction_header_id WHERE batch_id = p_batch_id;