APPS.OKL_SETUPPRODUCTS_PVT dependencies on WF_EVENT

Line 931: FROM wf_event_subscriptions a,

927: FUNCTION exist_subscription(p_event_name IN VARCHAR2) RETURN VARCHAR2
928: IS
929: CURSOR exist_subscription IS
930: SELECT 'Y'
931: FROM wf_event_subscriptions a,
932: wf_events b
933: WHERE a.event_filter_guid = b.guid
934: AND a.status = 'ENABLED'
935: AND b.name = p_event_name

Line 932: wf_events b

928: IS
929: CURSOR exist_subscription IS
930: SELECT 'Y'
931: FROM wf_event_subscriptions a,
932: wf_events b
933: WHERE a.event_filter_guid = b.guid
934: AND a.status = 'ENABLED'
935: AND b.name = p_event_name
936: AND ROWNUM = 1;

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

1093: END IF;
1094: -- modification by dcshanmu for bug 5999276 ends
1095:
1096: --Set Parameters
1097: wf_event.AddParameterToList('TRANSACTION_ID',TO_CHAR(p_pdtv_rec.ID),l_parameter_list);
1098: --added by akrangan
1099: -- modified by dcshanmu for bug 5999276 starts
1100: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);
1101: -- We need to status to Approved Pending since We are sending for approval

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

1096: --Set Parameters
1097: wf_event.AddParameterToList('TRANSACTION_ID',TO_CHAR(p_pdtv_rec.ID),l_parameter_list);
1098: --added by akrangan
1099: -- modified by dcshanmu for bug 5999276 starts
1100: wf_event.AddParameterToList('ORG_ID',l_org_id ,l_parameter_list);
1101: -- We need to status to Approved Pending since We are sending for approval
1102:
1103: update_product_status(p_api_version => l_api_version,
1104: p_init_msg_list => l_init_msg_list,

Line 1124: wf_event.RAISE( p_event_name => l_event_name

1120:
1121: -- Raise Event
1122: -- It is overloaded function so use according to requirement
1123:
1124: wf_event.RAISE( p_event_name => l_event_name
1125: ,p_event_key => l_key
1126: ,p_parameters => l_parameter_list);
1127:
1128: l_parameter_list.DELETE;