APPS.CS_BUS_PROCESS_TXNS_PKG dependencies on CS_BUS_PROCESS_TXNS

Line 1: PACKAGE BODY cs_bus_process_txns_pkg AS

1: PACKAGE BODY cs_bus_process_txns_pkg AS
2: /* $Header: cssebptb.pls 115.1 99/07/16 09:00:40 porting s $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_BUSINESS_PROCESS_ID in NUMBER,

Line 27: cursor C is select ROWID from CS_BUS_PROCESS_TXNS

23: X_ATTRIBUTE15 in VARCHAR2,
24: X_CONTEXT in VARCHAR2,
25: X_MODE in VARCHAR2 default 'R'
26: ) is
27: cursor C is select ROWID from CS_BUS_PROCESS_TXNS
28: where BUSINESS_PROCESS_ID = X_BUSINESS_PROCESS_ID
29: and TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
30: X_LAST_UPDATE_DATE DATE;
31: X_LAST_UPDATED_BY NUMBER;

Line 51: insert into CS_BUS_PROCESS_TXNS (

47: else
48: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
49: app_exception.raise_exception;
50: end if;
51: insert into CS_BUS_PROCESS_TXNS (
52: BUSINESS_PROCESS_ID,
53: TRANSACTION_TYPE_ID,
54: START_DATE_ACTIVE,
55: END_DATE_ACTIVE,

Line 156: from CS_BUS_PROCESS_TXNS

152: ATTRIBUTE13,
153: ATTRIBUTE14,
154: ATTRIBUTE15,
155: CONTEXT
156: from CS_BUS_PROCESS_TXNS
157: where BUSINESS_PROCESS_ID = X_BUSINESS_PROCESS_ID
158: and TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
159: for update of BUSINESS_PROCESS_ID nowait;
160: tlinfo c1%rowtype;

Line 280: update CS_BUS_PROCESS_TXNS set

276: else
277: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
278: app_exception.raise_exception;
279: end if;
280: update CS_BUS_PROCESS_TXNS set
281: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
282: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
283: ATTRIBUTE1 = X_ATTRIBUTE1,
284: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 334: cursor c1 is select rowid from CS_BUS_PROCESS_TXNS

330: X_ATTRIBUTE15 in VARCHAR2,
331: X_CONTEXT in VARCHAR2,
332: X_MODE in VARCHAR2 default 'R'
333: ) is
334: cursor c1 is select rowid from CS_BUS_PROCESS_TXNS
335: where BUSINESS_PROCESS_ID = X_BUSINESS_PROCESS_ID
336: and TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
337: ;
338: dummy c1%rowtype;

Line 399: delete from CS_BUS_PROCESS_TXNS

395: X_BUSINESS_PROCESS_ID in NUMBER,
396: X_TRANSACTION_TYPE_ID in NUMBER
397: ) is
398: begin
399: delete from CS_BUS_PROCESS_TXNS
400: where BUSINESS_PROCESS_ID = X_BUSINESS_PROCESS_ID
401: and TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
402: if (sql%notfound) then
403: raise no_data_found;

Line 407: end CS_BUS_PROCESS_TXNS_PKG;

403: raise no_data_found;
404: end if;
405: end DELETE_ROW;
406:
407: end CS_BUS_PROCESS_TXNS_PKG;