APPS.PSP_ELEMENT_TYPE_ACCOUNTS_PKG dependencies on PSP_ELEMENT_TYPE_ACCOUNTS

Line 1: package body PSP_ELEMENT_TYPE_ACCOUNTS_PKG as

1: package body PSP_ELEMENT_TYPE_ACCOUNTS_PKG as
2: /* $Header: PSPSUEAB.pls 115.7 2002/11/18 08:31:55 lveerubh ship $ */
3:
4: /* Introduced x_poeta_start_date,x_poeta_end_date for Enh. Bug# 2259310 */
5: procedure INSERT_ROW (

Line 41: cursor C is select ROWID from PSP_ELEMENT_TYPE_ACCOUNTS

37: X_SET_OF_BOOKS_ID in NUMBER,
38: X_POETA_START_DATE in DATE DEFAULT NULL,
39: X_POETA_END_DATE in DATE DEFAULT NULL
40: ) is
41: cursor C is select ROWID from PSP_ELEMENT_TYPE_ACCOUNTS
42: where ELEMENT_ACCOUNT_ID = X_ELEMENT_ACCOUNT_ID
43: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
44: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID;
45: X_LAST_UPDATE_DATE DATE;

Line 66: insert into PSP_ELEMENT_TYPE_ACCOUNTS (

62: else
63: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
64: app_exception.raise_exception;
65: end if;
66: insert into PSP_ELEMENT_TYPE_ACCOUNTS (
67: ELEMENT_ACCOUNT_ID,
68: ELEMENT_TYPE_ID,
69: START_DATE_ACTIVE,
70: END_DATE_ACTIVE,

Line 215: from PSP_ELEMENT_TYPE_ACCOUNTS

211: ATTRIBUTE14,
212: ATTRIBUTE15,
213: BUSINESS_GROUP_ID,
214: SET_OF_BOOKS_ID
215: from PSP_ELEMENT_TYPE_ACCOUNTS
216: where ELEMENT_ACCOUNT_ID = X_ELEMENT_ACCOUNT_ID
217: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
218: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
219: for update of ELEMENT_ACCOUNT_ID nowait;

Line 374: update PSP_ELEMENT_TYPE_ACCOUNTS set

370: else
371: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
372: app_exception.raise_exception;
373: end if;
374: update PSP_ELEMENT_TYPE_ACCOUNTS set
375: ELEMENT_TYPE_ID = X_ELEMENT_TYPE_ID,
376: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
377: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
378: GL_CODE_COMBINATION_ID = X_GL_CODE_COMBINATION_ID,

Line 453: cursor c1 is select rowid from PSP_ELEMENT_TYPE_ACCOUNTS

449: X_SET_OF_BOOKS_ID in NUMBER,
450: X_POETA_START_DATE in DATE DEFAULT NULL,
451: X_POETA_END_DATE in DATE DEFAULT NULL
452: ) is
453: cursor c1 is select rowid from PSP_ELEMENT_TYPE_ACCOUNTS
454: where ELEMENT_ACCOUNT_ID = X_ELEMENT_ACCOUNT_ID
455: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
456: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
457: ;

Line 548: delete from PSP_ELEMENT_TYPE_ACCOUNTS

544: X_BUSINESS_GROUP_ID in NUMBER,
545: X_SET_OF_BOOKS_ID in NUMBER
546: ) is
547: begin
548: delete from PSP_ELEMENT_TYPE_ACCOUNTS
549: where ELEMENT_ACCOUNT_ID = X_ELEMENT_ACCOUNT_ID
550: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
551: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID;
552: if (sql%notfound) then

Line 557: end PSP_ELEMENT_TYPE_ACCOUNTS_PKG;

553: raise no_data_found;
554: end if;
555: end DELETE_ROW;
556:
557: end PSP_ELEMENT_TYPE_ACCOUNTS_PKG;