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_ITEM_ATTRIBUTES

Line 17: G_WF_ITM_SUBSIDY_POOL_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_ID';

13: G_TRANS_APP_NAME_POOL CONSTANT ame_calling_apps.application_name%TYPE DEFAULT 'OKL LA Subsidy Pool Approval';
14: G_TRANS_APP_NAME_LINE CONSTANT ame_calling_apps.application_name%TYPE DEFAULT 'OKL LA Subsidy Pool Budget Approval';
15: G_TRX_TYPE_POOL_APPROVAL CONSTANT okl_trx_types_b.trx_type_class%TYPE DEFAULT 'SUBSIDY_POOL_APPROVAL';
16:
17: G_WF_ITM_SUBSIDY_POOL_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_ID';
18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';
19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';

Line 18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';

14: G_TRANS_APP_NAME_LINE CONSTANT ame_calling_apps.application_name%TYPE DEFAULT 'OKL LA Subsidy Pool Budget Approval';
15: G_TRX_TYPE_POOL_APPROVAL CONSTANT okl_trx_types_b.trx_type_class%TYPE DEFAULT 'SUBSIDY_POOL_APPROVAL';
16:
17: G_WF_ITM_SUBSIDY_POOL_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_ID';
18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';
19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';

Line 19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';

15: G_TRX_TYPE_POOL_APPROVAL CONSTANT okl_trx_types_b.trx_type_class%TYPE DEFAULT 'SUBSIDY_POOL_APPROVAL';
16:
17: G_WF_ITM_SUBSIDY_POOL_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_ID';
18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';
19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';

Line 20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';

16:
17: G_WF_ITM_SUBSIDY_POOL_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_ID';
18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';
19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';

Line 21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';

17: G_WF_ITM_SUBSIDY_POOL_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_ID';
18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';
19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';

Line 22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';

18: G_WF_ITM_SUBSIDY_POOL_NAME CONSTANT wf_item_attributes.name%TYPE DEFAULT 'SUBSIDY_POOL_NAME';
19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';

Line 23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';

19: G_WF_ITM_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'FROM_DATE';
20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';

Line 24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';

20: G_WF_ITM_TO_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TO_DATE';
21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';

Line 25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';

21: G_WF_ITM_TOTAL_BUDGETS CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TOTAL_BUDGETS';
22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';

Line 26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';

22: G_WF_ITM_POOL_CURRENCY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'CURRENCY_CODE';
23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';

Line 27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';

23: G_WF_ITM_POOL_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'POOL_DESCRIPTION';
24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';

Line 28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';

24: G_WF_ITM_BUDGET_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_LINE_ID';
25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';

Line 29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';

25: G_WF_ITM_BUDGET_AMOUNT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_AMOUNT';
26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';

Line 30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';

26: G_WF_ITM_BUDGET_FROM_DATE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_EFFECTIVE_DATE';
27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';

Line 31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';

27: G_WF_ITM_BUDGET_TYPE CONSTANT wf_item_attributes.name%TYPE DEFAULT 'BUDGET_TYPE_CODE';
28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';

Line 32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';

28: G_WF_ITM_REQUESTOR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTER';
29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';

Line 33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';

29: G_WF_ITM_REQUESTOR_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REQUESTOR_ID';
30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';

Line 34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';

30: G_WF_ITM_APP_REQUEST_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REQUEST_SUB';
31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';

Line 35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';

31: G_WF_ITM_APP_REMINDER_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_SUB';
32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';

Line 36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';

32: G_WF_ITM_APP_APPROVED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_SUB';
33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:

Line 37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';

33: G_WF_ITM_APP_REJECTED_SUB CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_SUB';
34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';

Line 38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';

34: G_WF_ITM_APP_REMINDER_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REMINDER_HEAD';
35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';

Line 39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';

35: G_WF_ITM_APP_APPROVED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_APPROVED_HEAD';
36: G_WF_ITM_APP_REJECTED_HEAD CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APP_REJECTED_HEAD';
37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';

Line 41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';

37: G_WF_ITM_APPLICATION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPLICATION_ID';
38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
45: G_WF_ITM_RESULT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'RESULT';

Line 42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';

38: G_WF_ITM_TRANSACTION_TYPE_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRX_TYPE_ID';
39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
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';

Line 43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';

39: G_WF_ITM_TRANSACTION_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'TRANSACTION_ID';
40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
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';

Line 44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';

40:
41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
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:

Line 45: G_WF_ITM_RESULT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'RESULT';

41: G_WF_ITM_APPROVER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVER';
42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
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';

Line 46: G_WF_ITM_APPROVED_YN_YES CONSTANT wf_item_attributes.name%TYPE DEFAULT 'APPROVED';

42: G_WF_ITM_MESSAGE_SUBJECT CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_SUBJECT';
43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
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';

Line 47: G_WF_ITM_APPROVED_YN_NO CONSTANT wf_item_attributes.name%TYPE DEFAULT 'REJECTED';

43: G_WF_ITM_MESSAGE_DESCR CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DESCRIPTION';
44: G_WF_ITM_MESSAGE_BODY CONSTANT wf_item_attributes.name%TYPE DEFAULT 'MESSAGE_DOC';
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:

Line 215: ,attrib wf_item_attributes.name%TYPE

211:
212: PROCEDURE set_attrib_message(itemtype IN VARCHAR2
213: ,itemkey IN VARCHAR2
214: ,message fnd_new_messages.message_name%TYPE
215: ,attrib wf_item_attributes.name%TYPE
216: ,pool_or_line IN VARCHAR2
217: ) IS
218: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
219: lv_total_budget VARCHAR2(200);