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.

[Home] [Help]

APPS.PA_BUDGET_FUND_PKG dependencies on PA_BUDGET_ACCT_LINES

Line 21: FROM PA_BUDGET_ACCT_LINES PBA,

17: SELECT 'X'
18: FROM dual
19: WHERE EXISTS
20: (SELECT 'X'
21: FROM PA_BUDGET_ACCT_LINES PBA,
22: GL_PERIOD_STATUSES GLS
23: WHERE GLS.application_id = PA_Period_Process_Pkg.Application_ID -- 101
24: AND GLS.set_of_books_id = c_set_of_books_id
25: AND GLS.period_name = PBA.gl_period_name

Line 181: log_message('updated pa_budget_acct_lines table with accounted_amount ');

177: log_message('l_period_set_name ...'||l_period_set_name);
178: log_message('p_budget_version_id .. '||p_budget_version_id);
179:
180: -- added for bug 1824164
181: log_message('updated pa_budget_acct_lines table with accounted_amount ');
182:
183: /* Commented for bug 3039985
184: UPDATE PA_BUDGET_ACCT_LINES PBA
185: SET PBA.accounted_amount = nvl(PBA.curr_ver_available_amount,0) - nvl(PBA.prev_ver_available_amount,0)

Line 184: UPDATE PA_BUDGET_ACCT_LINES PBA

180: -- added for bug 1824164
181: log_message('updated pa_budget_acct_lines table with accounted_amount ');
182:
183: /* Commented for bug 3039985
184: UPDATE PA_BUDGET_ACCT_LINES PBA
185: SET PBA.accounted_amount = nvl(PBA.curr_ver_available_amount,0) - nvl(PBA.prev_ver_available_amount,0)
186: WHERE PBA.budget_version_id = p_budget_version_id; */
187:
188: /* Added for bug 3039985 */

Line 189: UPDATE PA_BUDGET_ACCT_LINES PBA

185: SET PBA.accounted_amount = nvl(PBA.curr_ver_available_amount,0) - nvl(PBA.prev_ver_available_amount,0)
186: WHERE PBA.budget_version_id = p_budget_version_id; */
187:
188: /* Added for bug 3039985 */
189: UPDATE PA_BUDGET_ACCT_LINES PBA
190: SET PBA.accounted_amount = nvl(PBA.curr_ver_budget_amount,0) - nvl(PBA.prev_ver_budget_amount,0)
191: WHERE PBA.budget_version_id = p_budget_version_id;
192:
193: log_message('rows updated .........'||to_char(sql%rowcount)) ;

Line 297: PA_BUDGET_ACCT_LINES PBA,

293: sysdate,
294: fnd_global.user_id,
295: pba.budget_acct_line_id
296: FROM
297: PA_BUDGET_ACCT_LINES PBA,
298: GL_PERIOD_STATUSES GP,
299: GL_CODE_COMBINATIONS GL
300: WHERE PBA.accounted_amount <> 0
301: AND PBA.budget_version_id = p_budget_version_id

Line 335: -- Update the PA_BUDGET_ACCT_LINES table from the CC Funds Check Results

331: log_message(' l_result_code '||l_result_code);
332: log_message(' get mesage '||fnd_msg_pub.get(1));
333:
334:
335: -- Update the PA_BUDGET_ACCT_LINES table from the CC Funds Check Results
336: UPDATE PA_BUDGET_ACCT_LINES PBA
337: SET (PBA.funds_check_status_code,
338: PBA.funds_check_result_code) = (SELECT ICC.status_code,
339: ICC.cbc_result_code

Line 336: UPDATE PA_BUDGET_ACCT_LINES PBA

332: log_message(' get mesage '||fnd_msg_pub.get(1));
333:
334:
335: -- Update the PA_BUDGET_ACCT_LINES table from the CC Funds Check Results
336: UPDATE PA_BUDGET_ACCT_LINES PBA
337: SET (PBA.funds_check_status_code,
338: PBA.funds_check_result_code) = (SELECT ICC.status_code,
339: ICC.cbc_result_code
340: FROM IGC_CC_INTERFACE ICC

Line 354: log_message('rows updated into PA_BUDGET_ACCT_LINES Table .. '||sql%rowcount);

350: FROM IGC_CC_INTERFACE ICC
351: WHERE ICC.cc_header_id = p_budget_version_id
352: AND ICC.DOCUMENT_TYPE = 'PA'
353: AND ICC.reference_1 = 'PA')) ;
354: log_message('rows updated into PA_BUDGET_ACCT_LINES Table .. '||sql%rowcount);
355:
356: -- x_funds_chk_rsrv_status = Decode(l_ret_code,
357: -- Funds Check Return Code for the Packet processed. Valid Return Codes
358: -- are : 'S' for Success, 'A' for Advisory, 'F' for Failure, 'P' for Partial,

Line 2412: UPDATE PA_BUDGET_ACCT_LINES

2408: x_return_status := FND_API.G_RET_STS_SUCCESS;
2409:
2410: log_message('Inside upd_bdgt_acct_bal');
2411:
2412: UPDATE PA_BUDGET_ACCT_LINES
2413: SET curr_ver_available_amount = curr_ver_available_amount - p_amount
2414: WHERE budget_version_id = p_budget_version_id
2415: AND gl_period_name = p_gl_period_name
2416: AND code_combination_id = p_ccid ;

Line 2434: -- Purpose : Update the amount available column in pa_budget_acct_lines

2430: END upd_bdgt_acct_bal;
2431:
2432: --
2433: -- Procedure : upd_bdgt_acct_bal_no_fck
2434: -- Purpose : Update the amount available column in pa_budget_acct_lines
2435: -- table during budget baselining process. This is called when
2436: -- funds check is not required during baselining process.
2437: -- The projects funds check process deternimes this by comparing
2438: -- current budget's budget lines with the previous budget's budget

Line 2468: UPDATE PA_BUDGET_ACCT_LINES

2464: log_message('Entering upd_bdgt_acct_bal_no_fck ..... ');
2465: x_return_status := FND_API.G_RET_STS_SUCCESS;
2466:
2467: log_message('budget_version_id '||to_char(p_budget_version_id));
2468: UPDATE PA_BUDGET_ACCT_LINES
2469: SET curr_ver_available_amount = (curr_ver_budget_amount - prev_ver_budget_amount
2470: + prev_ver_available_amount)
2471: WHERE budget_version_id = p_budget_version_id ;
2472:

Line 3395: Update pa_budget_acct_lines

3391: PRAGMA AUTONOMOUS_TRANSACTION;
3392: Begin
3393:
3394: log_message(' In Fail_draft_acct_summary');
3395: Update pa_budget_acct_lines
3396: set funds_check_status_code = 'R',
3397: funds_check_result_code = decode(substr(nvl(funds_check_result_code,'P'),1,1),'P',
3398: decode(p_failure_status,
3399: 'FAIL',decode(g_processing_mode,