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.XLA_CA_BALANCES_PKG dependencies on XLA_CTRL_BALANCES_INT

Line 175: UPDATE xla_ctrl_balances_int xib SET code_combination_id =

171: --
172: -- Populate code_combination_id based on segments value where CCID is NULL
173: --
174:
175: UPDATE xla_ctrl_balances_int xib SET code_combination_id =
176: (SELECT
177: gcc.code_Combination_id
178: FROM gl_code_combinations gcc
179: ,gl_ledgers gll

Line 247: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL) stmp

243: , NVL (xcb.party_type_code, ' ')
244: ,min(xcb.effective_period_num)
245: from xla_control_balances xcb,
246: (select application_id, ledger_id, code_combination_id, party_id, party_site_id, party_type_code
247: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL) stmp
248: where stmp.application_id = xcb.application_id
249: AND stmp.ledger_id = xcb.ledger_id
250: AND stmp.code_combination_id = xcb.code_combination_id
251: AND stmp.party_id = xcb.party_id

Line 271: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL)

267:
268: update /*+ index(b,xla_control_balances_N99) */ xla_control_balances b set b.initial_balance_flag ='N' where b.initial_balance_flag ='Y'
269: and ( b.application_id , b.ledger_id , b.code_combination_id , b.party_id, NVL (b.party_site_id, -9999) , NVL (b.party_type_code, ' ') )
270: in (select application_id, ledger_id, code_combination_id, party_id , NVL (party_site_id, -9999) , NVL (party_type_code, ' ')
271: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL)
272: and effective_period_num
273: >
274: (select min(effective_period_num) from xla_control_balances xcb
275: where b.application_id = xcb.application_id

Line 308: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL));

304: and gps.period_num > 1
305: and xcb.first_period_flag = 'Y'
306: and (xcb.application_id, xcb.ledger_id, xcb.code_combination_id, xcb.party_id , NVL (xcb.party_site_id, -9999) , NVL (xcb.party_type_code, ' ') )
307: in (select application_id, ledger_id, code_combination_id, party_id, nvl(party_site_id,-9999), nvl(party_type_code,' ')
308: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL));
309:
310:
311: --
312: -- set the fist_period_flag='Y' for rows whose period_num=1

Line 329: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL));

325: and gps.ledger_id = xcb.ledger_id
326: and gps.period_num = 1
327: and (xcb.application_id, xcb.ledger_id, xcb.code_combination_id, xcb.party_id , NVL (xcb.party_site_id, -9999) , NVL (xcb.party_type_code, ' ') )
328: in (select application_id, ledger_id, code_combination_id, party_id, nvl(party_site_id,-9999), nvl(party_type_code,' ')
329: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL));
330:
331: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
332: trace
333: (p_module => l_log_module

Line 356: UPDATE xla_ctrl_balances_int xib

352: --
353: -- Populate existing initial balance (if interface period_name data exists in xla_control_balances for the account group)
354: --
355:
356: UPDATE xla_ctrl_balances_int xib
357: SET(existing_init_balance_dr
358: ,existing_init_balance_cr
359: ,existing_effective_period_num) =
360: (SELECT beginning_balance_dr

Line 393: UPDATE xla_ctrl_balances_int xib

389: -- Get miniMum effective period num existing in xla_control_balances (if initializing row period_name does not exists
390: -- but periods > initializing row period_name exists in xla_control_balance table then get the min of those periods)
391: --
392:
393: UPDATE xla_ctrl_balances_int xib
394: SET existing_effective_period_num =
395: ( SELECT min(glp.effective_period_num) effective_period_num
396: FROM xla_control_balances xcb
397: ,gl_period_statuses glp

Line 431: UPDATE xla_ctrl_balances_int xib

427: -- Populate effective_period_num for new and valid account groups which are not in xla_control_balances
428: --
429:
430:
431: UPDATE xla_ctrl_balances_int xib
432: SET(existing_init_balance_dr
433: ,existing_init_balance_cr
434: ,existing_effective_period_num) =
435: ( SELECT 0,

Line 497: FROM xla_ctrl_balances_int xin

493: ,xin.existing_init_balance_cr
494: ,glp.period_year
495: ,glp.period_num
496: ,glp.effective_period_num
497: FROM xla_ctrl_balances_int xin
498: ,gl_period_statuses glp
499: WHERE xin.ledger_id = glp.set_of_books_id
500: AND xin.period_name = glp.period_name
501: AND glp.application_id = 101

Line 588: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL)

584:
585: update /*+ index(b,xla_control_balances_N99) */ xla_control_balances b set b.initial_balance_flag ='N' where b.initial_balance_flag ='Y'
586: and ( b.application_id , b.ledger_id , b.code_combination_id , b.party_id, NVL (b.party_site_id, -9999) , NVL (b.party_type_code, ' ') )
587: in (select application_id, ledger_id, code_combination_id, party_id , NVL (party_site_id, -9999) , NVL (party_type_code, ' ')
588: from xla_ctrl_balances_int WHERE message_codes IS NULL AND status IS NULL)
589: and effective_period_num
590: >
591: (select min(effective_period_num) from xla_control_balances xcb
592: where b.application_id = xcb.application_id

Line 616: xla_ctrl_balances_int.existing_period_num store the minimum period

612: then initial balance period will be treated as first period) for each
613: set of application_id,ledger_id,code_combination_id,party_type_code,
614: party_id, party_site_id (this combination will refer as party set info)
615:
616: xla_ctrl_balances_int.existing_period_num store the minimum period
617: which exist in xla_control_balance for each party set info
618:
619: In below select statement Decode(xcb.period_year,round(xib.existing_period_num
620: will identify the row whether it belong to same period in which initial balance

Line 632: balance populated in xla_ctrl_balances_int and existing initial balance

628: negative beginning balance in select statement revert the beginning balance
629: in update statement and we are left with only new value
630:
631: Finally the new inital balance is calculated as difference of New initial
632: balance populated in xla_ctrl_balances_int and existing initial balance
633: in xla_control_balance (if any)
634:
635: SIGN function is use to identify whether the net amount is going to be added
636: as Dr or Cr based on differenct of Dr- Cr

Line 710: ,xla_ctrl_balances_int xib

706: ,l_array_period_year
707: ,l_array_new_dr
708: ,l_array_new_cr
709: FROM xla_control_balances xcb
710: ,xla_ctrl_balances_int xib
711: WHERE xib.application_id = xcb.application_id
712: AND xib.ledger_id = xcb.ledger_id
713: AND xib.code_combination_id = xcb.code_combination_id
714: AND xib.party_type_code =xcb.party_type_code

Line 809: FROM xla_ctrl_balances_int xin

805: ,'N' initial_balance_flag
806: ,DECODE(glp1.period_num,1,'Y','N') first_period_flag
807: ,glp1.period_year
808: ,glp1.effective_period_num
809: FROM xla_ctrl_balances_int xin
810: ,gl_period_statuses glp1
811: ,xla_control_balances xcb
812: where
813: xcb.application_id = xin.application_id

Line 866: FROM xla_ctrl_balances_int xib

862: ,l_array_party_type_code
863: ,l_array_party_id
864: ,l_array_party_site_id
865: ,l_array_period_num
866: FROM xla_ctrl_balances_int xib
867: ,xla_control_balances xcb
868: ,gl_period_statuses glp
869: WHERE xib.application_id = xcb.application_id
870: AND xib.ledger_id = xcb.ledger_id

Line 930: UPDATE xla_ctrl_balances_int

926: END IF;
927: --
928: -- Update status of rows in interface table
929: --
930: UPDATE xla_ctrl_balances_int
931: SET status = 'IMPORTED'
932: ,last_update_date = g_date
933: ,last_updated_by = g_user_id
934: ,last_update_login = g_login_id

Line 983: UPDATE xla_ctrl_balances_int xin

979: --
980: -- Updating the invalid rows in interface table
981: --
982:
983: UPDATE xla_ctrl_balances_int xin
984: SET message_codes =
985: ( SELECT NVL2(IB001,IB001||',',NULL)||
986: NVL2(IB002,IB002||',',NULL)||
987: NVL2(IB003,IB003||',',NULL)||

Line 1048: FROM xla_ctrl_balances_int xib

1044: ,DECODE(glp.period_num,1,NULL,'IB024') IB024
1045: ,DECODE(glp.closing_status,'C',NULL,'P',NULL,'IB025') IB025
1046: ,DECODE(glp.adjustment_period_flag ,'Y','IB026',NULL) IB026
1047: ,DECODE(glp.period_num,1,decode(glp2.period_num,1,decode(sign(glp.effective_period_num-xlp.min_effect_period_num),0,NULL,'IB027'),NULL),NULL) IB027
1048: FROM xla_ctrl_balances_int xib
1049: ,xla_subledgers xls
1050: ,gl_ledgers gll
1051: ,gl_ledger_relationships glr
1052: ,gl_code_combinations gcc

Line 1086: ,xla_ctrl_balances_int xib

1082: ,MIN(glp.effective_period_num) effective_period_num
1083: FROM xla_ae_headers xah
1084: ,xla_ae_lines xal
1085: ,gl_period_statuses glp
1086: ,xla_ctrl_balances_int xib
1087: WHERE xah.application_id = xal.application_id
1088: AND xah.ae_header_id = xal.ae_header_id
1089: AND glp.period_name = xah.period_name
1090: AND glp.application_id = 101

Line 1114: ,xla_ctrl_balances_int xib

1110: ,xcb.party_id
1111: ,xcb.party_site_id
1112: ,MIN(xcb.effective_period_num) effective_period_num
1113: FROM xla_control_balances xcb
1114: ,xla_ctrl_balances_int xib
1115: WHERE xcb.application_id = xib.application_id
1116: AND xcb.ledger_id = xib.ledger_id
1117: AND xcb.code_combination_id = xib.code_combination_id
1118: AND xcb.party_type_code = xib.party_type_code

Line 1175: UPDATE xla_ctrl_balances_int

1171: --
1172: -- Marking error for multiple Initial balances of same third party information
1173: --
1174:
1175: UPDATE xla_ctrl_balances_int
1176: SET message_codes = message_codes||'IB022'
1177: WHERE(application_id ,ledger_id ,code_combination_id ,party_type_code ,party_id ,nvl(party_site_id,-999))
1178: IN (SELECT application_id ,ledger_id ,code_combination_id ,party_type_code ,party_id ,nvl(party_site_id,-999)
1179: FROM xla_ctrl_balances_int

Line 1179: FROM xla_ctrl_balances_int

1175: UPDATE xla_ctrl_balances_int
1176: SET message_codes = message_codes||'IB022'
1177: WHERE(application_id ,ledger_id ,code_combination_id ,party_type_code ,party_id ,nvl(party_site_id,-999))
1178: IN (SELECT application_id ,ledger_id ,code_combination_id ,party_type_code ,party_id ,nvl(party_site_id,-999)
1179: FROM xla_ctrl_balances_int
1180: WHERE nvl(status, ' ') <> 'IMPORTED'
1181: GROUP BY application_id
1182: ,ledger_id
1183: ,code_combination_id

Line 1201: UPDATE xla_ctrl_balances_int

1197:
1198: --
1199: -- Marking Error status
1200: --
1201: UPDATE xla_ctrl_balances_int
1202: SET status = 'ERROR'
1203: ,last_update_date =g_date
1204: ,last_updated_by = g_user_id
1205: ,last_update_login = g_login_id

Line 1247: DELETE FROM xla_ctrl_balances_int

1243: -- Logic for puging data from Interface table
1244: --
1245: CASE
1246: WHEN p_purge_option = 'S' THEN
1247: DELETE FROM xla_ctrl_balances_int
1248: WHERE message_codes IS NULL
1249: AND nvl(status,' ') = 'IMPORTED';
1250: WHEN p_purge_option = 'A' THEN
1251:

Line 1252: DELETE FROM xla_ctrl_balances_int;

1248: WHERE message_codes IS NULL
1249: AND nvl(status,' ') = 'IMPORTED';
1250: WHEN p_purge_option = 'A' THEN
1251:
1252: DELETE FROM xla_ctrl_balances_int;
1253:
1254: ELSE
1255: NULL;
1256: END CASE;