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.IGC_CBC_VALIDATIONS_PKG dependencies on IGC_CBC_JE_LINES

Line 170: | IGC_CBC_JE_LINES. |

166: | |
167: | Note : This procedure is designed to validate the CCID that is given |
168: | based upon the rules defined for the CCID to be entered into |
169: | the CBC Funds Checker process and inserted into the table |
170: | IGC_CBC_JE_LINES. |
171: | |
172: | If there is to be any changes inside of this procedure then |
173: | there needs to be analysis performed on the effect it will have|
174: | on the Funds Checker process. |

Line 210: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Contract ID

206: p_msg_count OUT NOCOPY NUMBER,
207: p_msg_data OUT NOCOPY VARCHAR2,
208:
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,

Line 211: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date

207: p_msg_data OUT NOCOPY VARCHAR2,
208:
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

Line 212: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,

208:
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

Line 242: l_period_name igc_cbc_je_lines.period_name%TYPE;

238: l_enabled_flag gl_code_combinations.enabled_flag%TYPE;
239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;
245: l_period_num igc_cbc_je_lines.period_num%TYPE;
246: l_period_year igc_cbc_je_lines.period_year%TYPE;

Line 243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;

239: l_start_date gl_code_combinations.start_date_active%TYPE;
240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;
245: l_period_num igc_cbc_je_lines.period_num%TYPE;
246: l_period_year igc_cbc_je_lines.period_year%TYPE;
247: l_msg_count NUMBER;

Line 244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;

240: l_end_date gl_code_combinations.end_date_active%TYPE;
241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;
245: l_period_num igc_cbc_je_lines.period_num%TYPE;
246: l_period_year igc_cbc_je_lines.period_year%TYPE;
247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2(2000);

Line 245: l_period_num igc_cbc_je_lines.period_num%TYPE;

241: l_closing_status gl_period_statuses.closing_status%TYPE;
242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;
245: l_period_num igc_cbc_je_lines.period_num%TYPE;
246: l_period_year igc_cbc_je_lines.period_year%TYPE;
247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2(2000);
249: l_Return_Status VARCHAR2(1);

Line 246: l_period_year igc_cbc_je_lines.period_year%TYPE;

242: l_period_name igc_cbc_je_lines.period_name%TYPE;
243: l_period_set_name igc_cbc_je_lines.period_set_name%TYPE;
244: l_quarter_num igc_cbc_je_lines.quarter_num%TYPE;
245: l_period_num igc_cbc_je_lines.period_num%TYPE;
246: l_period_year igc_cbc_je_lines.period_year%TYPE;
247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2(2000);
249: l_Return_Status VARCHAR2(1);
250: l_validation_error BOOLEAN := FALSE;

Line 441: | the table IGC_CBC_JE_LINES. |

437: | |
438: | Note : This procedure is designed to validate the CCID Budget Version |
439: | information based upon the rules defined for the CCID to be |
440: | entered into the CBC Funds Checker process and inserted into |
441: | the table IGC_CBC_JE_LINES. |
442: | |
443: | If there is to be any changes inside of this procedure then |
444: | there needs to be analysis performed on the effect it will have|
445: | on the Funds Checker process. |

Line 487: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,

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,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,

Line 488: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,

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,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,

Line 489: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,

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,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,

Line 490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date

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,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
494: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE

Line 491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,

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,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
494: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
495: ) IS

Line 492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_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,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
494: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
495: ) IS
496:

Line 493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,

489: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
494: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
495: ) IS
496:
497: -- -------------------------------------------------------------------------

Line 494: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE

490: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
491: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
492: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
493: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
494: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
495: ) IS
496:
497: -- -------------------------------------------------------------------------
498: -- Declare local variables used within fuction

Line 500: l_budget_ver_id igc_cbc_je_lines.budget_version_id%TYPE;

496:
497: -- -------------------------------------------------------------------------
498: -- Declare local variables used within fuction
499: -- -------------------------------------------------------------------------
500: l_budget_ver_id igc_cbc_je_lines.budget_version_id%TYPE;
501: l_amount_type igc_cbc_je_lines.amount_type%TYPE;
502: l_funds_level_code igc_cbc_je_lines.funds_check_level_code%TYPE;
503: l_cbc_override igc_cbc_je_lines.funds_check_level_code%TYPE;
504:

Line 501: l_amount_type igc_cbc_je_lines.amount_type%TYPE;

497: -- -------------------------------------------------------------------------
498: -- Declare local variables used within fuction
499: -- -------------------------------------------------------------------------
500: l_budget_ver_id igc_cbc_je_lines.budget_version_id%TYPE;
501: l_amount_type igc_cbc_je_lines.amount_type%TYPE;
502: l_funds_level_code igc_cbc_je_lines.funds_check_level_code%TYPE;
503: l_cbc_override igc_cbc_je_lines.funds_check_level_code%TYPE;
504:
505: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Get_CCID_Budget_Info';

Line 502: l_funds_level_code igc_cbc_je_lines.funds_check_level_code%TYPE;

498: -- Declare local variables used within fuction
499: -- -------------------------------------------------------------------------
500: l_budget_ver_id igc_cbc_je_lines.budget_version_id%TYPE;
501: l_amount_type igc_cbc_je_lines.amount_type%TYPE;
502: l_funds_level_code igc_cbc_je_lines.funds_check_level_code%TYPE;
503: l_cbc_override igc_cbc_je_lines.funds_check_level_code%TYPE;
504:
505: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Get_CCID_Budget_Info';
506: l_api_version CONSTANT NUMBER := 1.0;

Line 503: l_cbc_override igc_cbc_je_lines.funds_check_level_code%TYPE;

499: -- -------------------------------------------------------------------------
500: l_budget_ver_id igc_cbc_je_lines.budget_version_id%TYPE;
501: l_amount_type igc_cbc_je_lines.amount_type%TYPE;
502: l_funds_level_code igc_cbc_je_lines.funds_check_level_code%TYPE;
503: l_cbc_override igc_cbc_je_lines.funds_check_level_code%TYPE;
504:
505: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Get_CCID_Budget_Info';
506: l_api_version CONSTANT NUMBER := 1.0;
507: l_gl_application_id fnd_application.application_id%TYPE;

Line 945: | the table IGC_CBC_JE_LINES. |

941: | |
942: | Note : This procedure is designed to validate the CCID Period Name |
943: | information based upon the rules defined for the CCID to be |
944: | entered into the CBC Funds Checker process and inserted into |
945: | the table IGC_CBC_JE_LINES. |
946: | |
947: | If there is to be any changes inside of this procedure then |
948: | there needs to be analysis performed on the effect it will have|
949: | on the Funds Checker process. |

Line 987: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,

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,
991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,

Line 989: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,

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,
991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
992: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
993: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,

Line 990: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,

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,
991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
992: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
993: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
994: p_result_status OUT NOCOPY VARCHAR2

Line 991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%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,
991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
992: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
993: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
994: p_result_status OUT NOCOPY VARCHAR2
995: ) IS

Line 992: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%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,
991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
992: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
993: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
994: p_result_status OUT NOCOPY VARCHAR2
995: ) IS
996:

Line 993: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,

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,
991: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
992: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
993: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
994: p_result_status OUT NOCOPY VARCHAR2
995: ) IS
996:
997: -- -------------------------------------------------------------------------

Line 1234: | the table IGC_CBC_JE_LINES. |

1230: | |
1231: | Note : This procedure is designed to validate the CCID Period Name |
1232: | information based upon the rules defined for the CCID to be |
1233: | entered into the CBC Funds Checker process and inserted into |
1234: | the table IGC_CBC_JE_LINES. |
1235: | |
1236: | If there is to be any changes inside of this procedure then |
1237: | there needs to be analysis performed on the effect it will have|
1238: | on the Funds Checker process. |

Line 1444: | the table IGC_CBC_JE_LINES. |

1440: | |
1441: | Note : This procedure is designed to validate the CC Interface table |
1442: | information based upon the rules defined for the CCID to be |
1443: | entered into the CBC Funds Checker process and inserted into |
1444: | the table IGC_CBC_JE_LINES. |
1445: | |
1446: | If there is to be any changes inside of this procedure then |
1447: | there needs to be analysis performed on the effect it will have|
1448: | on the Funds Checker process. |

Line 1490: -- p_sum_line_num OUT NOCOPY igc_cbc_je_lines.cbc_je_line_num%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,
1490: -- p_sum_line_num OUT NOCOPY igc_cbc_je_lines.cbc_je_line_num%TYPE,
1491: p_cbc_flag OUT NOCOPY VARCHAR2,
1492: p_sbc_flag OUT NOCOPY VARCHAR2
1493: -- p_packet_id IN NUMBER
1494: ) IS