APPS.PA_AMOUNT_TYPES_PKG dependencies on PA_AMOUNT_TYPES_B

Line 17: cursor C is select ROWID from PA_AMOUNT_TYPES_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from PA_AMOUNT_TYPES_B
18: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
19: ;
20: begin
21: insert into PA_AMOUNT_TYPES_B (

Line 21: insert into PA_AMOUNT_TYPES_B (

17: cursor C is select ROWID from PA_AMOUNT_TYPES_B
18: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
19: ;
20: begin
21: insert into PA_AMOUNT_TYPES_B (
22: PLAN_ADJ_AMOUNT_FLAG,
23: PLAN_ADJUSTABLE_FLAG,
24: AMOUNT_TYPE_ID,
25: AMOUNT_TYPE_CODE,

Line 96: from PA_AMOUNT_TYPES_B

92: PLAN_ADJ_AMOUNT_FLAG,
93: PLAN_ADJUSTABLE_FLAG,
94: AMOUNT_TYPE_CODE,
95: AMOUNT_TYPE_CLASS
96: from PA_AMOUNT_TYPES_B
97: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
98: for update of AMOUNT_TYPE_ID nowait;
99: recinfo c%rowtype;
100:

Line 156: update PA_AMOUNT_TYPES_B set

152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update PA_AMOUNT_TYPES_B set
157: PLAN_ADJ_AMOUNT_FLAG = X_PLAN_ADJ_AMOUNT_FLAG,
158: PLAN_ADJUSTABLE_FLAG = X_PLAN_ADJUSTABLE_FLAG,
159: AMOUNT_TYPE_CODE = X_AMOUNT_TYPE_CODE,
160: AMOUNT_TYPE_CLASS = X_AMOUNT_TYPE_CLASS,

Line 195: delete from PA_AMOUNT_TYPES_B

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: delete from PA_AMOUNT_TYPES_B
196: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 209: from PA_AMOUNT_TYPES_B B

205: begin
206: delete from PA_AMOUNT_TYPES_TL T
207: where not exists
208: (select NULL
209: from PA_AMOUNT_TYPES_B B
210: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID
211: );
212:
213: update PA_AMOUNT_TYPES_TL T set (