eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_PVT dependencies on PA_PROJECTS_ALL

Line 153: ,px_pa_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895

149: PROCEDURE Validate_Header_Info
150: ( p_api_version_number IN NUMBER
151: ,p_budget_version_name IN VARCHAR2 /* Introduced for bug 3133930*/
152: ,p_init_msg_list IN VARCHAR2
153: ,px_pa_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
154: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE
155: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
156: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
157: ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE

Line 154: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE

150: ( p_api_version_number IN NUMBER
151: ,p_budget_version_name IN VARCHAR2 /* Introduced for bug 3133930*/
152: ,p_init_msg_list IN VARCHAR2
153: ,px_pa_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
154: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE
155: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
156: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
157: ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
158: ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895

Line 155: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE

151: ,p_budget_version_name IN VARCHAR2 /* Introduced for bug 3133930*/
152: ,p_init_msg_list IN VARCHAR2
153: ,px_pa_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
154: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE
155: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
156: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
157: ,p_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
158: ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895
159: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895

Line 202: ,pa_projects_all ppa

198: IS
199: SELECT ppt.allow_cost_budget_entry_flag
200: ,ppt.allow_rev_budget_entry_flag
201: FROM pa_project_types ppt
202: ,pa_projects_all ppa
203: WHERE ppa.project_id = c_project_id
204: AND ppa.project_type = ppt.project_type;
205:
206: -- Cursor to get the details of the budget entry method passed

Line 252: (c_project_id pa_projects_all.project_id%TYPE)

248:
249: -- Cursot to get the segment 1 of the project. Added baseline funding flag as part
250: -- changes due to finplan in AMG
251: CURSOR l_amg_project_csr
252: (c_project_id pa_projects_all.project_id%TYPE)
253: IS
254: SELECT segment1
255: ,baseline_funding_flag
256: FROM pa_projects_all

Line 256: FROM pa_projects_all

252: (c_project_id pa_projects_all.project_id%TYPE)
253: IS
254: SELECT segment1
255: ,baseline_funding_flag
256: FROM pa_projects_all
257: WHERE project_id=c_project_id;
258:
259: l_amg_project_rec l_amg_project_csr%ROWTYPE;
260:

Line 331: ,c_project_id pa_projects_all.project_id%TYPE)

327: -- Cursor to know whether a version exists for plan type created by upgrading the budget type
328: -- which is given as input. Crated as part of changes due to finplan in AMG
329: CURSOR is_budget_type_upgraded_csr
330: ( c_budget_type_code pa_budget_types.budget_type_code%TYPE
331: ,c_project_id pa_projects_all.project_id%TYPE)
332: IS
333: SELECT 'X'
334: FROM pa_fin_plan_types_b fin ,pa_proj_fp_options pfo
335: WHERE pfo.project_id=c_project_id

Line 420: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

416: -- is reported while validating the input parameters
417: -- passed by the user
418: l_any_error_occurred_flag VARCHAR2(1) :='N';
419:
420: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;

Line 421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;

417: -- passed by the user
418: l_any_error_occurred_flag VARCHAR2(1) :='N';
419:
420: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;

Line 422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;

418: l_any_error_occurred_flag VARCHAR2(1) :='N';
419:
420: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;

Line 423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;

419:
420: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
427: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;

Line 424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;

420: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
427: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
428: l_is_rate_type_valid BOOLEAN;

Line 425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;

421: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
427: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
428: l_is_rate_type_valid BOOLEAN;
429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';

Line 426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;

422: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
423: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
424: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
425: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
426: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
427: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
428: l_is_rate_type_valid BOOLEAN;
429: l_planning_level_lookup CONSTANT VARCHAR2(30) := 'BUDGET ENTRY LEVEL';
430: l_time_phasing_lookup CONSTANT VARCHAR2(30) := 'BUDGET TIME PHASED TYPE';

Line 450: px_pa_project_id_in pa_projects_all.project_id%TYPE;

446:
447: -- for bug 3954329
448: l_res_list_migration_code pa_resource_list_members.migration_code%TYPE := FND_API.G_MISS_CHAR;
449: l_targ_request_id pa_budget_versions.request_id%TYPE;
450: px_pa_project_id_in pa_projects_all.project_id%TYPE;
451: px_resource_list_id_in pa_resource_lists_all_bg.resource_list_id%TYPE;
452: px_fin_plan_type_id_in pa_fin_plan_types_b.fin_plan_type_id%TYPE;
453:
454: BEGIN

Line 2772: (c_project_id pa_projects_all.project_id%TYPE)

2768:
2769:
2770: -- Cursor to get the segment 1 of the project.
2771: CURSOR l_amg_project_csr
2772: (c_project_id pa_projects_all.project_id%TYPE)
2773: IS
2774: SELECT segment1
2775: FROM pa_projects_all
2776: WHERE project_id=c_project_id;

Line 2775: FROM pa_projects_all

2771: CURSOR l_amg_project_csr
2772: (c_project_id pa_projects_all.project_id%TYPE)
2773: IS
2774: SELECT segment1
2775: FROM pa_projects_all
2776: WHERE project_id=c_project_id;
2777:
2778: -- Cursor used in validating the product code
2779: Cursor p_product_code_csr (c_pm_product_code IN VARCHAR2)

Line 5094: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c

5090:
5091: BEGIN
5092: SELECT projfunc_currency_code
5093: INTO l_txn_currency_code
5094: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c
5095: WHERE a.project_id = b.project_id
5096: AND b.budget_version_id = c.budget_version_id
5097: AND c.resource_assignment_id = p_resource_assignment_id
5098: AND b.ci_id IS NULL; -- -- Added an extra clause b.ci_id IS NULL --Bug # 3507156

Line 5694: ,p_pa_project_id IN pa_projects_all.project_id%TYPE

5690: -- sgoteti 11-May-05 Added p_run_id parameter. This parameter will be used in web ADI flow only
5691: PROCEDURE Validate_Budget_Lines
5692: ( p_calling_context IN VARCHAR2 DEFAULT 'BUDGET_LINE_LEVEL_VALIDATION'
5693: ,p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE
5694: ,p_pa_project_id IN pa_projects_all.project_id%TYPE
5695: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5696: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5697: ,p_version_type IN pa_budget_versions.version_type%TYPE
5698: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE

Line 5775: ,pa_projects_all p

5771: ,c_project_id pa_fp_txn_currencies.project_id%TYPE)
5772: IS
5773: SELECT txn_currency_code
5774: FROM pa_fp_txn_currencies ptxn
5775: ,pa_projects_all p
5776: WHERE p.project_id=c_project_id
5777: AND ptxn.project_id = p.project_id
5778: AND ptxn.txn_currency_code NOT IN (p.project_currency_code, p.projfunc_currency_code)
5779: AND ptxn.proj_fp_options_id = c_proj_fp_options_id; --made changes to the sql for bug 4886319 (performance)

Line 5790: ,pa_projects_all p

5786: ,c_fin_plan_version_id pa_fp_txn_currencies.fin_plan_version_id%TYPE)
5787: IS
5788: SELECT txn_currency_code
5789: FROM pa_fp_txn_currencies ptxn
5790: ,pa_projects_all p
5791: WHERE p.project_id = c_project_id
5792: AND ptxn.project_id = p.project_id
5793: AND ptxn.fin_plan_type_id = c_fin_plan_type_id
5794: AND ptxn.txn_currency_code NOT IN (p.project_currency_code, p.projfunc_currency_code)

