1322: p_cohort_instance IN VARCHAR2,
1323: p_new_cohort_status IN VARCHAR2,
1324: p_new_rank_status IN VARCHAR2) IS
1325:
1326: l_wf_event_t WF_EVENT_T;
1327: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1328:
1329: BEGIN
1330: --
1327: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1328:
1329: BEGIN
1330: --
1331: -- initialize the wf_event_t object
1332: --
1333: WF_EVENT_T.Initialize(l_wf_event_t);
1334: --
1335: -- set the event name
1329: BEGIN
1330: --
1331: -- initialize the wf_event_t object
1332: --
1333: WF_EVENT_T.Initialize(l_wf_event_t);
1334: --
1335: -- set the event name
1336: --
1337: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr001');
1333: WF_EVENT_T.Initialize(l_wf_event_t);
1334: --
1335: -- set the event name
1336: --
1337: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr001');
1338: --
1339: -- set the event key but before the select a number from sequenec
1340: --
1341: l_wf_event_t.setEventKey ( pEventKey => 'be_cr001'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1337: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr001');
1338: --
1339: -- set the event key but before the select a number from sequenec
1340: --
1341: l_wf_event_t.setEventKey ( pEventKey => 'be_cr001'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1342: --
1343: -- set the parameter list
1344: --
1345: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1341: l_wf_event_t.setEventKey ( pEventKey => 'be_cr001'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1342: --
1343: -- set the parameter list
1344: --
1345: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1346: --
1347: -- now add the parameters to the parameter list
1348: --
1349: wf_event.addparametertolist(
1382: p_ovrby_person_id IN NUMBER,
1383: p_ovrby_person_number IN VARCHAR2,
1384: p_ovrby_person_name IN VARCHAR2) IS
1385:
1386: l_wf_event_t WF_EVENT_T;
1387: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1388:
1389: BEGIN
1390: --
1387: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1388:
1389: BEGIN
1390: --
1391: -- initialize the wf_event_t object
1392: --
1393: WF_EVENT_T.Initialize(l_wf_event_t);
1394: --
1395: -- set the event name
1389: BEGIN
1390: --
1391: -- initialize the wf_event_t object
1392: --
1393: WF_EVENT_T.Initialize(l_wf_event_t);
1394: --
1395: -- set the event name
1396: --
1397: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr002');
1393: WF_EVENT_T.Initialize(l_wf_event_t);
1394: --
1395: -- set the event name
1396: --
1397: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr002');
1398: --
1399: -- set the event key but before the select a number from sequenec
1400: --
1401: l_wf_event_t.setEventKey ( pEventKey => 'be_cr002'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1397: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr002');
1398: --
1399: -- set the event key but before the select a number from sequenec
1400: --
1401: l_wf_event_t.setEventKey ( pEventKey => 'be_cr002'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1402: --
1403: -- set the parameter list
1404: --
1405: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1401: l_wf_event_t.setEventKey ( pEventKey => 'be_cr002'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1402: --
1403: -- set the parameter list
1404: --
1405: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1406: --
1407: -- now add the parameters to the parameter list
1408: --
1409: wf_event.addparametertolist(
1454: p_cohort_instance IN VARCHAR2,
1455: p_run_date IN VARCHAR2,
1456: p_cohort_total_students IN VARCHAR2) IS
1457:
1458: l_wf_event_t WF_EVENT_T;
1459: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1460:
1461: BEGIN
1462: --
1459: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1460:
1461: BEGIN
1462: --
1463: -- initialize the wf_event_t object
1464: --
1465: WF_EVENT_T.Initialize(l_wf_event_t);
1466: --
1467: -- set the event name
1461: BEGIN
1462: --
1463: -- initialize the wf_event_t object
1464: --
1465: WF_EVENT_T.Initialize(l_wf_event_t);
1466: --
1467: -- set the event name
1468: --
1469: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr003');
1465: WF_EVENT_T.Initialize(l_wf_event_t);
1466: --
1467: -- set the event name
1468: --
1469: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr003');
1470: --
1471: -- set the event key but before the select a number from sequenec
1472: --
1473: l_wf_event_t.setEventKey ( pEventKey => 'be_cr003'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1469: l_wf_event_t.setEventName( pEventName => 'oracle.apps.igs.pr.clsrank_be_cr003');
1470: --
1471: -- set the event key but before the select a number from sequenec
1472: --
1473: l_wf_event_t.setEventKey ( pEventKey => 'be_cr003'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1474: --
1475: -- set the parameter list
1476: --
1477: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1473: l_wf_event_t.setEventKey ( pEventKey => 'be_cr003'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
1474: --
1475: -- set the parameter list
1476: --
1477: l_wf_event_t.setParameterList ( pParameterList => l_wf_parameter_list_t );
1478: --
1479: -- now add the parameters to the parameter list
1480: --
1481: wf_event.addparametertolist(