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.OTA_MANDATORY_ENROLL_UTIL dependencies on DBMS_SQL

Line 15: enr_prereq_type dbms_sql.varchar2_table,

11: p_event_id IN NUMBER) IS
12:
13:
14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,

Line 16: event_id dbms_sql.number_table,

12:
13:
14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,

Line 17: person_id dbms_sql.number_table,

13:
14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,

Line 18: organization_id dbms_sql.number_table,

14: TYPE mandatory_event_assoc_rec IS RECORD(
15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,

Line 19: job_id dbms_sql.number_table,

15: enr_prereq_type dbms_sql.varchar2_table,
16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table

Line 20: position_id dbms_sql.varchar2_table,

16: event_id dbms_sql.number_table,
17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );

Line 21: org_structure_version_id dbms_sql.number_table,

17: person_id dbms_sql.number_table,
18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );
25:

Line 22: user_group_id dbms_sql.number_table,

18: organization_id dbms_sql.number_table,
19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );
25:
26: l_rec mandatory_event_assoc_rec;

Line 23: requestor_id dbms_sql.number_table

19: job_id dbms_sql.number_table,
20: position_id dbms_sql.varchar2_table,
21: org_structure_version_id dbms_sql.number_table,
22: user_group_id dbms_sql.number_table,
23: requestor_id dbms_sql.number_table
24: );
25:
26: l_rec mandatory_event_assoc_rec;
27: l_date ota_events.course_end_date%type;

Line 127: enr_prereq_type dbms_sql.varchar2_table,

123: p_event_id IN NUMBER) IS
124:
125:
126: TYPE mandatory_event_assoc_rec IS RECORD(
127: enr_prereq_type dbms_sql.varchar2_table,
128: event_id dbms_sql.number_table,
129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,

Line 128: event_id dbms_sql.number_table,

124:
125:
126: TYPE mandatory_event_assoc_rec IS RECORD(
127: enr_prereq_type dbms_sql.varchar2_table,
128: event_id dbms_sql.number_table,
129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,

Line 129: person_id dbms_sql.number_table,

125:
126: TYPE mandatory_event_assoc_rec IS RECORD(
127: enr_prereq_type dbms_sql.varchar2_table,
128: event_id dbms_sql.number_table,
129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,

Line 130: organization_id dbms_sql.number_table,

126: TYPE mandatory_event_assoc_rec IS RECORD(
127: enr_prereq_type dbms_sql.varchar2_table,
128: event_id dbms_sql.number_table,
129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,
134: user_group_id dbms_sql.number_table,

Line 131: job_id dbms_sql.number_table,

127: enr_prereq_type dbms_sql.varchar2_table,
128: event_id dbms_sql.number_table,
129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,
134: user_group_id dbms_sql.number_table,
135: requestor_id dbms_sql.number_table

Line 132: position_id dbms_sql.varchar2_table,

128: event_id dbms_sql.number_table,
129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,
134: user_group_id dbms_sql.number_table,
135: requestor_id dbms_sql.number_table
136: );

Line 133: org_structure_version_id dbms_sql.number_table,

129: person_id dbms_sql.number_table,
130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,
134: user_group_id dbms_sql.number_table,
135: requestor_id dbms_sql.number_table
136: );
137:

Line 134: user_group_id dbms_sql.number_table,

130: organization_id dbms_sql.number_table,
131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,
134: user_group_id dbms_sql.number_table,
135: requestor_id dbms_sql.number_table
136: );
137:
138: cursor csr_check_mand_multi_running(c_conc_req_id fnd_concurrent_requests.REQUEST_ID%type) is

Line 135: requestor_id dbms_sql.number_table

131: job_id dbms_sql.number_table,
132: position_id dbms_sql.varchar2_table,
133: org_structure_version_id dbms_sql.number_table,
134: user_group_id dbms_sql.number_table,
135: requestor_id dbms_sql.number_table
136: );
137:
138: cursor csr_check_mand_multi_running(c_conc_req_id fnd_concurrent_requests.REQUEST_ID%type) is
139: select 1 from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

