eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SE_GEN_001 dependencies on WF_EVENT

Line 1593: l_wf_event_t WF_EVENT_T;

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

Line 1622: -- Initialize the wf_event_t object

1618: -- using a IGS_PE sequence for this.
1619:
1620: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val from DUAL;
1621:
1622: -- Initialize the wf_event_t object
1623: WF_EVENT_T.Initialize(l_wf_event_t);
1624:
1625: -- Set the event name
1626: l_wf_event_t.setEventName(pEventName => 'oracle.apps.igf.se.earnings.limit.reached');

Line 1623: WF_EVENT_T.Initialize(l_wf_event_t);

1619:
1620: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val from DUAL;
1621:
1622: -- Initialize the wf_event_t object
1623: WF_EVENT_T.Initialize(l_wf_event_t);
1624:
1625: -- Set the event name
1626: l_wf_event_t.setEventName(pEventName => 'oracle.apps.igf.se.earnings.limit.reached');
1627:

Line 1626: l_wf_event_t.setEventName(pEventName => 'oracle.apps.igf.se.earnings.limit.reached');

1622: -- Initialize the wf_event_t object
1623: WF_EVENT_T.Initialize(l_wf_event_t);
1624:
1625: -- Set the event name
1626: l_wf_event_t.setEventName(pEventName => 'oracle.apps.igf.se.earnings.limit.reached');
1627:
1628: -- Set the event key
1629: l_wf_event_t.setEventKey(
1630: pEventKey => 'oracle.apps.igf.se.earnings.limit.reached' || l_seq_val

Line 1629: l_wf_event_t.setEventKey(

1625: -- Set the event name
1626: l_wf_event_t.setEventName(pEventName => 'oracle.apps.igf.se.earnings.limit.reached');
1627:
1628: -- Set the event key
1629: l_wf_event_t.setEventKey(
1630: pEventKey => 'oracle.apps.igf.se.earnings.limit.reached' || l_seq_val
1631: );
1632:
1633: -- Set the parameter list

Line 1634: l_wf_event_t.setParameterList(

1630: pEventKey => 'oracle.apps.igf.se.earnings.limit.reached' || l_seq_val
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

Line 1640: wf_event.addparametertolist(

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');
1640: wf_event.addparametertolist(
1641: p_name => 'SUBJECT',
1642: p_value => fnd_message.get,
1643: p_parameterlist => l_wf_parameter_list_t
1644: );

Line 1648: wf_event.addparametertolist(

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');
1648: wf_event.addparametertolist(
1649: p_name => 'MESSGAE_BODY',
1650: p_value => fnd_message.get,
1651: p_parameterlist => l_wf_parameter_list_t
1652: );

Line 1655: wf_event.addparametertolist(

1651: p_parameterlist => l_wf_parameter_list_t
1652: );
1653:
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: );

Line 1661: wf_event.addparametertolist(

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',
1663: p_value => person_rec.full_name,
1664: p_parameterlist => l_wf_parameter_list_t
1665: );

Line 1667: wf_event.addparametertolist(

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',
1669: p_value => fund_rec.fund_code,
1670: p_parameterlist => l_wf_parameter_list_t
1671: );

Line 1673: wf_event.addparametertolist(

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',
1675: p_value => earned_amt_rec.paid_amt,
1676: p_parameterlist => l_wf_parameter_list_t
1677: );

Line 1680: wf_event.addparametertolist(

1676: p_parameterlist => l_wf_parameter_list_t
1677: );
1678:
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: );

Line 1686: wf_event.addparametertolist(

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',
1688: p_value => fund_rec.threshold_value,
1689: p_parameterlist => l_wf_parameter_list_t
1690: );

Line 1692: wf_Event.raise(

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',
1694: p_event_key => 'oracle.apps.igf.se.earnings.limit.reached' || l_seq_val,
1695: p_parameters => l_wf_parameter_list_t
1696: );