APPS.FA_CUA_HR_DISTRIBUTION_PKG dependencies on FA_HIERARCHY_DISTRIBUTIONS

Line 19: Cursor C1 is Select ROWID from FA_HIERARCHY_DISTRIBUTIONS

15: , X_LAST_UPDATED_BY in number
16: , X_LAST_UPDATE_LOGIN in number
17: )
18: is
19: Cursor C1 is Select ROWID from FA_HIERARCHY_DISTRIBUTIONS
20: where distribution_id = x_distribution_id;
21: CURSOR C is Select FA_HIERARCHY_DISTRIBUTIONS_S.nextval from sys.dual;
22: Begin
23: if X_distribution_id is null then

Line 21: CURSOR C is Select FA_HIERARCHY_DISTRIBUTIONS_S.nextval from sys.dual;

17: )
18: is
19: Cursor C1 is Select ROWID from FA_HIERARCHY_DISTRIBUTIONS
20: where distribution_id = x_distribution_id;
21: CURSOR C is Select FA_HIERARCHY_DISTRIBUTIONS_S.nextval from sys.dual;
22: Begin
23: if X_distribution_id is null then
24: open C;
25: fetch C into X_distribution_id ;

Line 28: insert into FA_HIERARCHY_DISTRIBUTIONS

24: open C;
25: fetch C into X_distribution_id ;
26: close C;
27: end if;
28: insert into FA_HIERARCHY_DISTRIBUTIONS
29: ( distribution_id
30: , dist_set_id
31: , book_type_code
32: , distribution_line_percentage

Line 86: from FA_HIERARCHY_DISTRIBUTIONS

82: , distribution_line_percentage
83: , code_combination_id
84: , location_id
85: , assigned_to
86: from FA_HIERARCHY_DISTRIBUTIONS
87: where rowid = x_rowid
88: FOR UPDATE NOWAIT;
89: tlinfo C1%ROWTYPE;
90: begin

Line 138: update FA_HIERARCHY_DISTRIBUTIONS

134: , X_LAST_UPDATE_LOGIN in number
135: )
136: is
137: Begin
138: update FA_HIERARCHY_DISTRIBUTIONS
139: set
140: book_type_code = x_book_type_code
141: , distribution_line_percentage = x_distribution_line_percentage
142: , code_combination_id = x_code_combination_id

Line 159: delete from FA_HIERARCHY_DISTRIBUTIONS

155: x_rowid in varchar2
156: )
157: is
158: Begin
159: delete from FA_HIERARCHY_DISTRIBUTIONS
160: where rowid = x_rowid;
161: if (sql%notfound) then
162: raise no_data_found;
163: end if;