DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on MO_GLOBAL

Line 100: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

96: l_key := l_event_name ||l_seq ;
97:
98: wf_event.AddParameterToList('TAS_ID',p_tas_id,l_parameter_list);
99: --added by akrangan
100: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
101:
102: -- Raise Event
103: wf_event.raise(p_event_name => l_event_name
104: ,p_event_key => l_key

Line 499: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

495: CLOSE okl_key_csr;
496: l_key := l_event_name ||l_seq ;
497: wf_event.AddParameterToList('TRX_ID',p_trx_id,l_parameter_list);
498: --added by akrangan
499: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
500:
501:
502: -- rmunjulu send the values to user_id, appl_id and resp_id for bug 11717591, these attributes are now added to the WF OKLCSTRQ.wft
503: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);

Line 1065: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)

1061: AS
1062: CURSOR c_document(p_ptm_code IN VARCHAR2) IS
1063: SELECT jtf_amv_item_id,email_subject_line
1064: FROM okl_cs_process_tmplts_uv
1065: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
1066: AND start_date <= TRUNC(sysdate)
1067: AND NVL(end_date, sysdate) >= TRUNC(sysdate)
1068: AND ptm_code = p_ptm_code;
1069:

Line 1187: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)

1183: AS
1184: CURSOR c_document(p_ptm_code IN VARCHAR2) IS
1185: SELECT jtf_amv_item_id,email_subject_line
1186: FROM okl_cs_process_tmplts_uv
1187: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
1188: AND start_date <= TRUNC(sysdate)
1189: AND NVL(end_date, sysdate) >= TRUNC(sysdate)
1190: AND ptm_code = p_ptm_code;
1191:

Line 3030: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

3026: l_key := l_event_name ||l_seq ;
3027:
3028: wf_event.AddParameterToList('REQUEST_ID',p_request_id,l_parameter_list);
3029: --added by akrangan
3030: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
3031:
3032: -- Raise Event
3033: wf_event.raise(p_event_name => l_event_name
3034: ,p_event_key => l_key

Line 3348: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);

3344: l_key := l_event_name ||l_seq ;
3345:
3346: wf_event.AddParameterToList('REQUEST_ID',p_request_id,l_parameter_list);
3347: --added by akrangan
3348: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
3349:
3350: -- Raise Event
3351: wf_event.raise(p_event_name => l_event_name
3352: ,p_event_key => l_key

Line 3799: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list); --dkagrawa added for MOAC

3795: CLOSE okl_key_csr;
3796: l_key := l_event_name ||l_seq ;
3797:
3798: wf_event.AddParameterToList('REQUEST_ID',p_request_id,l_parameter_list);
3799: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list); --dkagrawa added for MOAC
3800: -- Set the User Id, Responsibility Id and Application Id as workflow attributes Bug#5743303
3801: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
3802: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
3803: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);