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