DBA Data[Home] [Help]

APPS.AD_MANUAL_STEP_OBJECT dependencies on AD_TRACKABLE_ENTITIES

Line 99: l_level ad_trackable_entities.codelevel%type;

95: function is_on_codelevel (p_entity varchar2,
96: p_level varchar2)
97: return number
98: is
99: l_level ad_trackable_entities.codelevel%type;
100: l_baseline ad_trackable_entities.baseline%type;
101: l_status varchar2(10);
102: begin
103:

Line 100: l_baseline ad_trackable_entities.baseline%type;

96: p_level varchar2)
97: return number
98: is
99: l_level ad_trackable_entities.codelevel%type;
100: l_baseline ad_trackable_entities.baseline%type;
101: l_status varchar2(10);
102: begin
103:
104: ad_trackable_entities_pkg.get_code_level(p_entity,

Line 104: ad_trackable_entities_pkg.get_code_level(p_entity,

100: l_baseline ad_trackable_entities.baseline%type;
101: l_status varchar2(10);
102: begin
103:
104: ad_trackable_entities_pkg.get_code_level(p_entity,
105: l_level,
106: l_baseline,
107: l_status);
108: if (l_status = 'TRUE' and

Line 127: l_level ad_trackable_entities.codelevel%type;

123: function is_on_baseline (p_entity varchar2,
124: p_baseline varchar2)
125: return number
126: is
127: l_level ad_trackable_entities.codelevel%type;
128: l_baseline ad_trackable_entities.baseline%type;
129: l_status varchar2(10);
130: begin
131:

Line 128: l_baseline ad_trackable_entities.baseline%type;

124: p_baseline varchar2)
125: return number
126: is
127: l_level ad_trackable_entities.codelevel%type;
128: l_baseline ad_trackable_entities.baseline%type;
129: l_status varchar2(10);
130: begin
131:
132: ad_trackable_entities_pkg.get_code_level(p_entity,

Line 132: ad_trackable_entities_pkg.get_code_level(p_entity,

128: l_baseline ad_trackable_entities.baseline%type;
129: l_status varchar2(10);
130: begin
131:
132: ad_trackable_entities_pkg.get_code_level(p_entity,
133: l_level,
134: l_baseline,
135: l_status);
136: if (l_status = 'TRUE' and