APPS.FTP_PAYMENT_PATTERN_PKG dependencies on FTP_PAYMENT_PATTERN_B

Line 16: cursor C is select ROWID from FTP_PAYMENT_PATTERN_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from FTP_PAYMENT_PATTERN_B
17: where PAYMENT_ID = X_PAYMENT_ID
18: ;
19: begin
20: insert into FTP_PAYMENT_PATTERN_B (

Line 20: insert into FTP_PAYMENT_PATTERN_B (

16: cursor C is select ROWID from FTP_PAYMENT_PATTERN_B
17: where PAYMENT_ID = X_PAYMENT_ID
18: ;
19: begin
20: insert into FTP_PAYMENT_PATTERN_B (
21: PAYMENT_ID,
22: AMRT_TYPE_CODE,
23: PATTERN_NAME,
24: OBJECT_VERSION_NUMBER,

Line 95: from FTP_PAYMENT_PATTERN_B

91: cursor c is select
92: AMRT_TYPE_CODE,
93: PATTERN_NAME,
94: OBJECT_VERSION_NUMBER
95: from FTP_PAYMENT_PATTERN_B
96: where PAYMENT_ID = X_PAYMENT_ID
97: for update of PAYMENT_ID nowait;
98: recinfo c%rowtype;
99:

Line 153: update FTP_PAYMENT_PATTERN_B set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update FTP_PAYMENT_PATTERN_B set
154: AMRT_TYPE_CODE = X_AMRT_TYPE_CODE,
155: PATTERN_NAME = X_PATTERN_NAME,
156: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
157: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 191: delete from FTP_PAYMENT_PATTERN_B

187: if (sql%notfound) then
188: raise no_data_found;
189: end if;
190:
191: delete from FTP_PAYMENT_PATTERN_B
192: where PAYMENT_ID = X_PAYMENT_ID;
193:
194: if (sql%notfound) then
195: raise no_data_found;

Line 205: from FTP_PAYMENT_PATTERN_B B

201: begin
202: delete from FTP_PAYMENT_PATTERN_TL T
203: where not exists
204: (select NULL
205: from FTP_PAYMENT_PATTERN_B B
206: where B.PAYMENT_ID = T.PAYMENT_ID
207: );
208:
209: update FTP_PAYMENT_PATTERN_TL T set (