APPS.GMS_INSTALLMENTS_PKG dependencies on GMS_INSTALLMENTS

Line 1: package body GMS_INSTALLMENTS_PKG as

1: package body GMS_INSTALLMENTS_PKG as
2: -- $Header: gmsawinb.pls 120.1 2005/07/26 14:20:45 appldev ship $
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_INSTALLMENT_ID in NUMBER,

Line 36: cursor C is select ROWID from GMS_INSTALLMENTS

32: X_ATTRIBUTE14 in VARCHAR2,
33: X_ATTRIBUTE15 in VARCHAR2,
34: X_MODE in VARCHAR2 default 'R'
35: ) is
36: cursor C is select ROWID from GMS_INSTALLMENTS
37: where INSTALLMENT_ID = X_INSTALLMENT_ID;
38: X_LAST_UPDATE_DATE DATE;
39: X_LAST_UPDATED_BY NUMBER;
40: X_LAST_UPDATE_LOGIN NUMBER;

Line 59: insert into GMS_INSTALLMENTS (

55: else
56: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
57: app_exception.raise_exception;
58: end if;
59: insert into GMS_INSTALLMENTS (
60: INSTALLMENT_ID,
61: INSTALLMENT_NUM,
62: AWARD_ID,
63: START_DATE_ACTIVE,

Line 201: from GMS_INSTALLMENTS

197: ATTRIBUTE12,
198: ATTRIBUTE13,
199: ATTRIBUTE14,
200: ATTRIBUTE15
201: from GMS_INSTALLMENTS
202: where INSTALLMENT_ID = X_INSTALLMENT_ID
203: for update of INSTALLMENT_ID nowait;
204: tlinfo c1%rowtype;
205:

Line 363: update GMS_INSTALLMENTS set

359: else
360: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
361: app_exception.raise_exception;
362: end if;
363: update GMS_INSTALLMENTS set
364: INSTALLMENT_NUM = X_INSTALLMENT_NUM,
365: AWARD_ID = X_AWARD_ID,
366: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
367: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 435: cursor c1 is select rowid from GMS_INSTALLMENTS

431: X_ATTRIBUTE14 in VARCHAR2,
432: X_ATTRIBUTE15 in VARCHAR2,
433: X_MODE in VARCHAR2 default 'R'
434: ) is
435: cursor c1 is select rowid from GMS_INSTALLMENTS
436: where INSTALLMENT_ID = X_INSTALLMENT_ID
437: ;
438: dummy c1%rowtype;
439: begin

Line 516: delete from GMS_INSTALLMENTS

512: procedure DELETE_ROW (
513: X_INSTALLMENT_ID in NUMBER
514: ) is
515: begin
516: delete from GMS_INSTALLMENTS
517: where INSTALLMENT_ID = X_INSTALLMENT_ID;
518: if (sql%notfound) then
519: raise no_data_found;
520: end if;

Line 540: -- gms_installments_pkg.installment_order(installment_num),installment_num

536: -- will be displayed by numeric order first and then by character
537:
538: -- The above logic is incorporated In Award Form by using
539: -- order by start_date_active,
540: -- gms_installments_pkg.installment_order(installment_num),installment_num
541:
542: FUNCTION installment_order(p_installment_num VARCHAR2) RETURN NUMBER IS
543: l_numeric_installment NUMBER;
544: BEGIN

Line 552: end GMS_INSTALLMENTS_PKG;

548: WHEN VALUE_ERROR THEN
549: RETURN NULL;
550: END installment_order;
551:
552: end GMS_INSTALLMENTS_PKG;