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.OKL_SSC_WF dependencies on WF_EVENT

Line 48: wf_event.addparametertolist('SSCREQUESTORID'

44:
45: begin
46:
47: -- pass the parameters to the event
48: wf_event.addparametertolist('SSCREQUESTORID'
49: ,requestorId
50: ,l_parameter_list);
51: wf_event.addparametertolist('ASSETID'
52: ,parent_line_id

Line 51: wf_event.addparametertolist('ASSETID'

47: -- pass the parameters to the event
48: wf_event.addparametertolist('SSCREQUESTORID'
49: ,requestorId
50: ,l_parameter_list);
51: wf_event.addparametertolist('ASSETID'
52: ,parent_line_id
53: ,l_parameter_list);
54:
55: wf_event.addparametertolist('NEWSITEID1'

Line 55: wf_event.addparametertolist('NEWSITEID1'

51: wf_event.addparametertolist('ASSETID'
52: ,parent_line_id
53: ,l_parameter_list);
54:
55: wf_event.addparametertolist('NEWSITEID1'
56: ,new_site_id1
57: ,l_parameter_list);
58:
59: wf_event.addparametertolist('NEWSITEID2'

Line 59: wf_event.addparametertolist('NEWSITEID2'

55: wf_event.addparametertolist('NEWSITEID1'
56: ,new_site_id1
57: ,l_parameter_list);
58:
59: wf_event.addparametertolist('NEWSITEID2'
60: ,new_site_id2
61: ,l_parameter_list);
62: wf_event.addparametertolist('OLDSITE1'
63: ,old_site_id1

Line 62: wf_event.addparametertolist('OLDSITE1'

58:
59: wf_event.addparametertolist('NEWSITEID2'
60: ,new_site_id2
61: ,l_parameter_list);
62: wf_event.addparametertolist('OLDSITE1'
63: ,old_site_id1
64: ,l_parameter_list);
65: wf_event.addparametertolist('OLDSITE2'
66: ,old_site_id2

Line 65: wf_event.addparametertolist('OLDSITE2'

61: ,l_parameter_list);
62: wf_event.addparametertolist('OLDSITE1'
63: ,old_site_id1
64: ,l_parameter_list);
65: wf_event.addparametertolist('OLDSITE2'
66: ,old_site_id2
67: ,l_parameter_list);
68: wf_event.addparametertolist('TRX_DATE'
69: ,fnd_date.date_to_canonical(trx_date)

Line 68: wf_event.addparametertolist('TRX_DATE'

64: ,l_parameter_list);
65: wf_event.addparametertolist('OLDSITE2'
66: ,old_site_id2
67: ,l_parameter_list);
68: wf_event.addparametertolist('TRX_DATE'
69: ,fnd_date.date_to_canonical(trx_date)
70: ,l_parameter_list);
71:
72:

Line 1480: FROM wf_event_subscriptions a,

1476: -----------------------------------------------------------------------
1477: IS
1478: CURSOR cu0 IS
1479: SELECT 'Y'
1480: FROM wf_event_subscriptions a,
1481: wf_events b
1482: WHERE a.event_filter_guid = b.guid
1483: AND a.status = 'ENABLED'
1484: AND b.name = p_event_name

Line 1481: wf_events b

1477: IS
1478: CURSOR cu0 IS
1479: SELECT 'Y'
1480: FROM wf_event_subscriptions a,
1481: wf_events b
1482: WHERE a.event_filter_guid = b.guid
1483: AND a.status = 'ENABLED'
1484: AND b.name = p_event_name
1485: AND rownum = 1;

Line 1538: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);

1534: fetch event_number into l_event_key;
1535: close event_number;
1536:
1537:
1538: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);

Line 1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);

1535: close event_number;
1536:
1537:
1538: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);

Line 1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);

1536:
1537:
1538: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);

Line 1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);

1537:
1538: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);

Line 1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);

1538: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);

Line 1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);

