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.JAI_CMN_RG_MASTER_ORG_PKG dependencies on JAI_CMN_RG_BALANCES

Line 631: 6. Updation of JAI_CMN_RG_BALANCES is done for Master Organization/Location.

627: 3. opening_balance_cur has been commented with a condition And nvl(master_flag,'N') = 'Y';
628: 4. A new cursor is added to fetch the Active Financial Year(c_fetch_fin_active_year).
629: 5. A new Cusor is added to fetch the Closing Balance of RG23A and RG23C Registers
630: (c_final_balance_rg23)
631: 6. Updation of JAI_CMN_RG_BALANCES is done for Master Organization/Location.
632:
633: 2. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
634: Master Org Consolidation has been implemented for CESS taxes and any other new
635: tax types that may be added in future.

Line 860: UPDATE JAI_CMN_RG_BALANCES

856: if v_debug_flag = 'Y' THEN
857: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);
858: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);
859: end if;
860: UPDATE JAI_CMN_RG_BALANCES
861: SET RG23A_BALANCE = v_rg23a_final_balance, RG23C_BALANCE=v_rg23c_final_balance
862: where organization_id=p_organization_id
863: and location_id =p_location_id;
864: --Ends here.....

Line 993: 6. Updation of JAI_CMN_RG_BALANCES.pla_balance is done for Master Organization/Location.

989: 3. opening_balance_cur has been commented with a condition And nvl(master_flag,'N') = 'Y';
990: 4. A new cursor is added to fetch the Active Financial Year(c_fetch_fin_active_year).
991: 5. A new Cusor is added to fetch the Closing Balance of RG23A and RG23C Registers
992: (c_final_balance_pla)
993: 6. Updation of JAI_CMN_RG_BALANCES.pla_balance is done for Master Organization/Location.
994:
995:
996: 2. 2003/12/30 Nagaraj.s for Bug#3335814. Version - 618.1
997:

Line 1000: Updation of JAI_CMN_RG_BALANCES was going wrong.

996: 2. 2003/12/30 Nagaraj.s for Bug#3335814. Version - 618.1
997:
998: In scenarios where Master Org records is not present and not processed, and if
999: no data existed for Organization, Location, Present Financial Year, then the
1000: Updation of JAI_CMN_RG_BALANCES was going wrong.
1001:
1002: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES
1003: happens only if child records are present and processed. Hence now a record count
1004: is kept of the records processed in the loop and if the record count > 0 only

Line 1002: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES

998: In scenarios where Master Org records is not present and not processed, and if
999: no data existed for Organization, Location, Present Financial Year, then the
1000: Updation of JAI_CMN_RG_BALANCES was going wrong.
1001:
1002: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES
1003: happens only if child records are present and processed. Hence now a record count
1004: is kept of the records processed in the loop and if the record count > 0 only
1005: then the updation of JAI_CMN_RG_BALANCES would happen.
1006:

Line 1005: then the updation of JAI_CMN_RG_BALANCES would happen.

1001:
1002: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES
1003: happens only if child records are present and processed. Hence now a record count
1004: is kept of the records processed in the loop and if the record count > 0 only
1005: then the updation of JAI_CMN_RG_BALANCES would happen.
1006:
1007: 3. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
1008: Master Org Consolidation has been implemented for CESS taxes and any other new
1009: tax types that may be added in future.

Line 1217: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);

1213: CLOSE c_final_balance_pla;
1214:
1215: if v_debug_flag = 'Y' THEN
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1218: end if;
1219:
1220: --This is for Updation of RG Balances table
1221: UPDATE JAI_CMN_RG_BALANCES

Line 1221: UPDATE JAI_CMN_RG_BALANCES

1217: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1218: end if;
1219:
1220: --This is for Updation of RG Balances table
1221: UPDATE JAI_CMN_RG_BALANCES
1222: SET PLA_BALANCE = v_pla_balance
1223: where organization_id=p_organization_id
1224: and location_id =p_location_id;
1225: end if; --end if for v_record_count.