DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_BUDGET_PVT dependencies on WF_EVENT

Line 4: G_WF_EVT_BUDGET_LINE_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_pending_approval';

1: PACKAGE BODY OKL_SUBSIDY_POOL_BUDGET_PVT AS
2: /* $Header: OKLRSIBB.pls 120.2 2005/10/30 03:17:02 appldev noship $ */
3:
4: G_WF_EVT_BUDGET_LINE_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_pending_approval';
5: G_WF_EVT_BUDGET_LINE_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_approved';
6: G_WF_EVT_BUDGET_LINE_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_rejected';
7: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
8: G_WF_ITM_BUDGET_LINE_ID CONSTANT VARCHAR2(30) := 'BUDGET_LINE_ID';

Line 5: G_WF_EVT_BUDGET_LINE_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_approved';

1: PACKAGE BODY OKL_SUBSIDY_POOL_BUDGET_PVT AS
2: /* $Header: OKLRSIBB.pls 120.2 2005/10/30 03:17:02 appldev noship $ */
3:
4: G_WF_EVT_BUDGET_LINE_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_pending_approval';
5: G_WF_EVT_BUDGET_LINE_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_approved';
6: G_WF_EVT_BUDGET_LINE_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_rejected';
7: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
8: G_WF_ITM_BUDGET_LINE_ID CONSTANT VARCHAR2(30) := 'BUDGET_LINE_ID';
9:

Line 6: G_WF_EVT_BUDGET_LINE_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_rejected';

2: /* $Header: OKLRSIBB.pls 120.2 2005/10/30 03:17:02 appldev noship $ */
3:
4: G_WF_EVT_BUDGET_LINE_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_pending_approval';
5: G_WF_EVT_BUDGET_LINE_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_approved';
6: G_WF_EVT_BUDGET_LINE_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.budget_line_rejected';
7: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
8: G_WF_ITM_BUDGET_LINE_ID CONSTANT VARCHAR2(30) := 'BUDGET_LINE_ID';
9:
10: -------------------------------------------------------------------------------

Line 377: l_event_name wf_events.name%TYPE;

373: l_msg_count NUMBER ;
374: l_msg_data VARCHAR2(2000);
375: l_api_name CONSTANT VARCHAR2(30) := 'set_decision_status_code';
376: l_parameter_list WF_PARAMETER_LIST_T;
377: l_event_name wf_events.name%TYPE;
378: l_system_date DATE ;
379: -------------------
380: -- DECLARE Cursors
381: -------------------

Line 476: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);

472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: END IF;
474: IF(l_budget_line_rec.decision_status_code = 'PENDING')THEN
475: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
476: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
478: l_event_name := G_WF_EVT_BUDGET_LINE_PENDING;
479: ELSIF(l_budget_line_rec.decision_status_code = 'ACTIVE') THEN
480: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.

Line 477: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);

473: END IF;
474: IF(l_budget_line_rec.decision_status_code = 'PENDING')THEN
475: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
476: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
478: l_event_name := G_WF_EVT_BUDGET_LINE_PENDING;
479: ELSIF(l_budget_line_rec.decision_status_code = 'ACTIVE') THEN
480: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
481: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);

Line 481: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);

477: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
478: l_event_name := G_WF_EVT_BUDGET_LINE_PENDING;
479: ELSIF(l_budget_line_rec.decision_status_code = 'ACTIVE') THEN
480: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
481: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
483: l_event_name := G_WF_EVT_BUDGET_LINE_APPROVED;
484: ELSIF(l_budget_line_rec.decision_status_code = 'REJECTED')THEN
485: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.

Line 482: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);

478: l_event_name := G_WF_EVT_BUDGET_LINE_PENDING;
479: ELSIF(l_budget_line_rec.decision_status_code = 'ACTIVE') THEN
480: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
481: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
483: l_event_name := G_WF_EVT_BUDGET_LINE_APPROVED;
484: ELSIF(l_budget_line_rec.decision_status_code = 'REJECTED')THEN
485: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
486: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);

Line 486: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);

482: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
483: l_event_name := G_WF_EVT_BUDGET_LINE_APPROVED;
484: ELSIF(l_budget_line_rec.decision_status_code = 'REJECTED')THEN
485: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
486: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);
487: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
488: l_event_name := G_WF_EVT_BUDGET_LINE_REJECTED;
489: END IF;
490: IF (l_event_name IS NOT NULL) THEN

Line 487: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);

483: l_event_name := G_WF_EVT_BUDGET_LINE_APPROVED;
484: ELSIF(l_budget_line_rec.decision_status_code = 'REJECTED')THEN
485: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
486: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);
487: wf_event.AddParameterToList(G_WF_ITM_BUDGET_LINE_ID, l_budget_line_rec.id, l_parameter_list);
488: l_event_name := G_WF_EVT_BUDGET_LINE_REJECTED;
489: END IF;
490: IF (l_event_name IS NOT NULL) THEN
491: raise_business_event(p_api_version => p_api_version,