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 1394: FROM wf_event_subscriptions a,

1390: -----------------------------------------------------------------------
1391: IS
1392: CURSOR cu0 IS
1393: SELECT 'Y'
1394: FROM wf_event_subscriptions a,
1395: wf_events b
1396: WHERE a.event_filter_guid = b.guid
1397: AND a.status = 'ENABLED'
1398: AND b.name = p_event_name

Line 1395: wf_events b

1391: IS
1392: CURSOR cu0 IS
1393: SELECT 'Y'
1394: FROM wf_event_subscriptions a,
1395: wf_events b
1396: WHERE a.event_filter_guid = b.guid
1397: AND a.status = 'ENABLED'
1398: AND b.name = p_event_name
1399: AND rownum = 1;

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

1448: fetch event_number into l_event_key;
1449: close event_number;
1450:
1451:
1452: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1453: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);

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

1449: close event_number;
1450:
1451:
1452: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1453: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);

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

1450:
1451:
1452: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1453: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);

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

1451:
1452: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1453: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);

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

1452: WF_EVENT.AddParameterToList('SSCKID',to_char(contract_id),l_params);
1453: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);

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

1453: WF_EVENT.AddParameterToList('SSCINSPROVIDERID',to_char(provider_id),l_params);
1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1461: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);

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

1454: WF_EVENT.AddParameterToList('SSCSITEID',to_char(site_id),l_params);
1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1461: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1462: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);

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

1455: WF_EVENT.AddParameterToList('SSCPOLICYNUMBER',policy_number,l_params);
1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1461: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1462: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1463:

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

1456: WF_EVENT.AddParameterToList('SSCSTARTDATE',to_char(policy_start_date),l_params);
1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1461: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1462: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1463:
1464: if (provider_id IS NOT null) then --existing provider workflow

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

1457: WF_EVENT.AddParameterToList('SSCENDDATE',to_char(policy_end_date),l_params);
1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1461: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1462: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1463:
1464: if (provider_id IS NOT null) then --existing provider workflow
1465:

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

1458: WF_EVENT.AddParameterToList('SSCCOVERAGEAMOUNT',to_char(coverage_amount),l_params);
1459: WF_EVENT.AddParameterToList('SSCDEDUCTIBLE',to_char(deductible),l_params);
1460: WF_EVENT.AddParameterToList('SSCLESSORINSURED',lessor_insured,l_params);
1461: WF_EVENT.AddParameterToList('SSCLESSORPAYEE',lessor_payee,l_params);
1462: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1463:
1464: if (provider_id IS NOT null) then --existing provider workflow
1465:
1466: WF_EVENT.raise('oracle.apps.okl.ssc.submitthirdpartyinsurance',

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

1462: WF_EVENT.AddParameterToList('REQUESTOR',to_char(requestor_id),l_params);
1463:
1464: if (provider_id IS NOT null) then --existing provider workflow
1465:
1466: WF_EVENT.raise('oracle.apps.okl.ssc.submitthirdpartyinsurance',
1467: l_event_key,
1468: null,
1469: l_params);
1470: else

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

1468: null,
1469: l_params);
1470: else
1471:
1472: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1473: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);

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

1469: l_params);
1470: else
1471:
1472: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1473: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);

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

1470: else
1471:
1472: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1473: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);

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

1471:
1472: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1473: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);

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

1472: WF_EVENT.AddParameterToList('SSCNEWPROVIDERNAME',provider_name,l_params);
1473: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);

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

1473: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS1',address1,l_params);
1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);

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

1474: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS2',address2,l_params);
1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);

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

1475: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS3',address3,l_params);
1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);

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

1476: WF_EVENT.AddParameterToList('SSCPROVIDERADDRESS4',address4,l_params);
1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1484: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);

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

1477: WF_EVENT.AddParameterToList('SSCPROVIDERCITY',city,l_params);
1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1484: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1485:

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

1478: WF_EVENT.AddParameterToList('SSCPROVIDERSTATECODE',state,l_params);
1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1484: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1485:
1486: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',

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

1479: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTRY',country,l_params);
1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1484: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1485:
1486: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',
1487: l_event_key,

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

1480: WF_EVENT.AddParameterToList('SSCPROVIDERCOUNTY',county,l_params);
1481: WF_EVENT.AddParameterToList('SSCPROVIDERPROVINCE',province,l_params);
1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1484: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1485:
1486: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',
1487: l_event_key,
1488: null,

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

1482: WF_EVENT.AddParameterToList('SSCPROVIDERZIPCODE',zip,l_params);
1483: WF_EVENT.AddParameterToList('SSCPROVIDERPHONENUMBER',telephone,l_params);
1484: WF_EVENT.AddParameterToList('SSCPROVIDEREMAILADDRESS',email,l_params);
1485:
1486: WF_EVENT.raise('oracle.apps.okl.ssc.createandsubmitthirdpartyinsurance',
1487: l_event_key,
1488: null,
1489: l_params);
1490:

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

2442: FETCH item_key_seq INTO item_key_rec;
2443: item_key := to_char( item_key_rec.key);
2444: CLOSE item_key_seq;
2445:
2446: WF_EVENT.raise2( 'oracle.apps.okl.ssc.requestinvoiceformatchange',item_key, null, 'SSCKID', contract_id , 'SSCREQUESTORID', user_id, 'SSCINVFORID', invoice_format_id ) ;
2447:
2448:
2449:
2450: end raise_inv_format_chg_event;

Line 2489: 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) ;

2485:
2486: mo_global.init('OKL');
2487: MO_GLOBAL.set_policy_context('S',l_org_id);
2488:
2489: 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) ;
2490:
2491:
2492: end raise_billinf_change_event;
2493:

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

2707: x_return_status := l_return_status ;
2708: x_msg_count := l_msg_count ;
2709: x_msg_data := l_msg_data ;
2710: IF (l_return_status='S') THEN
2711: WF_EVENT.raise2('oracle.apps.okl.ssc.cancelInsurance'
2712: ,l_event_name||l_seq, null
2713: ,'SSCINSPOLID', p_polid
2714: ,'SSCREQUESTORID',p_userid);
2715: END IF;

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

2883: select OKLSSC_WFITEMKEY_S.nextval INTO l_seq FROM DUAL ;
2884: l_key := l_event_name ||l_seq ;
2885:
2886: --Set Parameters
2887: wf_event.AddParameterToList('CLAIM_ID',TO_CHAR(p_claim_id),l_parameter_list);
2888:
2889: -- Call it again if you have more than one parameter
2890: -- Keep data type (text) only
2891:

Line 2894: wf_event.raise( p_event_name => l_event_name

2890: -- Keep data type (text) only
2891:
2892: -- Raise Event
2893: -- It is overloaded function so use according to requirement
2894: wf_event.raise( p_event_name => l_event_name
2895: ,p_event_key => l_key
2896: ,p_parameters => l_parameter_list);
2897: l_parameter_list.DELETE;
2898:

Line 3567: WF_EVENT.raise2(l_event_name,

3563: FND_MSG_PUB.ADD;
3564: l_return_status := OKC_API.G_RET_STS_ERROR;
3565: raise api_exception;
3566: ELSE
3567: WF_EVENT.raise2(l_event_name,
3568: l_event_name||l_seq,
3569: null,
3570: 'SSCQUOTEID', p_qte_id,
3571: 'SSCREQUESTORID',p_user_id);

Line 3733: wf_event.addparametertolist('SSCREQUESTORID'

3729:
3730: begin
3731:
3732: -- pass the parameters to the event
3733: wf_event.addparametertolist('SSCREQUESTORID'
3734: ,requestorId
3735: ,l_parameter_list);
3736: wf_event.addparametertolist('SSCTASID'
3737: ,requestId

Line 3736: wf_event.addparametertolist('SSCTASID'

3732: -- pass the parameters to the event
3733: wf_event.addparametertolist('SSCREQUESTORID'
3734: ,requestorId
3735: ,l_parameter_list);
3736: wf_event.addparametertolist('SSCTASID'
3737: ,requestId
3738: ,l_parameter_list);
3739:
3740: wf_event.addparametertolist('SSCTALTYPE'

Line 3740: wf_event.addparametertolist('SSCTALTYPE'

3736: wf_event.addparametertolist('SSCTASID'
3737: ,requestId
3738: ,l_parameter_list);
3739:
3740: wf_event.addparametertolist('SSCTALTYPE'
3741: ,requestType
3742: ,l_parameter_list);
3743:
3744: