87: l_accounting_line_type_code VARCHAR2(1) := p_accounting_line_type_code;
88:
89: BEGIN
90:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
89: BEGIN
90:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
90:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
99: xla_conditions_pkg.delete_condition
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
99: xla_conditions_pkg.delete_condition
100: (p_context => 'A'
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
99: xla_conditions_pkg.delete_condition
100: (p_context => 'A'
101: ,p_application_id => l_application_id
112: AND event_class_code = p_event_class_code
113: AND accounting_line_type_code = p_accounting_line_type_code
114: AND accounting_line_code = p_accounting_line_code;
115:
116: xla_utility_pkg.trace('< xla_line_types_pkg.delete_line_type_details' , 10);
117:
118: EXCEPTION
119: WHEN xla_exceptions_pkg.application_exception THEN
120: RAISE;
208: AND source_code = l_condition.value_source_code;
209:
210: BEGIN
211:
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
210: BEGIN
211:
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
211:
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
222:
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
222:
223: OPEN c_conditions;
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
222:
223: OPEN c_conditions;
224: LOOP
389: ,l_last_update_login);
390: END LOOP;
391: CLOSE c_acct_sources;
392:
393: xla_utility_pkg.trace('< xla_line_types_pkg.copy_line_type_details' , 10);
394:
395: EXCEPTION
396: WHEN xla_exceptions_pkg.application_exception THEN
397: IF c_conditions%ISOPEN THEN
496: l_mpa_active_assignment_exist c_mpa_active_assignment_exist%rowtype;
497:
498: BEGIN
499:
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
498: BEGIN
499:
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
499:
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
509: IF p_event in ('DELETE','UPDATE') THEN
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
509: IF p_event in ('DELETE','UPDATE') THEN
510: OPEN c_assignment_exist;
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
509: IF p_event in ('DELETE','UPDATE') THEN
510: OPEN c_assignment_exist;
511: FETCH c_assignment_exist
595: ,'LOCATION' ,'xla_line_types_pkg.line_type_in_use');
596:
597: END IF;
598:
599: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_in_use' , 10);
600:
601: return l_return;
602:
603: EXCEPTION
662: l_accounting_line_type_code VARCHAR2(1) := p_accounting_line_type_code;
663:
664: BEGIN
665:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
664: BEGIN
665:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
665:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
674: --
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
674: --
675: -- check if condition is invalid
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
674: --
675: -- check if condition is invalid
676: --
712: l_return := FALSE;
713: END IF;
714: END IF;
715:
716: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
717: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_invalid' , 10);
718:
719: return l_return;
720:
713: END IF;
714: END IF;
715:
716: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
717: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_invalid' , 10);
718:
719: return l_return;
720:
721: EXCEPTION
778: AND a.line_definition_code = s.line_definition_code);
779:
780: BEGIN
781:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
780: BEGIN
781:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
781:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
790: OPEN c_frozen_assignment_exist;
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
790: OPEN c_frozen_assignment_exist;
791: FETCH c_frozen_assignment_exist
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
790: OPEN c_frozen_assignment_exist;
791: FETCH c_frozen_assignment_exist
792: INTO l_exist;
796: l_return := FALSE;
797: END IF;
798: CLOSE c_frozen_assignment_exist;
799:
800: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_locked' , 10);
801:
802: return l_return;
803:
804: EXCEPTION
832: ,p_accounting_line_type_code IN VARCHAR2
833: ,p_accounting_line_code IN VARCHAR2)
834: IS
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
833: ,p_accounting_line_code IN VARCHAR2)
834: IS
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
834: IS
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs
843: WHERE application_id = p_application_id
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs
843: WHERE application_id = p_application_id
844: AND amb_context_code = p_amb_context_code
851: ,'EXCHANGE_RATE_TYPE'
852: ,'EXCHANGE_DATE'
853: ,'EXCHANGE_RATE'
854: );
855: xla_utility_pkg.trace('< xla_line_types_pkg.delete_non_gain_acct_attrs' , 10);
856:
857: EXCEPTION
858: WHEN xla_exceptions_pkg.application_exception THEN
859: RAISE;
900: l_arr_source_type_code t_array_codes;
901: l_arr_source_code t_array_codes;
902:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
901: l_arr_source_code t_array_codes;
902:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
902:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(
912: application_id
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(
912: application_id
913: ,amb_context_code
974: AND event_class_default_flag = 'Y';
975: END IF;
976: CLOSE c_attr_source;
977:
978: xla_utility_pkg.trace('< xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
979:
980: EXCEPTION
981: WHEN xla_exceptions_pkg.application_exception THEN
982: RAISE;
1018: ,'EXCHANGE_RATE'
1019: );
1020: BEGIN
1021:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1020: BEGIN
1021:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1021:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1030: open c_non_gain_acct_attrs;
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1030: open c_non_gain_acct_attrs;
1031: fetch c_non_gain_acct_attrs into l_temp;
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1030: open c_non_gain_acct_attrs;
1031: fetch c_non_gain_acct_attrs into l_temp;
1032: IF c_non_gain_acct_attrs%notfound THEN
1036: END IF;
1037:
1038: return l_result;
1039:
1040: xla_utility_pkg.trace('< xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1041:
1042: EXCEPTION
1043: WHEN xla_exceptions_pkg.application_exception THEN
1044: RAISE;
1118: AND l.inherited_flag = 'N';
1119:
1120: BEGIN
1121:
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1120: BEGIN
1121:
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1121:
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1129: OPEN c_acct_sources;
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1129: OPEN c_acct_sources;
1130: FETCH c_acct_sources
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1129: OPEN c_acct_sources;
1130: FETCH c_acct_sources
1131: INTO l_exist;
1308: END IF;
1309: END IF;
1310: CLOSE c_acct_sources;
1311:
1312: xla_utility_pkg.trace('< xla_line_types_pkg.create_accounting_attributes' , 10);
1313:
1314: EXCEPTION
1315: WHEN xla_exceptions_pkg.application_exception THEN
1316: RAISE;
1415: l_product_rule_type_codes t_array_type_codes;
1416: l_product_rule_codes t_array_codes;
1417: BEGIN
1418:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1417: BEGIN
1418:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1418:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1427: l_return := TRUE;
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1427: l_return := TRUE;
1428:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1427: l_return := TRUE;
1428:
1429: FOR l_lock_aad IN c_locked_aads LOOP
1531: x_event_class_name := l_event_class_name;
1532: x_event_type_name := l_event_type_name;
1533: x_locking_status_flag := l_locking_status_flag;
1534:
1535: xla_utility_pkg.trace('< xla_line_types_pkg.uncompile_definitions' , 10);
1536:
1537: return l_return;
1538:
1539: EXCEPTION
1599: AND l.lookup_type (+) = 'XLA_SOURCE_TYPE';
1600:
1601: BEGIN
1602:
1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);
1604:
1605: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1607:
1601: BEGIN
1602:
1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);
1604:
1605: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1607:
1608: OPEN c_dflt_source;
1609: FETCH c_dflt_source
1602:
1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);
1604:
1605: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1607:
1608: OPEN c_dflt_source;
1609: FETCH c_dflt_source
1610: INTO p_source_application_id, p_source_type_code, p_source_code,
1618:
1619: END IF;
1620: CLOSE c_dflt_source;
1621:
1622: xla_utility_pkg.trace('< xla_line_types_pkg.get_default_attr_assignment' , 10);
1623:
1624: EXCEPTION
1625: WHEN xla_exceptions_pkg.application_exception THEN
1626: RAISE;
1875: AND source_code = l_condition.value_source_code;
1876:
1877: BEGIN
1878:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1877: BEGIN
1878:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1878:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1887: OPEN c_conditions;
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1887: OPEN c_conditions;
1888: LOOP
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1887: OPEN c_conditions;
1888: LOOP
1889: FETCH c_conditions
1958: END IF;
1959: END LOOP;
1960: CLOSE c_conditions;
1961:
1962: xla_utility_pkg.trace('< xla_line_types_pkg.check_copy_line_type_details' , 10);
1963:
1964: RETURN l_return;
1965:
1966: EXCEPTION
2036: AND l.inherited_flag = 'Y';
2037:
2038: BEGIN
2039:
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2038: BEGIN
2039:
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2039:
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2047: IF p_business_method_code = 'PRIOR_ENTRY' THEN
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2047: IF p_business_method_code = 'PRIOR_ENTRY' THEN
2048: -- Update the inherited accounting attributes to null source mapping
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2047: IF p_business_method_code = 'PRIOR_ENTRY' THEN
2048: -- Update the inherited accounting attributes to null source mapping
2049:
2093: END IF;
2094: CLOSE c_non_prior_entry;
2095: END IF;
2096:
2097: xla_utility_pkg.trace('< xla_line_types_pkg.update_acct_attrs' , 10);
2098:
2099: EXCEPTION
2100: WHEN xla_exceptions_pkg.application_exception THEN
2101: RAISE;
2167: l_mpa_assignment_exist c_mpa_assignment_exist%rowtype;
2168:
2169: BEGIN
2170:
2171: xla_utility_pkg.trace('> xla_line_types_pkg.mpa_line_type_in_use' , 10);
2172:
2173: OPEN c_mpa_option_code;
2174: FETCH c_mpa_option_code
2175: INTO l_mpa_option_code;
2220: CLOSE c_mpa_assignment_exist;
2221:
2222: END IF;
2223:
2224: xla_utility_pkg.trace('< xla_line_types_pkg.mpa_line_type_in_use' , 10);
2225: x_mpa_option_code := l_mpa_option_code;
2226:
2227: return l_return;
2228: