APPS.IBY_PAYMENT_REASONS_PKG dependencies on IBY_PAYMENT_REASONS_B

Line 20: cursor C is select ROWID from IBY_PAYMENT_REASONS_B

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER,
18: X_SEEDED_FLAG in VARCHAR2
19: ) is
20: cursor C is select ROWID from IBY_PAYMENT_REASONS_B
21: where PAYMENT_REASON_CODE = X_PAYMENT_REASON_CODE
22: ;
23: begin
24: insert into IBY_PAYMENT_REASONS_B (

Line 24: insert into IBY_PAYMENT_REASONS_B (

20: cursor C is select ROWID from IBY_PAYMENT_REASONS_B
21: where PAYMENT_REASON_CODE = X_PAYMENT_REASON_CODE
22: ;
23: begin
24: insert into IBY_PAYMENT_REASONS_B (
25: INACTIVE_DATE,
26: TERRITORY_CODE,
27: PAYMENT_REASON_CODE,
28: FORMAT_VALUE,

Line 106: from IBY_PAYMENT_REASONS_B

102: INACTIVE_DATE,
103: TERRITORY_CODE,
104: FORMAT_VALUE,
105: OBJECT_VERSION_NUMBER
106: from IBY_PAYMENT_REASONS_B
107: where PAYMENT_REASON_CODE = X_PAYMENT_REASON_CODE
108: for update of PAYMENT_REASON_CODE nowait;
109: recinfo c%rowtype;
110:

Line 172: update IBY_PAYMENT_REASONS_B set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update IBY_PAYMENT_REASONS_B set
173: INACTIVE_DATE = X_INACTIVE_DATE,
174: TERRITORY_CODE = X_TERRITORY_CODE,
175: FORMAT_VALUE = X_FORMAT_VALUE,
176: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 212: delete from IBY_PAYMENT_REASONS_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from IBY_PAYMENT_REASONS_B
213: where PAYMENT_REASON_CODE = X_PAYMENT_REASON_CODE;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from IBY_PAYMENT_REASONS_B B

222: begin
223: delete from IBY_PAYMENT_REASONS_TL T
224: where not exists
225: (select NULL
226: from IBY_PAYMENT_REASONS_B B
227: where B.PAYMENT_REASON_CODE = T.PAYMENT_REASON_CODE
228: );
229:
230: update IBY_PAYMENT_REASONS_TL T set (