DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on WF_PARAMETER_LIST_T

Line 1327: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

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: --
1331: -- initialize the wf_event_t object

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 1352: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1354: P_NAME => 'COHORT_INSTANCE' ,
1355: P_VALUE => p_cohort_instance,
1356: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1356: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1358: P_NAME => 'NEW_COHORT_STATUS' ,
1359: P_VALUE => p_new_cohort_status ,
1360: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1360: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1362: P_NAME => 'NEW_RANK_STATUS' ,
1363: P_VALUE => p_new_rank_status ,
1364: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1364: P_PARAMETERLIST => l_wf_parameter_list_t);

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:
1366: --
1367: -- raise the event
1368: --

Line 1372: p_parameters => l_wf_parameter_list_t);

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:
1374: END raise_clsrank_be_cr001;
1375:
1376:

Line 1387: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

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: --
1391: -- initialize the wf_event_t object

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 1412: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1414: P_NAME => 'PERSON_NUMBER' ,
1415: P_VALUE => p_person_number,
1416: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1416: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1418: P_NAME => 'PERSON_NAME' ,
1419: P_VALUE => p_person_name ,
1420: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1420: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1422: P_NAME => 'CURRENT_RANK' ,
1423: P_VALUE => p_current_rank ,
1424: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1424: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1426: P_NAME => 'OVERRIDE_RANK' ,
1427: P_VALUE => p_override_rank ,
1428: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1428: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1430: P_NAME => 'OVRBY_PERSON_ID' ,
1431: P_VALUE => p_ovrby_person_id ,
1432: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1432: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1434: P_NAME => 'OVRBY_PERSON_NUMBER' ,
1435: P_VALUE => p_ovrby_person_number ,
1436: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1436: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1438: P_NAME => 'OVRBY_PERSON_NAME' ,
1439: P_VALUE => p_ovrby_person_name ,
1440: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1440: P_PARAMETERLIST => l_wf_parameter_list_t);

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: --
1442: -- raise the event
1443: --
1444: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.pr.clsrank_be_cr002',

Line 1447: p_parameters => l_wf_parameter_list_t);

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:
1449: END raise_clsrank_be_cr002;
1450:
1451:

Line 1459: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

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: --
1463: -- initialize the wf_event_t object

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 1484: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1486: P_NAME => 'COHORT_INSTANCE' ,
1487: P_VALUE => p_cohort_instance,
1488: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1488: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1490: P_NAME => 'NEW_RUN_DATE' ,
1491: P_VALUE => p_run_date ,
1492: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1492: P_PARAMETERLIST => l_wf_parameter_list_t);

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(
1494: P_NAME => 'NEW_COHORT_TOTAL_STUDENTS' ,
1495: P_VALUE => p_cohort_total_students ,
1496: P_PARAMETERLIST => l_wf_parameter_list_t);

Line 1496: P_PARAMETERLIST => l_wf_parameter_list_t);

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:
1498: --
1499: -- raise the event
1500: --

Line 1504: p_parameters => l_wf_parameter_list_t);

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:
1506: END raise_clsrank_be_cr003;
1507:
1508: