DBA Data[Home] [Help]

APPS.RCV_FTE_TXN_LINES_PVT dependencies on FND_GLOBAL

Line 30: fnd_global.user_id,

26: p_action,
27: p_status,
28: p_txn_id,
29: SYSDATE,
30: fnd_global.user_id,
31: SYSDATE,
32: fnd_global.user_id,
33: fnd_global.login_id);
34: END insert_row;

Line 32: fnd_global.user_id,

28: p_txn_id,
29: SYSDATE,
30: fnd_global.user_id,
31: SYSDATE,
32: fnd_global.user_id,
33: fnd_global.login_id);
34: END insert_row;
35:
36: PROCEDURE update_record_to_reported(

Line 33: fnd_global.login_id);

29: SYSDATE,
30: fnd_global.user_id,
31: SYSDATE,
32: fnd_global.user_id,
33: fnd_global.login_id);
34: END insert_row;
35:
36: PROCEDURE update_record_to_reported(
37: p_header_id IN NUMBER,

Line 46: last_updated_by = FND_GLOBAL.user_id,

42: IF (p_line_id IS NULL) THEN
43: UPDATE rcv_fte_transaction_lines
44: SET reported_flag = 'Y',
45: last_update_date = SYSDATE,
46: last_updated_by = FND_GLOBAL.user_id,
47: last_update_login = FND_GLOBAL.login_id
48:
49: WHERE
50: header_id = p_header_id

Line 47: last_update_login = FND_GLOBAL.login_id

43: UPDATE rcv_fte_transaction_lines
44: SET reported_flag = 'Y',
45: last_update_date = SYSDATE,
46: last_updated_by = FND_GLOBAL.user_id,
47: last_update_login = FND_GLOBAL.login_id
48:
49: WHERE
50: header_id = p_header_id
51: AND action = p_action

Line 57: last_updated_by = FND_GLOBAL.user_id,

53: ELSE
54: UPDATE rcv_fte_transaction_lines
55: SET reported_flag = 'Y',
56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.user_id,
58: last_update_login = FND_GLOBAL.login_id
59:
60: WHERE
61: header_id = p_header_id

Line 58: last_update_login = FND_GLOBAL.login_id

54: UPDATE rcv_fte_transaction_lines
55: SET reported_flag = 'Y',
56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.user_id,
58: last_update_login = FND_GLOBAL.login_id
59:
60: WHERE
61: header_id = p_header_id
62: AND line_id = p_line_id

Line 78: last_updated_by = FND_GLOBAL.user_id,

74: IF (p_line_id IS NULL) THEN
75: UPDATE rcv_fte_transaction_lines
76: SET reported_flag = 'F',
77: last_update_date = SYSDATE,
78: last_updated_by = FND_GLOBAL.user_id,
79: last_update_login = FND_GLOBAL.login_id
80:
81: WHERE
82: header_id = p_header_id

Line 79: last_update_login = FND_GLOBAL.login_id

75: UPDATE rcv_fte_transaction_lines
76: SET reported_flag = 'F',
77: last_update_date = SYSDATE,
78: last_updated_by = FND_GLOBAL.user_id,
79: last_update_login = FND_GLOBAL.login_id
80:
81: WHERE
82: header_id = p_header_id
83: AND action = p_action

Line 89: last_updated_by = FND_GLOBAL.user_id,

85: ELSE
86: UPDATE rcv_fte_transaction_lines
87: SET reported_flag = 'F',
88: last_update_date = SYSDATE,
89: last_updated_by = FND_GLOBAL.user_id,
90: last_update_login = FND_GLOBAL.login_id
91:
92: WHERE
93: header_id = p_header_id

Line 90: last_update_login = FND_GLOBAL.login_id

86: UPDATE rcv_fte_transaction_lines
87: SET reported_flag = 'F',
88: last_update_date = SYSDATE,
89: last_updated_by = FND_GLOBAL.user_id,
90: last_update_login = FND_GLOBAL.login_id
91:
92: WHERE
93: header_id = p_header_id
94: AND line_id = p_line_id

Line 110: last_updated_by = FND_GLOBAL.user_id,

106: IF (p_line_id IS NULL) THEN
107: UPDATE rcv_fte_transaction_lines
108: SET reported_flag = 'U',
109: last_update_date = SYSDATE,
110: last_updated_by = FND_GLOBAL.user_id,
111: last_update_login = FND_GLOBAL.login_id
112:
113: WHERE
114: header_id = p_header_id

Line 111: last_update_login = FND_GLOBAL.login_id

107: UPDATE rcv_fte_transaction_lines
108: SET reported_flag = 'U',
109: last_update_date = SYSDATE,
110: last_updated_by = FND_GLOBAL.user_id,
111: last_update_login = FND_GLOBAL.login_id
112:
113: WHERE
114: header_id = p_header_id
115: AND action = p_action

Line 121: last_updated_by = FND_GLOBAL.user_id,

117: ELSE
118: UPDATE rcv_fte_transaction_lines
119: SET reported_flag = 'U',
120: last_update_date = SYSDATE,
121: last_updated_by = FND_GLOBAL.user_id,
122: last_update_login = FND_GLOBAL.login_id
123: WHERE
124: header_id = p_header_id
125: AND line_id = p_line_id

Line 122: last_update_login = FND_GLOBAL.login_id

118: UPDATE rcv_fte_transaction_lines
119: SET reported_flag = 'U',
120: last_update_date = SYSDATE,
121: last_updated_by = FND_GLOBAL.user_id,
122: last_update_login = FND_GLOBAL.login_id
123: WHERE
124: header_id = p_header_id
125: AND line_id = p_line_id
126: AND action = p_action