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_CA_GEN_002 dependencies on IGS_CA_DA_OFST

Line 40: -- from a IGS_CA_DA_OFST, attempts to resolve any dt_alias_offset_constrts

36: ***************************************************************/
37:
38: BEGIN -- calp_clc_daio_cnstrt
39: -- This module accepts a IGS_CA_DA_INST date value which has been derived
40: -- from a IGS_CA_DA_OFST, attempts to resolve any dt_alias_offset_constrts
41: -- which exist for the IGS_CA_DA_OFST and then returns the modified date
42: -- value. Refer to S_DT_OFFSET_CONSTRAINT_TYPE table for list of valid
43: -- constraint types.
44: DECLARE

Line 41: -- which exist for the IGS_CA_DA_OFST and then returns the modified date

37:
38: BEGIN -- calp_clc_daio_cnstrt
39: -- This module accepts a IGS_CA_DA_INST date value which has been derived
40: -- from a IGS_CA_DA_OFST, attempts to resolve any dt_alias_offset_constrts
41: -- which exist for the IGS_CA_DA_OFST and then returns the modified date
42: -- value. Refer to S_DT_OFFSET_CONSTRAINT_TYPE table for list of valid
43: -- constraint types.
44: DECLARE
45: cst_must CONSTANT VARCHAR2(10) := 'MUST';

Line 573: -- from a IGS_CA_DA_OFST, attempts to resolve any dt_alias_offset_constrts

569: RETURN DATE AS
570: gv_other_detail VARCHAR2(255);
571: BEGIN -- calp_clc_dao_cnstrt
572: -- This module accepts a IGS_CA_DA_INST date value which has been derived
573: -- from a IGS_CA_DA_OFST, attempts to resolve any dt_alias_offset_constrts
574: -- which exist for the IGS_CA_DA_OFST and then returns the modified date
575: -- value. Refer to S_DT_OFFSET_CONSTRAINT_TYPE table for list of valid
576: -- constraint types.
577: DECLARE

Line 574: -- which exist for the IGS_CA_DA_OFST and then returns the modified date

570: gv_other_detail VARCHAR2(255);
571: BEGIN -- calp_clc_dao_cnstrt
572: -- This module accepts a IGS_CA_DA_INST date value which has been derived
573: -- from a IGS_CA_DA_OFST, attempts to resolve any dt_alias_offset_constrts
574: -- which exist for the IGS_CA_DA_OFST and then returns the modified date
575: -- value. Refer to S_DT_OFFSET_CONSTRAINT_TYPE table for list of valid
576: -- constraint types.
577: DECLARE
578: cst_must CONSTANT VARCHAR2(10) := 'MUST';

Line 1027: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;

1023: p_message_name OUT NOCOPY VARCHAR2 )
1024: RETURN DATE AS
1025: v_other_detail VARCHAR(255);
1026: v_alias_value DATE;
1027: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
1028: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
1029: v_date_offset DATE := NULL;
1030: CURSOR c_dt_alias_offset
1031: IS

Line 1033: FROM IGS_CA_DA_OFST

1029: v_date_offset DATE := NULL;
1030: CURSOR c_dt_alias_offset
1031: IS
1032: SELECT *
1033: FROM IGS_CA_DA_OFST
1034: WHERE DT_ALIAS = p_dt_alias;
1035: CURSOR c_dt_alias_instance
1036: IS
1037: SELECT *