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:
21: nc_ROWID VARCHAR2(30);

Line 26: insert into PA_AMOUNT_TYPES_B (

22:
23: begin
24: nc_ROWID := X_ROWID;
25:
26: insert into PA_AMOUNT_TYPES_B (
27: PLAN_ADJ_AMOUNT_FLAG,
28: PLAN_ADJUSTABLE_FLAG,
29: AMOUNT_TYPE_ID,
30: AMOUNT_TYPE_CODE,

Line 106: from PA_AMOUNT_TYPES_B

102: PLAN_ADJ_AMOUNT_FLAG,
103: PLAN_ADJUSTABLE_FLAG,
104: AMOUNT_TYPE_CODE,
105: AMOUNT_TYPE_CLASS
106: from PA_AMOUNT_TYPES_B
107: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
108: for update of AMOUNT_TYPE_ID nowait;
109: recinfo c%rowtype;
110:

Line 166: update PA_AMOUNT_TYPES_B set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update PA_AMOUNT_TYPES_B set
167: PLAN_ADJ_AMOUNT_FLAG = X_PLAN_ADJ_AMOUNT_FLAG,
168: PLAN_ADJUSTABLE_FLAG = X_PLAN_ADJUSTABLE_FLAG,
169: AMOUNT_TYPE_CODE = X_AMOUNT_TYPE_CODE,
170: AMOUNT_TYPE_CLASS = X_AMOUNT_TYPE_CLASS,

Line 205: delete from PA_AMOUNT_TYPES_B

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: delete from PA_AMOUNT_TYPES_B
206: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 219: from PA_AMOUNT_TYPES_B B

215: begin
216: delete from PA_AMOUNT_TYPES_TL T
217: where not exists
218: (select NULL
219: from PA_AMOUNT_TYPES_B B
220: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID
221: );
222:
223: update PA_AMOUNT_TYPES_TL T set (