APPS.FEM_APAYINST_TYPES_PKG dependencies on FEM_APAYINST_TYPES_B

Line 19: cursor C is select ROWID from FEM_APAYINST_TYPES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FEM_APAYINST_TYPES_B
20: where AUTOPAY_INSTR_TYPE_ID = X_AUTOPAY_INSTR_TYPE_ID
21: ;
22: begin
23: insert into FEM_APAYINST_TYPES_B (

Line 23: insert into FEM_APAYINST_TYPES_B (

19: cursor C is select ROWID from FEM_APAYINST_TYPES_B
20: where AUTOPAY_INSTR_TYPE_ID = X_AUTOPAY_INSTR_TYPE_ID
21: ;
22: begin
23: insert into FEM_APAYINST_TYPES_B (
24: AUTOPAY_INSTR_TYPE_ID,
25: AUTOPAY_INSTRTYPE_DISPLAY_CODE,
26: ENABLED_FLAG,
27: PERSONAL_FLAG,

Line 105: from FEM_APAYINST_TYPES_B

101: ENABLED_FLAG,
102: PERSONAL_FLAG,
103: READ_ONLY_FLAG,
104: OBJECT_VERSION_NUMBER
105: from FEM_APAYINST_TYPES_B
106: where AUTOPAY_INSTR_TYPE_ID = X_AUTOPAY_INSTR_TYPE_ID
107: for update of AUTOPAY_INSTR_TYPE_ID nowait;
108: recinfo c%rowtype;
109:

Line 168: update FEM_APAYINST_TYPES_B set

164: X_LAST_UPDATED_BY in NUMBER,
165: X_LAST_UPDATE_LOGIN in NUMBER
166: ) is
167: begin
168: update FEM_APAYINST_TYPES_B set
169: AUTOPAY_INSTRTYPE_DISPLAY_CODE = X_AUTOPAY_INSTRTYPE_DISPLAY_CO,
170: ENABLED_FLAG = X_ENABLED_FLAG,
171: PERSONAL_FLAG = X_PERSONAL_FLAG,
172: READ_ONLY_FLAG = X_READ_ONLY_FLAG,

Line 209: delete from FEM_APAYINST_TYPES_B

205: if (sql%notfound) then
206: raise no_data_found;
207: end if;
208:
209: delete from FEM_APAYINST_TYPES_B
210: where AUTOPAY_INSTR_TYPE_ID = X_AUTOPAY_INSTR_TYPE_ID;
211:
212: if (sql%notfound) then
213: raise no_data_found;

Line 223: from FEM_APAYINST_TYPES_B B

219: begin
220: delete from FEM_APAYINST_TYPES_TL T
221: where not exists
222: (select NULL
223: from FEM_APAYINST_TYPES_B B
224: where B.AUTOPAY_INSTR_TYPE_ID = T.AUTOPAY_INSTR_TYPE_ID
225: );
226:
227: update FEM_APAYINST_TYPES_TL T set (