1539: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);

Line 1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);

1540: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);

Line 1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);

1541: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1549:

Line 1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);

1542: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1549:
1550: if (provider_id IS NOT null) then --existing provider workflow

Line 1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);

1543: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1549:
1550: if (provider_id IS NOT null) then --existing provider workflow
1551:

Line 1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);

1544: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1545: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1546: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1547: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1549:
1550: if (provider_id IS NOT null) then --existing provider workflow
1551:
1552: WF_EVENT.raise('oracle.apps.okl.ssc.submitthirdpartyinsurance',

Line 1552: WF_EVENT.raise('oracle.apps.okl.ssc.submitthirdpartyinsurance',

1548: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1549:
1550: if (provider_id IS NOT null) then --existing provider workflow
1551:
1552: WF_EVENT.raise('oracle.apps.okl.ssc.submitthirdpartyinsurance',
1553: l_event_key,
1554: null,
1555: l_params);
1556: else

Line 1558: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);

1554: null,
1555: l_params);
1556: else
1557:
1558: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);

Line 1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);

1555: l_params);
1556: else
1557:
1558: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);

Line 1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);

1556: else
1557:
1558: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);

Line 1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);

1557:
1558: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);

Line 1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);

1558: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);

Line 1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);

1559: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);

Line 1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);

1560: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);

Line 1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);

1561: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);

Line 1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);

1562: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);

Line 1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);

1563: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1571:

Line 1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);

1564: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1571:
1572: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',

Line 1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);

1565: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1571:
1572: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',
1573: l_event_key,

Line 1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);

1566: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1567: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1571:
1572: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',
1573: l_event_key,
1574: null,

Line 1572: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',

1568: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1569: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1570: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1571:
1572: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',
1573: l_event_key,
1574: null,
1575: l_params);
1576:

Line 2532: WF_EVENT.raise2( 'oracle.apps.okl.ssc.requestinvoiceformatchange',item_key, null, 'SSCKID', contract_id , 'SSCREQUESTORID', user_id, 'SSCINVFORID', invoice_format_id ) ;

2528: FETCH item_key_seq INTO item_key_rec;
2529: item_key := to_char( item_key_rec.key);
2530: CLOSE item_key_seq;
2531:
2532: WF_EVENT.raise2( 'oracle.apps.okl.ssc.requestinvoiceformatchange',item_key, null, 'SSCKID', contract_id , 'SSCREQUESTORID', user_id, 'SSCINVFORID', invoice_format_id ) ;
2533:
2534:
2535:
2536: end raise_inv_format_chg_event;

Line 2575: WF_EVENT.raise2('oracle.apps.okl.ssc.requestbillinginfochange',item_key, null, 'SSCKID', contract_id , 'SSCREQUESTORID', user_id, 'SSCNEWBILLSITEID', bill_site_id,'ORG_ID',l_org_id) ;

2571:
2572: mo_global.init('OKL');
2573: MO_GLOBAL.set_policy_context('S',l_org_id);
2574:
2575: WF_EVENT.raise2('oracle.apps.okl.ssc.requestbillinginfochange',item_key, null, 'SSCKID', contract_id , 'SSCREQUESTORID', user_id, 'SSCNEWBILLSITEID', bill_site_id,'ORG_ID',l_org_id) ;
2576:
2577:
2578: end raise_billinf_change_event;
2579:

