APPS.RCV_FTE_TXN_LINES_PVT dependencies on RCV_FTE_TRANSACTION_LINES

Line 12: INSERT INTO rcv_fte_transaction_lines(

8: p_action IN VARCHAR2,
9: p_status IN VARCHAR2 DEFAULT 'N')
10: IS
11: BEGIN
12: INSERT INTO rcv_fte_transaction_lines(
13: header_id,
14: line_id,
15: action,
16: reported_flag,

Line 43: UPDATE rcv_fte_transaction_lines

39: p_action IN VARCHAR2)
40: IS
41: BEGIN
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

Line 54: UPDATE rcv_fte_transaction_lines

50: header_id = p_header_id
51: AND action = p_action
52: AND reported_flag = 'N';
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

Line 75: UPDATE rcv_fte_transaction_lines

71: p_action IN VARCHAR2)
72: IS
73: BEGIN
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

Line 86: UPDATE rcv_fte_transaction_lines

82: header_id = p_header_id
83: AND action = p_action
84: AND reported_flag = 'N';
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

Line 107: UPDATE rcv_fte_transaction_lines

103: p_action IN VARCHAR2)
104: IS
105: BEGIN
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

Line 118: UPDATE rcv_fte_transaction_lines

114: header_id = p_header_id
115: AND action = p_action
116: AND reported_flag = 'N';
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