DBA Data[Home] [Help]

APPS.FTE_RATE_CHART_PKG dependencies on FND_GLOBAL

Line 674: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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;

Line 676: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_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

Line 687: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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:

Line 689: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

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

Line 925: FND_GLOBAL.USER_ID,

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

Line 926: FND_GLOBAL.USER_ID,

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

Line 927: FND_GLOBAL.USER_ID);

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;

Line 986: FND_GLOBAL.USER_ID,

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

Line 987: FND_GLOBAL.USER_ID,

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;

Line 988: FND_GLOBAL.USER_ID);

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]');

Line 1106: FND_GLOBAL.USER_ID,

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

Line 1107: FND_GLOBAL.USER_ID,

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;

Line 1108: FND_GLOBAL.USER_ID);

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]');

Line 1236: FND_GLOBAL.USER_ID,

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

Line 1237: FND_GLOBAL.USER_ID,

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

Line 1238: FND_GLOBAL.USER_ID);

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;