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_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 331: -- Update the PA_BUDGET_ACCT_LINES table from the CC Funds Check Results

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

Line 332: UPDATE PA_BUDGET_ACCT_LINES PBA

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

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

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

Line 2321: UPDATE PA_BUDGET_ACCT_LINES

2317: BEGIN
2318:
2319: x_return_status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: UPDATE PA_BUDGET_ACCT_LINES
2322: SET curr_ver_available_amount = curr_ver_available_amount - p_amount
2323: WHERE budget_version_id = p_budget_version_id
2324: AND gl_period_name = p_gl_period_name
2325: AND code_combination_id = p_ccid ;

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

2337: END upd_bdgt_acct_bal;
2338:
2339: --
2340: -- Procedure : upd_bdgt_acct_bal_no_fck
2341: -- Purpose : Update the amount available column in pa_budget_acct_lines
2342: -- table during budget baselining process. This is called when
2343: -- funds check is not required during baselining process.
2344: -- The projects funds check process deternimes this by comparing
2345: -- current budget's budget lines with the previous budget's budget

Line 2375: UPDATE PA_BUDGET_ACCT_LINES

2371: log_message('Entering upd_bdgt_acct_bal_no_fck ..... ');
2372: x_return_status := FND_API.G_RET_STS_SUCCESS;
2373:
2374: log_message('budget_version_id '||to_char(p_budget_version_id));
2375: UPDATE PA_BUDGET_ACCT_LINES
2376: SET curr_ver_available_amount = (curr_ver_budget_amount - prev_ver_budget_amount
2377: + prev_ver_available_amount)
2378: WHERE budget_version_id = p_budget_version_id ;
2379:

Line 3287: Update pa_budget_acct_lines

3283: PRAGMA AUTONOMOUS_TRANSACTION;
3284: Begin
3285:
3286: log_message(' In Fail_draft_acct_summary');
3287: Update pa_budget_acct_lines
3288: set funds_check_status_code = 'R',
3289: funds_check_result_code = decode(substr(nvl(funds_check_result_code,'P'),1,1),'P',
3290: decode(p_failure_status,
3291: 'FAIL',decode(g_processing_mode,