[Home] [Help]
41:
42: wf_debug ('Value of l_seq' || l_seq);
43: --defining event key value
44: l_event_key := p_event_name || l_seq;
45: --Adding all the input parameters to the varray list for wf_event.raise parameter
46: wf_event.addparametertolist ('TRANSACTION_ID',
47: p_transaction_id,
48: l_parameter_list
49: );
42: wf_debug ('Value of l_seq' || l_seq);
43: --defining event key value
44: l_event_key := p_event_name || l_seq;
45: --Adding all the input parameters to the varray list for wf_event.raise parameter
46: wf_event.addparametertolist ('TRANSACTION_ID',
47: p_transaction_id,
48: l_parameter_list
49: );
50: wf_event.addparametertolist ('LEASE_ID', p_lease_id, l_parameter_list);
46: wf_event.addparametertolist ('TRANSACTION_ID',
47: p_transaction_id,
48: l_parameter_list
49: );
50: wf_event.addparametertolist ('LEASE_ID', p_lease_id, l_parameter_list);
51: wf_event.addparametertolist ('OLD_LEASE_STATUS',
52: p_old_lease_status,
53: l_parameter_list
54: );
47: p_transaction_id,
48: l_parameter_list
49: );
50: wf_event.addparametertolist ('LEASE_ID', p_lease_id, l_parameter_list);
51: wf_event.addparametertolist ('OLD_LEASE_STATUS',
52: p_old_lease_status,
53: l_parameter_list
54: );
55: wf_event.addparametertolist ('NEW_LEASE_STATUS',
51: wf_event.addparametertolist ('OLD_LEASE_STATUS',
52: p_old_lease_status,
53: l_parameter_list
54: );
55: wf_event.addparametertolist ('NEW_LEASE_STATUS',
56: p_new_lease_status,
57: l_parameter_list
58: );
59:
59:
60: -- MOAC checking
61: IF p_event_name IN ('oracle.apps.pn.lease.leasestatus')
62: THEN
63: wf_event.addparametertolist ('ORG_ID',
64: mo_global.get_current_org_id,
65: l_parameter_list
66: );
67: END IF;
66: );
67: END IF;
68:
69: -- Raise Event
70: wf_event.RAISE (p_event_name => p_event_name,
71: p_event_key => l_event_key,
72: p_parameters => l_parameter_list
73: );
74: -- Clear parameter list