APPS.IGS_RU_GEN_004 dependencies on IGS_PS_UNIT_RU

Line 56: -- This module inserts a IGS_PS_UNIT_RU asscoaited with a IGS_PS_UNIT. This involves:

52: --Created by : nsinha, Oracle India
53: --Date created: 12-Mar-2002
54: --
55: --Purpose:
56: -- This module inserts a IGS_PS_UNIT_RU asscoaited with a IGS_PS_UNIT. This involves:
57: -- Creating IGS_PS_UNIT_RU IGS_RU_RULE and associated records (IGS_RU_RULE) when the
58: -- IGS_PS_UNIT_RU does not already exist.
59: -- Set the default message number
60: --

Line 57: -- Creating IGS_PS_UNIT_RU IGS_RU_RULE and associated records (IGS_RU_RULE) when the

53: --Date created: 12-Mar-2002
54: --
55: --Purpose:
56: -- This module inserts a IGS_PS_UNIT_RU asscoaited with a IGS_PS_UNIT. This involves:
57: -- Creating IGS_PS_UNIT_RU IGS_RU_RULE and associated records (IGS_RU_RULE) when the
58: -- IGS_PS_UNIT_RU does not already exist.
59: -- Set the default message number
60: --
61: --Known limitations/enhancements and/or remarks:

Line 58: -- IGS_PS_UNIT_RU does not already exist.

54: --
55: --Purpose:
56: -- This module inserts a IGS_PS_UNIT_RU asscoaited with a IGS_PS_UNIT. This involves:
57: -- Creating IGS_PS_UNIT_RU IGS_RU_RULE and associated records (IGS_RU_RULE) when the
58: -- IGS_PS_UNIT_RU does not already exist.
59: -- Set the default message number
60: --
61: --Known limitations/enhancements and/or remarks:
62: --

Line 77: v_ur_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE;

73: DECLARE
74: v_rowid VARCHAR2(25);
75: v_rowid_pur VARCHAR2(25);
76: v_count NUMBER(6);
77: v_ur_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE;
78: s_n_next IGS_RU_RULE.sequence_number%TYPE;
79: CURSOR c_ur IS
80: SELECT ur.rul_sequence_number
81: FROM IGS_PS_UNIT_RU ur

Line 81: FROM IGS_PS_UNIT_RU ur

77: v_ur_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE;
78: s_n_next IGS_RU_RULE.sequence_number%TYPE;
79: CURSOR c_ur IS
80: SELECT ur.rul_sequence_number
81: FROM IGS_PS_UNIT_RU ur
82: WHERE ur.unit_cd = p_unit_cd AND
83: ur.s_rule_call_cd = p_s_rule_call_cd;
84: CURSOR c_ur_count IS
85: SELECT count(*)

Line 86: FROM IGS_PS_UNIT_RU ur

82: WHERE ur.unit_cd = p_unit_cd AND
83: ur.s_rule_call_cd = p_s_rule_call_cd;
84: CURSOR c_ur_count IS
85: SELECT count(*)
86: FROM IGS_PS_UNIT_RU ur
87: WHERE ur.unit_cd = p_unit_cd AND
88: ur.s_rule_call_cd = p_s_rule_call_cd;
89:
90: CURSOR C_IGS_RU_RULE_SEQ_NUM_S IS

Line 109: -- Create IGS_PS_UNIT_RU if it doesn't already exist.

105: p_message_name := 'IGS_GE_INVALID_VALUE';
106: RETURN FALSE;
107: END IF;
108:
109: -- Create IGS_PS_UNIT_RU if it doesn't already exist.
110:
111: OPEN c_ur;
112: FETCH c_ur INTO v_ur_sequence_number;
113: p_rul_sequence_number := v_ur_sequence_number;

Line 135: -- Create IGS_PS_UNIT_RU and associated records.

131: END IF;
132: CLOSE C_IGS_RU_RULE_SEQ_NUM_S;
133: END IF;
134:
135: -- Create IGS_PS_UNIT_RU and associated records.
136:
137: IGS_RU_RULE_PKG.Insert_Row(
138: x_rowid => v_rowid,
139: x_sequence_number => s_n_next

Line 144: IGS_PS_UNIT_RU_PKG.Insert_Row(

140: );
141:
142: p_rul_sequence_number := s_n_next;
143: IF p_insert_rule_only = FALSE THEN
144: IGS_PS_UNIT_RU_PKG.Insert_Row(
145: x_rowid => v_rowid_pur,
146: x_unit_cd => p_unit_cd,
147: x_s_rule_call_cd => p_s_rule_call_cd,
148: x_rul_sequence_number => s_n_next