[Home] [Help]
98: LAST_UPDATE_DATE
99: into l_transaction_id,
100: l_db_luby,
101: l_db_ludate
102: from ECX_TRANSACTIONS_B
103: where TRANSACTION_TYPE = X_TRANSACTION_TYPE
104: and TRANSACTION_SUBTYPE = X_TRANSACTION_SUBTYPE
105: and PARTY_TYPE = X_PARTY_TYPE;
106:
160: X_LAST_UPDATE_DATE in DATE,
161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: cursor C is select ROWID from ECX_TRANSACTIONS_B
165: where TRANSACTION_ID = X_TRANSACTION_ID
166: ;
167: begin
168: insert into ECX_TRANSACTIONS_B (
164: cursor C is select ROWID from ECX_TRANSACTIONS_B
165: where TRANSACTION_ID = X_TRANSACTION_ID
166: ;
167: begin
168: insert into ECX_TRANSACTIONS_B (
169: TRANSACTION_ID,
170: TRANSACTION_TYPE,
171: TRANSACTION_SUBTYPE,
172: PARTY_TYPE,
237: cursor c is select
238: TRANSACTION_TYPE,
239: TRANSACTION_SUBTYPE,
240: PARTY_TYPE
241: from ECX_TRANSACTIONS_B
242: where TRANSACTION_ID = X_TRANSACTION_ID
243: for update of TRANSACTION_ID nowait;
244: recinfo c%rowtype;
245:
295: X_LAST_UPDATED_BY in NUMBER,
296: X_LAST_UPDATE_LOGIN in NUMBER
297: ) is
298: begin
299: update ECX_TRANSACTIONS_B set
300: TRANSACTION_TYPE = X_TRANSACTION_TYPE,
301: TRANSACTION_SUBTYPE = X_TRANSACTION_SUBTYPE,
302: PARTY_TYPE = X_PARTY_TYPE,
303: ADMIN_USER = X_ADMIN_USER,
334: if (sql%notfound) then
335: raise no_data_found;
336: end if;
337:
338: delete from ECX_TRANSACTIONS_B
339: where TRANSACTION_ID = X_TRANSACTION_ID;
340:
341: if (sql%notfound) then
342: raise no_data_found;
348: begin
349: delete from ECX_TRANSACTIONS_TL T
350: where not exists
351: (select NULL
352: from ECX_TRANSACTIONS_B B
353: where B.TRANSACTION_ID = T.TRANSACTION_ID
354: );
355:
356: update ECX_TRANSACTIONS_TL T set (