DBA Data[Home] [Help]

APPS.IBY_ACCPPMTMTHD_PKG dependencies on FND_GLOBAL

Line 110: last_updated_by = fnd_global.user_id,

106: else
107: UPDATE iby_accppmtmthd
108: SET status = 1,
109: last_update_date = sysdate,
110: last_updated_by = fnd_global.user_id,
111: last_update_login = fnd_global.login_id
112: WHERE payeeid = i_payeeid
113: AND ecappid = i_ecappid
114: AND status = 0

Line 111: last_update_login = fnd_global.login_id

107: UPDATE iby_accppmtmthd
108: SET status = 1,
109: last_update_date = sysdate,
110: last_updated_by = fnd_global.user_id,
111: last_update_login = fnd_global.login_id
112: WHERE payeeid = i_payeeid
113: AND ecappid = i_ecappid
114: AND status = 0
115: AND accttypeid in ( SELECT accttypeid

Line 132: sysdate, fnd_global.user_id,

128: last_update_date, last_updated_by,
129: creation_date, created_by,
130: last_update_login, object_version_number)
131: VALUES ( i_ecappid, l_mpayeeid, i_payeeid, l_accttypeid , 1,
132: sysdate, fnd_global.user_id,
133: sysdate, fnd_global.user_id,
134: fnd_global.login_id, 1);
135: end if;
136:

Line 133: sysdate, fnd_global.user_id,

129: creation_date, created_by,
130: last_update_login, object_version_number)
131: VALUES ( i_ecappid, l_mpayeeid, i_payeeid, l_accttypeid , 1,
132: sysdate, fnd_global.user_id,
133: sysdate, fnd_global.user_id,
134: fnd_global.login_id, 1);
135: end if;
136:
137: commit;

Line 134: fnd_global.login_id, 1);

130: last_update_login, object_version_number)
131: VALUES ( i_ecappid, l_mpayeeid, i_payeeid, l_accttypeid , 1,
132: sysdate, fnd_global.user_id,
133: sysdate, fnd_global.user_id,
134: fnd_global.login_id, 1);
135: end if;
136:
137: commit;
138: end;

Line 163: last_updated_by = fnd_global.user_id,

159: */
160: UPDATE iby_accppmtmthd
161: SET status = 0,
162: last_update_date = sysdate,
163: last_updated_by = fnd_global.user_id,
164: last_update_login = fnd_global.login_id
165: WHERE payeeid = i_payeeid
166: AND ecappid = i_ecappid
167: AND status = 1

Line 164: last_update_login = fnd_global.login_id

160: UPDATE iby_accppmtmthd
161: SET status = 0,
162: last_update_date = sysdate,
163: last_updated_by = fnd_global.user_id,
164: last_update_login = fnd_global.login_id
165: WHERE payeeid = i_payeeid
166: AND ecappid = i_ecappid
167: AND status = 1
168: AND accttypeid in ( SELECT accttypeid