DBA Data[Home] [Help]

APPS.FII_LOB_ASSIGNMENTS_PKG dependencies on FND_GLOBAL

Line 19: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);

15: l_creation_date date;
16: l_last_update_login number(15);
17: BEGIN
18: l_last_update_date := nvl(x_last_update_date, sysdate);
19: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);
20: l_created_by := nvl(x_created_by, fnd_global.user_id);
21: l_creation_date := nvl(x_creation_date, sysdate);
22: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);
23:

Line 20: l_created_by := nvl(x_created_by, fnd_global.user_id);

16: l_last_update_login number(15);
17: BEGIN
18: l_last_update_date := nvl(x_last_update_date, sysdate);
19: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);
20: l_created_by := nvl(x_created_by, fnd_global.user_id);
21: l_creation_date := nvl(x_creation_date, sysdate);
22: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);
23:
24: INSERT INTO fii_lob_assignments

Line 22: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);

18: l_last_update_date := nvl(x_last_update_date, sysdate);
19: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);
20: l_created_by := nvl(x_created_by, fnd_global.user_id);
21: l_creation_date := nvl(x_creation_date, sysdate);
22: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);
23:
24: INSERT INTO fii_lob_assignments
25: (line_of_business, company_cost_center_org_id,
26: creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 45: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);

41: l_last_updated_by number(15);
42: l_last_update_login number(15);
43: BEGIN
44: l_last_update_date := nvl(x_last_update_date, sysdate);
45: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);
46: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);
47:
48: IF x_rowid IS NOT NULL THEN
49: UPDATE fii_lob_assignments

Line 46: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);

42: l_last_update_login number(15);
43: BEGIN
44: l_last_update_date := nvl(x_last_update_date, sysdate);
45: l_last_updated_by := nvl(x_last_updated_by, fnd_global.user_id);
46: l_last_update_login := nvl(x_last_update_login, fnd_global.login_id);
47:
48: IF x_rowid IS NOT NULL THEN
49: UPDATE fii_lob_assignments
50: SET