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_PUB dependencies on PA_BUDGET_LINES

Line 47: -- pa_budget_lines_v_pkg.check_overlapping_dates

43: --
44: --
45: --Called subprograms: PA_BUDGET_UTILS.create_draft
46: -- pa_budget_pvt.insert_budget_line
47: -- pa_budget_lines_v_pkg.check_overlapping_dates
48: -- PA_BUDGET_UTILS.summerize_project_totals
49: -- PA_BUDGET_FUND_PKG.get_budget_ctrl_options
50: --
51: --

Line 161: ,pa_budget_lines bl

157: IS
158: SELECT 'x'
159: FROM pa_budget_versions bv
160: ,pa_resource_assignments ra
161: ,pa_budget_lines bl
162: WHERE bv.budget_version_id = c_budget_version_id
163: AND bv.budget_version_id = ra.budget_version_id (+)
164: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
165: AND bv.ci_id IS NULL -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 2216: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id

2212: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2213: END IF;
2214:
2215: -- check for overlapping dates
2216: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id
2217: ,x_resource_name => l_resource_name
2218: ,x_err_code => l_err_code );
2219:
2220: IF l_err_code > 0

Line 2246: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

2242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2243: THEN
2244:
2245: FND_MSG_PUB.add_exc_msg
2246: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
2247: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
2248: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2249:
2250: END IF;

Line 2624: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

2620: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2621: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2622: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2623: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2624: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2625: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2626: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2627: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2628: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 2632: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

2628: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2629: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2630: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2631: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2632: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2633: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2634: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2635: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2636: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 2640: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

2636: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2637: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2638: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2639: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2640: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2641: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2642: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2643: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2644: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 2648: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

2644: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2645: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2646: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2647: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2648: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
2649: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2650: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
2651: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2652: )

Line 2650: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

2646: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2647: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2648: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
2649: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2650: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
2651: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2652: )
2653:
2654: IS

Line 3316: FROM pa_budget_lines

3312: CURSOR l_budget_lines_csr
3313: (p_budget_version_id NUMBER )
3314: IS
3315: SELECT 1
3316: FROM pa_budget_lines
3317: WHERE budget_version_id = p_budget_version_id;
3318:
3319: --8423481
3320: CURSOR l_resource_assignments_csr

Line 4275: -- and for old model budget we will check for budget lines in pa_budget_lines

4271:
4272: -- check for budget lines in pa_resource_assignments,
4273: -- we only permit submit/baseline action when there are budget lines
4274: -- Fix for bug#8423481, for new budget we will check for budget lines in pa_resource_assignments,
4275: -- and for old model budget we will check for budget lines in pa_budget_lines
4276: -- we only permit submit/baseline action when there are budget lines
4277: IF( p_budget_type_code IS NOT NULL
4278: AND p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
4279:

Line 5105: -- pa_budget_lines_v_pkg.check_overlapping_dates

5101: -- existing WORKING budget.
5102: --
5103: --Called subprograms:
5104: -- pa_budget_pvt.insert_budget_line
5105: -- pa_budget_lines_v_pkg.check_overlapping_dates
5106: -- PA_BUDGET_UTILS.summerize_project_totals
5107: --
5108: --
5109: --

Line 5433: PA_BUDGET_LINES_V_PKG.check_overlapping_dates

5429: END IF;
5430:
5431:
5432: --check for overlapping dates
5433: PA_BUDGET_LINES_V_PKG.check_overlapping_dates
5434: ( x_budget_version_id => l_budget_version_id --IN
5435: ,x_resource_name => l_resource_name --OUT
5436: ,x_err_code => l_err_code );
5437:

Line 5467: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

5463:
5464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5465: THEN
5466: FND_MSG_PUB.add_exc_msg
5467: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5468: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
5469: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5470: END IF;
5471:

Line 6185: , pa_budget_lines bl

6181: IS
6182: SELECT 'x'
6183: FROM pa_budget_versions bv
6184: , pa_resource_assignments ra
6185: , pa_budget_lines bl
6186: WHERE bv.budget_version_id = p_budget_version_id
6187: AND bv.budget_version_id = ra.budget_version_id (+)
6188: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
6189: AND bv.ci_id IS NULL -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156

Line 8098: FROM pa_budget_lines

8094: SELECT rowidtochar(rowid)
8095: ,txn_currency_code
8096: ,start_date
8097: ,end_date
8098: FROM pa_budget_lines
8099: WHERE resource_assignment_id = p_resource_assignment_id
8100: AND trunc(start_date) = nvl(trunc(p_budget_start_date),trunc(start_date))
8101: AND txn_currency_code = nvl(p_currency_code,txn_currency_code);
8102:

Line 8140: FROM pa_budget_lines

8136: --needed to lock the budget line row
8137: CURSOR l_lock_budget_line_csr( p_budget_line_rowid VARCHAR2)
8138: IS
8139: SELECT 'x'
8140: FROM pa_budget_lines
8141: WHERE rowid = p_budget_line_rowid
8142: FOR UPDATE NOWAIT;
8143:
8144: --This cursor is used to get the approved rev plan type flag of the plan type

Line 8767: /FPB2: MRC PA_BUDGET_LINES_V_PKG.delete_row( l_budget_line_rowid ); /

8763:
8764: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
8765: CLOSE l_lock_budget_line_csr;
8766:
8767: /*FPB2: MRC PA_BUDGET_LINES_V_PKG.delete_row( l_budget_line_rowid ); */
8768: pa_budget_lines_v_pkg.delete_row(X_Rowid => l_budget_line_rowid);
8769: -- Bug Fix: 4569365. Removed MRC code.
8770: --, x_mrc_flag => 'Y'); /* FPB2: Added x_mrc_flag for MRC changes */
8771:

Line 8768: pa_budget_lines_v_pkg.delete_row(X_Rowid => l_budget_line_rowid);

8764: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
8765: CLOSE l_lock_budget_line_csr;
8766:
8767: /*FPB2: MRC PA_BUDGET_LINES_V_PKG.delete_row( l_budget_line_rowid ); */
8768: pa_budget_lines_v_pkg.delete_row(X_Rowid => l_budget_line_rowid);
8769: -- Bug Fix: 4569365. Removed MRC code.
8770: --, x_mrc_flag => 'Y'); /* FPB2: Added x_mrc_flag for MRC changes */
8771:
8772:

Line 8783: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

8779:
8780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8781: THEN
8782: FND_MSG_PUB.add_exc_msg
8783: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
8784: , p_procedure_name => 'DELETE_ROW'
8785: , p_error_text => SQLCODE );
8786:
8787: END IF;

Line 9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9185: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9186: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9187: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9188: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9189: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9190: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9191: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9192: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9193: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9198: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9198: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9194: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9195: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9196: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9197: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9198: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9199: /* Plan Amount Entry flags introduced by bug 6408139 */
9200: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9201: ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9202: ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9229: FROM pa_budget_lines

9225: (p_resource_assigment_id NUMBER
9226: ,p_budget_start_date DATE )
9227: IS
9228: SELECT 'X'
9229: FROM pa_budget_lines
9230: WHERE resource_assignment_id = p_resource_assigment_id
9231: AND start_date = p_budget_start_date;
9232:
9233: --needed to get the current budget version data

Line 9338: , pa_budget_lines bl

9334: IS
9335: SELECT 'x'
9336: FROM pa_budget_versions bv
9337: , pa_resource_assignments ra
9338: , pa_budget_lines bl
9339: WHERE bv.budget_version_id = p_budget_version_id
9340: AND bv.budget_version_id = ra.budget_version_id (+)
9341: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
9342: AND bv.ci_id IS NULL -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156

Line 9460: FROM pa_budget_lines

9456: ,p_budget_start_date DATE
9457: ,p_txn_currency_code VARCHAR2)
9458: IS
9459: SELECT 'X'
9460: FROM pa_budget_lines
9461: WHERE resource_assignment_id = p_resource_assigment_id
9462: AND start_date = p_budget_start_date
9463: AND txn_currency_code = p_txn_currency_code;
9464:

Line 9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

9581: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9589:

Line 9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;

9582: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9589:
9590: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

Line 9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

9583: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9589:
9590: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9591: /*Added local variables for bug 6408139*/

Line 9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

9584: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9585: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9586: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9587: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9588: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9589:
9590: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9591: /*Added local variables for bug 6408139*/
9592: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 12663: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id --IN

12659: /*Added the below if condition for the bug 3453650*/
12660: IF l_budget_type_code IS NOT NULL THEN
12661:
12662: -- check for overlapping dates
12663: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id --IN
12664: ,x_resource_name => l_resource_name --OUT
12665: ,x_err_code => l_err_code );
12666:
12667: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );

Line 12667: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );

12663: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id --IN
12664: ,x_resource_name => l_resource_name --OUT
12665: ,x_err_code => l_err_code );
12666:
12667: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );
12668:
12669: IF l_err_code > 0 THEN
12670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12671: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');

Line 12680: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

12676: RAISE FND_API.G_EXC_ERROR;
12677: ELSIF l_err_code < 0 THEN
12678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12679: FND_MSG_PUB.add_exc_msg
12680: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
12681: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
12682: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12683: END IF;
12684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12899: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12900: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12901: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12902: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12903: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12904: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12905: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12906: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12907: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12908: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12909: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12910: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12915: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12915: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12911: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12912: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12913: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12914: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12915: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12916: )
12917:
12918: IS
12919:

Line 13233: FROM pa_budget_lines

13229: ,p_currency_code VARCHAR2)
13230: IS
13231: SELECT rowidtochar(rowid)
13232: ,budget_line_id
13233: FROM pa_budget_lines
13234: WHERE resource_assignment_id = p_resource_assigment_id
13235: AND trunc(start_date) = nvl(trunc(p_budget_start_date),trunc(start_date))
13236: AND txn_currency_code = nvl(p_currency_code,txn_currency_code);
13237:

Line 13242: FROM pa_budget_lines

13238: --needed to lock the budget line row
13239: CURSOR l_lock_budget_line_csr( p_budget_line_rowid VARCHAR2)
13240: IS
13241: SELECT 'x'
13242: FROM pa_budget_lines
13243: WHERE rowid = p_budget_line_rowid
13244: FOR UPDATE NOWAIT;
13245:
13246: l_api_name CONSTANT VARCHAR2(30) := 'update_budget_line';

Line 13874: --Take a db lock on the table pa_budget_lines

13870: --Update budget line for old FORMS based Budgets Model
13871: IF l_budget_type_code IS NOT NULL
13872: THEN
13873:
13874: --Take a db lock on the table pa_budget_lines
13875: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
13876: CLOSE l_lock_budget_line_csr; --FYI, does not release lock
13877:
13878: --Calling update_budget_line_sql to build a dynamic update statement

Line 14355: -- view definition. Changing the pa_budget_lines_v view could have a large impact.

14351: l_context_budget CONSTANT VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET;
14352:
14353: -- Bug 2863564 The cursor has been modified for financial planning changes.
14354: -- The changes include fetching of new columns which aren't included in the
14355: -- view definition. Changing the pa_budget_lines_v view could have a large impact.
14356: -- So, cursor has been modified to be based on the direct tables.
14357:
14358: ---- Bug # 3507156
14359: -- Modified the select statement to selecy alias name directly from pa_resource_list_members table

Line 14392: FROM pa_budget_lines bl,

14388: ,bl.project_revenue project_revenue
14389: ,bl.raw_cost projfunc_raw_cost
14390: ,bl.burdened_cost projfunc_burdened_cost
14391: ,bl.revenue projfunc_revenue
14392: FROM pa_budget_lines bl,
14393: pa_resource_assignments ra,
14394: pa_resource_list_members rlm
14395: WHERE bl.budget_version_id = c_budget_version_id
14396: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 14466: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */

14462: l_entry_level pa_budget_entry_methods.entry_level_code%type; /* 2207723 */
14463:
14464: p_multiple_task_msg VARCHAR2(1) := 'T';
14465:
14466: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */
14467:
14468: --Included the following variables as part of changes to AMG due to finplan model.
14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

Line 14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

14465:
14466: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */
14467:
14468: --Included the following variables as part of changes to AMG due to finplan model.
14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

Line 14575: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;

14571: l_resource_id pa_resource_txn_attributes.resource_id%type;
14572: l_resource_name per_all_people_f.full_name%type;
14573: l_locked_by_name per_people_x.full_name%type;
14574:
14575: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14576: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14577: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14578:
14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE

Line 14576: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;

14572: l_resource_name per_all_people_f.full_name%type;
14573: l_locked_by_name per_people_x.full_name%type;
14574:
14575: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14576: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14577: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14578:
14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14580: INDEX BY BINARY_INTEGER;

Line 14577: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;

14573: l_locked_by_name per_people_x.full_name%type;
14574:
14575: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14576: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14577: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14578:
14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14580: INDEX BY BINARY_INTEGER;
14581: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE

Line 14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE

14575: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14576: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14577: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14578:
14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14580: INDEX BY BINARY_INTEGER;
14581: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE
14582: INDEX BY BINARY_INTEGER;
14583: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE

Line 14581: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE

14577: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14578:
14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14580: INDEX BY BINARY_INTEGER;
14581: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE
14582: INDEX BY BINARY_INTEGER;
14583: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE
14584: INDEX BY BINARY_INTEGER;
14585:

Line 14583: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE

14579: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14580: INDEX BY BINARY_INTEGER;
14581: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE
14582: INDEX BY BINARY_INTEGER;
14583: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE
14584: INDEX BY BINARY_INTEGER;
14585:
14586: l_rw_cost_rate_override_tbl l_rw_cost_rate_override_tbl_t;
14587: l_burden_cst_rate_override_tbl l_burdn_cst_rte_override_tbl_t;

Line 16444: UPDATE pa_budget_lines

16440: IF p_multiple_task_msg <> 'F' THEN
16441: IF l_context = l_context_budget
16442: THEN
16443: FORALL i IN l_rowid_tbl.first .. l_rowid_tbl.last
16444: UPDATE pa_budget_lines
16445: SET raw_cost = l_txn_raw_cost_tbl(i),
16446: burdened_cost = l_txn_burdened_cost_tbl(i),
16447: revenue = l_txn_revenue_tbl(i),
16448: last_update_date = SYSDATE,

Line 16454: UPDATE pa_budget_lines

16450: last_update_login = G_LOGIN_ID
16451: WHERE rowid = l_rowid_tbl(i);
16452: ELSE
16453: FORALL i IN l_rowid_tbl.first .. l_rowid_tbl.last
16454: UPDATE pa_budget_lines
16455: SET quantity = l_quantity_tbl(i),
16456: display_quantity = l_display_quantity_tbl(i), --IPM Arch Enhancements Bug 4865563
16457: txn_raw_cost = l_txn_raw_cost_tbl(i),
16458: txn_burdened_cost = l_txn_burdened_cost_tbl(i),

Line 18982: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18978: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18979: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18980: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18981: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18982: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18983: ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18984: ,P_START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
18985: ,P_END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
18986: ,P_QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 19877: from pa_budget_lines

19873: end;*/
19874: l_resource_assignment_id_tbl(i) := pa_budget_pvt.G_res_assign_tbl(i).resource_assignment_id;
19875: begin
19876: select txn_currency_code into l_currency_code_tbl(i)
19877: from pa_budget_lines
19878: where resource_assignment_id=l_resource_assignment_id_tbl(i)
19879: and rownum=1;
19880: exception when no_data_found then
19881: l_currency_code_tbl(i):=l_currency_code;