DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on WF_EVENT

Line 1326: l_wf_event_t WF_EVENT_T;

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: --

Line 1331: -- initialize the wf_event_t object

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

Line 1333: WF_EVENT_T.Initialize(l_wf_event_t);

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');

Line 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') );

Line 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 );

Line 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(

Line 1349: wf_event.addparametertolist(

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(
1350: P_NAME => 'COHORT_NAME' ,
1351: P_VALUE => p_cohort_name ,
1352: P_PARAMETERLIST => l_wf_parameter_list_t);
1353: wf_event.addparametertolist(

Line 1353: wf_event.addparametertolist(

1349: wf_event.addparametertolist(
1350: P_NAME => 'COHORT_NAME' ,
1351: P_VALUE => p_cohort_name ,
1352: P_PARAMETERLIST => l_wf_parameter_list_t);
1353: wf_event.addparametertolist(
1354: P_NAME => 'COHORT_INSTANCE' ,
1355: P_VALUE => p_cohort_instance,
1356: P_PARAMETERLIST => l_wf_parameter_list_t);
1357: wf_event.addparametertolist(

Line 1357: wf_event.addparametertolist(

1353: wf_event.addparametertolist(
1354: P_NAME => 'COHORT_INSTANCE' ,
1355: P_VALUE => p_cohort_instance,
1356: P_PARAMETERLIST => l_wf_parameter_list_t);
1357: wf_event.addparametertolist(
1358: P_NAME => 'NEW_COHORT_STATUS' ,
1359: P_VALUE => p_new_cohort_status ,
1360: P_PARAMETERLIST => l_wf_parameter_list_t);
1361: wf_event.addparametertolist(

Line 1361: wf_event.addparametertolist(

1357: wf_event.addparametertolist(
1358: P_NAME => 'NEW_COHORT_STATUS' ,
1359: P_VALUE => p_new_cohort_status ,
1360: P_PARAMETERLIST => l_wf_parameter_list_t);
1361: wf_event.addparametertolist(
1362: P_NAME => 'NEW_RANK_STATUS' ,
1363: P_VALUE => p_new_rank_status ,
1364: P_PARAMETERLIST => l_wf_parameter_list_t);
1365:

Line 1369: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr001',

1365:
1366: --
1367: -- raise the event
1368: --
1369: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr001',
1370: p_event_key => 'be_cr001'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
1371: p_event_data => NULL,
1372: p_parameters => l_wf_parameter_list_t);
1373:

Line 1386: l_wf_event_t WF_EVENT_T;

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: --

Line 1391: -- initialize the wf_event_t object

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

Line 1393: WF_EVENT_T.Initialize(l_wf_event_t);

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');

Line 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') );

Line 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 );

Line 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(

Line 1409: wf_event.addparametertolist(

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(
1410: P_NAME => 'PERSON_ID' ,
1411: P_VALUE => p_person_id ,
1412: P_PARAMETERLIST => l_wf_parameter_list_t);
1413: wf_event.addparametertolist(

Line 1413: wf_event.addparametertolist(

1409: wf_event.addparametertolist(
1410: P_NAME => 'PERSON_ID' ,
1411: P_VALUE => p_person_id ,
1412: P_PARAMETERLIST => l_wf_parameter_list_t);
1413: wf_event.addparametertolist(
1414: P_NAME => 'PERSON_NUMBER' ,
1415: P_VALUE => p_person_number,
1416: P_PARAMETERLIST => l_wf_parameter_list_t);
1417: wf_event.addparametertolist(

Line 1417: wf_event.addparametertolist(

1413: wf_event.addparametertolist(
1414: P_NAME => 'PERSON_NUMBER' ,
1415: P_VALUE => p_person_number,
1416: P_PARAMETERLIST => l_wf_parameter_list_t);
1417: wf_event.addparametertolist(
1418: P_NAME => 'PERSON_NAME' ,
1419: P_VALUE => p_person_name ,
1420: P_PARAMETERLIST => l_wf_parameter_list_t);
1421: wf_event.addparametertolist(

Line 1421: wf_event.addparametertolist(

1417: wf_event.addparametertolist(
1418: P_NAME => 'PERSON_NAME' ,
1419: P_VALUE => p_person_name ,
1420: P_PARAMETERLIST => l_wf_parameter_list_t);
1421: wf_event.addparametertolist(
1422: P_NAME => 'CURRENT_RANK' ,
1423: P_VALUE => p_current_rank ,
1424: P_PARAMETERLIST => l_wf_parameter_list_t);
1425: wf_event.addparametertolist(

Line 1425: wf_event.addparametertolist(

1421: wf_event.addparametertolist(
1422: P_NAME => 'CURRENT_RANK' ,
1423: P_VALUE => p_current_rank ,
1424: P_PARAMETERLIST => l_wf_parameter_list_t);
1425: wf_event.addparametertolist(
1426: P_NAME => 'OVERRIDE_RANK' ,
1427: P_VALUE => p_override_rank ,
1428: P_PARAMETERLIST => l_wf_parameter_list_t);
1429: wf_event.addparametertolist(

Line 1429: wf_event.addparametertolist(

1425: wf_event.addparametertolist(
1426: P_NAME => 'OVERRIDE_RANK' ,
1427: P_VALUE => p_override_rank ,
1428: P_PARAMETERLIST => l_wf_parameter_list_t);
1429: wf_event.addparametertolist(
1430: P_NAME => 'OVRBY_PERSON_ID' ,
1431: P_VALUE => p_ovrby_person_id ,
1432: P_PARAMETERLIST => l_wf_parameter_list_t);
1433: wf_event.addparametertolist(

Line 1433: wf_event.addparametertolist(

1429: wf_event.addparametertolist(
1430: P_NAME => 'OVRBY_PERSON_ID' ,
1431: P_VALUE => p_ovrby_person_id ,
1432: P_PARAMETERLIST => l_wf_parameter_list_t);
1433: wf_event.addparametertolist(
1434: P_NAME => 'OVRBY_PERSON_NUMBER' ,
1435: P_VALUE => p_ovrby_person_number ,
1436: P_PARAMETERLIST => l_wf_parameter_list_t);
1437: wf_event.addparametertolist(

Line 1437: wf_event.addparametertolist(

1433: wf_event.addparametertolist(
1434: P_NAME => 'OVRBY_PERSON_NUMBER' ,
1435: P_VALUE => p_ovrby_person_number ,
1436: P_PARAMETERLIST => l_wf_parameter_list_t);
1437: wf_event.addparametertolist(
1438: P_NAME => 'OVRBY_PERSON_NAME' ,
1439: P_VALUE => p_ovrby_person_name ,
1440: P_PARAMETERLIST => l_wf_parameter_list_t);
1441: --

Line 1444: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr002',

1440: P_PARAMETERLIST => l_wf_parameter_list_t);
1441: --
1442: -- raise the event
1443: --
1444: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr002',
1445: p_event_key => 'be_cr002'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
1446: p_event_data => NULL,
1447: p_parameters => l_wf_parameter_list_t);
1448:

Line 1458: l_wf_event_t WF_EVENT_T;

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: --

Line 1463: -- initialize the wf_event_t object

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

Line 1465: WF_EVENT_T.Initialize(l_wf_event_t);

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');

Line 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') );

Line 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 );

Line 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(

Line 1481: wf_event.addparametertolist(

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(
1482: P_NAME => 'COHORT_NAME' ,
1483: P_VALUE => p_cohort_name ,
1484: P_PARAMETERLIST => l_wf_parameter_list_t);
1485: wf_event.addparametertolist(

Line 1485: wf_event.addparametertolist(

1481: wf_event.addparametertolist(
1482: P_NAME => 'COHORT_NAME' ,
1483: P_VALUE => p_cohort_name ,
1484: P_PARAMETERLIST => l_wf_parameter_list_t);
1485: wf_event.addparametertolist(
1486: P_NAME => 'COHORT_INSTANCE' ,
1487: P_VALUE => p_cohort_instance,
1488: P_PARAMETERLIST => l_wf_parameter_list_t);
1489: wf_event.addparametertolist(

Line 1489: wf_event.addparametertolist(

1485: wf_event.addparametertolist(
1486: P_NAME => 'COHORT_INSTANCE' ,
1487: P_VALUE => p_cohort_instance,
1488: P_PARAMETERLIST => l_wf_parameter_list_t);
1489: wf_event.addparametertolist(
1490: P_NAME => 'NEW_RUN_DATE' ,
1491: P_VALUE => p_run_date ,
1492: P_PARAMETERLIST => l_wf_parameter_list_t);
1493: wf_event.addparametertolist(

Line 1493: wf_event.addparametertolist(

1489: wf_event.addparametertolist(
1490: P_NAME => 'NEW_RUN_DATE' ,
1491: P_VALUE => p_run_date ,
1492: P_PARAMETERLIST => l_wf_parameter_list_t);
1493: wf_event.addparametertolist(
1494: P_NAME => 'NEW_COHORT_TOTAL_STUDENTS' ,
1495: P_VALUE => p_cohort_total_students ,
1496: P_PARAMETERLIST => l_wf_parameter_list_t);
1497:

Line 1501: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr003',

1497:
1498: --
1499: -- raise the event
1500: --
1501: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr003',
1502: p_event_key => 'be_cr003'||TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),
1503: p_event_data => NULL,
1504: p_parameters => l_wf_parameter_list_t);
1505: