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.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_EXTRACT_PKG

Line 57: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

53: ----------------------------------------
54: --
55: PROCEDURE get_org_vat_num (
56: --p_report_name IN VARCHAR2,
57: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
58: -- p_request_id IN NUMBER,
59: p_establishment_id IN NUMBER,
60: p_org_vat_num_tbl OUT NOCOPY ATTRIBUTE2_TBL);
61:

Line 64: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

60: p_org_vat_num_tbl OUT NOCOPY ATTRIBUTE2_TBL);
61:
62: PROCEDURE get_territory_info(
63: --p_report_name IN VARCHAR2,
64: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
65: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
66: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
67: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
68:

Line 65: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,

61:
62: PROCEDURE get_territory_info(
63: --p_report_name IN VARCHAR2,
64: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
65: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
66: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
67: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
68:
69: PROCEDURE adjustment_tax_code(

Line 70: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

66: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
67: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
68:
69: PROCEDURE adjustment_tax_code(
70: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
71: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
72: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL);
73:
74: --Private Procedures Included for the Bug 5251425

Line 71: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,

67: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
68:
69: PROCEDURE adjustment_tax_code(
70: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
71: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
72: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL);
73:
74: --Private Procedures Included for the Bug 5251425
75: PROCEDURE GET_CREATED_BY

Line 77: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

73:
74: --Private Procedures Included for the Bug 5251425
75: PROCEDURE GET_CREATED_BY
76: (
77: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
78: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
79: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
80: ) ;
81:

Line 78: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

74: --Private Procedures Included for the Bug 5251425
75: PROCEDURE GET_CREATED_BY
76: (
77: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
78: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
79: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
80: ) ;
81:
82: PROCEDURE GET_OU_DESC

Line 84: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

80: ) ;
81:
82: PROCEDURE GET_OU_DESC
83: (
84: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
85: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
86: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
87: ) ;
88:

Line 85: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,

81:
82: PROCEDURE GET_OU_DESC
83: (
84: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
85: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
86: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
87: ) ;
88:
89: PROCEDURE GET_MATCH

Line 91: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

87: ) ;
88:
89: PROCEDURE GET_MATCH
90: (
91: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
92: p_acc_ccid_tbl ACC_CCID_TBL ,
93: p_match_tbl OUT NOCOPY ATTRIBUTE5_TBL
94: );
95:

Line 98: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

94: );
95:
96: PROCEDURE GET_RECEIVED_AMOUNTS
97: (
98: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
99: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
100: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
101: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
102: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL

Line 99: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

95:
96: PROCEDURE GET_RECEIVED_AMOUNTS
97: (
98: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
99: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
100: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
101: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
102: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
103: );

Line 100: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,

96: PROCEDURE GET_RECEIVED_AMOUNTS
97: (
98: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
99: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
100: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
101: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
102: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
103: );
104:

Line 117: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

113:
114: -- Public APIs
115:
116: PROCEDURE populate_core_ap(
117: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
118: )
119: IS
120:
121: p_request_id NUMBER;

Line 125: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

121: p_request_id NUMBER;
122: p_report_name VARCHAR2(30);
123: p_legal_entity_id NUMBER;
124: p_product VARCHAR2(30);
125: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
126: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
127: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
128: l_org_vat_num_tbl ATTRIBUTE2_TBL;
129: l_territory_short_name_tbl ATTRIBUTE2_TBL;

Line 126: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

122: p_report_name VARCHAR2(30);
123: p_legal_entity_id NUMBER;
124: p_product VARCHAR2(30);
125: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
126: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
127: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
128: l_org_vat_num_tbl ATTRIBUTE2_TBL;
129: l_territory_short_name_tbl ATTRIBUTE2_TBL;
130: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;

Line 127: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;

123: p_legal_entity_id NUMBER;
124: p_product VARCHAR2(30);
125: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
126: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
127: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
128: l_org_vat_num_tbl ATTRIBUTE2_TBL;
129: l_territory_short_name_tbl ATTRIBUTE2_TBL;
130: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
131: l_establishment_id NUMBER;

Line 132: l_tax_rate_code_tbl ZX_EXTRACT_PKG.TAX_RATE_CODE_TBL;

128: l_org_vat_num_tbl ATTRIBUTE2_TBL;
129: l_territory_short_name_tbl ATTRIBUTE2_TBL;
130: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
131: l_establishment_id NUMBER;
132: l_tax_rate_code_tbl ZX_EXTRACT_PKG.TAX_RATE_CODE_TBL;
133: l_adj_tax_code_tbl ATTRIBUTE1_TBL;
134:
135: --Bug 5251425
136: l_trx_currency_code_tbl zx_extract_pkg.trx_currency_code_tbl;

Line 136: l_trx_currency_code_tbl zx_extract_pkg.trx_currency_code_tbl;

132: l_tax_rate_code_tbl ZX_EXTRACT_PKG.TAX_RATE_CODE_TBL;
133: l_adj_tax_code_tbl ATTRIBUTE1_TBL;
134:
135: --Bug 5251425
136: l_trx_currency_code_tbl zx_extract_pkg.trx_currency_code_tbl;
137: l_trx_currency_desc_tbl trx_currency_desc_tbl;
138: l_batch_name_tbl batch_name_tbl;
139: l_err_msg varchar2(120);
140: l_created_by_tbl attribute6_tbl;

Line 142: l_internal_organization_id_tbl zx_extract_pkg.internal_organization_id_tbl;

138: l_batch_name_tbl batch_name_tbl;
139: l_err_msg varchar2(120);
140: l_created_by_tbl attribute6_tbl;
141: l_ou_desc_tbl attribute7_tbl;
142: l_internal_organization_id_tbl zx_extract_pkg.internal_organization_id_tbl;
143: l_acc_ccid_tbl acc_ccid_tbl;
144: l_match_tbl attribute5_tbl;
145:
146:

Line 539: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

535:
536: PROCEDURE get_territory_info
537: (
538: --p_report_name IN VARCHAR2,
539: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
540: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
541: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
542: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL
543: )

Line 540: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,

536: PROCEDURE get_territory_info
537: (
538: --p_report_name IN VARCHAR2,
539: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
540: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
541: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
542: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL
543: )
544: IS

Line 571: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

567: END get_territory_info;
568:
569: PROCEDURE get_org_vat_num (
570: --p_report_name IN VARCHAR2,
571: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
572: -- p_request_id IN NUMBER,
573: p_establishment_id IN NUMBER,
574: p_org_vat_num_tbl OUT NOCOPY ATTRIBUTE2_TBL)
575: IS

Line 610: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

606: END get_org_vat_num;
607:
608:
609: PROCEDURE adjustment_tax_code(
610: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
611: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
612: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL)
613: IS
614: BEGIN

Line 611: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,

607:
608:
609: PROCEDURE adjustment_tax_code(
610: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
611: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
612: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL)
613: IS
614: BEGIN
615: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP

Line 681: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

677:
678: --Bug 5251425
679: PROCEDURE GET_CREATED_BY
680: (
681: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
682: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
683: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
684: )
685: IS

Line 682: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

678: --Bug 5251425
679: PROCEDURE GET_CREATED_BY
680: (
681: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
682: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
683: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
684: )
685: IS
686:

Line 712: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

708:
709: --Bug 5251425
710: PROCEDURE GET_OU_DESC
711: (
712: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
713: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
714: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
715: )
716: IS

Line 713: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,

709: --Bug 5251425
710: PROCEDURE GET_OU_DESC
711: (
712: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
713: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
714: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
715: )
716: IS
717:

Line 739: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

735:
736: END GET_OU_DESC;
737: --Bug 5251425
738: PROCEDURE GET_MATCH(
739: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
740: p_acc_ccid_tbl ACC_CCID_TBL ,
741: p_match_tbl OUT NOCOPY ATTRIBUTE5_TBL
742: )
743: IS

Line 777: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

773:
774: --To get the Received amounts for the report ZXXCDE
775: PROCEDURE GET_RECEIVED_AMOUNTS
776: (
777: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
778: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
779: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
780: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
781: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL

Line 778: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

774: --To get the Received amounts for the report ZXXCDE
775: PROCEDURE GET_RECEIVED_AMOUNTS
776: (
777: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
778: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
779: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
780: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
781: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
782: )

Line 779: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,

775: PROCEDURE GET_RECEIVED_AMOUNTS
776: (
777: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
778: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
779: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
780: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
781: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
782: )
783: IS

Line 859: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

855: +======================================================================================*/
856:
857:
858: PROCEDURE POPULATE_CORE_AR(
859: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
860: )
861: IS
862:
863: P_REPORT_NAME VARCHAR2(30);

Line 900: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

896: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
897: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
898: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
899:
900: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
901: l_event_class_mapping_id_tbl EVENT_CLASS_MAPPING_ID_TBL;
902: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
903: l_trx_line_id_tbl TRX_LINE_ID_TBL;
904: l_trx_level_type_tbl TRX_LEVEL_TYPE_TBL;

Line 902: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

898: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
899:
900: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
901: l_event_class_mapping_id_tbl EVENT_CLASS_MAPPING_ID_TBL;
902: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
903: l_trx_line_id_tbl TRX_LINE_ID_TBL;
904: l_trx_level_type_tbl TRX_LEVEL_TYPE_TBL;
905: l_pos_type_code_tbl POS_TYPE_CODE_TBL;
906: l_ship_to_location_id_tbl SHIP_TO_LOCATION_ID_TBL;

Line 918: l_ledger_id_tbl zx_extract_pkg.ledger_id_tbl;

914: l_county_tbl GEO_VAL_TBL;
915: l_city_tbl GEO_VAL_TBL;
916:
917: --Bug 5251425 : Variable Declarations for the Bug.
918: l_ledger_id_tbl zx_extract_pkg.ledger_id_tbl;
919: l_period_net_dr_tbl number_tbl;
920: l_period_net_cr_tbl number_tbl;
921: l_gl_activity_tbl number_tbl;
922: t_gl_activity_tbl number_tbl;

Line 927: l_org_id_tbl zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL;

923: l_ccid_tbl ccid_tbl ;
924:
925: l_amount_received_tbl NUMERIC2_TBL;
926: l_tax_received_tbl NUMERIC1_TBL;
927: l_org_id_tbl zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL;
928:
929: l_bal_seg_prompt_tbl ATTRIBUTE1_TBL;
930:
931: l_set_of_books_id apps.gl_sets_of_books.set_of_books_id%type;