DBA Data[Home] [Help]

APPS.IGS_AD_WRKFLOW_PKG dependencies on WF_EVENT

Line 1029: l_event_t wf_event_t;

1025: p_applicant_name IN VARCHAR2,
1026: p_applicant_full_name IN VARCHAR2
1027: )
1028: IS
1029: l_event_t wf_event_t;
1030: l_parameter_list_t wf_parameter_list_t;
1031: l_itemKey varchar2(100);
1032: l_incomplt_appl_url varchar2(1000);
1033:

Line 1042: -- initialize the wf_event_t object

1038:
1039:
1040: BEGIN
1041:
1042: -- initialize the wf_event_t object
1043: --
1044: wf_event_t.Initialize(l_event_t);
1045:
1046: OPEN cur_seq ;

Line 1044: wf_event_t.Initialize(l_event_t);

1040: BEGIN
1041:
1042: -- initialize the wf_event_t object
1043: --
1044: wf_event_t.Initialize(l_event_t);
1045:
1046: OPEN cur_seq ;
1047: FETCH cur_seq INTO l_itemKey ;
1048: CLOSE cur_seq ;

Line 1052: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);

1048: CLOSE cur_seq ;
1049:
1050:
1051:
1052: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1053: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1054: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_full_name, p_parameterlist=>l_parameter_list_t);
1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);
1056:

Line 1053: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);

1049:
1050:
1051:
1052: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1053: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1054: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_full_name, p_parameterlist=>l_parameter_list_t);
1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);
1056:
1057: -- raise the event

Line 1054: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_full_name, p_parameterlist=>l_parameter_list_t);

1050:
1051:
1052: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1053: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1054: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_full_name, p_parameterlist=>l_parameter_list_t);
1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);
1056:
1057: -- raise the event
1058:

Line 1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);

1051:
1052: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1053: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1054: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_full_name, p_parameterlist=>l_parameter_list_t);
1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);
1056:
1057: -- raise the event
1058:
1059: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.incmpl_appl',

Line 1059: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.incmpl_appl',

1055: -- wf_event.AddParameterToList ( p_Name => 'IA_INCOM_APPL_URL',p_Value => l_incomplt_appl_url, p_parameterlist=>l_parameter_list_t);
1056:
1057: -- raise the event
1058:
1059: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.incmpl_appl',
1060: p_event_key => l_itemKey,
1061: p_parameters => l_parameter_list_t);
1062:
1063: l_parameter_list_t.delete;

Line 1534: l_event_t wf_event_t;

1530: p_alt_code_acad IN VARCHAR2,
1531: p_alt_code_adm IN VARCHAR2
1532: )
1533: IS
1534: l_event_t wf_event_t;
1535: l_parameter_list_t wf_parameter_list_t;
1536: l_itemKey varchar2(100);
1537: l_incomplt_appl_url varchar2(1000);
1538:

Line 1547: -- initialize the wf_event_t object

1543:
1544:
1545: BEGIN
1546:
1547: -- initialize the wf_event_t object
1548: --
1549: wf_event_t.Initialize(l_event_t);
1550:
1551: OPEN cur_seq ;

Line 1549: wf_event_t.Initialize(l_event_t);

1545: BEGIN
1546:
1547: -- initialize the wf_event_t object
1548: --
1549: wf_event_t.Initialize(l_event_t);
1550:
1551: OPEN cur_seq ;
1552: FETCH cur_seq INTO l_itemKey ;
1553: CLOSE cur_seq ;

Line 1557: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);

1553: CLOSE cur_seq ;
1554:
1555:
1556:
1557: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1558: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1559: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1560:
1561: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);

Line 1558: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);

1554:
1555:
1556:
1557: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1558: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1559: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1560:
1561: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1562: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);

Line 1559: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);

1555:
1556:
1557: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1558: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1559: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1560:
1561: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1562: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);
1563:

Line 1561: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);

1557: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1558: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1559: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1560:
1561: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1562: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);
1563:
1564: --
1565: -- raise the event

Line 1562: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);

1558: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1559: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1560:
1561: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1562: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);
1563:
1564: --
1565: -- raise the event
1566: --

Line 1567: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.adm_req',

1563:
1564: --
1565: -- raise the event
1566: --
1567: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.adm_req',
1568: p_event_key => l_itemKey,
1569: p_parameters => l_parameter_list_t);
1570:
1571: l_parameter_list_t.delete;

Line 1587: l_event_t wf_event_t;

1583: p_alt_code_acad IN VARCHAR2,
1584: p_alt_code_adm IN VARCHAR2
1585: )
1586: IS
1587: l_event_t wf_event_t;
1588: l_parameter_list_t wf_parameter_list_t;
1589: l_itemKey varchar2(100);
1590: l_incomplt_appl_url varchar2(1000);
1591:

Line 1600: -- initialize the wf_event_t object

1596:
1597:
1598: BEGIN
1599:
1600: -- initialize the wf_event_t object
1601: --
1602: wf_event_t.Initialize(l_event_t);
1603:
1604: OPEN cur_seq ;

Line 1602: wf_event_t.Initialize(l_event_t);

1598: BEGIN
1599:
1600: -- initialize the wf_event_t object
1601: --
1602: wf_event_t.Initialize(l_event_t);
1603:
1604: OPEN cur_seq ;
1605: FETCH cur_seq INTO l_itemKey ;
1606: CLOSE cur_seq ;

Line 1609: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);

1605: FETCH cur_seq INTO l_itemKey ;
1606: CLOSE cur_seq ;
1607:
1608:
1609: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1610: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1611: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1612:
1613: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);

Line 1610: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);

1606: CLOSE cur_seq ;
1607:
1608:
1609: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1610: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1611: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1612:
1613: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1614: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);

Line 1611: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);

1607:
1608:
1609: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1610: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1611: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1612:
1613: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1614: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);
1615:

Line 1613: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);

1609: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_ID',p_Value => p_applicant_id, p_parameterlist=>l_parameter_list_t);
1610: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1611: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1612:
1613: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1614: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);
1615:
1616: --
1617: -- raise the event

Line 1614: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);

1610: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_NAME',p_Value => p_applicant_name, p_parameterlist=>l_parameter_list_t);
1611: wf_event.AddParameterToList ( p_Name => 'IA_PERSON_FULL_NAME',p_Value => p_applicant_display_name, p_parameterlist=>l_parameter_list_t);
1612:
1613: wf_event.AddParameterToList ( p_Name => 'IA_ACAD_CALENDAR',p_Value => p_alt_code_acad, p_parameterlist=>l_parameter_list_t);
1614: wf_event.AddParameterToList ( p_Name => 'IA_ADM_CALENDAR',p_Value => p_alt_code_adm, p_parameterlist=>l_parameter_list_t);
1615:
1616: --
1617: -- raise the event
1618: --

Line 1620: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.post_adm_req',

1616: --
1617: -- raise the event
1618: --
1619:
1620: WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.ad.appl.post_adm_req',
1621: p_event_key => l_itemKey,
1622: p_parameters => l_parameter_list_t);
1623:
1624: l_parameter_list_t.delete;