APPS.CE_BASIG_WF dependencies on CE_BA_SIGNATORIES

Line 23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%TYPE;

19: g_org_id NUMBER(15);
20:
21: g_start_date DATE;
22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%TYPE;
24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;
25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;
26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;

Line 24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;

20:
21: g_start_date DATE;
22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%TYPE;
24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;
25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;
26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;
28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;

Line 25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;

21: g_start_date DATE;
22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%TYPE;
24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;
25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;
26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;
28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
29: g_bank_account_number ce_bank_accounts.bank_Account_num%type;

Line 26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;

22: g_end_date DATE;
23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%TYPE;
24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;
25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;
26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;
28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
29: g_bank_account_number ce_bank_accounts.bank_Account_num%type;
30: g_signer_group CE_BA_SIGNATORIES_V.signer_group%type;

Line 27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;

23: g_other_limits CE_BA_SIGNATORIES.OTHER_LIMITS%TYPE;
24: g_person_type CE_BA_SIGNATORIES_V.person_type%TYPE;
25: g_person_job CE_BA_SIGNATORIES_V.person_job%TYPE;
26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;
28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
29: g_bank_account_number ce_bank_accounts.bank_Account_num%type;
30: g_signer_group CE_BA_SIGNATORIES_V.signer_group%type;
31:

Line 30: g_signer_group CE_BA_SIGNATORIES_V.signer_group%type;

26: g_person_org_name CE_BA_SIGNATORIES_V.person_org_name%TYPE;
27: g_person_location CE_BA_SIGNATORIES_V.person_location%type;
28: g_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
29: g_bank_account_number ce_bank_accounts.bank_Account_num%type;
30: g_signer_group CE_BA_SIGNATORIES_V.signer_group%type;
31:
32:
33:
34: PROCEDURE initialize

Line 258: UPDATE ce_ba_signatories

254: if (funcmode = 'RUN') then
255: l_signatory_id := WF_ENGINE.GetItemAttrNumber(itemtype,
256: itemkey,
257: 'SIGNATORY_ID');
258: UPDATE ce_ba_signatories
259: SET status = 'APPROVED'
260: WHERE signatory_id = l_signatory_id;
261:
262: result := 'COMPLETE';

Line 305: UPDATE ce_ba_signatories

301: l_signatory_id := WF_ENGINE.GetItemAttrNumber(itemtype,
302: itemkey,
303: 'SIGNATORY_ID');
304:
305: UPDATE ce_ba_signatories
306: SET status = 'REJECTED'
307: WHERE signatory_id = l_signatory_id;
308:
309: result := 'COMPLETE';

Line 486: FROM ce_ba_signatories_v basv,

482: g_currency_code, g_bank_branch_name,
483: g_person_type, g_person_job,
484: g_person_location, g_person_org_name,
485: g_start_Date, g_end_date
486: FROM ce_ba_signatories_v basv,
487: ce_bank_accts_gt_v ba, --ce_bank_accounts_v ba,
488: ce_bank_branches_v bb
489: WHERE basv.signatory_id = l_signatory_id
490: AND ba.bank_account_id = basv.bank_Account_id