eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_CR_TYPES_PKG dependencies on IGS_FI_CR_TYPES

Line 1: PACKAGE BODY igs_fi_cr_types_pkg AS

1: PACKAGE BODY igs_fi_cr_types_pkg AS
2: /* $Header: IGSSI88B.pls 120.1 2005/09/22 01:53:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_cr_types_all%ROWTYPE;

Line 5: old_references igs_fi_cr_types_all%ROWTYPE;

1: PACKAGE BODY igs_fi_cr_types_pkg AS
2: /* $Header: IGSSI88B.pls 120.1 2005/09/22 01:53:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_cr_types_all%ROWTYPE;
6: new_references igs_fi_cr_types_all%ROWTYPE;
7: PROCEDURE beforerowdelete;
8:
9: PROCEDURE set_column_values (

Line 6: new_references igs_fi_cr_types_all%ROWTYPE;

2: /* $Header: IGSSI88B.pls 120.1 2005/09/22 01:53:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_cr_types_all%ROWTYPE;
6: new_references igs_fi_cr_types_all%ROWTYPE;
7: PROCEDURE beforerowdelete;
8:
9: PROCEDURE set_column_values (
10: p_action IN VARCHAR2,

Line 74: FROM IGS_FI_CR_TYPES_ALL

70: */
71:
72: CURSOR cur_old_ref_values IS
73: SELECT *
74: FROM IGS_FI_CR_TYPES_ALL
75: WHERE rowid = x_rowid;
76:
77: BEGIN
78:

