[Home] [Help]
209: p_validation_type IN VARCHAR2,
210: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Contract ID
211: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
212: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
213: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
214: p_actual_flag IN VARCHAR2,
215: p_result_code OUT NOCOPY VARCHAR2
216: ) IS
217:
224: GCC.enabled_flag,
225: GCC.start_date_active,
226: GCC.end_date_active
227: FROM gl_code_combinations GCC,
228: gl_sets_of_books GSB
229: WHERE GCC.code_combination_id = p_ccid
230: AND GSB.set_of_books_id = p_set_of_books_id
231: AND GCC.chart_of_accounts_id = GSB.chart_of_accounts_id;
232:
481: p_msg_count OUT NOCOPY NUMBER,
482: p_msg_data OUT NOCOPY VARCHAR2,
483:
484: p_efc_enabled IN VARCHAR2,
485: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
486: p_actual_flag IN VARCHAR2,
487: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,
488: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
489: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
982: p_return_status OUT NOCOPY VARCHAR2,
983: p_msg_count OUT NOCOPY NUMBER,
984: p_msg_data OUT NOCOPY VARCHAR2,
985:
986: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
987: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,
988: p_check_type IN VARCHAR2,
989: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
990: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
1012: GPS.period_num,
1013: GPS.period_year,
1014: GPS.quarter_num
1015: FROM gl_period_statuses GPS,
1016: gl_sets_of_books GP
1017: WHERE GPS.set_of_books_id = p_sob_id
1018: AND GPS.application_id = l_gl_application_id
1019: AND GPS.adjustment_period_flag = 'N'
1020: AND GP.set_of_books_id = GPS.set_of_books_id
1034: GPS.period_num,
1035: GPS.period_year,
1036: GPS.quarter_num
1037: FROM gl_period_statuses GPS,
1038: gl_sets_of_books GP
1039: WHERE GPS.set_of_books_id = p_sob_id
1040: AND GPS.application_id = l_gl_application_id
1041: AND GPS.adjustment_period_flag = 'N'
1042: AND GP.set_of_books_id = GPS.set_of_books_id
1264: p_return_status OUT NOCOPY VARCHAR2,
1265: p_msg_count OUT NOCOPY NUMBER,
1266: p_msg_data OUT NOCOPY VARCHAR2,
1267:
1268: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
1269: p_efc_enabled OUT NOCOPY VARCHAR2
1270: ) IS
1271:
1272: -- --------------------------------------------------------------------
1481: p_return_status OUT NOCOPY VARCHAR2,
1482: p_msg_count OUT NOCOPY NUMBER,
1483: p_msg_data OUT NOCOPY VARCHAR2,
1484:
1485: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
1486: p_cbc_enabled IN VARCHAR2,
1487: p_cc_head_id IN igc_cbc_je_batches.cc_header_id%TYPE,
1488: p_actl_flag IN VARCHAR2,
1489: p_documt_type IN igc_cc_interface.document_type%TYPE,