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_SUMMARIZE_ORG_ROLLUP_PVT dependencies on PA_SUMM_BALANCES

Line 481: ,pa_summ_balances bal

477: ,bal.amount_type_id
478: ,bal.period_num
479: ,bal.period_balance
480: FROM pa_org_hierarchy_denorm hier
481: ,pa_summ_balances bal
482: ,pa_objects obj
483: WHERE hier.parent_organization_id = p_start_org_id
484: AND hier.parent_level = p_maximum_level
485: AND NVL(hier.org_id,-99) = p_org_id

Line 534: FROM pa_summ_balances bal

530: ,MAX(bal.quarter_or_month_number)
531: ,bal.amount_type_id
532: ,MAX(bal.period_num)
533: ,SUM(bal.period_balance)
534: FROM pa_summ_balances bal
535: ,pa_objects obj
536: ,pa_objects obj1
537: ,pa_org_hierarchy_denorm hier
538: WHERE obj1.object_type_code = obj.object_type_code

Line 620: * Delete all total and sub-org numbers from pa_summ_balances.

616: PA_DEBUG.log_message('org_rollup_pagl_period_type: ' || PA_DEBUG.g_err_stage);
617: END IF;
618:
619: /*
620: * Delete all total and sub-org numbers from pa_summ_balances.
621: */
622: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
623: PA_DEBUG.g_err_stage := '100:Deleting Total and Sub-org Records';
624: PA_DEBUG.log_message('org_rollup_pagl_period_type: ' || PA_DEBUG.g_err_stage);

Line 628: FROM pa_summ_balances bal

624: PA_DEBUG.log_message('org_rollup_pagl_period_type: ' || PA_DEBUG.g_err_stage);
625: END IF;
626: LOOP
627: DELETE
628: FROM pa_summ_balances bal
629: WHERE bal.amount_type_id IN ( l_org_sub_hrs_id
630: ,l_org_sub_wtdhrs_org_id
631: ,l_org_sub_prvhrs_id
632: ,l_org_sub_prvwtdhrs_org_id

Line 752: INTO pa_summ_balances( object_id

748:
749:
750: FORALL i IN l_object_id_tab.FIRST .. l_object_id_tab.LAST
751: INSERT
752: INTO pa_summ_balances( object_id
753: ,version_id
754: ,object_type_code
755: ,period_type
756: ,period_set_name

Line 881: INTO pa_summ_balances( object_id

877: END IF;
878:
879: FORALL i IN l_object_id_tab.FIRST .. l_object_id_tab.LAST
880: INSERT
881: INTO pa_summ_balances( object_id
882: ,version_id
883: ,object_type_code
884: ,period_type
885: ,period_set_name

Line 930: UPDATE pa_summ_balances bal

926: /*
927: * Update the tot_num records with tot_num = tot_num + sub_org
928: */
929: FORALL i IN l_object_id_tab.FIRST .. l_object_id_tab.LAST
930: UPDATE pa_summ_balances bal
931: SET bal.period_balance = bal.period_balance + l_sub_org_total_tab(i)
932: WHERE bal.object_id = l_object_id_tab(i)
933: AND bal.version_id = -1
934: AND bal.object_type_code = l_object_type_code_tab(i)

Line 966: INTO pa_summ_balances( object_id

962: /*
963: * Update didnt' go thro' so, INSERT.
964: */
965: INSERT
966: INTO pa_summ_balances( object_id
967: ,version_id
968: ,object_type_code
969: ,period_type
970: ,period_set_name

Line 1075: ,pa_summ_balances bal

1071: ,bal.quarter_or_month_number
1072: ,bal.amount_type_id
1073: ,bal.period_balance
1074: FROM pa_org_hierarchy_denorm hier
1075: ,pa_summ_balances bal
1076: ,pa_objects obj
1077: WHERE hier.parent_organization_id = p_start_org_id
1078: AND hier.parent_level = p_maximum_level
1079: AND NVL(hier.org_id,-99) = p_org_id

Line 1127: FROM pa_summ_balances bal

1123: ,MAX(bal.period_year)
1124: ,MAX(bal.quarter_or_month_number)
1125: ,bal.amount_type_id
1126: ,SUM(bal.period_balance)
1127: FROM pa_summ_balances bal
1128: ,pa_objects obj
1129: ,pa_objects obj1
1130: ,pa_org_hierarchy_denorm hier
1131: WHERE obj1.object_type_code = obj.object_type_code

Line 1212: * Delete all total and sub-org numbers from pa_summ_balances.

1208: PA_DEBUG.g_err_stage := '100:Deleting Total and Sub-org Records';
1209: PA_DEBUG.log_message('org_rollup_ge_period_type: ' || PA_DEBUG.g_err_stage);
1210: END IF;
1211: /*
1212: * Delete all total and sub-org numbers from pa_summ_balances.
1213: */
1214: LOOP
1215: DELETE
1216: FROM pa_summ_balances bal

Line 1216: FROM pa_summ_balances bal

1212: * Delete all total and sub-org numbers from pa_summ_balances.
1213: */
1214: LOOP
1215: DELETE
1216: FROM pa_summ_balances bal
1217: WHERE bal.amount_type_id IN ( l_org_sub_hrs_id
1218: ,l_org_sub_wtdhrs_org_id
1219: ,l_org_sub_prvhrs_id
1220: ,l_org_sub_prvwtdhrs_org_id

Line 1342: INTO pa_summ_balances( object_id

1338:
1339:
1340: FORALL i IN l_object_id_tab.FIRST .. l_object_id_tab.LAST
1341: INSERT
1342: INTO pa_summ_balances( object_id
1343: ,version_id
1344: ,object_type_code
1345: ,period_type
1346: ,period_set_name

Line 1476: INTO pa_summ_balances( object_id

1472: END IF;
1473:
1474: FORALL i IN l_object_id_tab.FIRST .. l_object_id_tab.LAST
1475: INSERT
1476: INTO pa_summ_balances( object_id
1477: ,version_id
1478: ,object_type_code
1479: ,period_type
1480: ,period_set_name

Line 1526: UPDATE pa_summ_balances bal

1522: * Update the tot_num records with tot_num = tot_num + sub_org
1523: * Some of the checks in the where clause may not be required.
1524: */
1525: FORALL i IN l_object_id_tab.FIRST .. l_object_id_tab.LAST
1526: UPDATE pa_summ_balances bal
1527: SET bal.period_balance = bal.period_balance + l_sub_org_total_tab(i)
1528: WHERE bal.object_id = l_object_id_tab(i)
1529: AND bal.version_id = -1
1530: AND bal.object_type_code = l_object_type_code_tab(i)

Line 1559: INTO pa_summ_balances( object_id

1555: /*
1556: * Update didnt' go thro' so, INSERT.
1557: */
1558: INSERT
1559: INTO pa_summ_balances( object_id
1560: ,version_id
1561: ,object_type_code
1562: ,period_type
1563: ,period_set_name