APPS.PA_BUDGET_FUND_PKG dependencies on PA_PROJECTS_ALL

Line 37: g_project_id pa_projects_all.project_id%type;

33: g_msg_data VARCHAR2(1000);
34: g_procedure_name VARCHAR2(30);
35: g_debug_mode VARCHAR2(10);
36: g_draft_bvid pa_budget_versions.budget_version_id%type;
37: g_project_id pa_projects_all.project_id%type;
38: g_org_id pa_implementations_all.org_id%type; --Bug 6524116
39:
40: -- This is an autonomous procedure ...
41: PROCEDURE Update_bc_packets_fail(p_bud_ver_id IN NUMBER,

Line 110: l_project_num pa_projects_all.segment1%type; --Bug 6524116

106: l_msg_index_out NUMBER ;
107: l_chk_res_unres_multi NUMBER ;
108:
109: l_period_set_name VARCHAR2(15);
110: l_project_num pa_projects_all.segment1%type; --Bug 6524116
111:
112: --PRAGMA AUTONOMOUS_TRANSACTION;--Bug 6524116; Removed as this is causing issue with IGC funds checking.
113:
114: BEGIN

Line 198: from pa_projects_all p,

194:
195: --Bug 6524116
196: select segment1
197: into l_project_num
198: from pa_projects_all p,
199: pa_budget_versions bv
200: where p.project_id = bv.project_id
201: and bv.budget_version_id = p_budget_version_id;
202:

Line 935: l_template_flag pa_projects_all.template_flag%type;

931: l_msg_data VARCHAR2(240) ;
932: l_dummy number;
933: l_sqlerrm VARCHAR2(4000);
934: l_request_id NUMBER;
935: l_template_flag pa_projects_all.template_flag%type;
936: --Bug 6524116
937: l_cc_budget_entry_level_code VARCHAR2(30) ;
938: P_prev_budget_version_id number;
939: rejected_event_id_tab PSA_FUNDS_CHECKER_PKG.num_rec;

Line 1013: FROM pa_projects_all

1009: -- You should not call FC for template project ...
1010: -- ----------------------------------------------------------------------+
1011: SELECT nvl(template_flag,'N'), org_id
1012: INTO l_template_flag , g_org_id
1013: FROM pa_projects_all
1014: WHERE project_id = p_project_id;
1015:
1016: If l_template_flag = 'Y' then
1017: log_message('check_or_reserve_funds called for template project ..exit with success');

Line 2741: l_project_id pa_projects_all.project_id%TYPE;

2737: l_calling_module VARCHAR2(20);
2738: l_cc_calling_module VARCHAR2(20);
2739: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2740: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2741: l_project_id pa_projects_all.project_id%TYPE;
2742: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2743:
2744: l_return_status VARCHAR2(1);
2745: l_msg_count NUMBER;

Line 3242: pa_projects_all pp

3238: Select decode(NVL(ppt.burden_cost_flag, 'N'),'Y',
3239: NVL(ppt.burden_amt_display_method,'S'),'N')
3240: into l_burden_method
3241: from pa_project_types ppt,
3242: pa_projects_all pp
3243: where ppt.project_type = pp.project_type
3244: and pp.project_id = X_project_id;
3245:
3246: log_message(' In Unburdened_cdl_exists:Burden method is :'||l_burden_method);