Line 958: v_split_sql_stmt DBMS_SQL.VARCHAR2S;

954: l_ota_global_bg_prof_val number;
955:
956: sql_stmnt clob;
957: usergroup_whereclause clob;
958: v_split_sql_stmt DBMS_SQL.VARCHAR2S;
959: v_upperbound NUMBER;
960: v_cur INTEGER;
961: v_person_id number;
962: v_job_id number;

Line 1073: v_cur := DBMS_SQL.OPEN_CURSOR;

1069: ,((i-1)*256)+1 -- offset
1070: );
1071: END LOOP;
1072:
1073: v_cur := DBMS_SQL.OPEN_CURSOR;
1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);

Line 1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);

1070: );
1071: END LOOP;
1072:
1073: v_cur := DBMS_SQL.OPEN_CURSOR;
1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);

Line 1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);

1071: END LOOP;
1072:
1073: v_cur := DBMS_SQL.OPEN_CURSOR;
1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);

Line 1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);

1072:
1073: v_cur := DBMS_SQL.OPEN_CURSOR;
1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);

Line 1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);

1073: v_cur := DBMS_SQL.OPEN_CURSOR;
1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);

Line 1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);

1074: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:

Line 1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);

1075: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);

Line 1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);

1076: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);

Line 1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);

1077: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1078: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);

Line 1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);

1079: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);

Line 1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);

1080: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1088:

Line 1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);

1081: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1088:
1089: ignore := DBMS_SQL.EXECUTE(v_cur);

Line 1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);

1082:
1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1088:
1089: ignore := DBMS_SQL.EXECUTE(v_cur);
1090:

Line 1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);

1083: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1084: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1088:
1089: ignore := DBMS_SQL.EXECUTE(v_cur);
1090:
1091: LOOP

Line 1089: ignore := DBMS_SQL.EXECUTE(v_cur);

1085: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1086: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1087: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1088:
1089: ignore := DBMS_SQL.EXECUTE(v_cur);
1090:
1091: LOOP
1092: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1093: -- get column values of the row

Line 1092: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN

1088:
1089: ignore := DBMS_SQL.EXECUTE(v_cur);
1090:
1091: LOOP
1092: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1093: -- get column values of the row
1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);

Line 1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);

1090:
1091: LOOP
1092: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1093: -- get column values of the row
1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);

Line 1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);

1091: LOOP
1092: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1093: -- get column values of the row
1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);

Line 1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);

1092: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1093: -- get column values of the row
1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1100: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);

Line 1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);

1093: -- get column values of the row
1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1100: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1101:

Line 1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);

1094: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1100: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1101:
1102: create_request_member_record(v_person_id,

Line 1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);

1095: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1100: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1101:
1102: create_request_member_record(v_person_id,
1103: request.mandatory_enr_request_id,

Line 1100: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);

