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 10: | IGC_CBC_JE_LINES. |

6: | |
7: | Note : This procedure is designed to validate the CCID that is given |
8: | based upon the rules defined for the CCID to be entered into |
9: | the CBC Funds Checker process and inserted into the table |
10: | IGC_CBC_JE_LINES. |
11: | |
12: | If there is to be any changes inside of this procedure then |
13: | there needs to be analysis performed on the effect it will have|
14: | on the Funds Checker process. |

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

46: p_msg_count OUT NOCOPY NUMBER,
47: p_msg_data OUT NOCOPY VARCHAR2,
48:
49: p_validation_type IN VARCHAR2,
50: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Contract ID
51: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
52: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
53: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
54: p_actual_flag IN VARCHAR2,

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

47: p_msg_data OUT NOCOPY VARCHAR2,
48:
49: p_validation_type IN VARCHAR2,
50: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Contract ID
51: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
52: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
53: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
54: p_actual_flag IN VARCHAR2,
55: p_result_code OUT NOCOPY VARCHAR2

Line 52: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,

48:
49: p_validation_type IN VARCHAR2,
50: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE, -- Contract ID
51: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
52: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
53: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
54: p_actual_flag IN VARCHAR2,
55: p_result_code OUT NOCOPY VARCHAR2
56: );

Line 65: | the table IGC_CBC_JE_LINES. |

61: | |
62: | Note : This procedure is designed to validate the CCID Budget Version |
63: | information based upon the rules defined for the CCID to be |
64: | entered into the CBC Funds Checker process and inserted into |
65: | the table IGC_CBC_JE_LINES. |
66: | |
67: | If there is to be any changes inside of this procedure then |
68: | there needs to be analysis performed on the effect it will have|
69: | on the Funds Checker process. |

Line 111: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,

107:
108: p_efc_enabled IN VARCHAR2,
109: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
110: p_actual_flag IN VARCHAR2,
111: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,
112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,

Line 112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,

108: p_efc_enabled IN VARCHAR2,
109: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
110: p_actual_flag IN VARCHAR2,
111: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,
112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,

Line 113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,

109: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
110: p_actual_flag IN VARCHAR2,
111: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,
112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
117: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,

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

110: p_actual_flag IN VARCHAR2,
111: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,
112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
117: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
118: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE

Line 115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,

111: p_ccid IN igc_cbc_je_lines.code_combination_id%TYPE,
112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
117: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
118: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
119: );

Line 116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,

112: p_det_sum_value IN igc_cbc_je_lines.detail_summary_code%TYPE,
113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
117: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
118: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
119: );
120:

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

113: p_currency_code IN igc_cbc_je_lines.currency_code%TYPE,
114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
117: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
118: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
119: );
120:
121:

Line 118: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE

114: p_effective_date IN igc_cbc_je_lines.effective_date%TYPE, -- Transaction Date
115: p_budget_ver_id IN igc_cbc_je_lines.budget_version_id%TYPE,
116: p_out_budget_ver_id OUT NOCOPY igc_cbc_je_lines.budget_version_id%TYPE,
117: p_amount_type OUT NOCOPY igc_cbc_je_lines.amount_type%TYPE,
118: p_funds_level_code OUT NOCOPY igc_cbc_je_lines.funds_check_level_code%TYPE
119: );
120:
121:
122: /*=======================================================================+

Line 128: | the table IGC_CBC_JE_LINES. |

124: | |
125: | Note : This procedure is designed to validate the CCID Period Name |
126: | information based upon the rules defined for the CCID to be |
127: | entered into the CBC Funds Checker process and inserted into |
128: | the table IGC_CBC_JE_LINES. |
129: | |
130: | If there is to be any changes inside of this procedure then |
131: | there needs to be analysis performed on the effect it will have|
132: | on the Funds Checker process. |

Line 170: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,

166: p_msg_count OUT NOCOPY NUMBER,
167: p_msg_data OUT NOCOPY VARCHAR2,
168:
169: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
170: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,
171: p_check_type IN VARCHAR2,
172: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
173: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,

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

168:
169: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
170: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,
171: p_check_type IN VARCHAR2,
172: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
173: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
175: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
176: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,

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

169: p_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
170: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,
171: p_check_type IN VARCHAR2,
172: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
173: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
175: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
176: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
177: p_result_status OUT NOCOPY VARCHAR2

Line 174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,

170: p_effect_date IN igc_cbc_je_lines.effective_date%TYPE,
171: p_check_type IN VARCHAR2,
172: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
173: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
175: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
176: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
177: p_result_status OUT NOCOPY VARCHAR2
178: );

Line 175: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,

171: p_check_type IN VARCHAR2,
172: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
173: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
175: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
176: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
177: p_result_status OUT NOCOPY VARCHAR2
178: );
179:

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

172: p_period_name OUT NOCOPY igc_cbc_je_lines.period_name%TYPE,
173: p_period_set_name OUT NOCOPY igc_cbc_je_lines.period_set_name%TYPE,
174: p_quarter_num OUT NOCOPY igc_cbc_je_lines.quarter_num%TYPE,
175: p_period_num OUT NOCOPY igc_cbc_je_lines.period_num%TYPE,
176: p_period_year OUT NOCOPY igc_cbc_je_lines.period_year%TYPE,
177: p_result_status OUT NOCOPY VARCHAR2
178: );
179:
180:

Line 187: | the table IGC_CBC_JE_LINES. |

183: | |
184: | Note : This procedure is designed to validate the CCID Period Name |
185: | information based upon the rules defined for the CCID to be |
186: | entered into the CBC Funds Checker process and inserted into |
187: | the table IGC_CBC_JE_LINES. |
188: | |
189: | If there is to be any changes inside of this procedure then |
190: | there needs to be analysis performed on the effect it will have|
191: | on the Funds Checker process. |

Line 232: | the table IGC_CBC_JE_LINES. |

228: | |
229: | Note : This procedure is designed to validate the CC Interface table |
230: | information based upon the rules defined for the CCID to be |
231: | entered into the CBC Funds Checker process and inserted into |
232: | the table IGC_CBC_JE_LINES. |
233: | |
234: | If there is to be any changes inside of this procedure then |
235: | there needs to be analysis performed on the effect it will have|
236: | on the Funds Checker process. |

Line 281: -- p_sum_line_num OUT NOCOPY igc_cbc_je_lines.cbc_je_line_num%TYPE,

277: p_cc_head_id IN igc_cbc_je_batches.cc_header_id%TYPE,
278: p_actl_flag IN VARCHAR2,
279: p_documt_type IN igc_cc_interface.document_type%TYPE,
280: /*Bug No : 6341012. R12 SLA uptake*/
281: -- p_sum_line_num OUT NOCOPY igc_cbc_je_lines.cbc_je_line_num%TYPE,
282: p_cbc_flag OUT NOCOPY VARCHAR2,
283: p_sbc_flag OUT NOCOPY VARCHAR2
284: -- p_packet_id IN NUMBER DEFAULT NULL
285: );