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 608: 6. Updation of JAI_CMN_RG_BALANCES is done for Master Organization/Location.

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

Line 829: UPDATE JAI_CMN_RG_BALANCES

825: if v_debug_flag = 'Y' THEN
826: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);
827: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);
828: end if;
829: UPDATE JAI_CMN_RG_BALANCES
830: SET RG23A_BALANCE = v_rg23a_final_balance, RG23C_BALANCE=v_rg23c_final_balance
831: where organization_id=p_organization_id
832: and location_id =p_location_id;
833: --Ends here.....

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

958: 3. opening_balance_cur has been commented with a condition And nvl(master_flag,'N') = 'Y';
959: 4. A new cursor is added to fetch the Active Financial Year(c_fetch_fin_active_year).
960: 5. A new Cusor is added to fetch the Closing Balance of RG23A and RG23C Registers
961: (c_final_balance_pla)
962: 6. Updation of JAI_CMN_RG_BALANCES.pla_balance is done for Master Organization/Location.
963:
964:
965: 2. 2003/12/30 Nagaraj.s for Bug#3335814. Version - 618.1
966:

Line 969: Updation of JAI_CMN_RG_BALANCES was going wrong.

965: 2. 2003/12/30 Nagaraj.s for Bug#3335814. Version - 618.1
966:
967: In scenarios where Master Org records is not present and not processed, and if
968: no data existed for Organization, Location, Present Financial Year, then the
969: Updation of JAI_CMN_RG_BALANCES was going wrong.
970:
971: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES
972: happens only if child records are present and processed. Hence now a record count
973: is kept of the records processed in the loop and if the record count > 0 only

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

967: In scenarios where Master Org records is not present and not processed, and if
968: no data existed for Organization, Location, Present Financial Year, then the
969: Updation of JAI_CMN_RG_BALANCES was going wrong.
970:
971: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES
972: happens only if child records are present and processed. Hence now a record count
973: is kept of the records processed in the loop and if the record count > 0 only
974: then the updation of JAI_CMN_RG_BALANCES would happen.
975:

Line 974: then the updation of JAI_CMN_RG_BALANCES would happen.

970:
971: This has been rectified by ensuring that the updation of JAI_CMN_RG_BALANCES
972: happens only if child records are present and processed. Hence now a record count
973: is kept of the records processed in the loop and if the record count > 0 only
974: then the updation of JAI_CMN_RG_BALANCES would happen.
975:
976: 3. 2005/01/07 Harshita.J - For Bug #410667 Version - 115.0
977: Master Org Consolidation has been implemented for CESS taxes and any other new
978: tax types that may be added in future.

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

1182: CLOSE c_final_balance_pla;
1183:
1184: if v_debug_flag = 'Y' THEN
1185: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1187: end if;
1188:
1189: --This is for Updation of RG Balances table
1190: UPDATE JAI_CMN_RG_BALANCES

Line 1190: UPDATE JAI_CMN_RG_BALANCES

1186: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1187: end if;
1188:
1189: --This is for Updation of RG Balances table
1190: UPDATE JAI_CMN_RG_BALANCES
1191: SET PLA_BALANCE = v_pla_balance
1192: where organization_id=p_organization_id
1193: and location_id =p_location_id;
1194: end if; --end if for v_record_count.