eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_WF dependencies on WF_EVENT

Line 49: G_POOL_APPROVAL_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.approval_requested';

45: G_WF_ITM_RESULT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'RESULT';
46: G_WF_ITM_APPROVED_YN_YES CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVED';
47: G_WF_ITM_APPROVED_YN_NO CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REJECTED';
48:
49: G_POOL_APPROVAL_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.approval_requested';
50: G_POOL_BUDGET_APPROVAL_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.approval_budget_requested';
51:
52: G_DEFAULT_USER CONSTANT VARCHAR2(10) := 'SYSADMIN';
53: G_DEFAULT_USER_DESC CONSTANT VARCHAR2(30) := 'System Administrator';

Line 50: G_POOL_BUDGET_APPROVAL_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.approval_budget_requested';

46: G_WF_ITM_APPROVED_YN_YES CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVED';
47: G_WF_ITM_APPROVED_YN_NO CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REJECTED';
48:
49: G_POOL_APPROVAL_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.approval_requested';
50: G_POOL_BUDGET_APPROVAL_EVENT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.approval_budget_requested';
51:
52: G_DEFAULT_USER CONSTANT VARCHAR2(10) := 'SYSADMIN';
53: G_DEFAULT_USER_DESC CONSTANT VARCHAR2(30) := 'System Administrator';
54: G_WF_USER_ORIG_SYSTEM_HR CONSTANT VARCHAR2(5) := 'PER';

Line 891: lv_receiving_event wf_events.name%TYPE;

887:
888: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'get_subsidy_pool_approver';
889:
890: l_user_id VARCHAR2(200);
891: lv_receiving_event wf_events.name%TYPE;
892: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
893: lv_total_budget VARCHAR2(200);
894: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
895: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;

Line 1028: lv_receiving_event wf_events.name%TYPE;

1024: ,actid IN NUMBER
1025: ,funcmode IN VARCHAR2
1026: ,resultout OUT NOCOPY VARCHAR2) IS
1027: lv_approval_status VARCHAR2(10);
1028: lv_receiving_event wf_events.name%TYPE;
1029: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
1030: lv_total_budget VARCHAR2(200);
1031: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
1032: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;

Line 1402: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);

1398: RAISE OKL_API.G_EXCEPTION_ERROR;
1399: END IF;
1400: CLOSE c_get_trx_type_csr;
1401: IF l_application_id = l_trans_appl_id THEN
1402: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
1403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
1404: END IF;
1405: -- write to log
1406: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN

Line 1403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);

1399: END IF;
1400: CLOSE c_get_trx_type_csr;
1401: IF l_application_id = l_trans_appl_id THEN
1402: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
1403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
1404: END IF;
1405: -- write to log
1406: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1407: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

Line 1429: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,p_subsidy_pool_id,l_parameter_list);

1425: IF(l_approval_option IN (G_SUBSIDY_POOL_APPROVAL_WF, G_SUBSIDY_POOL_APPROVAL_AME))THEN
1426: OPEN c_get_pool_info_csr (cp_subsidy_pool_id => p_subsidy_pool_id);
1427: FETCH c_get_pool_info_csr INTO cv_get_pool_info;
1428: CLOSE c_get_pool_info_csr;
1429: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,p_subsidy_pool_id,l_parameter_list);
1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);
1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);

Line 1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);

1426: OPEN c_get_pool_info_csr (cp_subsidy_pool_id => p_subsidy_pool_id);
1427: FETCH c_get_pool_info_csr INTO cv_get_pool_info;
1428: CLOSE c_get_pool_info_csr;
1429: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,p_subsidy_pool_id,l_parameter_list);
1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);
1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);

Line 1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);

1427: FETCH c_get_pool_info_csr INTO cv_get_pool_info;
1428: CLOSE c_get_pool_info_csr;
1429: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,p_subsidy_pool_id,l_parameter_list);
1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);
1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);
1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);

Line 1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);

1428: CLOSE c_get_pool_info_csr;
1429: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,p_subsidy_pool_id,l_parameter_list);
1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);
1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);
1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);
1436:

Line 1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);

1429: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,p_subsidy_pool_id,l_parameter_list);
1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);
1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);
1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);
1436:
1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);

Line 1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);

1430: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_pool_info.subsidy_pool_name,l_parameter_list);
1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);
1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);
1436:
1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);
1438:

Line 1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);

1431: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,to_date(cv_get_pool_info.effective_from_date,'DD/MM/RRRR'),l_parameter_list);
1432: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,to_date(cv_get_pool_info.effective_to_date,'DD/MM/RRRR'),l_parameter_list);
1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);
1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);
1436:
1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);
1438:
1439: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);

Line 1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);

1433: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_pool_info.budget_amount,l_parameter_list);
1434: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_pool_info.currency_code,l_parameter_list);
1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);
1436:
1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);
1438:
1439: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);
1440: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1441:

Line 1439: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);

1435: wf_event.AddParameterToList(G_WF_ITM_POOL_DESCR,cv_get_pool_info.short_description,l_parameter_list);
1436:
1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);
1438:
1439: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);
1440: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1441:
1442: lv_wf_item_key := get_item_key_wf;
1443: -- Raise Event

Line 1440: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);

