APPS.OTA_BATCH_ACTION_API dependencies on OTA_BATCH_RANGES

Line 14: l_range_id OTA_BATCH_RANGES.RANGE_ID%type;

10: ,p_starting_person_action_id in number default null
11: ,p_ending_person_action_id in number default null
12: ,p_object_version_number out nocopy number) as
13:
14: l_range_id OTA_BATCH_RANGES.RANGE_ID%type;
15: l_object_verion_number OTA_BATCH_RANGES.OBJECT_VERSION_NUMBER%Type := 1;
16:
17: Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;
18:

Line 15: l_object_verion_number OTA_BATCH_RANGES.OBJECT_VERSION_NUMBER%Type := 1;

11: ,p_ending_person_action_id in number default null
12: ,p_object_version_number out nocopy number) as
13:
14: l_range_id OTA_BATCH_RANGES.RANGE_ID%type;
15: l_object_verion_number OTA_BATCH_RANGES.OBJECT_VERSION_NUMBER%Type := 1;
16:
17: Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;
18:
19: begin

Line 17: Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;

13:
14: l_range_id OTA_BATCH_RANGES.RANGE_ID%type;
15: l_object_verion_number OTA_BATCH_RANGES.OBJECT_VERSION_NUMBER%Type := 1;
16:
17: Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;
18:
19: begin
20:
21: Open C_Sel1;

Line 25: insert into OTA_BATCH_RANGES

21: Open C_Sel1;
22: Fetch C_Sel1 Into l_range_id;
23: Close C_Sel1;
24:
25: insert into OTA_BATCH_RANGES
26: (RANGE_ID,
27: BATCH_SOURCE_CD, -- newly added
28: BATCH_ACTION_ID,
29: RANGE_STATUS_CD,