Line 5844: ,c_project_id pa_projects_all.project_id%TYPE)

5840: --This cursor is used to get the approved rev plan type flag of the plan type
5841: --Added as part of the changes for fin plan model in FP L
5842: CURSOR l_approved_revenue_flag_csr
5843: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
5844: ,c_project_id pa_projects_all.project_id%TYPE)
5845: IS
5846: SELECT approved_rev_plan_type_flag,
5847: proj_fp_options_id
5848: FROM pa_proj_fp_options

Line 5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

5900: l_module_name VARCHAR2(80);
5901: l_top_task_id pa_tasks.top_task_id%TYPE;
5902: l_dummy VARCHAR2(1);
5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;

Line 5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;

5901: l_top_task_id pa_tasks.top_task_id%TYPE;
5902: l_dummy VARCHAR2(1);
5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;

Line 5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;

5902: l_dummy VARCHAR2(1);
5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;

Line 5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;

5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;

Line 5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;

5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;

Line 5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;

5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;
5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;

Line 5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;

5906: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE ;
5907: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE ;
5908: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE ;
5909: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE ;
5910: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE ;
5911: l_top_task_planning_level pa_fp_elements.top_task_planning_level%TYPE;
5912: l_res_planning_level pa_fp_elements.resource_planning_level%TYPE;
5913: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
5914: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;

Line 6252: from pa_projects_all

6248: where spread_curve_code = 'FIXED_DATE';
6249:
6250: select segment1
6251: into l_project_number
6252: from pa_projects_all
6253: where project_id=p_pa_project_id;
6254:
6255: END IF; -- Bug 5509192
6256:

Line 8968: ( p_pa_project_id IN pa_projects_all.project_id%TYPE

8964: -- 27-SEP-2005 jwhite Created per bug 4588279
8965:
8966:
8967: PROCEDURE Get_Latest_BC_Year
8968: ( p_pa_project_id IN pa_projects_all.project_id%TYPE
8969: ,x_latest_encumbrance_year OUT NOCOPY gl_ledgers.Latest_Encumbrance_Year%TYPE
8970: ,x_return_status OUT NOCOPY VARCHAR2
8971: ,x_msg_count OUT NOCOPY NUMBER
8972: ,x_msg_data OUT NOCOPY VARCHAR2

Line 8999: , pa_projects_all p

8995: SELECT l.Latest_Encumbrance_Year
8996: INTO x_latest_encumbrance_year
8997: FROM GL_ledgers l
8998: , pa_implementations_all i
8999: , pa_projects_all p
9000: WHERE l.LEDGER_ID = i.set_of_books_id
9001: AND i.org_id = p.org_id
9002: AND p.project_id = p_pa_project_id;
9003: