APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_MANDATORY_ENROLL_UTIL

Line 1: package body ota_mandatory_enroll_util as

1: package body ota_mandatory_enroll_util as
2: /* $Header: otmandatoryenr.pkb 120.6.12020000.21 2013/06/24 13:01:14 jaysridh ship $ */
3:
4:
5: g_package varchar2(33) := 'ota_mandatory_enroll_util.'; -- Global package name

Line 5: g_package varchar2(33) := 'ota_mandatory_enroll_util.'; -- Global package name

1: package body ota_mandatory_enroll_util as
2: /* $Header: otmandatoryenr.pkb 120.6.12020000.21 2013/06/24 13:01:14 jaysridh ship $ */
3:
4:
5: g_package varchar2(33) := 'ota_mandatory_enroll_util.'; -- Global package name
6:
7:
8:
9: PROCEDURE process_mandatory_event_assoc( ERRBUF OUT NOCOPY VARCHAR2,

Line 262: ota_mandatory_enroll_util.check_all_slaves_finished

258: l_conc_request_id := p_action_id;
259: create_enrollments_multi(l_conc_request_id);
260: end if;
261:
262: ota_mandatory_enroll_util.check_all_slaves_finished
263: (p_rpt_flag => TRUE);
264:
265: -- Start workflow AND send a notification to the requestor
266: if p_action_id is null then

Line 1061: AND OTA_MANDATORY_ENROLL_UTIL.learner_can_enroll_in_class(:5,ppf.person_id) = ''Y''

1057: AND ptp.system_person_type IN (''EMP'', ''CWK'')
1058: AND ptf.person_id = ppf.PERSON_ID)
1059: )
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

Line 1516: AND OTA_MANDATORY_ENROLL_UTIL.learner_can_enroll_in_class(:5,ppf.person_id) = ''Y''

1512: AND ptp.system_person_type IN (''EMP'', ''CWK'')
1513: AND ptf.person_id = ppf.PERSON_ID)
1514: )
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

Line 1688: ota_mandatory_enroll_util.g_num_processes := ota_mandatory_enroll_util.g_num_processes + 1;

1684:
1685: --
1686: -- Store the request id of the concurrent request
1687: --
1688: ota_mandatory_enroll_util.g_num_processes := ota_mandatory_enroll_util.g_num_processes + 1;
1689: ota_mandatory_enroll_util.g_processes_tbl(ota_mandatory_enroll_util.g_num_processes) := l_request_id;
1690:
1691: --
1692: end loop;

Line 1689: ota_mandatory_enroll_util.g_processes_tbl(ota_mandatory_enroll_util.g_num_processes) := l_request_id;

1685: --
1686: -- Store the request id of the concurrent request
1687: --
1688: ota_mandatory_enroll_util.g_num_processes := ota_mandatory_enroll_util.g_num_processes + 1;
1689: ota_mandatory_enroll_util.g_processes_tbl(ota_mandatory_enroll_util.g_num_processes) := l_request_id;
1690:
1691: --
1692: end loop;
1693: --

Line 2348: ota_mandatory_enroll_util.check_all_slaves_finished

2344: l_conc_request_id := p_action_id;
2345: create_cert_subscriptions(l_conc_request_id);
2346: end if;
2347:
2348: ota_mandatory_enroll_util.check_all_slaves_finished
2349: (p_rpt_flag => TRUE);
2350:
2351: if p_action_id is null then
2352:

Line 2914: ota_mandatory_enroll_util.g_num_processes := ota_mandatory_enroll_util.g_num_processes + 1;

2910:
2911: --
2912: -- Store the request id of the concurrent request
2913: --
2914: ota_mandatory_enroll_util.g_num_processes := ota_mandatory_enroll_util.g_num_processes + 1;
2915: ota_mandatory_enroll_util.g_processes_tbl(ota_mandatory_enroll_util.g_num_processes) := l_request_id;
2916:
2917: --
2918: end loop;

Line 2915: ota_mandatory_enroll_util.g_processes_tbl(ota_mandatory_enroll_util.g_num_processes) := l_request_id;

2911: --
2912: -- Store the request id of the concurrent request
2913: --
2914: ota_mandatory_enroll_util.g_num_processes := ota_mandatory_enroll_util.g_num_processes + 1;
2915: ota_mandatory_enroll_util.g_processes_tbl(ota_mandatory_enroll_util.g_num_processes) := l_request_id;
2916:
2917: --
2918: end loop;
2919: --

Line 3355: END ota_mandatory_enroll_util;

3351: end if;
3352: hr_utility.set_location ('Leaving '||l_proc,5);
3353: end purge_mand_enroll_data;
3354:
3355: END ota_mandatory_enroll_util;