1436:
1437: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_id,l_parameter_list);
1438:
1439: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);
1440: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1441:
1442: lv_wf_item_key := get_item_key_wf;
1443: -- Raise Event
1444: wf_event.RAISE(p_event_name => G_POOL_APPROVAL_EVENT,

Line 1444: wf_event.RAISE(p_event_name => G_POOL_APPROVAL_EVENT,

1440: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1441:
1442: lv_wf_item_key := get_item_key_wf;
1443: -- Raise Event
1444: wf_event.RAISE(p_event_name => G_POOL_APPROVAL_EVENT,
1445: p_event_key => lv_wf_item_key,
1446: p_parameters => l_parameter_list);
1447: l_parameter_list.DELETE;
1448: END IF;

Line 1610: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);

1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: CLOSE c_get_trx_type_csr;
1609: IF l_application_id = l_trans_appl_id THEN
1610: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
1611: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
1612: END IF;
1613: -- write to log
1614: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN

Line 1611: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);

1607: END IF;
1608: CLOSE c_get_trx_type_csr;
1609: IF l_application_id = l_trans_appl_id THEN
1610: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
1611: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
1612: END IF;
1613: -- write to log
1614: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1615: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

Line 1637: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,cv_get_budget_info.subsidy_pool_id,l_parameter_list); -- pool id

1633: OPEN c_get_budget_info_csr(cp_pool_budget_id => p_subsidy_pool_budget_id);
1634: FETCH c_get_budget_info_csr INTO cv_get_budget_info;
1635: CLOSE c_get_budget_info_csr;
1636:
1637: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,cv_get_budget_info.subsidy_pool_id,l_parameter_list); -- pool id
1638: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_budget_info.subsidy_pool_name,l_parameter_list); -- pool name
1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date
1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget

Line 1638: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_budget_info.subsidy_pool_name,l_parameter_list); -- pool name

1634: FETCH c_get_budget_info_csr INTO cv_get_budget_info;
1635: CLOSE c_get_budget_info_csr;
1636:
1637: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,cv_get_budget_info.subsidy_pool_id,l_parameter_list); -- pool id
1638: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_budget_info.subsidy_pool_name,l_parameter_list); -- pool name
1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date
1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:

Line 1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date

1635: CLOSE c_get_budget_info_csr;
1636:
1637: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,cv_get_budget_info.subsidy_pool_id,l_parameter_list); -- pool id
1638: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_budget_info.subsidy_pool_name,l_parameter_list); -- pool name
1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date
1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id

Line 1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date

1636:
1637: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,cv_get_budget_info.subsidy_pool_id,l_parameter_list); -- pool id
1638: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_budget_info.subsidy_pool_name,l_parameter_list); -- pool name
1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date
1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount

Line 1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget

1637: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_ID,cv_get_budget_info.subsidy_pool_id,l_parameter_list); -- pool id
1638: wf_event.AddParameterToList(G_WF_ITM_SUBSIDY_POOL_NAME,cv_get_budget_info.subsidy_pool_name,l_parameter_list); -- pool name
1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date
1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount
1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date

Line 1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id

1639: wf_event.AddParameterToList(G_WF_ITM_FROM_DATE,cv_get_budget_info.pool_start_date,l_parameter_list); -- pool start date
1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount
1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date
1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)
1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code

Line 1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount

1640: wf_event.AddParameterToList(G_WF_ITM_TO_DATE,cv_get_budget_info.effective_to_date,l_parameter_list); -- pool end date
1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount
1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date
1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)
1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code
1648:

Line 1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date

1641: wf_event.AddParameterToList(G_WF_ITM_TOTAL_BUDGETS,cv_get_budget_info.total_budgets,l_parameter_list); -- pool total budget
1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount
1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date
1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)
1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code
1648:
1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);

Line 1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)

1642:
1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount
1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date
1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)
1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code
1648:
1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);
1650:

Line 1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code

1643: wf_event.AddParameterToList(G_WF_ITM_BUDGET_ID,p_subsidy_pool_budget_id,l_parameter_list); -- budget line id
1644: wf_event.AddParameterToList(G_WF_ITM_BUDGET_AMOUNT,cv_get_budget_info.budget_amount,l_parameter_list); -- budget amount
1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date
1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)
1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code
1648:
1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);
1650:
1651: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);

Line 1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);

1645: wf_event.AddParameterToList(G_WF_ITM_BUDGET_FROM_DATE,to_date(cv_get_budget_info.budget_line_date,'DD/MM/RRRR'),l_parameter_list); -- budget line date
1646: wf_event.AddParameterToList(G_WF_ITM_BUDGET_TYPE,cv_get_budget_info.budget_type_code,l_parameter_list); -- type of budget (Addition or Reduction)
1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code
1648:
1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);
1650:
1651: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);
1652: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1653:

Line 1651: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);

1647: wf_event.AddParameterToList(G_WF_ITM_POOL_CURRENCY,cv_get_budget_info.currency_code,l_parameter_list); -- pool currency code
1648:
1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);
1650:
1651: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);
1652: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1653:
1654: lv_wf_item_key := get_item_key_wf;
1655: -- Raise Event

Line 1652: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);

1648:
1649: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,p_subsidy_pool_budget_id,l_parameter_list);
1650:
1651: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR,l_requester,l_parameter_list);
1652: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1653:
1654: lv_wf_item_key := get_item_key_wf;
1655: -- Raise Event
1656: wf_event.RAISE(p_event_name => G_POOL_BUDGET_APPROVAL_EVENT,

Line 1656: wf_event.RAISE(p_event_name => G_POOL_BUDGET_APPROVAL_EVENT,

1652: wf_event.AddParameterToList(G_WF_ITM_REQUESTOR_ID,fnd_global.user_id,l_parameter_list);
1653:
1654: lv_wf_item_key := get_item_key_wf;
1655: -- Raise Event
1656: wf_event.RAISE(p_event_name => G_POOL_BUDGET_APPROVAL_EVENT,
1657: p_event_key => lv_wf_item_key,
1658: p_parameters => l_parameter_list);
1659: l_parameter_list.DELETE;
1660: END IF;