APPS.OKL_VP_PA_WF dependencies on AME_CALLING_APPS

Line 15: G_TRANS_APP_NAME_PA CONSTANT ame_calling_apps.application_name%TYPE DEFAULT 'OKL LA Program Agreement Approval';

11:
12: G_ITEM_TYPE_WF CONSTANT VARCHAR2(10) DEFAULT 'OKLPAAPP';
13: G_ITEM_TYPE_AME CONSTANT VARCHAR2(10) DEFAULT 'OKLAMAPP';
14:
15: G_TRANS_APP_NAME_PA CONSTANT ame_calling_apps.application_name%TYPE DEFAULT 'OKL LA Program Agreement Approval';
16:
17: G_WF_ITM_AGREEMENT_ID CONSTANT wf_item_attributes.name%TYPE DEFAULT 'AGREEMENT_ID';
18: G_WF_ITM_AGREEMENT_NUMBER CONSTANT wf_item_attributes.name%TYPE DEFAULT 'AGREEMENT_NUMBER';
19:

Line 234: FROM AME_CALLING_APPS

230: -- Get the Transaction Type Id from OAM
231: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
232: SELECT transaction_type_id,
233: fnd_application_id
234: FROM AME_CALLING_APPS
235: WHERE application_name = cp_trx_type;
236: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
237:
238: l_parameter_list wf_parameter_list_t;

Line 245: l_trans_appl_id ame_calling_apps.application_id%TYPE;

241: l_requester VARCHAR2(200);
242: l_name VARCHAR2(200);
243:
244: l_application_id fnd_application.application_id%TYPE;
245: l_trans_appl_id ame_calling_apps.application_id%TYPE;
246: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
247:
248: l_api_version CONSTANT NUMBER DEFAULT 1.0;
249: l_approval_process fnd_lookups.lookup_code%TYPE;

Line 246: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;

242: l_name VARCHAR2(200);
243:
244: l_application_id fnd_application.application_id%TYPE;
245: l_trans_appl_id ame_calling_apps.application_id%TYPE;
246: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
247:
248: l_api_version CONSTANT NUMBER DEFAULT 1.0;
249: l_approval_process fnd_lookups.lookup_code%TYPE;
250: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_pa_FOR_APPROVAL';