APPS.IGF_SE_GEN_001 dependencies on WF_PARAMETER_LIST_T

Line 1594: l_wf_parameter_list_t WF_PARAMETER_LIST_T;

1590: l_seq_val NUMBER;
1591: l_wf_installed fnd_lookups.lookup_code%TYPE;
1592:
1593: l_wf_event_t WF_EVENT_T;
1594: l_wf_parameter_list_t WF_PARAMETER_LIST_T;
1595:
1596: BEGIN
1597:
1598: -- get the profile value that is set for checking if workflow is installed

Line 1635: pParameterList => l_wf_parameter_list_t

1631: );
1632:
1633: -- Set the parameter list
1634: l_wf_event_t.setParameterList(
1635: pParameterList => l_wf_parameter_list_t
1636: );
1637:
1638: -- Pass Person Number, Person Name, Fund Code, Earned Amount and threshold percentage or value that is marked at the Fund Level as the event parameters
1639: fnd_message.set_name('IGF','IGF_SE_MSG_SUBJ');

Line 1643: p_parameterlist => l_wf_parameter_list_t

1639: fnd_message.set_name('IGF','IGF_SE_MSG_SUBJ');
1640: wf_event.addparametertolist(
1641: p_name => 'SUBJECT',
1642: p_value => fnd_message.get,
1643: p_parameterlist => l_wf_parameter_list_t
1644: );
1645:
1646: -- Get the body of the mail from fnd_new_messages and assign it to the attribute defined in the workflow definition
1647: fnd_message.set_name('IGF','IGF_AP_SAP_MSG_SUBJ');

Line 1651: p_parameterlist => l_wf_parameter_list_t

1647: fnd_message.set_name('IGF','IGF_AP_SAP_MSG_SUBJ');
1648: wf_event.addparametertolist(
1649: p_name => 'MESSGAE_BODY',
1650: p_value => fnd_message.get,
1651: p_parameterlist => l_wf_parameter_list_t
1652: );
1653:
1654:
1655: wf_event.addparametertolist(

Line 1658: p_parameterlist => l_wf_parameter_list_t

1654:
1655: wf_event.addparametertolist(
1656: p_name => 'PERSON_NUMBER',
1657: p_value => person_rec.person_number,
1658: p_parameterlist => l_wf_parameter_list_t
1659: );
1660:
1661: wf_event.addparametertolist(
1662: p_name => 'NAME',

Line 1664: p_parameterlist => l_wf_parameter_list_t

1660:
1661: wf_event.addparametertolist(
1662: p_name => 'NAME',
1663: p_value => person_rec.full_name,
1664: p_parameterlist => l_wf_parameter_list_t
1665: );
1666:
1667: wf_event.addparametertolist(
1668: p_name => 'FUND_CODE',

Line 1670: p_parameterlist => l_wf_parameter_list_t

1666:
1667: wf_event.addparametertolist(
1668: p_name => 'FUND_CODE',
1669: p_value => fund_rec.fund_code,
1670: p_parameterlist => l_wf_parameter_list_t
1671: );
1672:
1673: wf_event.addparametertolist(
1674: p_name => 'EARNED_AMOUNT',

Line 1676: p_parameterlist => l_wf_parameter_list_t

1672:
1673: wf_event.addparametertolist(
1674: p_name => 'EARNED_AMOUNT',
1675: p_value => earned_amt_rec.paid_amt,
1676: p_parameterlist => l_wf_parameter_list_t
1677: );
1678:
1679: IF fund_rec.threshold_perct IS NOT NULL THEN
1680: wf_event.addparametertolist(

Line 1683: p_parameterlist => l_wf_parameter_list_t

1679: IF fund_rec.threshold_perct IS NOT NULL THEN
1680: wf_event.addparametertolist(
1681: p_name => 'THRESHOLD_PERCT',
1682: p_value => fund_rec.threshold_perct,
1683: p_parameterlist => l_wf_parameter_list_t
1684: );
1685: ELSE
1686: wf_event.addparametertolist(
1687: p_name => 'THRESHOLD_VALUE',

Line 1689: p_parameterlist => l_wf_parameter_list_t

1685: ELSE
1686: wf_event.addparametertolist(
1687: p_name => 'THRESHOLD_VALUE',
1688: p_value => fund_rec.threshold_value,
1689: p_parameterlist => l_wf_parameter_list_t
1690: );
1691: END IF;
1692: wf_Event.raise(
1693: p_event_name => 'oracle.apps.igf.se.earnings.limit.reached',

Line 1695: p_parameters => l_wf_parameter_list_t

1691: END IF;
1692: wf_Event.raise(
1693: p_event_name => 'oracle.apps.igf.se.earnings.limit.reached',
1694: p_event_key => 'oracle.apps.igf.se.earnings.limit.reached' || l_seq_val,
1695: p_parameters => l_wf_parameter_list_t
1696: );
1697:
1698: END IF;
1699: