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.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_ACCOUNT_BALANCES

Line 28: ( ledger_id ja_cn_account_balances.ledger_ID%TYPE

24: -- upgrade from 11i to R12 |
25: --+======================================================================*/
26:
27: TYPE cnao_balance_rec IS RECORD
28: ( ledger_id ja_cn_account_balances.ledger_ID%TYPE
29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE
30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE

Line 29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE

25: --+======================================================================*/
26:
27: TYPE cnao_balance_rec IS RECORD
28: ( ledger_id ja_cn_account_balances.ledger_ID%TYPE
29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE
30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE

Line 30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE

26:
27: TYPE cnao_balance_rec IS RECORD
28: ( ledger_id ja_cn_account_balances.ledger_ID%TYPE
29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE
30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE

Line 31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE

27: TYPE cnao_balance_rec IS RECORD
28: ( ledger_id ja_cn_account_balances.ledger_ID%TYPE
29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE
30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE

Line 32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE

28: ( ledger_id ja_cn_account_balances.ledger_ID%TYPE
29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE
30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE

Line 33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE

29: , LEGAL_ENTITY_ID ja_cn_account_balances.LEGAL_ENTITY_ID%TYPE
30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE

Line 34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE

30: , COMPANY_SEGMENT ja_cn_account_balances.COMPANY_SEGMENT%TYPE
31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE

Line 35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE

31: , PERIOD_NAME ja_cn_account_balances.PERIOD_NAME %TYPE
32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE

Line 36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE

32: , CURRENCY_CODE ja_cn_account_balances.CURRENCY_CODE %TYPE
33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE

Line 37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE

33: , COST_CENTER ja_cn_account_balances.COST_CENTER %TYPE
34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE

Line 38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE

34: , THIRD_PARTY_TYPE ja_cn_account_balances.THIRD_PARTY_TYPE %TYPE
35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE

Line 39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE

35: , THIRD_PARTY_ID ja_cn_account_balances.THIRD_PARTY_ID %TYPE
36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE

Line 40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE

36: , THIRD_PARTY_NUMBER ja_cn_account_balances.THIRD_PARTY_NUMBER %TYPE
37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE

Line 41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE

37: , PROJECT_ID ja_cn_account_balances.PROJECT_ID %TYPE
38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE

Line 42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE

38: , PROJECT_NUMBER ja_cn_account_balances.PROJECT_NUMBER %TYPE
39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE

Line 43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE

39: , PROJECT_SOURCE ja_cn_account_balances.PROJECT_SOURCE %TYPE
40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE
47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE

Line 44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE

40: , ACCOUNT_SEGMENT ja_cn_account_balances.ACCOUNT_SEGMENT %TYPE
41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE
47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE
48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE

Line 45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE

41: , ACCOUNT_type ja_cn_account_balances.ACCOUNT_type %TYPE
42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE
47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE
48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE
49: );

Line 46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE

42: , PERSONNEL_ID ja_cn_account_balances.PERSONNEL_ID %TYPE
43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE
47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE
48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE
49: );
50:

Line 47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE

43: , PERSONNEL_NUMBER ja_cn_account_balances.PERSONNEL_NUMBER %TYPE
44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE
47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE
48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE
49: );
50:
51: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_POST_UTILITY_PKG.';

Line 48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE

44: , FUNC_PERIOD_NET_DR ja_cn_account_balances.FUNC_PERIOD_NET_DR %TYPE
45: , FUNC_PERIOD_NET_CR ja_cn_account_balances.FUNC_PERIOD_NET_CR %TYPE
46: , ORIG_PERIOD_NET_DR ja_cn_account_balances.ORIG_PERIOD_NET_DR %TYPE
47: , ORIG_PERIOD_NET_CR ja_cn_account_balances.ORIG_PERIOD_NET_CR %TYPE
48: , PERIOD_MON ja_cn_account_balances.PERIOD_MON %TYPE
49: );
50:
51: G_MODULE_PREFIX VARCHAR2(30):='JA_CN_POST_UTILITY_PKG.';
52: G_PROC_LEVEL INT :=fnd_log.LEVEL_PROCEDURE;

Line 153: l_period_month ja_cn_account_balances.period_mon%TYPE;

149: l_first_fiscal_period_flag CHAR(1);
150: l_prior_period_name gl_periods.period_name%TYPE;
151: l_prior_period_num ja_cn_periods.period_num%TYPE;
152:
153: l_period_month ja_cn_account_balances.period_mon%TYPE;
154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
155:
156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;

Line 156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;

152:
153: l_period_month ja_cn_account_balances.period_mon%TYPE;
154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
155:
156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;
159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;

Line 157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;

153: l_period_month ja_cn_account_balances.period_mon%TYPE;
154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
155:
156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;
159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;

Line 158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;

154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
155:
156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;
159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:

Line 159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;

155:
156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;
159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;

Line 160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;

156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;
159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;

Line 161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;

157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;
159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;

Line 168: l_ret_account_type ja_cn_account_balances.account_type%TYPE;

164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
166: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
167:
168: l_ret_account_type ja_cn_account_balances.account_type%TYPE;
169:
170: l_cost_center_second_tracking BOOLEAN:=FALSE;
171:
172: --get retained earning account segements: company, account, cost center

Line 341: INSERT INTO ja_cn_account_balances(

337: WHERE jjb.ledger_id=p_ledger_id
338: AND jjb.period_num =l_prior_period_num;
339:
340: --transfer prior period end balance the period begin balance
341: INSERT INTO ja_cn_account_balances(
342: ledger_id
343: , legal_entity_id
344: , company_segment
345: , period_name

Line 403: FROM ja_cn_account_balances_v a

399: , SYSDATE
400: , fnd_global.USER_ID
401: , SYSDATE
402: , fnd_global.LOGIN_ID
403: FROM ja_cn_account_balances_v a
404: WHERE a.ledger_id = p_ledger_id
405: AND a.legal_entity_id = p_legal_entity_ID
406: AND a.period_name = l_prior_period_name;
407:

Line 412: UPDATE ja_cn_account_balances jab

408: IF l_first_fiscal_period_flag='Y'
409: --transfer the income and expense account to retained earnings account
410: THEN
411: --set the non-retained earning account balance to zero
412: UPDATE ja_cn_account_balances jab
413: SET func_begin_balance_dr = 0
414: , func_begin_balance_cr = 0
415: , orig_begin_balance_dr = 0
416: , Orig_Begin_Balance_Cr = 0

Line 527: UPDATE ja_cn_account_balances

523: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
524: AND ffv.flex_value = jcc.account_segment;
525:
526: --change the retained earning account balance
527: UPDATE ja_cn_account_balances
528: SET func_begin_balance_dr = l_ret_acct_balance_dr_beq
529: , func_begin_balance_cr = l_ret_acct_balance_cr_beq
530: , orig_begin_balance_dr = l_ret_acct_balance_dr
531: , Orig_Begin_Balance_Cr = l_ret_acct_balance_cr

Line 548: INSERT INTO ja_cn_account_balances(

544:
545: --first period after EBS run
546: IF SQL%ROWCOUNT = 0
547: THEN
548: INSERT INTO ja_cn_account_balances(
549: ledger_id
550: , LEGAL_ENTITY_ID
551: , COMPANY_SEGMENT
552: , PERIOD_NAME

Line 695: UPDATE ja_cn_account_balances

691:
692: --if the period in parameter is the journal's period
693: IF p_current_period_flag='Y'
694: THEN
695: UPDATE ja_cn_account_balances
696: SET FUNC_PERIOD_NET_DR = FUNC_PERIOD_NET_DR + p_balance_rec.FUNC_PERIOD_NET_DR
697: , FUNC_PERIOD_NET_CR = FUNC_PERIOD_NET_CR + p_balance_rec.FUNC_PERIOD_NET_CR
698: , ORIG_PERIOD_NET_DR = ORIG_PERIOD_NET_DR + p_balance_rec.ORIG_PERIOD_NET_DR
699: , ORIG_PERIOD_NET_CR = ORIG_PERIOD_NET_CR + p_balance_rec.ORIG_PERIOD_NET_CR

Line 746: INSERT INTO ja_cn_account_balances(

742: ||':'|| p_balance_rec.PERSONNEL_ID
743: ||':'|| p_balance_rec.PERSONNEL_NUMBER);
744: END IF;
745:
746: INSERT INTO ja_cn_account_balances(
747: ledger_id
748: , LEGAL_ENTITY_ID
749: , COMPANY_SEGMENT
750: , PERIOD_NAME

Line 812: UPDATE ja_cn_account_balances

808: , fnd_global.login_id
809: );
810: END IF; --SQL%ROWCOUNT = 0
811: ELSE --p_current_period_flag='Y'
812: UPDATE ja_cn_account_balances
813: SET FUNC_begin_BALANCE_DR = FUNC_begin_BALANCE_DR + p_balance_rec.FUNC_PERIOD_NET_DR
814: , FUNC_begin_BALANCE_CR = FUNC_begin_BALANCE_cR + p_balance_rec.FUNC_PERIOD_NET_CR
815: , ORIG_begin_BALANCE_DR = FUNC_begin_BALANCE_DR + p_balance_rec.ORIG_PERIOD_NET_DR
816: , ORIG_begin_BALANCE_CR = FUNC_begin_BALANCE_cR + p_balance_rec.ORIG_PERIOD_NET_CR

Line 862: INSERT INTO ja_cn_account_balances(

858: ||':'|| p_balance_rec.PERSONNEL_ID
859: ||':'|| p_balance_rec.PERSONNEL_NUMBER);
860: END IF;
861:
862: INSERT INTO ja_cn_account_balances(
863: ledger_id
864: , LEGAL_ENTITY_ID
865: , COMPANY_SEGMENT
866: , PERIOD_NAME

Line 979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;

975: l_period_year ja_cn_periods.period_year%TYPE;
976: --l_period_name ja_cn_periods.period_name%TYPE;
977:
978: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
980: l_row_count NUMBER;
981: l_cost_center_second_tracking BOOLEAN:=FALSE;
982: l_period_num ja_cn_periods.period_num%TYPE;
983: l_last_period_num ja_cn_periods.period_num%TYPE;

Line 1060: INSERT INTO ja_cn_account_balances_post_gt(

1056:
1057: IF l_cost_center_second_tracking
1058: THEN
1059: --insert all possible retain account into temp table
1060: INSERT INTO ja_cn_account_balances_post_gt(
1061: ledger_id
1062: , LEGAL_ENTITY_ID
1063: , COMPANY_SEGMENT
1064: , PERIOD_NAME

Line 1143: INSERT INTO ja_cn_account_balances_post_gt(

1139: AND nvl(jcc1.project_number,'0') =nvl(jcc.project_number,'0') ) );
1140:
1141: ELSE --l_cost_center_second_tracking = false
1142:
1143: INSERT INTO ja_cn_account_balances_post_gt(
1144: ledger_id
1145: , LEGAL_ENTITY_ID
1146: , COMPANY_SEGMENT
1147: , PERIOD_NAME

Line 1227: UPDATE ja_cn_account_balances_post_gt u

1223:
1224: END IF;--l_cost_center_second_tracking
1225:
1226: --update the period net occurance DR and CR
1227: UPDATE ja_cn_account_balances_post_gt u
1228: SET (FUNC_PERIOD_NET_DR
1229: , FUNC_PERIOD_NET_CR
1230: , ORIG_PERIOD_NET_DR
1231: , ORIG_PERIOD_NET_CR

Line 1238: FROM ja_cn_account_balances

1234: , FUNC_PERIOD_NET_CR
1235: , ORIG_PERIOD_NET_DR
1236: , ORIG_PERIOD_NET_CR
1237: , project_source
1238: FROM ja_cn_account_balances
1239: WHERE ledger_id = p_ledger_id
1240: AND period_name = u.period_name
1241: AND LEGAL_ENTITY_ID = p_legal_entity_ID
1242: AND COMPANY_SEGMENT = u.company_segment

Line 1256: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;

1252: AND PERSONNEL_ID IS NULL
1253: AND PERSONNEL_NUMBER IS NULL
1254: );
1255:
1256: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;
1257:
1258: --update the first priod begin balance in each year
1259: UPDATE ja_cn_account_balances_post_gt u
1260: SET ( FUNC_BEGIN_BALANCE_DR

Line 1259: UPDATE ja_cn_account_balances_post_gt u

1255:
1256: -- INSERT INTO hu_hu SELECT * FROM ja_cn_account_balances_post_gt;
1257:
1258: --update the first priod begin balance in each year
1259: UPDATE ja_cn_account_balances_post_gt u
1260: SET ( FUNC_BEGIN_BALANCE_DR
1261: , FUNC_BEGIN_BALANCE_CR
1262: , ORIG_BEGIN_BALANCE_DR
1263: , ORIG_BEGIN_BALANCE_CR)=

Line 1290: UPDATE ja_cn_account_balances_post_gt u

1286: AND gb.actual_flag = 'A'
1287: )
1288: WHERE period_mon=1;
1289:
1290: UPDATE ja_cn_account_balances_post_gt u
1291: SET FUNC_BEGIN_BALANCE_DR = nvl(FUNC_BEGIN_BALANCE_DR,0)
1292: , FUNC_BEGIN_BALANCE_CR = nvl(FUNC_BEGIN_BALANCE_CR,0)
1293: , ORIG_BEGIN_BALANCE_DR = nvl(ORIG_BEGIN_BALANCE_DR,0)
1294: , ORIG_BEGIN_BALANCE_CR = nvl(ORIG_BEGIN_BALANCE_CR,0)

Line 1307: UPDATE ja_cn_account_balances_post_gt u

1303: FROM ja_cn_periods jcp;
1304:
1305: FOR i IN 2..l_number
1306: LOOP
1307: UPDATE ja_cn_account_balances_post_gt u
1308: SET (FUNC_BEGIN_BALANCE_DR
1309: , FUNC_BEGIN_BALANCE_CR
1310: , ORIG_BEGIN_BALANCE_DR
1311: , ORIG_BEGIN_BALANCE_CR )=

Line 1316: FROM ja_cn_account_balances_post_gt

1312: (SELECT FUNC_BEGIN_BALANCE_DR + FUNC_PERIOD_NET_DR
1313: , FUNC_BEGIN_BALANCE_CR + FUNC_PERIOD_NET_CR
1314: , ORIG_BEGIN_BALANCE_DR + ORIG_PERIOD_NET_DR
1315: , ORIG_BEGIN_BALANCE_CR + ORIG_PERIOD_NET_CR
1316: FROM ja_cn_account_balances_post_gt
1317: WHERE period_num=u.period_num - 1
1318: AND ledger_id = p_ledger_id
1319: AND LEGAL_ENTITY_ID = p_legal_entity_ID
1320: AND COMPANY_SEGMENT = u.company_segment

Line 1337: DELETE ja_cn_account_balances u

1333:
1334: END LOOP;
1335:
1336: -- replace the new balance of retain earning account
1337: DELETE ja_cn_account_balances u
1338: WHERE EXISTS
1339: (SELECT *
1340: FROM ja_cn_account_balances_post_gt t
1341: WHERE t.ledger_id =u.ledger_id

Line 1340: FROM ja_cn_account_balances_post_gt t

1336: -- replace the new balance of retain earning account
1337: DELETE ja_cn_account_balances u
1338: WHERE EXISTS
1339: (SELECT *
1340: FROM ja_cn_account_balances_post_gt t
1341: WHERE t.ledger_id =u.ledger_id
1342: AND t.LEGAL_ENTITY_ID =u.LEGAL_ENTITY_ID
1343: AND t.COMPANY_SEGMENT =u.COMPANY_SEGMENT
1344: AND t.CURRENCY_CODE =u.CURRENCY_CODE

Line 1355: INSERT INTO ja_cn_account_balances(

1351: AND nvl(t.PROJECT_NUMBER ,'0') =nvl(u.PROJECT_NUMBER ,'0')
1352: AND nvl(t.PERSONNEL_ID ,'0') =nvl(u.PERSONNEL_ID ,'0')
1353: AND nvl(t.PERSONNEL_NUMBER ,'0') =nvl(u.PERSONNEL_NUMBER ,'0'));
1354:
1355: INSERT INTO ja_cn_account_balances(
1356: ledger_id
1357: , LEGAL_ENTITY_ID
1358: , COMPANY_SEGMENT
1359: , PERIOD_NAME

Line 1417: FROM ja_cn_account_balances_post_gt;

1413: , SYSDATE
1414: , fnd_global.USER_ID
1415: , SYSDATE
1416: , fnd_global.LOGIN_ID
1417: FROM ja_cn_account_balances_post_gt;
1418:
1419: /* -- delete the old parent account balance
1420: DELETE ja_cn_account_balances jcb
1421: WHERE jcb.ledger_id = p_ledger_id

Line 1420: DELETE ja_cn_account_balances jcb

1416: , fnd_global.LOGIN_ID
1417: FROM ja_cn_account_balances_post_gt;
1418:
1419: /* -- delete the old parent account balance
1420: DELETE ja_cn_account_balances jcb
1421: WHERE jcb.ledger_id = p_ledger_id
1422: AND jcb.legal_entity_id = p_legal_entity_ID
1423: AND EXISTS (SELECT jcp.ledger_id
1424: FROM ja_cn_periods jcp

Line 1435: INSERT INTO ja_cn_account_balances(

1431: AND ffv.summary_flag = 'Y'
1432: );
1433:
1434: -- insert the parent account balance
1435: INSERT INTO ja_cn_account_balances(
1436: ledger_id
1437: , LEGAL_ENTITY_ID
1438: , COMPANY_SEGMENT
1439: , PERIOD_NAME

Line 1517: DELETE ja_cn_account_balances jcb

1513: , gb.period_num
1514: , ffv.COMPILED_VALUE_ATTRIBUTES;*/
1515:
1516: -- delete the old parent account balance
1517: DELETE ja_cn_account_balances jcb
1518: WHERE jcb.ledger_id = p_ledger_id
1519: AND jcb.legal_entity_id = p_legal_entity_ID
1520: AND EXISTS (SELECT jcp.ledger_id
1521: FROM ja_cn_periods jcp

Line 1594: INSERT INTO ja_cn_account_balances(

1590:
1591: DELETE JA_CN_ACCOUNT_CHILDREN_GT WHERE summary_flag = 'Y';
1592:
1593: --insert the parent account balance
1594: INSERT INTO ja_cn_account_balances(
1595: ledger_id
1596: , LEGAL_ENTITY_ID
1597: , COMPANY_SEGMENT
1598: , PERIOD_NAME

Line 1655: FROM ja_cn_account_balances jcb

1651: , SYSDATE
1652: , fnd_global.USER_ID
1653: , SYSDATE
1654: , fnd_global.LOGIN_ID
1655: FROM ja_cn_account_balances jcb
1656: , JA_CN_ACCOUNT_CHILDREN_GT jcc
1657: , ja_cn_periods jcp
1658: WHERE jcc.child_account = jcb.account_segment
1659: AND jcp.ledger_id = p_ledger_id

Line 1672: DELETE ja_cn_account_balances_post_gt;*/

1668: , jcc.parent_type;
1669:
1670:
1671: /* --initiate the working area
1672: DELETE ja_cn_account_balances_post_gt;*/
1673:
1674: --insert all parent account having only non-parent account
1675: /* INSERT INTO ja_cn_account_balances(
1676: ledger_id

Line 1675: /* INSERT INTO ja_cn_account_balances(

1671: /* --initiate the working area
1672: DELETE ja_cn_account_balances_post_gt;*/
1673:
1674: --insert all parent account having only non-parent account
1675: /* INSERT INTO ja_cn_account_balances(
1676: ledger_id
1677: , LEGAL_ENTITY_ID
1678: , COMPANY_SEGMENT
1679: , PERIOD_NAME

Line 1737: , ja_cn_account_balances jca

1733: , fnd_global.USER_ID
1734: , SYSDATE
1735: , fnd_global.LOGIN_ID
1736: FROM ja_cn_periods jcp
1737: , ja_cn_account_balances jca
1738: , FND_FLEX_VALUE_CHILDREN_V ffvc
1739: , fnd_flex_values ffv
1740: WHERE jca.account_segment = ffvc.flex_value*/
1741: