APPS.FII_LOB_ASSIGNMENTS_PKG dependencies on FII_LOB_ASSIGNMENTS

Line 1: PACKAGE BODY fii_lob_assignments_pkg AS

1: PACKAGE BODY fii_lob_assignments_pkg AS
2: /*$Header: FIILOBAB.pls 115.2 2003/01/11 00:31:02 ilavenil noship $*/
3: PROCEDURE insert_row(x_rowid IN OUT NOCOPY VARCHAR2,
4: x_line_of_business IN VARCHAR2,
5: x_company_cost_center_org_id IN NUMBER,

Line 24: INSERT INTO fii_lob_assignments

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)
27: VALUES
28: (x_line_of_business, x_company_cost_center_org_id,

Line 49: UPDATE fii_lob_assignments

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
51: company_cost_center_org_id = x_company_cost_center_org_id,
52: last_update_date = l_last_update_date,
53: last_updated_by = l_last_updated_by,

Line 57: UPDATE fii_lob_assignments

53: last_updated_by = l_last_updated_by,
54: last_update_login = l_last_update_login
55: WHERE ROWID = x_rowid;
56: ELSE
57: UPDATE fii_lob_assignments
58: SET
59: company_cost_center_org_id = x_company_cost_center_org_id,
60: last_update_date = l_last_update_date,
61: last_updated_by = l_last_updated_by,

Line 77: DELETE FROM fii_lob_assignments

73: x_line_of_business IN VARCHAR2)
74: IS
75: BEGIN
76: IF x_rowid IS NOT NULL THEN
77: DELETE FROM fii_lob_assignments
78: WHERE ROWID = x_rowid;
79: ELSE
80: DELETE FROM fii_lob_assignments
81: WHERE line_of_business = x_line_of_business;

Line 80: DELETE FROM fii_lob_assignments

76: IF x_rowid IS NOT NULL THEN
77: DELETE FROM fii_lob_assignments
78: WHERE ROWID = x_rowid;
79: ELSE
80: DELETE FROM fii_lob_assignments
81: WHERE line_of_business = x_line_of_business;
82: END IF;
83:
84: IF SQL%notfound THEN

Line 95: FROM fii_lob_assignments

91: x_company_cost_center_org_id IN NUMBER)
92: IS
93: CURSOR c_lob IS
94: SELECT *
95: FROM fii_lob_assignments
96: WHERE ROWID = x_rowid
97: FOR UPDATE OF company_cost_center_org_id nowait;
98: recinfo c_lob%ROWTYPE;
99: BEGIN

Line 118: END fii_lob_assignments_pkg;

114: app_exception.raise_exception;
115: END IF;
116: END lock_row;
117:
118: END fii_lob_assignments_pkg;