[Home] [Help]
2: -- $Header: PAFCUTLS.pls 120.13.12000000.2 2007/04/20 08:27:51 rshaik ship $
3:
4: --Global variables declared to use as one level cache
5: -- this improves the performance significantly
6: g_project_id pa_bc_packets.project_id%type := null;
7: g_bdgt_version_id pa_bc_packets.budget_version_id%type := null;
8: g_calling_mode VARCHAR2(25) := null;
9: g_calling_mode1 VARCHAR2(25) := null;
10: g_calling_mode2 VARCHAR2(25) := null;
3:
4: --Global variables declared to use as one level cache
5: -- this improves the performance significantly
6: g_project_id pa_bc_packets.project_id%type := null;
7: g_bdgt_version_id pa_bc_packets.budget_version_id%type := null;
8: g_calling_mode VARCHAR2(25) := null;
9: g_calling_mode1 VARCHAR2(25) := null;
10: g_calling_mode2 VARCHAR2(25) := null;
11: g_calling_mode3 VARCHAR2(25) := null;
8: g_calling_mode VARCHAR2(25) := null;
9: g_calling_mode1 VARCHAR2(25) := null;
10: g_calling_mode2 VARCHAR2(25) := null;
11: g_calling_mode3 VARCHAR2(25) := null;
12: g_task_id pa_bc_packets.task_id%type := null;
13: g_exp_type pa_bc_packets.expenditure_type%type := null;
14: g_exp_item_date DATE := null;
15: g_exp_org_id pa_bc_packets.expenditure_organization_id%type := null;
16: g_budget_ccid pa_bc_packets.budget_ccid%type := null;
9: g_calling_mode1 VARCHAR2(25) := null;
10: g_calling_mode2 VARCHAR2(25) := null;
11: g_calling_mode3 VARCHAR2(25) := null;
12: g_task_id pa_bc_packets.task_id%type := null;
13: g_exp_type pa_bc_packets.expenditure_type%type := null;
14: g_exp_item_date DATE := null;
15: g_exp_org_id pa_bc_packets.expenditure_organization_id%type := null;
16: g_budget_ccid pa_bc_packets.budget_ccid%type := null;
17: g_start_date DATE := null;
11: g_calling_mode3 VARCHAR2(25) := null;
12: g_task_id pa_bc_packets.task_id%type := null;
13: g_exp_type pa_bc_packets.expenditure_type%type := null;
14: g_exp_item_date DATE := null;
15: g_exp_org_id pa_bc_packets.expenditure_organization_id%type := null;
16: g_budget_ccid pa_bc_packets.budget_ccid%type := null;
17: g_start_date DATE := null;
18: g_end_date DATE := null;
19: g_rlmi pa_bc_packets.resource_list_member_id%type := null;
12: g_task_id pa_bc_packets.task_id%type := null;
13: g_exp_type pa_bc_packets.expenditure_type%type := null;
14: g_exp_item_date DATE := null;
15: g_exp_org_id pa_bc_packets.expenditure_organization_id%type := null;
16: g_budget_ccid pa_bc_packets.budget_ccid%type := null;
17: g_start_date DATE := null;
18: g_end_date DATE := null;
19: g_rlmi pa_bc_packets.resource_list_member_id%type := null;
20: g_period_name pa_bc_packets.period_name%type := null;
15: g_exp_org_id pa_bc_packets.expenditure_organization_id%type := null;
16: g_budget_ccid pa_bc_packets.budget_ccid%type := null;
17: g_start_date DATE := null;
18: g_end_date DATE := null;
19: g_rlmi pa_bc_packets.resource_list_member_id%type := null;
20: g_period_name pa_bc_packets.period_name%type := null;
21: g_compiled_set_id NUMBER := null;
22: g_multiplier NUMBER := null;
23: g_fnd_reqd_flag VARCHAR2(25) := null;
16: g_budget_ccid pa_bc_packets.budget_ccid%type := null;
17: g_start_date DATE := null;
18: g_end_date DATE := null;
19: g_rlmi pa_bc_packets.resource_list_member_id%type := null;
20: g_period_name pa_bc_packets.period_name%type := null;
21: g_compiled_set_id NUMBER := null;
22: g_multiplier NUMBER := null;
23: g_fnd_reqd_flag VARCHAR2(25) := null;
24: g_encum_type_id NUMBER := null;
26: g_sch_rev_id NUMBER := null;
27:
28: -- Bug 5373272
29: g_event_type_code xla_events.event_type_code%TYPE := NULL ;
30: g_document_distribution_id pa_bc_packets.document_distribution_id%TYPE := NULL ;
31: g_document_distribution_type pa_bc_packets.document_distribution_type%TYPE := NULL ;
32: g_parent_distribution_id pa_bc_packets.document_distribution_id%TYPE := NULL ;
33:
34: PROCEDURE init_util_variables;
27:
28: -- Bug 5373272
29: g_event_type_code xla_events.event_type_code%TYPE := NULL ;
30: g_document_distribution_id pa_bc_packets.document_distribution_id%TYPE := NULL ;
31: g_document_distribution_type pa_bc_packets.document_distribution_type%TYPE := NULL ;
32: g_parent_distribution_id pa_bc_packets.document_distribution_id%TYPE := NULL ;
33:
34: PROCEDURE init_util_variables;
35: -- this API gets the compiled multipliers for the given task and expenditure organization id
28: -- Bug 5373272
29: g_event_type_code xla_events.event_type_code%TYPE := NULL ;
30: g_document_distribution_id pa_bc_packets.document_distribution_id%TYPE := NULL ;
31: g_document_distribution_type pa_bc_packets.document_distribution_type%TYPE := NULL ;
32: g_parent_distribution_id pa_bc_packets.document_distribution_id%TYPE := NULL ;
33:
34: PROCEDURE init_util_variables;
35: -- this API gets the compiled multipliers for the given task and expenditure organization id
36: -- and expenditure item date for burden calculations