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_F_TYP_CA_INST_PKG dependencies on IGS_FI_F_TYP_CA_INST_ALL

Line 64: old_references IGS_FI_F_TYP_CA_INST_ALL%RowType;

60: | This is as per the SFCR015-HOLDS DLD. Bug:2126091
61: **************************************************************************************************************/
62:
63: l_rowid VARCHAR2(25);
64: old_references IGS_FI_F_TYP_CA_INST_ALL%RowType;
65: new_references IGS_FI_F_TYP_CA_INST_ALL%RowType;
66: PROCEDURE Set_Column_Values (
67: p_action IN VARCHAR2,
68: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 65: new_references IGS_FI_F_TYP_CA_INST_ALL%RowType;

61: **************************************************************************************************************/
62:
63: l_rowid VARCHAR2(25);
64: old_references IGS_FI_F_TYP_CA_INST_ALL%RowType;
65: new_references IGS_FI_F_TYP_CA_INST_ALL%RowType;
66: PROCEDURE Set_Column_Values (
67: p_action IN VARCHAR2,
68: x_rowid IN VARCHAR2 DEFAULT NULL,
69: x_fee_type IN VARCHAR2 DEFAULT NULL,

Line 119: FROM IGS_FI_F_TYP_CA_INST_ALL

115: || into new_references value.
116: ----------------------------------------------------------------------------*/
117: CURSOR cur_old_ref_values IS
118: SELECT *
119: FROM IGS_FI_F_TYP_CA_INST_ALL
120: WHERE rowid = x_rowid;
121: BEGIN
122: l_rowid := x_rowid;
123: -- Code for setting the Old and New Reference Values.

Line 176: -- ON IGS_FI_F_TYP_CA_INST_ALL

172: END Set_Column_Values;
173: -- Trigger description :-
174: -- "OSS_TST".trg_ftci_br_iud
175: -- BEFORE INSERT OR DELETE OR UPDATE
176: -- ON IGS_FI_F_TYP_CA_INST_ALL
177: -- FOR EACH ROW
178: PROCEDURE BeforeRowInsertUpdateDelete1(
179: p_inserting IN BOOLEAN DEFAULT FALSE,
180: p_updating IN BOOLEAN DEFAULT FALSE,

Line 336: -- ON IGS_FI_F_TYP_CA_INST_ALL

332: END BeforeRowInsertUpdateDelete1;
333: -- Trigger description :-
334: -- "OSS_TST".trg_ftci_ar_u_hist
335: -- AFTER UPDATE
336: -- ON IGS_FI_F_TYP_CA_INST_ALL
337: -- FOR EACH ROW
338: PROCEDURE AfterRowUpdate3(
339: p_inserting IN BOOLEAN DEFAULT FALSE,
340: p_updating IN BOOLEAN DEFAULT FALSE,

Line 399: -- ON IGS_FI_F_TYP_CA_INST_ALL

395:
396: -- Trigger description :-
397: -- "OSS_TST".trg_ftci_as_iu
398: -- AFTER INSERT OR UPDATE
399: -- ON IGS_FI_F_TYP_CA_INST_ALL
400: PROCEDURE Check_Constraints (
401: column_name IN VARCHAR2 DEFAULT NULL,
402: column_value IN VARCHAR2 DEFAULT NULL
403: ) AS

Line 860: FROM IGS_FI_F_TYP_CA_INST_ALL

856: -------------------------------------------------------------------
857:
858: CURSOR cur_rowid IS
859: SELECT rowid
860: FROM IGS_FI_F_TYP_CA_INST_ALL
861: WHERE fee_type = x_fee_type
862: AND fee_cal_type = x_fee_cal_type
863: AND fee_ci_sequence_number = x_fee_ci_sequence_number;
864:

Line 885: FROM IGS_FI_F_TYP_CA_INST_ALL

881: x_sequence_number IN NUMBER
882: ) AS
883: CURSOR cur_rowid IS
884: SELECT rowid
885: FROM IGS_FI_F_TYP_CA_INST_ALL
886: WHERE fee_cal_type = x_cal_type
887: AND fee_ci_sequence_number = x_sequence_number ;
888: lv_rowid cur_rowid%RowType;
889: BEGIN

Line 911: FROM IGS_FI_F_TYP_CA_INST_ALL

907: x_ci_sequence_number IN NUMBER
908: ) AS
909: CURSOR cur_rowid IS
910: SELECT rowid
911: FROM IGS_FI_F_TYP_CA_INST_ALL
912: WHERE (end_dt_alias = x_dt_alias
913: AND end_dai_sequence_number = x_sequence_number
914: AND fee_cal_type = x_cal_type
915: AND fee_ci_sequence_number = x_ci_sequence_number)

Line 943: FROM IGS_FI_F_TYP_CA_INST_ALL

939: x_fee_structure_status IN VARCHAR2
940: ) AS
941: CURSOR cur_rowid IS
942: SELECT rowid
943: FROM IGS_FI_F_TYP_CA_INST_ALL
944: WHERE fee_type_ci_status = x_fee_structure_status ;
945: lv_rowid cur_rowid%RowType;
946: BEGIN
947: Open cur_rowid;

Line 966: FROM IGS_FI_F_TYP_CA_INST_ALL

962: x_sequence_number IN NUMBER
963: ) AS
964: CURSOR cur_rowid IS
965: SELECT rowid
966: FROM IGS_FI_F_TYP_CA_INST_ALL
967: WHERE rul_sequence_number = x_sequence_number ;
968: lv_rowid cur_rowid%RowType;
969: BEGIN
970: Open cur_rowid;

Line 987: FROM IGS_FI_F_TYP_CA_INST_ALL

983: x_s_chg_method_type IN VARCHAR2
984: ) AS
985: CURSOR cur_rowid IS
986: SELECT rowid
987: FROM IGS_FI_F_TYP_CA_INST_ALL
988: WHERE s_chg_method_type = x_s_chg_method_type ;
989: lv_rowid cur_rowid%RowType;
990: BEGIN
991: Open cur_rowid;

Line 1008: FROM IGS_FI_F_TYP_CA_INST_ALL

1004: x_elm_rng_order_name IN VARCHAR2
1005: ) AS
1006: CURSOR cur_rowid IS
1007: SELECT rowid
1008: FROM IGS_FI_F_TYP_CA_INST_ALL
1009: WHERE elm_rng_order_name = x_elm_rng_order_name ;
1010: lv_rowid cur_rowid%RowType;
1011: BEGIN
1012: Open cur_rowid;

Line 1029: FROM IGS_FI_F_TYP_CA_INST_ALL

1025: x_scope_rul_sequence_num IN NUMBER
1026: ) AS
1027: CURSOR cur_rowid IS
1028: SELECT rowid
1029: FROM IGS_FI_F_TYP_CA_INST_ALL
1030: WHERE scope_rul_sequence_num = x_scope_rul_sequence_num ;
1031: lv_rowid cur_rowid%RowType;
1032: BEGIN
1033: Open cur_rowid;

Line 1232: cursor C is select ROWID from IGS_FI_F_TYP_CA_INST_ALL

1228: call to before_dml and from insert statement).
1229: SBALIGA 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
1230: in call to bafore_dml as part of SWCR006 build.
1231: ********************************************************************************/
1232: cursor C is select ROWID from IGS_FI_F_TYP_CA_INST_ALL
1233: where FEE_TYPE = X_FEE_TYPE
1234: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
1235: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER;
1236: X_LAST_UPDATE_DATE DATE;

Line 1308: insert into IGS_FI_F_TYP_CA_INST_ALL (

1304: x_scope_rul_sequence_num => x_scope_rul_sequence_num,
1305: x_elm_rng_order_name => x_elm_rng_order_name,
1306: x_max_chg_elements => x_max_chg_elements
1307: );
1308: insert into IGS_FI_F_TYP_CA_INST_ALL (
1309: FEE_TYPE,
1310: FEE_CAL_TYPE,
1311: FEE_CI_SEQUENCE_NUMBER,
1312: FEE_TYPE_CI_STATUS,

Line 1458: from IGS_FI_F_TYP_CA_INST_ALL

1454: nonzero_billable_cp_flag,
1455: scope_rul_sequence_num,
1456: elm_rng_order_name,
1457: max_chg_elements
1458: from IGS_FI_F_TYP_CA_INST_ALL
1459: where ROWID=X_ROWID
1460: for update nowait;
1461: tlinfo c1%rowtype;
1462: begin

Line 1652: update IGS_FI_F_TYP_CA_INST_ALL set

1648: x_scope_rul_sequence_num => x_scope_rul_sequence_num,
1649: x_elm_rng_order_name => x_elm_rng_order_name,
1650: x_max_chg_elements => x_max_chg_elements
1651: );
1652: update IGS_FI_F_TYP_CA_INST_ALL set
1653: FEE_TYPE_CI_STATUS = NEW_REFERENCES.FEE_TYPE_CI_STATUS,
1654: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
1655: START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
1656: END_DT_ALIAS = NEW_REFERENCES.END_DT_ALIAS,

Line 1736: cursor c1 is select rowid from IGS_FI_F_TYP_CA_INST_ALL

1732: || agairola 07-Sep-2004 Enh 3316063: Retention Enhancements changes
1733: || vvutukur 23-Jul-2002 Bug#2425767.removed parameter x_payment_hierarchy_rank
1734: || and its references(from calls to insert_row and update_row).
1735: ----------------------------------------------------------------------------*/
1736: cursor c1 is select rowid from IGS_FI_F_TYP_CA_INST_ALL
1737: where FEE_TYPE = X_FEE_TYPE
1738: and FEE_CAL_TYPE = X_FEE_CAL_TYPE
1739: and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
1740: ;