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_FP_UPGRADE_PKG dependencies on PA_PROJECTS

Line 33: ,c_project_type IN pa_projects.project_type%TYPE

29:
30: CURSOR projects_for_upgrade_cur1 (
31: c_from_project_number IN VARCHAR2
32: ,c_to_project_number IN VARCHAR2
33: ,c_project_type IN pa_projects.project_type%TYPE
34: ,c_project_statuses IN VARCHAR2) IS
35: SELECT project_id
36: FROM pa_projects
37: WHERE segment1 BETWEEN c_from_project_number AND c_to_project_number

Line 36: FROM pa_projects

32: ,c_to_project_number IN VARCHAR2
33: ,c_project_type IN pa_projects.project_type%TYPE
34: ,c_project_statuses IN VARCHAR2) IS
35: SELECT project_id
36: FROM pa_projects
37: WHERE segment1 BETWEEN c_from_project_number AND c_to_project_number
38: AND NVL(c_project_type,project_type) = project_type
39: AND DECODE(c_project_statuses,'ALL','ACTIVE',project_status_code) <> 'CLOSED'; --Bug 5194368
40:

Line 45: ,c_project_type IN pa_projects.project_type%TYPE

41:
42: CURSOR projects_for_upgrade_cur2 (
43: c_from_project_number IN VARCHAR2
44: ,c_to_project_number IN VARCHAR2
45: ,c_project_type IN pa_projects.project_type%TYPE
46: ,c_project_statuses IN VARCHAR2) IS
47: SELECT project_id
48: FROM pa_projects
49: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)

Line 48: FROM pa_projects

44: ,c_to_project_number IN VARCHAR2
45: ,c_project_type IN pa_projects.project_type%TYPE
46: ,c_project_statuses IN VARCHAR2) IS
47: SELECT project_id
48: FROM pa_projects
49: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)
50: AND c_project_type = project_type
51: AND DECODE(c_project_statuses,'ALL','ACTIVE',project_status_code) <> 'CLOSED'; --Bug 5194368
52:

Line 57: ,c_project_type IN pa_projects.project_type%TYPE

53:
54: CURSOR projects_for_upgrade_cur3 (
55: c_from_project_number IN VARCHAR2
56: ,c_to_project_number IN VARCHAR2
57: ,c_project_type IN pa_projects.project_type%TYPE
58: ,c_project_statuses IN VARCHAR2) IS
59: SELECT project_id
60: FROM pa_projects
61: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)

Line 60: FROM pa_projects

56: ,c_to_project_number IN VARCHAR2
57: ,c_project_type IN pa_projects.project_type%TYPE
58: ,c_project_statuses IN VARCHAR2) IS
59: SELECT project_id
60: FROM pa_projects
61: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)
62: AND NVL(c_project_type,project_type) = project_type
63: AND project_status_code <> 'CLOSED'; --Bug 5194368
64:

Line 70: ,c_project_type IN pa_projects.project_type%TYPE

66:
67: CURSOR projects_for_upgrade_cur (
68: c_from_project_number IN VARCHAR2
69: ,c_to_project_number IN VARCHAR2
70: ,c_project_type IN pa_projects.project_type%TYPE
71: ,c_project_statuses IN VARCHAR2) IS
72: SELECT project_id
73: FROM pa_projects
74: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)

Line 73: FROM pa_projects

69: ,c_to_project_number IN VARCHAR2
70: ,c_project_type IN pa_projects.project_type%TYPE
71: ,c_project_statuses IN VARCHAR2) IS
72: SELECT project_id
73: FROM pa_projects
74: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)
75: AND NVL(c_project_type,project_type) = project_type
76: AND DECODE(c_project_statuses,'ALL','ACTIVE',project_status_code) <> 'CLOSED'; --Bug 5194368
77:

Line 81: c_project_id IN pa_projects.project_id%TYPE)IS

77:
78: project_info_rec projects_for_upgrade_cur%ROWTYPE;
79:
80: CURSOR project_type_info_cur (
81: c_project_id IN pa_projects.project_id%TYPE)IS
82: SELECT allow_cost_budget_entry_flag
83: ,allow_rev_budget_entry_flag
84: ,name
85: ,segment1

Line 88: ,pa_projects pp

84: ,name
85: ,segment1
86: ,org_project_flag -- bug 2788983
87: FROM pa_project_types ppt
88: ,pa_projects pp
89: WHERE pp.project_id = c_project_id
90: AND ppt.project_type = pp.project_type;
91:
92: project_type_info_rec project_type_info_cur%ROWTYPE;

Line 95: c_project_id IN pa_projects.project_id%TYPE

91:
92: project_type_info_rec project_type_info_cur%ROWTYPE;
93:
94: CURSOR attached_plan_types_cur(
95: c_project_id IN pa_projects.project_id%TYPE
96: ,c_budget_types IN VARCHAR2 ) IS
97: SELECT pt.fin_plan_type_id fin_plan_type_id
98: ,bt.budget_Type_code budget_Type_code
99: FROM pa_fin_plan_types_b pt /* Bug# 2661650 - Replaced _vl by _b for performance reasons */

Line 125: c_project_id IN pa_projects.project_id%TYPE

121: -- bug 3673111, 07-JUN-4, jwhite -------------------------------
122: -- Add resource_list_id as a new column in the select statement.
123:
124: CURSOR budgets_for_upgrade_cur (
125: c_project_id IN pa_projects.project_id%TYPE
126: ,c_budget_types IN VARCHAR2
127: ,c_budget_statuses IN VARCHAR2
128: ,c_mode IN VARCHAR2 ) IS
129: SELECT budget_version_id

Line 214: c_project_id IN pa_projects.project_id%TYPE) IS

210:
211: budget_version_info_rec budget_version_info_cur%ROWTYPE;
212:
213: CURSOR project_type_level_info_cur (
214: c_project_id IN pa_projects.project_id%TYPE) IS
215: SELECT cost_budget_entry_method_code
216: ,cost_budget_resource_list_id
217: ,rev_budget_entry_method_code
218: ,rev_budget_resource_list_id

Line 221: FROM pa_projects a,

217: ,rev_budget_entry_method_code
218: ,rev_budget_resource_list_id
219: ,allow_cost_budget_entry_flag
220: ,allow_rev_budget_entry_flag
221: FROM pa_projects a,
222: pa_project_types b
223: WHERE a.project_id = c_project_id
224: AND b.project_type = a.project_type;
225:

Line 955: l_project_id pa_projects.project_id%TYPE;

951: l_data VARCHAR2(2000);
952: l_msg_index_out NUMBER;
953: l_debug_mode VARCHAR2(30);
954:
955: l_project_id pa_projects.project_id%TYPE;
956: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
957: l_upgrade_elements_rec upgrade_elements_rec_type;
958:
959: l_proj_validation_status VARCHAR2(30);

Line 1567: project level(pa_projects_all) for the plan type and plan version fp options if

1563: This process will create record in pa_proj_fp_options table for the project,
1564: plan type and plan version levels. It will create fp option only at the level
1565: for which this api is called.
1566: Bug#2731534: The api has been modified to default MC conversion attributes from
1567: project level(pa_projects_all) for the plan type and plan version fp options if
1568: Project currency <> Projfunc Currency for the project.
1569: ===============================================================================*/
1570: PROCEDURE Create_fp_options(
1571: p_project_id IN pa_proj_fp_options.project_id%TYPE

Line 1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

1590: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:

Line 1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:
1602:

Line 1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

1595: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:
1602:
1603: BEGIN

Line 1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

1596: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1597: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
1598: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
1599: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
1600: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
1601:
1602:
1603: BEGIN
1604:

Line 1825: p_project_id IN pa_projects.project_id%TYPE

1821: This process will identify the budget types for which budget versions exist for
1822: the project and add those plan types to the project.
1823: =============================================================================*/
1824: Procedure Add_Plan_Types(
1825: p_project_id IN pa_projects.project_id%TYPE
1826: ,p_budget_types IN VARCHAR2
1827: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1828: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1829: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 2057: p_project_id IN pa_projects.project_id%TYPE

2053: -- in upgrade_budget_versions api while calling
2054: -- apply_calculate_fpm_rules.
2055: =============================================================================*/
2056: PROCEDURE Upgrade_Budget_Versions (
2057: p_project_id IN pa_projects.project_id%TYPE
2058: ,p_budget_types IN VARCHAR2
2059: ,p_budget_statuses IN VARCHAR2
2060: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2061: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2915: l_project_id pa_projects.project_id%TYPE;

2911: l_return_status VARCHAR2(2000);
2912: l_debug_mode VARCHAR2(30);
2913:
2914: l_validation_status VARCHAR2(30);
2915: l_project_id pa_projects.project_id%TYPE;
2916:
2917: -- cursor written for bug 2853511
2918:
2919: CURSOR attached_budget_types_cur(

Line 2920: c_project_id IN pa_projects.project_id%TYPE

2916:
2917: -- cursor written for bug 2853511
2918:
2919: CURSOR attached_budget_types_cur(
2920: c_project_id IN pa_projects.project_id%TYPE
2921: ,c_budget_types IN VARCHAR2 ) IS
2922: SELECT bt.budget_type_code budget_type_code
2923: FROM pa_budget_types bt
2924: WHERE DECODE(c_budget_types,'ALL','Y', bt.upgrade_budget_type_flag) = 'Y'

Line 3226: not find cost conversion attributes in pa_projects_all, then get

3222:
3223: Bug#2731534. Checking billing flag doesn't suffice the availablity
3224: of the conversion attributes for the project. It takes care of the
3225: revenue conversion attributes only. For cost attributes, if we do
3226: not find cost conversion attributes in pa_projects_all, then get
3227: them from the implementations table for the project's OU and if
3228: we do not find them there then raise exception for the project.
3229: ==================================================================*/
3230:

Line 3247: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

3243: l_return_status VARCHAR2(2000);
3244: l_debug_mode VARCHAR2(30);
3245:
3246:
3247: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

3244: l_debug_mode VARCHAR2(30);
3245:
3246:
3247: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

3245:
3246:
3247: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3253: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

3246:
3247: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3253: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3254:

Line 3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

3247: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3253: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3254:
3255: BEGIN

Line 3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

3248: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3253: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3254:
3255: BEGIN
3256:

Line 3253: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

3249: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3250: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
3251: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
3252: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
3253: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
3254:
3255: BEGIN
3256:
3257: x_msg_count := 0;

Line 3295: /* This api fetches the cost rate types from pa_projects_all table,

3291: x_validation_status := 'Y';
3292:
3293: -- Fetch the project currencies, MCB flag and cost rate types
3294:
3295: /* This api fetches the cost rate types from pa_projects_all table,
3296: if they aren't defined for project level then they are fetched from
3297: pa_implementations table */
3298:
3299: PA_FIN_PLAN_UTILS.Get_Project_Curr_Attributes

Line 4349: l_project_id pa_projects.project_id%TYPE;

4345: l_msg_index_out NUMBER;
4346: l_debug_mode VARCHAR2(30);
4347: l_error_msg_code VARCHAR2(2000);
4348:
4349: l_project_id pa_projects.project_id%TYPE;
4350: l_bv_id pa_budget_versions.budget_version_id%TYPE;
4351: l_budg_ver_id pa_budget_versions.budget_version_id%TYPE;
4352: l_ci_id pa_control_items.ci_id%TYPE;
4353: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 4386: FROM pa_projects prj,

4382: bv.budget_version_id,
4383: bv.ci_id,
4384: op.proj_fp_options_id,
4385: ci.status_code
4386: FROM pa_projects prj,
4387: pa_budget_versions bv,
4388: pa_fin_plan_types_b fp,
4389: pa_control_items ci,
4390: pa_proj_fp_options op