Line 2797: WF_EVENT.raise2('oracle.apps.okl.ssc.cancelInsurance'

2793: x_return_status := l_return_status ;
2794: x_msg_count := l_msg_count ;
2795: x_msg_data := l_msg_data ;
2796: IF (l_return_status='S') THEN
2797: WF_EVENT.raise2('oracle.apps.okl.ssc.cancelInsurance'
2798: ,l_event_name||l_seq, null
2799: ,'SSCINSPOLID', p_polid
2800: ,'SSCREQUESTORID',p_userid);
2801: END IF;

Line 2973: wf_event.AddParameterToList('CLAIM_ID',TO_CHAR(p_claim_id),l_parameter_list);

2969: select OKLSSC_WFITEMKEY_S.nextval INTO l_seq FROM DUAL ;
2970: l_key := l_event_name ||l_seq ;
2971:
2972: --Set Parameters
2973: wf_event.AddParameterToList('CLAIM_ID',TO_CHAR(p_claim_id),l_parameter_list);
2974:
2975: -- Call it again if you have more than one parameter
2976: -- Keep data type (text) only
2977:

Line 2980: wf_event.raise( p_event_name => l_event_name

2976: -- Keep data type (text) only
2977:
2978: -- Raise Event
2979: -- It is overloaded function so use according to requirement
2980: wf_event.raise( p_event_name => l_event_name
2981: ,p_event_key => l_key
2982: ,p_parameters => l_parameter_list);
2983: l_parameter_list.DELETE;
2984:

Line 3653: WF_EVENT.raise2(l_event_name,

3649: FND_MSG_PUB.ADD;
3650: l_return_status := OKC_API.G_RET_STS_ERROR;
3651: raise api_exception;
3652: ELSE
3653: WF_EVENT.raise2(l_event_name,
3654: l_event_name||l_seq,
3655: null,
3656: 'SSCQUOTEID', p_qte_id,
3657: 'SSCREQUESTORID',p_user_id);

Line 3819: wf_event.addparametertolist('SSCREQUESTORID'

3815:
3816: begin
3817:
3818: -- pass the parameters to the event
3819: wf_event.addparametertolist('SSCREQUESTORID'
3820: ,requestorId
3821: ,l_parameter_list);
3822: wf_event.addparametertolist('SSCTASID'
3823: ,requestId

Line 3822: wf_event.addparametertolist('SSCTASID'

3818: -- pass the parameters to the event
3819: wf_event.addparametertolist('SSCREQUESTORID'
3820: ,requestorId
3821: ,l_parameter_list);
3822: wf_event.addparametertolist('SSCTASID'
3823: ,requestId
3824: ,l_parameter_list);
3825:
3826: wf_event.addparametertolist('SSCTALTYPE'

Line 3826: wf_event.addparametertolist('SSCTALTYPE'

3822: wf_event.addparametertolist('SSCTASID'
3823: ,requestId
3824: ,l_parameter_list);
3825:
3826: wf_event.addparametertolist('SSCTALTYPE'
3827: ,requestType
3828: ,l_parameter_list);
3829:
3830:

Line 3887: wf_event.addparametertolist('SSCREQUESTORID'

3883: FETCH assets_key_seq INTO assets_key_rec;
3884: assets_key := to_char( assets_key_rec.key);
3885: CLOSE assets_key_seq;
3886: -- pass the parameters to the event
3887: wf_event.addparametertolist('SSCREQUESTORID'
3888: ,requestorId
3889: ,l_parameter_list);
3890: wf_event.addparametertolist('SSCTASID'
3891: ,requestId

Line 3890: wf_event.addparametertolist('SSCTASID'

3886: -- pass the parameters to the event
3887: wf_event.addparametertolist('SSCREQUESTORID'
3888: ,requestorId
3889: ,l_parameter_list);
3890: wf_event.addparametertolist('SSCTASID'
3891: ,requestId
3892: ,l_parameter_list);
3893: wf_event.addparametertolist('SSCTALTYPE'
3894: ,requestType

Line 3893: wf_event.addparametertolist('SSCTALTYPE'

3889: ,l_parameter_list);
3890: wf_event.addparametertolist('SSCTASID'
3891: ,requestId
3892: ,l_parameter_list);
3893: wf_event.addparametertolist('SSCTALTYPE'
3894: ,requestType
3895: ,l_parameter_list);
3896:
3897: okl_wf_pvt.raise_event(p_api_version => l_api_version