APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on DBMS_LOB

Line 1064: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);

1060: OR pts.system_person_type IN (''EMP'', ''CWK''))
1061: AND OTA_MANDATORY_ENROLL_UTIL.learner_can_enroll_in_class(:5,ppf.person_id) = ''Y''
1062: )QRSLT WHERE'|| usergroup_whereclause;
1063:
1064: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);
1065: FOR i IN 1..v_upperbound
1066: LOOP
1067: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt
1068: ,256 -- amount

Line 1067: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt

1063:
1064: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);
1065: FOR i IN 1..v_upperbound
1066: LOOP
1067: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt
1068: ,256 -- amount
1069: ,((i-1)*256)+1 -- offset
1070: );
1071: END LOOP;

Line 1519: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);

1515: OR pts.system_person_type IN (''EMP'', ''CWK''))
1516: AND OTA_MANDATORY_ENROLL_UTIL.learner_can_enroll_in_class(:5,ppf.person_id) = ''Y''
1517: )QRSLT WHERE'|| usergroup_whereclause;
1518:
1519: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);
1520: FOR i IN 1..v_upperbound
1521: LOOP
1522: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt
1523: ,256 -- amount

Line 1522: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt

1518:
1519: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);
1520: FOR i IN 1..v_upperbound
1521: LOOP
1522: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt
1523: ,256 -- amount
1524: ,((i-1)*256)+1 -- offset
1525: );
1526: END LOOP;

Line 2721: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);

2717: )
2718: OR pts.system_person_type IN (''EMP'', ''CWK''))
2719: )QRSLT WHERE'|| usergroup_whereclause;
2720:
2721: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);
2722: FOR i IN 1..v_upperbound
2723: LOOP
2724: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt
2725: ,256 -- amount

Line 2724: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt

2720:
2721: v_upperbound := CEIL(DBMS_LOB.GETLENGTH(sql_stmnt)/256);
2722: FOR i IN 1..v_upperbound
2723: LOOP
2724: v_split_sql_stmt(i) := DBMS_LOB.SUBSTR(sql_stmnt
2725: ,256 -- amount
2726: ,((i-1)*256)+1 -- offset
2727: );
2728: END LOOP;