670:
671: -- Update FTE_LANE_RATE_CHARTS
672: UPDATE fte_lane_rate_charts
673: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
674: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
675: LAST_UPDATE_DATE = sysdate,
676: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
677: WHERE list_header_id = p_old_id
678: AND lane_id = l_lane_id;
672: UPDATE fte_lane_rate_charts
673: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
674: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
675: LAST_UPDATE_DATE = sysdate,
676: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
677: WHERE list_header_id = p_old_id
678: AND lane_id = l_lane_id;
679:
680: -- Update QP_LIST_HEADERS_B
683: END IF;
684:
685: UPDATE qp_list_headers_b
686: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
687: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
688: LAST_UPDATE_DATE = sysdate,
689: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
690: WHERE list_header_id = p_old_id;
691:
685: UPDATE qp_list_headers_b
686: SET end_date_active = LEAST(end_date_active, l_new_start_date-0.00001),
687: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
688: LAST_UPDATE_DATE = sysdate,
689: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
690: WHERE list_header_id = p_old_id;
691:
692:
693: -- I have to check if the new Rate Chart has date overlapping
921: 'US',
922: 'US',
923: sysdate,
924: sysdate,
925: FND_GLOBAL.USER_ID,
926: FND_GLOBAL.USER_ID,
927: FND_GLOBAL.USER_ID);
928:
929: EXCEPTION
922: 'US',
923: sysdate,
924: sysdate,
925: FND_GLOBAL.USER_ID,
926: FND_GLOBAL.USER_ID,
927: FND_GLOBAL.USER_ID);
928:
929: EXCEPTION
930: WHEN OTHERS THEN
923: sysdate,
924: sysdate,
925: FND_GLOBAL.USER_ID,
926: FND_GLOBAL.USER_ID,
927: FND_GLOBAL.USER_ID);
928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: x_error_msg := sqlerrm;
982: QL_QUALIFIER_CONTEXT(cnt),
983: QL_QUALIFIER_ATTR(cnt),
984: sysdate,
985: sysdate,
986: FND_GLOBAL.USER_ID,
987: FND_GLOBAL.USER_ID,
988: FND_GLOBAL.USER_ID);
989: EXCEPTION
990: WHEN OTHERS THEN
983: QL_QUALIFIER_ATTR(cnt),
984: sysdate,
985: sysdate,
986: FND_GLOBAL.USER_ID,
987: FND_GLOBAL.USER_ID,
988: FND_GLOBAL.USER_ID);
989: EXCEPTION
990: WHEN OTHERS THEN
991: x_error_msg := sqlerrm;
984: sysdate,
985: sysdate,
986: FND_GLOBAL.USER_ID,
987: FND_GLOBAL.USER_ID,
988: FND_GLOBAL.USER_ID);
989: EXCEPTION
990: WHEN OTHERS THEN
991: x_error_msg := sqlerrm;
992: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting qualifier]');
1102: LL_START_DATE_ACTIVE(cnt),
1103: LL_END_DATE_ACTIVE(cnt),
1104: sysdate,
1105: sysdate,
1106: FND_GLOBAL.USER_ID,
1107: FND_GLOBAL.USER_ID,
1108: FND_GLOBAL.USER_ID);
1109: EXCEPTION
1110: WHEN OTHERS THEN
1103: LL_END_DATE_ACTIVE(cnt),
1104: sysdate,
1105: sysdate,
1106: FND_GLOBAL.USER_ID,
1107: FND_GLOBAL.USER_ID,
1108: FND_GLOBAL.USER_ID);
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_error_msg := sqlerrm;
1104: sysdate,
1105: sysdate,
1106: FND_GLOBAL.USER_ID,
1107: FND_GLOBAL.USER_ID,
1108: FND_GLOBAL.USER_ID);
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_error_msg := sqlerrm;
1112: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, '[Inserting rate chart lines]');
1232: AT_COMP_OPERATOR_CODE(cnt),
1233: AT_LIST_LINE_NO(cnt),
1234: sysdate,
1235: sysdate,
1236: FND_GLOBAL.USER_ID,
1237: FND_GLOBAL.USER_ID,
1238: FND_GLOBAL.USER_ID);
1239:
1240: EXCEPTION
1233: AT_LIST_LINE_NO(cnt),
1234: sysdate,
1235: sysdate,
1236: FND_GLOBAL.USER_ID,
1237: FND_GLOBAL.USER_ID,
1238: FND_GLOBAL.USER_ID);
1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN
1234: sysdate,
1235: sysdate,
1236: FND_GLOBAL.USER_ID,
1237: FND_GLOBAL.USER_ID,
1238: FND_GLOBAL.USER_ID);
1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: x_error_msg := sqlerrm;