Line 174: CURSOR cur_overlapping_u(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,

170: --vvutukur 25-Jan-2002 Added code to error out NOCOPY when a Credit Type
171: -- with credit class CHGADJ already exists
172: -- for the subaccount for bug 2195715 as part of SFCR003.
173:
174: CURSOR cur_overlapping_u(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
175: cp_credit_class igs_fi_cr_types.credit_class%TYPE
176: ) IS
177: SELECT 'x'
178: FROM igs_fi_cr_types

Line 175: cp_credit_class igs_fi_cr_types.credit_class%TYPE

171: -- with credit class CHGADJ already exists
172: -- for the subaccount for bug 2195715 as part of SFCR003.
173:
174: CURSOR cur_overlapping_u(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
175: cp_credit_class igs_fi_cr_types.credit_class%TYPE
176: ) IS
177: SELECT 'x'
178: FROM igs_fi_cr_types
179: WHERE credit_class = cp_credit_class

Line 178: FROM igs_fi_cr_types

174: CURSOR cur_overlapping_u(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
175: cp_credit_class igs_fi_cr_types.credit_class%TYPE
176: ) IS
177: SELECT 'x'
178: FROM igs_fi_cr_types
179: WHERE credit_class = cp_credit_class
180: AND credit_type_id <> cp_credit_type_id
181: AND (new_references.effective_start_date >= effective_start_date AND new_references.effective_start_date <= NVL(effective_end_date,new_references.effective_start_date)
182: OR ((new_references.effective_end_date >= effective_start_date OR (new_references.effective_end_date IS NULL)) AND new_references.effective_start_date <= effective_start_date));

Line 315: IF NOT igs_fi_cr_types_pkg.get_pk_for_validation (

311: IF ((old_references.payment_credit_type_id = new_references.payment_credit_type_id) OR
312: (new_references.payment_credit_type_id IS NULL)) THEN
313: NULL;
314: ELSE
315: IF NOT igs_fi_cr_types_pkg.get_pk_for_validation (
316: x_credit_type_id => new_references.payment_credit_type_id
317: ) THEN
318: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
319: IGS_GE_MSG_STACK.ADD;

Line 335: || sapanigr 21-SEP-2005 Enhc 4228665 Deleted igs_fi_a_hierarchies_pkg.get_fk_igs_fi_cr_types_all

331: || Purpose : Checks for the existance of Child records.
332: || Known limitations, enhancements or remarks :
333: || Change History :
334: || Who When What
335: || sapanigr 21-SEP-2005 Enhc 4228665 Deleted igs_fi_a_hierarchies_pkg.get_fk_igs_fi_cr_types_all
336: || (reverse chronological order - newest change first)
337: */
338: BEGIN
339:

Line 342: igs_fi_bal_ex_c_typs_pkg.get_fk_igs_fi_cr_types_all (

338: BEGIN
339:
340:
341:
342: igs_fi_bal_ex_c_typs_pkg.get_fk_igs_fi_cr_types_all (
343: old_references.credit_type_id
344: );
345:
346: igs_fi_credits_pkg.get_fk_igs_fi_cr_types_all (

Line 346: igs_fi_credits_pkg.get_fk_igs_fi_cr_types_all (

342: igs_fi_bal_ex_c_typs_pkg.get_fk_igs_fi_cr_types_all (
343: old_references.credit_type_id
344: );
345:
346: igs_fi_credits_pkg.get_fk_igs_fi_cr_types_all (
347: old_references.credit_type_id
348: );
349:
350: -- Added by shtatiko as part of Enh Bug# 2584741, Deposits Build

Line 351: igs_fi_cr_types_pkg.get_fk_igs_fi_cr_types_all (

347: old_references.credit_type_id
348: );
349:
350: -- Added by shtatiko as part of Enh Bug# 2584741, Deposits Build
351: igs_fi_cr_types_pkg.get_fk_igs_fi_cr_types_all (
352: old_references.credit_type_id
353: );
354:
355: END check_child_existance;

Line 358: PROCEDURE GET_FK_IGS_FI_CR_TYPES_ALL(

354:
355: END check_child_existance;
356:
357:
358: PROCEDURE GET_FK_IGS_FI_CR_TYPES_ALL(
359: x_credit_type_id IN NUMBER
360: ) AS
361: /*
362: || Created By : shtatiko

Line 372: FROM IGS_FI_CR_TYPES_ALL

368: || (reverse chronological order - newest change first)
369: */
370: CURSOR cur_rowid IS
371: SELECT rowid
372: FROM IGS_FI_CR_TYPES_ALL
373: WHERE credit_type_id = x_credit_type_id;
374: lv_rowid cur_rowid%RowType;
375: BEGIN
376: Open cur_rowid;

Line 386: END GET_FK_IGS_FI_CR_TYPES_ALL;

382: Close cur_rowid;
383: Return;
384: END IF;
385: Close cur_rowid;
386: END GET_FK_IGS_FI_CR_TYPES_ALL;
387:
388:
389: FUNCTION get_pk_for_validation (
390: x_credit_type_id IN NUMBER

Line 399: || smadathi 10-Jun-2002 Bug 2404523. The row share table lock on the table igs_fi_cr_types_all

395: || Purpose : Validates the Primary Key of the table.
396: || Known limitations, enhancements or remarks :
397: || Change History :
398: || Who When What
399: || smadathi 10-Jun-2002 Bug 2404523. The row share table lock on the table igs_fi_cr_types_all
400: || removed.
401: || (reverse chronological order - newest change first)
402: */
403: CURSOR cur_rowid IS

Line 405: FROM igs_fi_cr_types_all

401: || (reverse chronological order - newest change first)
402: */
403: CURSOR cur_rowid IS
404: SELECT rowid
405: FROM igs_fi_cr_types_all
406: WHERE credit_type_id = x_credit_type_id ;
407:
408:
409: lv_rowid cur_rowid%RowType;

Line 441: FROM igs_fi_cr_types

437: || (reverse chronological order - newest change first)
438: */
439: CURSOR cur_rowid IS
440: SELECT rowid
441: FROM igs_fi_cr_types
442: WHERE credit_type_name = x_credit_type_name
443: AND ((effective_start_date = x_effective_start_date) OR (effective_start_date IS NULL AND x_effective_start_date IS NULL))
444: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
445:

Line 689: FROM igs_fi_cr_types_all

685: || DEFAULT keyword in parameter list.
686: */
687: CURSOR c IS
688: SELECT rowid
689: FROM igs_fi_cr_types_all
690: WHERE credit_type_id = x_credit_type_id;
691:
692: x_last_update_date DATE;
693: x_last_updated_by NUMBER;

Line 717: SELECT igs_fi_cr_types_s.NEXTVAL

713: igs_ge_msg_stack.add;
714: app_exception.raise_exception;
715: END IF;
716:
717: SELECT igs_fi_cr_types_s.NEXTVAL
718: INTO x_credit_type_id
719: FROM dual;
720:
721: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 771: INSERT INTO igs_fi_cr_types_all (

767: x_forfeiture_account_cd => x_forfeiture_account_cd,
768: x_appl_hierarchy_id => x_appl_hierarchy_id
769: );
770:
771: INSERT INTO igs_fi_cr_types_all (
772: credit_type_id,
773: credit_type_name,
774: description,
775: credit_class,

Line 970: FROM igs_fi_cr_types_all

966: payment_credit_type_id,
967: forfeiture_gl_ccid,
968: forfeiture_account_cd,
969: appl_hierarchy_id
970: FROM igs_fi_cr_types_all
971: WHERE rowid = x_rowid
972: FOR UPDATE NOWAIT;
973:
974: tlinfo c1%ROWTYPE;

Line 1171: UPDATE igs_fi_cr_types_all

1167: x_forfeiture_account_cd => x_forfeiture_account_cd,
1168: x_appl_hierarchy_id => x_appl_hierarchy_id
1169: );
1170:
1171: UPDATE igs_fi_cr_types_all
1172: SET
1173: credit_type_name = new_references.credit_type_name,
1174: description = new_references.description,
1175: credit_class = new_references.credit_class,

Line 1282: FROM igs_fi_cr_types_all

1278: || for x_title4_type_ind,x_mode in parameter list to avoid gscc warnings.
1279: */
1280: CURSOR c1 IS
1281: SELECT rowid
1282: FROM igs_fi_cr_types_all
1283: WHERE credit_type_id = x_credit_type_id;
1284:
1285: BEGIN
1286:

Line 1403: DELETE FROM igs_fi_cr_types_all

1399: p_action => 'DELETE',
1400: x_rowid => x_rowid
1401: );
1402:
1403: DELETE FROM igs_fi_cr_types_all
1404: WHERE rowid = x_rowid;
1405:
1406: IF (SQL%NOTFOUND) THEN
1407: RAISE NO_DATA_FOUND;

Line 1426: -- while inserting records into credits table, an explicit lock was place on the IGS_FI_CR_TYPES table

1422: --Change History:
1423: --Who When What
1424: -------------------------------------------------------------------
1425: BEGIN
1426: -- while inserting records into credits table, an explicit lock was place on the IGS_FI_CR_TYPES table
1427: -- As a result locking contention occured when simultaneous transactions on the credit table were
1428: -- carried out. Hence the row share table lock on the IGS_FI_CR_TYPES table was removed from get_pk_for_validation.
1429: -- Through the forms, deletion of the IGS_FI_CR_TYPES records are not happening. To ensure that none of the
1430: -- other process which manipulates the records of the IGS_FI_CR_TYPES should not delete any of the records present

Line 1428: -- carried out. Hence the row share table lock on the IGS_FI_CR_TYPES table was removed from get_pk_for_validation.

1424: -------------------------------------------------------------------
1425: BEGIN
1426: -- while inserting records into credits table, an explicit lock was place on the IGS_FI_CR_TYPES table
1427: -- As a result locking contention occured when simultaneous transactions on the credit table were
1428: -- carried out. Hence the row share table lock on the IGS_FI_CR_TYPES table was removed from get_pk_for_validation.
1429: -- Through the forms, deletion of the IGS_FI_CR_TYPES records are not happening. To ensure that none of the
1430: -- other process which manipulates the records of the IGS_FI_CR_TYPES should not delete any of the records present
1431: -- in the table, explicitly the logic has been coded to prevent the deletion of records.
1432: -- done as part of bug 2404523

Line 1429: -- Through the forms, deletion of the IGS_FI_CR_TYPES records are not happening. To ensure that none of the

1425: BEGIN
1426: -- while inserting records into credits table, an explicit lock was place on the IGS_FI_CR_TYPES table
1427: -- As a result locking contention occured when simultaneous transactions on the credit table were
1428: -- carried out. Hence the row share table lock on the IGS_FI_CR_TYPES table was removed from get_pk_for_validation.
1429: -- Through the forms, deletion of the IGS_FI_CR_TYPES records are not happening. To ensure that none of the
1430: -- other process which manipulates the records of the IGS_FI_CR_TYPES should not delete any of the records present
1431: -- in the table, explicitly the logic has been coded to prevent the deletion of records.
1432: -- done as part of bug 2404523
1433: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');

Line 1430: -- other process which manipulates the records of the IGS_FI_CR_TYPES should not delete any of the records present

1426: -- while inserting records into credits table, an explicit lock was place on the IGS_FI_CR_TYPES table
1427: -- As a result locking contention occured when simultaneous transactions on the credit table were
1428: -- carried out. Hence the row share table lock on the IGS_FI_CR_TYPES table was removed from get_pk_for_validation.
1429: -- Through the forms, deletion of the IGS_FI_CR_TYPES records are not happening. To ensure that none of the
1430: -- other process which manipulates the records of the IGS_FI_CR_TYPES should not delete any of the records present
1431: -- in the table, explicitly the logic has been coded to prevent the deletion of records.
1432: -- done as part of bug 2404523
1433: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
1434: IGS_GE_MSG_STACK.ADD;

Line 1438: END igs_fi_cr_types_pkg;

1434: IGS_GE_MSG_STACK.ADD;
1435: APP_EXCEPTION.RAISE_EXCEPTION;
1436: END beforerowdelete;
1437:
1438: END igs_fi_cr_types_pkg;