APPS.OKL_SETUPPRODUCTS_PVT dependencies on WF_EVENT

Line 948: FROM wf_event_subscriptions a,

944: FUNCTION exist_subscription(p_event_name IN VARCHAR2) RETURN VARCHAR2
945: IS
946: CURSOR exist_subscription IS
947: SELECT 'Y'
948: FROM wf_event_subscriptions a,
949: wf_events b
950: WHERE a.event_filter_guid = b.guid
951: AND a.status = 'ENABLED'
952: AND b.name = p_event_name

Line 949: wf_events b

945: IS
946: CURSOR exist_subscription IS
947: SELECT 'Y'
948: FROM wf_event_subscriptions a,
949: wf_events b
950: WHERE a.event_filter_guid = b.guid
951: AND a.status = 'ENABLED'
952: AND b.name = p_event_name
953: AND ROWNUM = 1;

Line 1114: wf_event.AddParameterToList('TRANSACTION_ID',TO_CHAR(p_pdtv_rec.ID),l_parameter_list);

1110: END IF;
1111: -- modification by dcshanmu for bug 5999276 ends
1112:
1113: --Set Parameters
1114: wf_event.AddParameterToList('TRANSACTION_ID',TO_CHAR(p_pdtv_rec.ID),l_parameter_list);
1115: --added by akrangan
1116: -- modified by dcshanmu for bug 5999276 starts
1117: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);
1118: -- We need to status to Approved Pending since We are sending for approval

Line 1117: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);

1113: --Set Parameters
1114: wf_event.AddParameterToList('TRANSACTION_ID',TO_CHAR(p_pdtv_rec.ID),l_parameter_list);
1115: --added by akrangan
1116: -- modified by dcshanmu for bug 5999276 starts
1117: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);
1118: -- We need to status to Approved Pending since We are sending for approval
1119:
1120: update_product_status(p_api_version => l_api_version,
1121: p_init_msg_list => l_init_msg_list,

Line 1141: wf_event.RAISE( p_event_name => l_event_name

1137:
1138: -- Raise Event
1139: -- It is overloaded function so use according to requirement
1140:
1141: wf_event.RAISE( p_event_name => l_event_name
1142: ,p_event_key => l_key
1143: ,p_parameters => l_parameter_list);
1144:
1145: l_parameter_list.DELETE;