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_ALL

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 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 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 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;