1096: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1097: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1098: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1099: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1100: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1101:
1102: create_request_member_record(v_person_id,
1103: request.mandatory_enr_request_id,
1104: request.event_id,

Line 1117: DBMS_SQL.CLOSE_CURSOR(v_cur);

1113: EXIT;
1114: END IF;
1115: END LOOP;
1116:
1117: DBMS_SQL.CLOSE_CURSOR(v_cur);
1118:
1119: /*OPEN csr_get_lrnr_in_ug FOR sql_stmnt USING request.event_id,request.event_id,l_event_start_date,l_event_start_date,request.event_id;
1120: LOOP
1121: FETCH csr_get_lrnr_in_ug into lrnr_rec;

Line 1341: v_split_sql_stmt DBMS_SQL.VARCHAR2S;

1337: l_ota_global_bg_prof_val number;
1338:
1339: sql_stmnt clob;
1340: usergroup_whereclause clob;
1341: v_split_sql_stmt DBMS_SQL.VARCHAR2S;
1342: v_upperbound NUMBER;
1343: v_cur INTEGER;
1344: v_person_id number;
1345: v_job_id number;

Line 1528: v_cur := DBMS_SQL.OPEN_CURSOR;

1524: ,((i-1)*256)+1 -- offset
1525: );
1526: END LOOP;
1527:
1528: v_cur := DBMS_SQL.OPEN_CURSOR;
1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);

Line 1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);

1525: );
1526: END LOOP;
1527:
1528: v_cur := DBMS_SQL.OPEN_CURSOR;
1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);

Line 1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);

1526: END LOOP;
1527:
1528: v_cur := DBMS_SQL.OPEN_CURSOR;
1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);

Line 1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);

1527:
1528: v_cur := DBMS_SQL.OPEN_CURSOR;
1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);

Line 1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);

1528: v_cur := DBMS_SQL.OPEN_CURSOR;
1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);

Line 1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);

1529: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:

Line 1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);

1530: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);

Line 1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);

1531: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);

Line 1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);

1532: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
1533: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_is_crs_prereq_comp,1);
1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);

Line 1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);

1534: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_is_comp_prereq_comp,1);
1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);

Line 1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);

1535: DBMS_SQL.DEFINE_COLUMN(v_cur, 6, v_org_id);
1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1543:

Line 1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);

1536: DBMS_SQL.DEFINE_COLUMN(v_cur, 7, v_assign_id);
1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1543:
1544: ignore := DBMS_SQL.EXECUTE(v_cur);

Line 1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);

1537:
1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1543:
1544: ignore := DBMS_SQL.EXECUTE(v_cur);
1545:

Line 1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);

1538: DBMS_SQL.BIND_VARIABLE(v_cur, ':1', request.event_id);
1539: DBMS_SQL.BIND_VARIABLE(v_cur, ':2', request.event_id);
1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1543:
1544: ignore := DBMS_SQL.EXECUTE(v_cur);
1545:
1546: LOOP

Line 1544: ignore := DBMS_SQL.EXECUTE(v_cur);

1540: DBMS_SQL.BIND_VARIABLE(v_cur, ':3', l_event_start_date);
1541: DBMS_SQL.BIND_VARIABLE(v_cur, ':4', l_event_start_date);
1542: DBMS_SQL.BIND_VARIABLE(v_cur, ':5', request.event_id);
1543:
1544: ignore := DBMS_SQL.EXECUTE(v_cur);
1545:
1546: LOOP
1547: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1548: -- get column values of the row

Line 1547: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN

1543:
1544: ignore := DBMS_SQL.EXECUTE(v_cur);
1545:
1546: LOOP
1547: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1548: -- get column values of the row
1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);

Line 1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);

1545:
1546: LOOP
1547: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1548: -- get column values of the row
1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);

Line 1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);

1546: LOOP
1547: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1548: -- get column values of the row
1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);

Line 1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);

1547: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
1548: -- get column values of the row
1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1555: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);

Line 1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);

1548: -- get column values of the row
1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1555: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1556:

Line 1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);

1549: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1555: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1556:
1557: create_request_member_record(v_person_id,

Line 1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);

1550: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1555: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1556:
1557: create_request_member_record(v_person_id,
1558: request.mandatory_enr_request_id,

Line 1555: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);

1551: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
1552: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_is_crs_prereq_comp);
1553: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_is_comp_prereq_comp);
1554: DBMS_SQL.COLUMN_VALUE(v_cur, 6, v_org_id);
1555: DBMS_SQL.COLUMN_VALUE(v_cur, 7, v_assign_id);
1556:
1557: create_request_member_record(v_person_id,
1558: request.mandatory_enr_request_id,
1559: request.event_id,

Line 1603: DBMS_SQL.CLOSE_CURSOR(v_cur);

1599: EXIT;
1600: END IF;
1601: END LOOP;
1602:
1603: DBMS_SQL.CLOSE_CURSOR(v_cur);
1604:
1605: /*OPEN csr_get_lrnr_in_ug FOR sql_stmnt USING request.event_id,request.event_id,l_event_start_date,l_event_start_date,request.event_id;
1606: LOOP
1607: FETCH csr_get_lrnr_in_ug into lrnr_rec;

Line 2231: enr_prereq_type dbms_sql.varchar2_table,

2227: p_cert_id IN NUMBER) IS
2228:
2229:
2230: TYPE auto_cert_subscr_rec IS RECORD(
2231: enr_prereq_type dbms_sql.varchar2_table,
2232: event_id dbms_sql.number_table,
2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,

Line 2232: event_id dbms_sql.number_table,

2228:
2229:
2230: TYPE auto_cert_subscr_rec IS RECORD(
2231: enr_prereq_type dbms_sql.varchar2_table,
2232: event_id dbms_sql.number_table,
2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,

Line 2233: person_id dbms_sql.number_table,

2229:
2230: TYPE auto_cert_subscr_rec IS RECORD(
2231: enr_prereq_type dbms_sql.varchar2_table,
2232: event_id dbms_sql.number_table,
2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,

Line 2234: organization_id dbms_sql.number_table,

2230: TYPE auto_cert_subscr_rec IS RECORD(
2231: enr_prereq_type dbms_sql.varchar2_table,
2232: event_id dbms_sql.number_table,
2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,

Line 2235: job_id dbms_sql.number_table,

2231: enr_prereq_type dbms_sql.varchar2_table,
2232: event_id dbms_sql.number_table,
2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,
2239: requestor_id dbms_sql.number_table,

Line 2236: position_id dbms_sql.varchar2_table,

2232: event_id dbms_sql.number_table,
2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,
2239: requestor_id dbms_sql.number_table,
2240: certification_id dbms_sql.number_table

Line 2237: org_structure_version_id dbms_sql.number_table,

2233: person_id dbms_sql.number_table,
2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,
2239: requestor_id dbms_sql.number_table,
2240: certification_id dbms_sql.number_table
2241: );

Line 2238: user_group_id dbms_sql.number_table,

2234: organization_id dbms_sql.number_table,
2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,
2239: requestor_id dbms_sql.number_table,
2240: certification_id dbms_sql.number_table
2241: );
2242:

Line 2239: requestor_id dbms_sql.number_table,

2235: job_id dbms_sql.number_table,
2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,
2239: requestor_id dbms_sql.number_table,
2240: certification_id dbms_sql.number_table
2241: );
2242:
2243: l_rec auto_cert_subscr_rec;

Line 2240: certification_id dbms_sql.number_table

2236: position_id dbms_sql.varchar2_table,
2237: org_structure_version_id dbms_sql.number_table,
2238: user_group_id dbms_sql.number_table,
2239: requestor_id dbms_sql.number_table,
2240: certification_id dbms_sql.number_table
2241: );
2242:
2243: l_rec auto_cert_subscr_rec;
2244: l_date ota_events.course_end_date%type;

Line 2514: v_split_sql_stmt DBMS_SQL.VARCHAR2S;

2510: l_cert_status_code NUMBER :=0;
2511:
2512: sql_stmnt clob;
2513: usergroup_whereclause clob;
2514: v_split_sql_stmt DBMS_SQL.VARCHAR2S;
2515: v_upperbound NUMBER;
2516: v_cur INTEGER;
2517: v_person_id number;
2518: v_job_id number;

Line 2730: v_cur := DBMS_SQL.OPEN_CURSOR;

2726: ,((i-1)*256)+1 -- offset
2727: );
2728: END LOOP;
2729:
2730: v_cur := DBMS_SQL.OPEN_CURSOR;
2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);

Line 2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);

2727: );
2728: END LOOP;
2729:
2730: v_cur := DBMS_SQL.OPEN_CURSOR;
2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);

Line 2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);

2728: END LOOP;
2729:
2730: v_cur := DBMS_SQL.OPEN_CURSOR;
2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);
2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);

Line 2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);

2729:
2730: v_cur := DBMS_SQL.OPEN_CURSOR;
2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);
2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);
2737:

Line 2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);

2730: v_cur := DBMS_SQL.OPEN_CURSOR;
2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);
2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);
2737:
2738: ignore := DBMS_SQL.EXECUTE(v_cur);

Line 2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);

2731: DBMS_SQL.PARSE(v_cur, v_split_sql_stmt, 1, v_upperbound, FALSE, DBMS_SQL.NATIVE);
2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);
2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);
2737:
2738: ignore := DBMS_SQL.EXECUTE(v_cur);
2739:

Line 2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);

2732: DBMS_SQL.DEFINE_COLUMN(v_cur, 1, v_person_id);
2733: DBMS_SQL.DEFINE_COLUMN(v_cur, 2, v_job_id);
2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);
2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);
2737:
2738: ignore := DBMS_SQL.EXECUTE(v_cur);
2739:
2740: LOOP

Line 2738: ignore := DBMS_SQL.EXECUTE(v_cur);

2734: DBMS_SQL.DEFINE_COLUMN(v_cur, 3, v_pos_id);
2735: DBMS_SQL.DEFINE_COLUMN(v_cur, 4, v_org_id);
2736: DBMS_SQL.DEFINE_COLUMN(v_cur, 5, v_assign_id);
2737:
2738: ignore := DBMS_SQL.EXECUTE(v_cur);
2739:
2740: LOOP
2741: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
2742: -- get column values of the row

Line 2741: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN

2737:
2738: ignore := DBMS_SQL.EXECUTE(v_cur);
2739:
2740: LOOP
2741: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
2742: -- get column values of the row
2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);

Line 2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);

2739:
2740: LOOP
2741: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
2742: -- get column values of the row
2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
2746: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_org_id);
2747: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_assign_id);

Line 2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);

2740: LOOP
2741: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
2742: -- get column values of the row
2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
2746: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_org_id);
2747: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_assign_id);
2748:

Line 2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);

2741: IF DBMS_SQL.FETCH_ROWS(v_cur)>0 THEN
2742: -- get column values of the row
2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
2746: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_org_id);
2747: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_assign_id);
2748:
2749: learner_can_enroll_in_cert(request.certification_id,v_person_id,l_cert_status_code, l_cert_enrollment_id);

Line 2746: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_org_id);

2742: -- get column values of the row
2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
2746: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_org_id);
2747: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_assign_id);
2748:
2749: learner_can_enroll_in_cert(request.certification_id,v_person_id,l_cert_status_code, l_cert_enrollment_id);
2750:

Line 2747: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_assign_id);

2743: DBMS_SQL.COLUMN_VALUE(v_cur, 1, v_person_id);
2744: DBMS_SQL.COLUMN_VALUE(v_cur, 2, v_job_id);
2745: DBMS_SQL.COLUMN_VALUE(v_cur, 3, v_pos_id);
2746: DBMS_SQL.COLUMN_VALUE(v_cur, 4, v_org_id);
2747: DBMS_SQL.COLUMN_VALUE(v_cur, 5, v_assign_id);
2748:
2749: learner_can_enroll_in_cert(request.certification_id,v_person_id,l_cert_status_code, l_cert_enrollment_id);
2750:
2751: IF l_cert_status_code = l_subc_doesnot_exist THEN

Line 2809: DBMS_SQL.CLOSE_CURSOR(v_cur);

2805: EXIT;
2806: END IF;
2807: END LOOP;
2808:
2809: DBMS_SQL.CLOSE_CURSOR(v_cur);
2810:
2811: /*OPEN csr_get_lrnr_in_ug FOR sql_stmnt;
2812: LOOP
2813: FETCH csr_get_lrnr_in_ug into lrnr_rec;