APPS.JA_CN_VOUCHER_NUM_MIG_PKG dependencies on JA_CN_VOUCHER_NUMBER

Line 93: FROM ja_cn_voucher_number jcvn

89: AND jclllbg.Ledger_Id = pn_ledger_id
90: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
91: AND NOT EXISTS
92: (SELECT je_header_id, je_line_number
93: FROM ja_cn_voucher_number jcvn
94: WHERE gjh.je_header_id = jcvn.je_header_id
95: AND jcjl.je_line_num = jcvn.je_line_number
96: AND jcvn.ledger_id = pn_ledger_id
97: AND jcvn.legal_entity_id = pn_legal_entity_id

Line 120: FROM ja_cn_voucher_number jcvn

116: --AND jcjl.status = 'P'
117: AND gjh.period_name = pv_period_name
118: AND NOT EXISTS
119: (SELECT je_header_id, je_line_number
120: FROM ja_cn_voucher_number jcvn
121: WHERE gjh.je_header_id = jcvn.je_header_id
122: AND jcjl.je_line_num = jcvn.je_line_number
123: AND jcvn.ledger_id = pn_ledger_id
124: AND jcvn.legal_entity_id = pn_legal_entity_id

Line 162: FROM ja_cn_voucher_number jcvn

158: AND jclllbg.Ledger_Id = pn_ledger_id
159: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
160: AND NOT EXISTS
161: (SELECT je_header_id, je_line_number
162: FROM ja_cn_voucher_number jcvn
163: WHERE gjh.je_header_id = jcvn.je_header_id
164: AND jcjl.je_line_num = jcvn.je_line_number
165: AND jcvn.ledger_id = pn_ledger_id
166: AND jcvn.legal_entity_id = pn_legal_entity_id

Line 178: FROM ja_cn_voucher_number jcvn

174: --AND jcjl.status = 'P'
175: AND gjh.period_name = pv_period_name
176: AND NOT EXISTS
177: (SELECT je_header_id, je_line_number
178: FROM ja_cn_voucher_number jcvn
179: WHERE gjh.je_header_id = jcvn.je_header_id
180: AND jcjl.je_line_num = jcvn.je_line_number
181: AND jcvn.ledger_id = pn_ledger_id
182: AND jcvn.legal_entity_id = pn_legal_entity_id

Line 196: DELETE FROM ja_cn_voucher_number

192: WHERE ledger_id = pn_ledger_id;
193: -- BSV is assigned, only the parameter legal entity will be handled.
194: IF (ln_bsv_assigned_num > 0) THEN
195: IF (ln_bsv_mig_num > 0) THEN
196: DELETE FROM ja_cn_voucher_number
197: WHERE ledger_id = pn_ledger_id
198: AND legal_entity_id = pn_legal_entity_id
199: AND period_name = pv_period_name
200: AND (data_source_tag <> 'M' OR data_source_tag is null);

Line 203: INSERT INTO ja_cn_voucher_number

199: AND period_name = pv_period_name
200: AND (data_source_tag <> 'M' OR data_source_tag is null);
201:
202: FOR v_row IN voucher_cur LOOP
203: INSERT INTO ja_cn_voucher_number
204: (ledger_id,
205: legal_entity_id,
206: period_name,
207: je_header_id,

Line 235: DELETE FROM ja_cn_voucher_number

231: END LOOP; -- FOR v_row IN voucher_cur
232: END IF;
233: ELSE
234: IF (ln_no_bsv_mig_num > 0) THEN
235: DELETE FROM ja_cn_voucher_number
236: WHERE ledger_id = pn_ledger_id
237: AND period_name = pv_period_name
238: AND (data_source_tag <> 'M' OR data_source_tag is null);
239:

Line 242: INSERT INTO ja_cn_voucher_number

238: AND (data_source_tag <> 'M' OR data_source_tag is null);
239:
240: FOR v_row IN voucher_no_bsv_cur LOOP
241: FOR v_row1 IN bsv_legal_entity_cur LOOP
242: INSERT INTO ja_cn_voucher_number
243: (ledger_id,
244: legal_entity_id,
245: period_name,
246: je_header_id,

Line 439: SELECT COUNT(VOUCHER_NUMBER), --JA_CN_VOUCHER_NUMBER_HAS_DATA

435:
436: Migrate_voucher_num_periods(pn_ledger_id => P_LEDGER_ID,
437: pn_legal_entity_id => P_LEGAL_ENTITY_ID);
438: FOR v_row IN periods_cur LOOP
439: SELECT COUNT(VOUCHER_NUMBER), --JA_CN_VOUCHER_NUMBER_HAS_DATA
440: MAX(VOUCHER_NUMBER),
441: MIN(VOUCHER_NUMBER)
442: INTO JOURNAL_AMOUNT, VOUCHER_NUMBER_TO, VOUCHER_NUMBER_FROM
443: FROM (SELECT DISTINCT VOUCHER_NUMBER

Line 444: FROM JA_CN_VOUCHER_NUMBER

440: MAX(VOUCHER_NUMBER),
441: MIN(VOUCHER_NUMBER)
442: INTO JOURNAL_AMOUNT, VOUCHER_NUMBER_TO, VOUCHER_NUMBER_FROM
443: FROM (SELECT DISTINCT VOUCHER_NUMBER
444: FROM JA_CN_VOUCHER_NUMBER
445: WHERE PERIOD_NAME = v_row.period_name
446: AND REQUEST_ID = fnd_global.CONC_REQUEST_ID);
447: IF (JOURNAL_AMOUNT <> 0) THEN
448: Fnd_Message.Set_Name(Application => 'JA',