[Home] [Help]
11: G_ITEM_TYPE_AME CONSTANT VARCHAR2(10) DEFAULT 'OKLAMAPP';
12: G_APPROVAL_PROCESS_AME CONSTANT VARCHAR2(30) DEFAULT 'APPROVAL_PROC';
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';
1318: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
1319:
1320: CURSOR l_trx_try_csr IS
1321: SELECT id
1322: FROM okl_trx_types_b
1323: WHERE trx_type_class = G_TRX_TYPE_POOL_APPROVAL;
1324:
1325: l_application_id fnd_application.application_id%TYPE;
1326: l_trans_appl_id ame_calling_apps.application_id%TYPE;
1528: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
1529:
1530: CURSOR l_trx_try_csr IS
1531: SELECT id
1532: FROM okl_trx_types_b
1533: WHERE trx_type_class = G_TRX_TYPE_POOL_APPROVAL;
1534:
1535: l_application_id fnd_application.application_id%TYPE;
1536: l_trans_appl_id ame_calling_apps.application_id%TYPE;