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.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_BUDGET_REVISION_LINES

Line 728: (select b.gl_period_name from psb_budget_revision_lines a, psb_budget_revision_accounts b

724: from GL_PERIOD_STATUSES
725: where application_id = 101
726: and set_of_books_id = g_set_of_books_id
727: and period_name in
728: (select b.gl_period_name from psb_budget_revision_lines a, psb_budget_revision_accounts b
729: where a.budget_revision_id = p_budget_revision_id
730: and b.budget_revision_acct_line_id = a.budget_revision_acct_line_id);
731:
732: cursor c_position_dates_br is

Line 1048: 'from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl ' ||

1044: -- Bug#3340060: Refixed bug#3022417 using bind variables. Earlier fix was
1045: -- causing duplicate record creation.
1046: sql_bra := '' ||
1047: 'select pbra.budget_revision_acct_line_id '||
1048: 'from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl ' ||
1049: 'where pbra.code_combination_id = :code_combination_id ' ||
1050: 'and pbra.gl_period_name = :gl_period_name ' ||
1051: 'and NVL(pbra.currency_code, :gmc1) = NVL(:currency_code, :gmc2) ' ||
1052: 'and NVL(pbra.gl_budget_version_id,:gmn1)=NVL(:budget_version_id,:gmn2) '||

Line 1075: DELETE psb_budget_revision_lines

1071: IF l_first_br_al_id IS NULL THEN
1072: l_first_br_al_id := l_budget_revision_acct_line_id;
1073: ELSE
1074: --
1075: DELETE psb_budget_revision_lines
1076: WHERE budget_revision_acct_line_id = l_budget_revision_acct_line_id;
1077: --
1078: DELETE psb_budget_revision_accounts
1079: WHERE budget_revision_acct_line_id = l_budget_revision_acct_line_id;

Line 1090: 'from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl ' ||

1086: -- Bug#3340060: End
1087:
1088: /* Commented as this code is replated by the above loop logic.
1089: sql_bra := 'select pbra.budget_revision_acct_line_id '||
1090: 'from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl ' ||
1091: 'where pbra.code_combination_id = :code_combination_id ' ||
1092: 'and pbra.gl_period_name = :gl_period_name ' ||
1093: 'and nvl(pbra.currency_code, ''' || FND_API.G_MISS_CHAR ||
1094: ''') = nvl(:currency_code, ''' || FND_API.G_MISS_CHAR || ''') ' ||

Line 1138: INSERT INTO PSB_BUDGET_REVISION_LINES

1134: -- this is used to propagate new budget revision entries created at any level to all the distributed levels
1135:
1136: for c_Distribute_Rev_Rec in c_Distribute_Rev (l_global_revision_id, p_budget_group_id) loop
1137:
1138: INSERT INTO PSB_BUDGET_REVISION_LINES
1139: (BUDGET_REVISION_ACCT_LINE_ID, BUDGET_REVISION_ID, FREEZE_FLAG,
1140: VIEW_LINE_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
1141: CREATION_DATE)
1142: VALUES (l_budget_revision_acct_line_id, c_Distribute_Rev_Rec.budget_revision_id, p_freeze_flag,

Line 1287: from psb_budget_revision_accounts a, psb_budget_revision_lines b

1283: and (effective_end_date > p_period_end_date))));
1284:
1285: cursor c_AcctExists is
1286: select 'Exists'
1287: from psb_budget_revision_accounts a, psb_budget_revision_lines b
1288: where a.code_combination_id = p_ccid
1289: and a.gl_period_name = p_period_name
1290: and b.budget_revision_id = p_budget_revision_id
1291: and b.budget_revision_acct_line_id = a.budget_revision_acct_line_id;

Line 1836: psb_budget_revision_lines pbrl,

1832:
1833: cursor c_original_budget is
1834: Select budget_balance
1835: from psb_budget_revision_accounts pbra,
1836: psb_budget_revision_lines pbrl,
1837: psb_budget_revisions pbr
1838: where pbra.code_combination_id = p_code_combination_id
1839: and pbra.gl_period_name = p_gl_period
1840: and pbra.gl_budget_version_id = p_gl_budget_version_id

Line 1853: psb_budget_revision_lines pbrl,

1849:
1850: Cursor c_original_budget_sum is
1851: Select sum(budget_balance) sum_budget_balance
1852: from psb_budget_revision_accounts pbra,
1853: psb_budget_revision_lines pbrl,
1854: psb_budget_revisions pbr
1855: where pbra.code_combination_id = p_code_combination_id
1856: and pbra.gl_budget_version_id = p_gl_budget_version_id
1857: and pbra.position_id is null

Line 3006: FROM psb_budget_revision_lines pbrl, psb_budget_revision_accounts pbra

3002: SELECT pbra.code_combination_id, pbra.gl_budget_version_id,
3003: pbra.budget_group_id,
3004: sum(decode(pbra.revision_type, 'D', -1 * pbra.revision_amount,
3005: pbra.revision_amount)) sum_revision
3006: FROM psb_budget_revision_lines pbrl, psb_budget_revision_accounts pbra
3007: WHERE pbrl.budget_revision_id = p_budget_revision_id
3008: AND pbra.budget_revision_acct_line_id = pbrl.budget_revision_acct_line_id
3009: AND pbra.gl_period_name = p_gl_period_name
3010: AND pbra.position_id IS NOT NULL

Line 5379: from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl

5375: pbra.revision_type,
5376: pbra.revision_value_type,
5377: pbra.revision_amount,
5378: pbrl.freeze_flag, pbrl.view_line_flag
5379: from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl
5380: where pbrl.budget_revision_id = p_budget_revision_id
5381: and pbra.budget_revision_acct_line_id = pbrl.budget_revision_acct_line_id
5382: and position_id = p_position_id
5383: and gl_period_name = l_gl_period;

Line 5387: from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl

5383: and gl_period_name = l_gl_period;
5384:
5385: cursor c_zero_accounts is
5386: select pbra.budget_revision_acct_line_id
5387: from psb_budget_revision_accounts pbra, psb_budget_revision_lines pbrl
5388: where pbrl.budget_revision_id = p_budget_revision_id
5389: and pbra.budget_revision_acct_line_id = pbrl.budget_revision_acct_line_id
5390: and pbra.revision_amount = 0;
5391:

Line 7051: FROM psb_budget_revision_lines

7047: (SELECT COUNT(1) acct_line_cnt
7048: FROM psb_budget_revision_accounts
7049: WHERE budgeT_revision_acct_line_id
7050: IN (SELECT budget_revision_Acct_line_id
7051: FROM psb_budget_revision_lines
7052: WHERE budget_revision_id = p_budget_revision_id)
7053: AND position_id = p_position_id)
7054: LOOP
7055: l_acct_line_cnt := l_acc_line_rec.acct_line_cnt;

Line 7381: from PSB_BUDGET_REVISION_LINES b,

7377: -- Compute Sum of BR Account Lines (all Account Sets assigned to the Constraint)
7378:
7379: cursor c_SumAll is
7380: select Sum(decode(a.revision_type,'I',nvl(a.revision_amount, 0),'D',-nvl(a.revision_amount,0))) Sum_Acc
7381: from PSB_BUDGET_REVISION_LINES b,
7382: PSB_BUDGET_REVISION_ACCOUNTS a
7383: where b.budget_revision_id = p_budget_revision_id
7384: and a.budget_revision_acct_line_id = b.budget_revision_acct_line_id
7385: and a.currency_code = p_currency_code

Line 7400: PSB_BUDGET_REVISION_LINES b

7396: -- Compute sum of BR Account Lines for a Constraint Formula of type 4
7397: cursor c_Sum (CCID NUMBER) is
7398: select Sum(decode(a.revision_type,'I',nvl(a.revision_amount, 0),'D',-nvl(a.revision_amount,0))) Sum_Acc
7399: from PSB_BUDGET_REVISION_ACCOUNTS a,
7400: PSB_BUDGET_REVISION_LINES b
7401: where a.code_combination_id = CCID
7402: and a.currency_code = p_currency_code
7403: and a.position_id is null
7404: and b.budget_revision_id = p_budget_revision_id

Line 7410: psb_budget_revision_lines pbrl,

7406:
7407: cursor c_Original_Balance (CCID NUMBER, Currency VARCHAR2) is
7408: select sum(budget_balance) original_balance
7409: from psb_budget_revision_accounts pbra,
7410: psb_budget_revision_lines pbrl,
7411: psb_budget_revisions pbr
7412: where pbra.code_combination_id = CCID
7413: and pbra.currency_code = Currency
7414: and pbra.position_id is null

Line 7430: psb_budget_revision_lines pbrl,

7426:
7427: cursor c_Original_Balance_Sum (Currency VARCHAR2) is
7428: select sum(budget_balance) original_balance
7429: from psb_budget_revision_accounts pbra,
7430: psb_budget_revision_lines pbrl,
7431: psb_budget_revisions pbr
7432: where pbra.code_combination_id in
7433: (select d.code_combination_id
7434: from psb_budget_accounts d,

Line 7458: psb_budget_revision_lines pbrl

7454: CURSOR c_Account (CCID NUMBER) IS
7455: SELECT pbra.gl_budget_version_id,
7456: pbra.gl_period_name -- Bug 5148786
7457: FROM psb_budget_revision_accounts pbra,
7458: psb_budget_revision_lines pbrl
7459: WHERE pbra.code_combination_id = CCID
7460: AND pbra.position_id is null
7461: AND pbrl.budget_revision_id = p_budget_revision_id
7462: AND pbrl.budget_revision_acct_line_id = pbra.budget_revision_acct_line_id;

Line 7469: psb_budget_revision_lines pbrl

7465: SELECT pbra.code_combination_id,
7466: pbra.gl_budget_version_id,
7467: pbra.gl_period_name -- Bug 5148786
7468: FROM psb_budget_revision_accounts pbra,
7469: psb_budget_revision_lines pbrl
7470: WHERE pbra.code_combination_id in
7471: (select d.code_combination_id
7472: from psb_budget_accounts d,
7473: psb_set_relations_v e

Line 9544: from psb_budget_revision_lines pbrl

9540: where pbr.budget_revision_id = p_budget_revision_id;
9541:
9542: Cursor C_Account_line is
9543: Select pbrl.budget_revision_acct_line_id
9544: from psb_budget_revision_lines pbrl
9545: where pbrl.budget_revision_id = p_budget_revision_id
9546: and pbrl.budget_revision_acct_line_id = p_budget_revision_acct_line_id;
9547:
9548: Begin

Line 9589: Delete PSB_BUDGET_REVISION_LINES

9585: IF l_global_revision = 'Y' THEN
9586: Delete PSB_BUDGET_REVISION_ACCOUNTS
9587: where budget_revision_acct_line_id = p_budget_revision_acct_line_id;
9588:
9589: Delete PSB_BUDGET_REVISION_LINES
9590: where budget_revision_acct_line_id = p_budget_revision_acct_line_id;
9591: ELSE
9592: Delete PSB_BUDGET_REVISION_LINES
9593: where budget_revision_acct_line_id = p_budget_revision_acct_line_id

Line 9592: Delete PSB_BUDGET_REVISION_LINES

9588:
9589: Delete PSB_BUDGET_REVISION_LINES
9590: where budget_revision_acct_line_id = p_budget_revision_acct_line_id;
9591: ELSE
9592: Delete PSB_BUDGET_REVISION_LINES
9593: where budget_revision_acct_line_id = p_budget_revision_acct_line_id
9594: and budget_revision_id = p_budget_revision_id;
9595: END IF;
9596:

Line 9637: -- psb_budget_revisions and matrix tables (psb_budget_revision_lines and

9633: | PROCEDURE Delete_Budget_Revision_Pvt ( Private ) |
9634: +===========================================================================*/
9635: --
9636: -- This API deletes an official budget_revision by performing deletes on
9637: -- psb_budget_revisions and matrix tables (psb_budget_revision_lines and
9638: -- psb_budget_revision_pos_lines).
9639: -- It also deletes budget_revision related data from other tables.
9640: --
9641: PROCEDURE Delete_Budget_Revision_Pvt

Line 9664: FROM psb_budget_revision_lines

9660:
9661: CURSOR l_br_account_lines_csr
9662: IS
9663: SELECT budget_revision_acct_line_id
9664: FROM psb_budget_revision_lines
9665: WHERE budget_revision_id = p_budget_revision_id;
9666:
9667: CURSOR l_br_position_lines_csr
9668: IS

Line 9727: -- Deleting records from psb_budget_revision_lines.

9723: IF (l_br_account_lines_csr%NOTFOUND) THEN
9724: EXIT;
9725: END IF;
9726:
9727: -- Deleting records from psb_budget_revision_lines.
9728:
9729: PSB_BUDGET_REVISIONS_PVT.Delete_Revision_Accounts
9730: ( p_api_version => 1.0 ,
9731: p_init_msg_list => FND_API.G_FALSE,

Line 9776: -- Deleting records from psb_budget_revision_lines.

9772: IF ( l_br_position_lines_csr%NOTFOUND ) THEN
9773: EXIT;
9774: END IF;
9775:
9776: -- Deleting records from psb_budget_revision_lines.
9777:
9778: PSB_BUDGET_REVISIONS_PVT.Delete_Revision_Positions
9779: ( p_api_version => 1.0 ,
9780: p_init_msg_list => FND_API.G_FALSE,

Line 10791: FROM PSB_BUDGET_REVISION_LINES brl,

10787: CURSOR c_acct_exists(l_rule_id NUMBER) IS
10788: SELECT 'exists' result FROM dual WHERE EXISTS
10789: (
10790: SELECT bra.code_combination_id
10791: FROM PSB_BUDGET_REVISION_LINES brl,
10792: PSB_BUDGET_REVISION_ACCOUNTS bra
10793: WHERE brl.budget_revision_id = p_budget_revision_id
10794: AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id
10795: /*For Bug No : 2161125 Start*/

Line 11167: FROM PSB_BUDGET_REVISION_LINES brl, PSB_BUDGET_REVISION_ACCOUNTS bra

11163: AND sr.account_or_position_type = 'A'
11164: AND sr.rule_id = p_rule_id
11165: /* Bug No 2135165 Start */
11166: AND ba.code_combination_id in (SELECT bra.code_combination_id
11167: FROM PSB_BUDGET_REVISION_LINES brl, PSB_BUDGET_REVISION_ACCOUNTS bra
11168: WHERE brl.budget_revision_id = p_budget_revision_id
11169: AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id
11170: AND EXISTS (SELECT 1 FROM PSB_ENTITY_ASSIGNMENT ea, gl_sets_of_books sob, gl_periods_v gp
11171: WHERE ea.entity_set_id = g_brr_rule_set_id

Line 11258: ' FROM PSB_BUDGET_REVISION_LINES brl,'||

11254:
11255: l_seg_sql := 'SELECT DISTINCT glcc.'||p_application_column_name||
11256: ' FROM gl_code_combinations glcc,'||
11257: ' (SELECT DISTINCT bra.code_combination_id '||
11258: ' FROM PSB_BUDGET_REVISION_LINES brl,'||
11259: ' PSB_BUDGET_REVISION_ACCOUNTS bra '||
11260: ' WHERE brl.budget_revision_id = '||to_char(p_budget_revision_id)||
11261: ' AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id'||
11262: ' ) rcc'||

Line 11272: ' FROM PSB_BUDGET_REVISION_LINES brl,'||

11268: ' WHERE ba.account_position_set_id = sr.account_position_set_id'||
11269: ' AND sr.account_or_position_type = '||''''||'A'||''''||
11270: ' AND sr.rule_id = :b_rule_id'||
11271: ' AND ba.code_combination_id in (SELECT bra.code_combination_id '||
11272: ' FROM PSB_BUDGET_REVISION_LINES brl,'||
11273: ' PSB_BUDGET_REVISION_ACCOUNTS bra'||
11274: ' WHERE brl.budget_revision_id = :b_budget_revision_id'||
11275: ' AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id'||
11276: ' AND EXISTS (SELECT 1 '||

Line 11294: ' FROM PSB_BUDGET_REVISION_LINES brl,'||

11290:
11291: ' ))'||
11292:
11293: ' AND EXISTS (SELECT 1 '||
11294: ' FROM PSB_BUDGET_REVISION_LINES brl,'||
11295: ' PSB_BUDGET_REVISION_ACCOUNTS bra'||
11296: ' WHERE brl.budget_revision_id = :b_budget_revision_id'||
11297: ' AND bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id'||
11298: ' AND bra.code_combination_id = ba.code_combination_id)'||

Line 11412: from psb_budget_revision_accounts bra, psb_budget_revision_lines brl

11408: FOR c_CCID_Rec in c_CCID loop
11409: /*For Bug No : 2150471 Start*/
11410: --commented due to performance issues
11411: /*select count(bra.code_combination_id) into l_cnt
11412: from psb_budget_revision_accounts bra, psb_budget_revision_lines brl
11413: where bra.budget_revision_acct_line_id = brl.budget_revision_acct_line_id
11414: and brl.budget_revision_id = p_budget_revision_id
11415: and bra.code_combination_id = c_CCID_Rec.code_combination_id;*/
11416:

Line 11516: FROM PSB_BUDGET_REVISION_LINES b,

11512:
11513: cursor c_SumAll is
11514: SELECT a.revision_type, a.revision_value_type, a.revision_amount,
11515: a.account_type, a.budget_balance
11516: FROM PSB_BUDGET_REVISION_LINES b,
11517: PSB_BUDGET_REVISION_ACCOUNTS a
11518: WHERE b.budget_revision_id = p_budget_revision_id
11519: AND a.budget_revision_acct_line_id = b.budget_revision_acct_line_id
11520: AND a.code_combination_id = p_ccid