APPS.IGS_CA_VAL_DAO dependencies on IGS_CA_DA

Line 3: -- Validate IGS_CA_DA_OFST

1: PACKAGE BODY IGS_CA_VAL_DAO AS
2: /* $Header: IGSCA11B.pls 115.3 2002/11/28 22:58:40 nsidana ship $ */
3: -- Validate IGS_CA_DA_OFST
4: FUNCTION calp_val_dao_ins(
5: p_dt_alias IN VARCHAR2 ,
6: p_offset_dt_alias IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )

Line 11: v_dt_alias_rec IGS_CA_DA%ROWTYPE;

7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN boolean AS
9: v_other_detail VARCHAR(255);
10: v_alias_value DATE;
11: v_dt_alias_rec IGS_CA_DA%ROWTYPE;
12: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
13: IS
14: SELECT *
15: FROM IGS_CA_DA_OFST

Line 12: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)

8: RETURN boolean AS
9: v_other_detail VARCHAR(255);
10: v_alias_value DATE;
11: v_dt_alias_rec IGS_CA_DA%ROWTYPE;
12: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
13: IS
14: SELECT *
15: FROM IGS_CA_DA_OFST
16: WHERE dt_alias = cp_dt_alias

Line 15: FROM IGS_CA_DA_OFST

11: v_dt_alias_rec IGS_CA_DA%ROWTYPE;
12: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
13: IS
14: SELECT *
15: FROM IGS_CA_DA_OFST
16: WHERE dt_alias = cp_dt_alias
17: AND (offset_dt_alias <> p_offset_dt_alias);
18: CURSOR c_dt_alias (cp_dt_alias IGS_CA_DA.dt_alias%TYPE)
19: IS

Line 18: CURSOR c_dt_alias (cp_dt_alias IGS_CA_DA.dt_alias%TYPE)

14: SELECT *
15: FROM IGS_CA_DA_OFST
16: WHERE dt_alias = cp_dt_alias
17: AND (offset_dt_alias <> p_offset_dt_alias);
18: CURSOR c_dt_alias (cp_dt_alias IGS_CA_DA.dt_alias%TYPE)
19: IS
20: SELECT *
21: FROM IGS_CA_DA
22: WHERE dt_alias = cp_dt_alias;

Line 21: FROM IGS_CA_DA

17: AND (offset_dt_alias <> p_offset_dt_alias);
18: CURSOR c_dt_alias (cp_dt_alias IGS_CA_DA.dt_alias%TYPE)
19: IS
20: SELECT *
21: FROM IGS_CA_DA
22: WHERE dt_alias = cp_dt_alias;
23: FUNCTION find_dao(p_org_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE,
24: p_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
25: RETURN BOOLEAN AS

Line 23: FUNCTION find_dao(p_org_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE,

19: IS
20: SELECT *
21: FROM IGS_CA_DA
22: WHERE dt_alias = cp_dt_alias;
23: FUNCTION find_dao(p_org_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE,
24: p_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
25: RETURN BOOLEAN AS
26: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
27: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)

Line 24: p_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)

20: SELECT *
21: FROM IGS_CA_DA
22: WHERE dt_alias = cp_dt_alias;
23: FUNCTION find_dao(p_org_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE,
24: p_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
25: RETURN BOOLEAN AS
26: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
27: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
28: IS

Line 26: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;

22: WHERE dt_alias = cp_dt_alias;
23: FUNCTION find_dao(p_org_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE,
24: p_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
25: RETURN BOOLEAN AS
26: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
27: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
28: IS
29: SELECT *
30: FROM IGS_CA_DA_OFST

Line 27: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)

23: FUNCTION find_dao(p_org_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE,
24: p_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
25: RETURN BOOLEAN AS
26: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
27: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
28: IS
29: SELECT *
30: FROM IGS_CA_DA_OFST
31: WHERE dt_alias = cp_dt_alias;

Line 30: FROM IGS_CA_DA_OFST

26: v_dt_alias_offset_rec IGS_CA_DA_OFST%ROWTYPE;
27: CURSOR c_dt_alias_offset (cp_dt_alias IGS_CA_DA_OFST.dt_alias%TYPE)
28: IS
29: SELECT *
30: FROM IGS_CA_DA_OFST
31: WHERE dt_alias = cp_dt_alias;
32: BEGIN
33: IF (c_dt_alias_offset%ISOPEN = FALSE) THEN
34: OPEN c_dt_alias_offset(p_dt_alias);