DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on FND_GLOBAL

Line 929: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

925:
926: update okl_streams
927: set say_code = 'HIST',
928: date_history = SYSDATE,
929: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
930: last_update_date = sysdate,
931: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
932: where khr_id = p_khr_id
933: and kle_id = r_rollover_fee.kleId;

Line 931: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

927: set say_code = 'HIST',
928: date_history = SYSDATE,
929: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
930: last_update_date = sysdate,
931: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
932: where khr_id = p_khr_id
933: and kle_id = r_rollover_fee.kleId;
934:
935: update okl_streams

Line 937: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

933: and kle_id = r_rollover_fee.kleId;
934:
935: update okl_streams
936: set active_yn = 'N',
937: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
938: last_update_date = sysdate,
939: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
940: where khr_id = p_khr_id
941: and kle_id = r_rollover_fee.kleId;

Line 939: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

935: update okl_streams
936: set active_yn = 'N',
937: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
938: last_update_date = sysdate,
939: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
940: where khr_id = p_khr_id
941: and kle_id = r_rollover_fee.kleId;
942:
943:

Line 10015: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

10011: If ( l_sty_id IS NOT NULL ) Then
10012:
10013: UPDATE okl_streams
10014: SET sty_id = l_sty_id,
10015: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10016: last_update_date = sysdate,
10017: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
10018: WHERE khr_id = p_khr_id
10019: AND say_code = 'WORK'

Line 10017: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

10013: UPDATE okl_streams
10014: SET sty_id = l_sty_id,
10015: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10016: last_update_date = sysdate,
10017: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
10018: WHERE khr_id = p_khr_id
10019: AND say_code = 'WORK'
10020: AND NVL(purpose_code, '-99') = l_purpose_code
10021: AND sty_id = l_rent_sty_id;

Line 10063: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

10059: -- print( l_prog_name, ' updating financed fees ' || to_char( r_financed_fees.id ));
10060:
10061: UPDATE okl_streams
10062: SET sty_id = l_sty_id,
10063: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10064: last_update_date = sysdate,
10065: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
10066: WHERE khr_id = p_khr_id
10067: AND kle_id = r_financed_fees.id

Line 10065: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

10061: UPDATE okl_streams
10062: SET sty_id = l_sty_id,
10063: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10064: last_update_date = sysdate,
10065: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
10066: WHERE khr_id = p_khr_id
10067: AND kle_id = r_financed_fees.id
10068: AND say_code = 'WORK'
10069: AND NVL(purpose_code, '-99') = l_purpose_code

Line 14652: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

14648: SET say_code = l_say_code_tbl(i),
14649: active_yn = l_active_yn_tbl(i),
14650: date_history = l_date_history_tbl(i),
14651: date_current = l_date_curr_tbl(i),
14652: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
14653: last_update_date = sysdate,
14654: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
14655: WHERE ID = l_strm_id_tbl(i);
14656:

Line 14654: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

14650: date_history = l_date_history_tbl(i),
14651: date_current = l_date_curr_tbl(i),
14652: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
14653: last_update_date = sysdate,
14654: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
14655: WHERE ID = l_strm_id_tbl(i);
14656:
14657: EXCEPTION
14658: WHEN OKL_API.G_EXCEPTION_ERROR THEN