DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_PVT dependencies on WF_EVENT

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

1: PACKAGE BODY OKL_SUBSIDY_POOL_PVT AS
2: /* $Header: OKLRSIPB.pls 120.2 2005/09/12 23:45:28 cklee noship $ */
3:
4: G_WF_EVT_SUBSIDY_POOL_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_pending_approval';
5: G_WF_EVT_SUBSIDY_POOL_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_approved';
6: G_WF_EVT_SUBSIDY_POOL_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_rejected';
7: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
8:

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

1: PACKAGE BODY OKL_SUBSIDY_POOL_PVT AS
2: /* $Header: OKLRSIPB.pls 120.2 2005/09/12 23:45:28 cklee noship $ */
3:
4: G_WF_EVT_SUBSIDY_POOL_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_pending_approval';
5: G_WF_EVT_SUBSIDY_POOL_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_approved';
6: G_WF_EVT_SUBSIDY_POOL_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_rejected';
7: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
8:
9: -- Cursor to fetch the record with the passed id.

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

2: /* $Header: OKLRSIPB.pls 120.2 2005/09/12 23:45:28 cklee noship $ */
3:
4: G_WF_EVT_SUBSIDY_POOL_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_pending_approval';
5: G_WF_EVT_SUBSIDY_POOL_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_approved';
6: G_WF_EVT_SUBSIDY_POOL_REJECTED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_rejected';
7: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
8:
9: -- Cursor to fetch the record with the passed id.
10: CURSOR c_get_pool_id (cp_pool_id IN okl_subsidy_pools_b.id%type) IS

Line 971: l_event_name wf_events.name%TYPE;

967: l_msg_count NUMBER ;
968: l_msg_data VARCHAR2(2000);
969: l_api_name CONSTANT VARCHAR2(30) := 'set_decision_status_code';
970: l_parameter_list WF_PARAMETER_LIST_T;
971: l_event_name wf_events.name%TYPE;
972: l_system_date CONSTANT DATE DEFAULT TRUNC(SYSDATE);
973: -------------------
974: -- DECLARE Cursors
975: -------------------

Line 1032: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);

1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030: IF(l_sub_pool_rec.decision_status_code = 'PENDING')THEN
1031: -- add subsidy pool id and subsidy pool to the parameter list and call the corresponding business event.
1032: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);
1033: l_event_name := G_WF_EVT_SUBSIDY_POOL_PENDING;
1034: ELSIF(l_sub_pool_rec.decision_status_code = 'ACTIVE')THEN
1035: -- add subsidy pool id and subsidy pool to the parameter list call the corresponding business event.
1036: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);

Line 1036: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);

1032: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);
1033: l_event_name := G_WF_EVT_SUBSIDY_POOL_PENDING;
1034: ELSIF(l_sub_pool_rec.decision_status_code = 'ACTIVE')THEN
1035: -- add subsidy pool id and subsidy pool to the parameter list call the corresponding business event.
1036: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);
1037: l_event_name := G_WF_EVT_SUBSIDY_POOL_APPROVED;
1038: ELSIF(l_sub_pool_rec.decision_status_code = 'REJECTED')THEN
1039: -- add subsidy pool id and subsidy pool to the parameter list call the corresponding business event.
1040: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);

Line 1040: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);

1036: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);
1037: l_event_name := G_WF_EVT_SUBSIDY_POOL_APPROVED;
1038: ELSIF(l_sub_pool_rec.decision_status_code = 'REJECTED')THEN
1039: -- add subsidy pool id and subsidy pool to the parameter list call the corresponding business event.
1040: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_sub_pool_rec.id, l_parameter_list);
1041: l_event_name := G_WF_EVT_SUBSIDY_POOL_REJECTED;
1042: END IF;
1043: IF (l_event_name IS NOT NULL) THEN
1044: raise_business_event(p_api_version => p_api_version,