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 67: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

63: ----------------------------------------
64: --
65: PROCEDURE get_org_vat_num (
66: --p_report_name IN VARCHAR2,
67: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
68: -- p_request_id IN NUMBER,
69: p_establishment_id IN NUMBER,
70: p_org_vat_num_tbl OUT NOCOPY ATTRIBUTE2_TBL);
71:

Line 74: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

70: p_org_vat_num_tbl OUT NOCOPY ATTRIBUTE2_TBL);
71:
72: PROCEDURE get_territory_info(
73: --p_report_name IN VARCHAR2,
74: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
75: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
76: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
77: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
78:

Line 75: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,

71:
72: PROCEDURE get_territory_info(
73: --p_report_name IN VARCHAR2,
74: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
75: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
76: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
77: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
78:
79: PROCEDURE adjustment_tax_code(

Line 80: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

76: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
77: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
78:
79: PROCEDURE adjustment_tax_code(
80: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
81: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
82: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL);
83:
84: --Private Procedures Included for the Bug 5251425

Line 81: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,

77: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL);
78:
79: PROCEDURE adjustment_tax_code(
80: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
81: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
82: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL);
83:
84: --Private Procedures Included for the Bug 5251425
85: PROCEDURE GET_CREATED_BY

Line 87: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

83:
84: --Private Procedures Included for the Bug 5251425
85: PROCEDURE GET_CREATED_BY
86: (
87: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
88: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
89: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
90: ) ;
91:

Line 88: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

84: --Private Procedures Included for the Bug 5251425
85: PROCEDURE GET_CREATED_BY
86: (
87: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
88: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
89: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
90: ) ;
91:
92: PROCEDURE GET_OU_DESC

Line 94: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

90: ) ;
91:
92: PROCEDURE GET_OU_DESC
93: (
94: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
95: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
96: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
97: ) ;
98:

Line 95: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,

91:
92: PROCEDURE GET_OU_DESC
93: (
94: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
95: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
96: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
97: ) ;
98:
99: PROCEDURE GET_MATCH

Line 101: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

97: ) ;
98:
99: PROCEDURE GET_MATCH
100: (
101: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
102: p_acc_ccid_tbl ACC_CCID_TBL ,
103: p_match_tbl OUT NOCOPY ATTRIBUTE5_TBL
104: );
105:

Line 108: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

104: );
105:
106: PROCEDURE GET_RECEIVED_AMOUNTS
107: (
108: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
109: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
110: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
111: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
112: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL

Line 109: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

105:
106: PROCEDURE GET_RECEIVED_AMOUNTS
107: (
108: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
109: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
110: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
111: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
112: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
113: );

Line 110: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,

106: PROCEDURE GET_RECEIVED_AMOUNTS
107: (
108: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
109: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
110: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
111: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
112: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
113: );
114:

Line 127: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

123:
124: -- Public APIs
125:
126: PROCEDURE populate_core_ap(
127: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
128: )
129: IS
130:
131: p_request_id NUMBER;

Line 135: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

131: p_request_id NUMBER;
132: p_report_name VARCHAR2(30);
133: p_legal_entity_id NUMBER;
134: p_product VARCHAR2(30);
135: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
136: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
137: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
138: l_country_code_reg_num_tbl ATTRIBUTE1_TBL;
139: l_org_vat_num_tbl ATTRIBUTE2_TBL;

Line 136: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

132: p_report_name VARCHAR2(30);
133: p_legal_entity_id NUMBER;
134: p_product VARCHAR2(30);
135: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
136: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
137: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
138: l_country_code_reg_num_tbl ATTRIBUTE1_TBL;
139: l_org_vat_num_tbl ATTRIBUTE2_TBL;
140: l_territory_short_name_tbl ATTRIBUTE2_TBL;

Line 137: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;

133: p_legal_entity_id NUMBER;
134: p_product VARCHAR2(30);
135: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
136: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
137: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
138: l_country_code_reg_num_tbl ATTRIBUTE1_TBL;
139: l_org_vat_num_tbl ATTRIBUTE2_TBL;
140: l_territory_short_name_tbl ATTRIBUTE2_TBL;
141: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;

Line 143: l_tax_rate_code_tbl ZX_EXTRACT_PKG.TAX_RATE_CODE_TBL;

139: l_org_vat_num_tbl ATTRIBUTE2_TBL;
140: l_territory_short_name_tbl ATTRIBUTE2_TBL;
141: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
142: l_establishment_id NUMBER;
143: l_tax_rate_code_tbl ZX_EXTRACT_PKG.TAX_RATE_CODE_TBL;
144: l_adj_tax_code_tbl ATTRIBUTE1_TBL;
145:
146: --Bug 5251425
147: l_trx_currency_code_tbl zx_extract_pkg.trx_currency_code_tbl;

Line 147: l_trx_currency_code_tbl zx_extract_pkg.trx_currency_code_tbl;

143: l_tax_rate_code_tbl ZX_EXTRACT_PKG.TAX_RATE_CODE_TBL;
144: l_adj_tax_code_tbl ATTRIBUTE1_TBL;
145:
146: --Bug 5251425
147: l_trx_currency_code_tbl zx_extract_pkg.trx_currency_code_tbl;
148: l_trx_currency_desc_tbl trx_currency_desc_tbl;
149: l_batch_name_tbl batch_name_tbl;
150: l_err_msg varchar2(120);
151: l_created_by_tbl attribute6_tbl;

Line 153: l_internal_organization_id_tbl zx_extract_pkg.internal_organization_id_tbl;

149: l_batch_name_tbl batch_name_tbl;
150: l_err_msg varchar2(120);
151: l_created_by_tbl attribute6_tbl;
152: l_ou_desc_tbl attribute7_tbl;
153: l_internal_organization_id_tbl zx_extract_pkg.internal_organization_id_tbl;
154: l_acc_ccid_tbl acc_ccid_tbl;
155: l_match_tbl attribute5_tbl;
156: p_posting_status VARCHAR2(30);
157:

Line 1047: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

1043:
1044: PROCEDURE get_territory_info
1045: (
1046: --p_report_name IN VARCHAR2,
1047: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1048: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
1049: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
1050: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL
1051: )

Line 1048: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,

1044: PROCEDURE get_territory_info
1045: (
1046: --p_report_name IN VARCHAR2,
1047: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1048: p_country_code_tbl IN ZX_EXTRACT_PKG.billing_tp_country_tbl,
1049: p_territory_short_name_tbl OUT NOCOPY ATTRIBUTE2_TBL,
1050: p_alternate_territory_name_tbl OUT NOCOPY ATTRIBUTE3_TBL
1051: )
1052: IS

Line 1079: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

1075: END get_territory_info;
1076:
1077: PROCEDURE get_org_vat_num (
1078: --p_report_name IN VARCHAR2,
1079: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1080: -- p_request_id IN NUMBER,
1081: p_establishment_id IN NUMBER,
1082: p_org_vat_num_tbl OUT NOCOPY ATTRIBUTE2_TBL)
1083: IS

Line 1118: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

1114: END get_org_vat_num;
1115:
1116:
1117: PROCEDURE adjustment_tax_code(
1118: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1119: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
1120: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL)
1121: IS
1122: BEGIN

Line 1119: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,

1115:
1116:
1117: PROCEDURE adjustment_tax_code(
1118: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1119: p_tax_rate_code_tbl IN ZX_EXTRACT_PKG.tax_rate_code_tbl,
1120: p_adj_tax_code_tbl OUT NOCOPY ATTRIBUTE1_TBL)
1121: IS
1122: BEGIN
1123: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP

Line 1189: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

1185:
1186: --Bug 5251425
1187: PROCEDURE GET_CREATED_BY
1188: (
1189: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1190: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
1191: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
1192: )
1193: IS

Line 1190: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

1186: --Bug 5251425
1187: PROCEDURE GET_CREATED_BY
1188: (
1189: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1190: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
1191: p_created_by_tbl OUT NOCOPY ATTRIBUTE6_TBL
1192: )
1193: IS
1194:

Line 1220: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,

1216:
1217: --Bug 5251425
1218: PROCEDURE GET_OU_DESC
1219: (
1220: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1221: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
1222: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
1223: )
1224: IS

Line 1221: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,

1217: --Bug 5251425
1218: PROCEDURE GET_OU_DESC
1219: (
1220: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.detail_tax_line_id_tbl,
1221: p_internal_organization_id_tbl IN ZX_EXTRACT_PKG.internal_organization_id_tbl,
1222: p_ou_desc_tbl OUT NOCOPY ATTRIBUTE7_TBL
1223: )
1224: IS
1225:

Line 1247: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

1243:
1244: END GET_OU_DESC;
1245: --Bug 5251425
1246: PROCEDURE GET_MATCH(
1247: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
1248: p_acc_ccid_tbl ACC_CCID_TBL ,
1249: p_match_tbl OUT NOCOPY ATTRIBUTE5_TBL
1250: )
1251: IS

Line 1285: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

1281:
1282: --To get the Received amounts for the report ZXXCDE
1283: PROCEDURE GET_RECEIVED_AMOUNTS
1284: (
1285: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
1286: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
1287: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
1288: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
1289: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL

Line 1286: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,

1282: --To get the Received amounts for the report ZXXCDE
1283: PROCEDURE GET_RECEIVED_AMOUNTS
1284: (
1285: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
1286: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
1287: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
1288: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
1289: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
1290: )

Line 1287: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,

1283: PROCEDURE GET_RECEIVED_AMOUNTS
1284: (
1285: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
1286: p_trx_id_tbl IN ZX_EXTRACT_PKG.trx_id_tbl,
1287: p_org_id_tbl IN zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL ,
1288: p_amount_received_tbl OUT NOCOPY NUMERIC2_TBL,
1289: p_tax_received_tbl OUT NOCOPY NUMERIC1_TBL
1290: )
1291: IS

Line 1369: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

1365: +======================================================================================*/
1366:
1367:
1368: PROCEDURE POPULATE_CORE_AR(
1369: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
1370: )
1371: IS
1372:
1373: P_REPORT_NAME VARCHAR2(30);

Line 1412: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1408: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1409: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
1410: TYPE PERIOD_NAME_TBL IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
1411:
1412: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1413: l_event_class_mapping_id_tbl EVENT_CLASS_MAPPING_ID_TBL;
1414: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1415: l_trx_line_id_tbl TRX_LINE_ID_TBL;
1416: l_trx_level_type_tbl TRX_LEVEL_TYPE_TBL;

Line 1414: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1410: TYPE PERIOD_NAME_TBL IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
1411:
1412: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1413: l_event_class_mapping_id_tbl EVENT_CLASS_MAPPING_ID_TBL;
1414: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1415: l_trx_line_id_tbl TRX_LINE_ID_TBL;
1416: l_trx_level_type_tbl TRX_LEVEL_TYPE_TBL;
1417: l_pos_type_code_tbl POS_TYPE_CODE_TBL;
1418: l_ship_to_location_id_tbl SHIP_TO_LOCATION_ID_TBL;

Line 1431: l_ledger_id_tbl zx_extract_pkg.ledger_id_tbl;

1427: l_city_tbl GEO_VAL_TBL;
1428: l_end_period_tbl PERIOD_NAME_TBL;
1429:
1430: --Bug 5251425 : Variable Declarations for the Bug.
1431: l_ledger_id_tbl zx_extract_pkg.ledger_id_tbl;
1432: l_period_net_dr_tbl number_tbl;
1433: l_period_net_cr_tbl number_tbl;
1434: l_gl_activity_tbl number_tbl;
1435: t_gl_activity_tbl number_tbl;

Line 1450: l_adj_trx_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_TRX_ID_TBL;

1446:
1447: --Bug 9031051
1448: l_reporting_code_tbl attribute2_tbl;
1449: l_reporting_code_char_tbl ATTRIBUTE10_TBL;
1450: l_adj_trx_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_TRX_ID_TBL;
1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;
1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;

Line 1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;

1447: --Bug 9031051
1448: l_reporting_code_tbl attribute2_tbl;
1449: l_reporting_code_char_tbl ATTRIBUTE10_TBL;
1450: l_adj_trx_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_TRX_ID_TBL;
1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;
1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;

Line 1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;

1448: l_reporting_code_tbl attribute2_tbl;
1449: l_reporting_code_char_tbl ATTRIBUTE10_TBL;
1450: l_adj_trx_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_TRX_ID_TBL;
1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;
1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;
1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;

Line 1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;

1449: l_reporting_code_char_tbl ATTRIBUTE10_TBL;
1450: l_adj_trx_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_TRX_ID_TBL;
1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;
1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;
1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;
1457: l_out_of_period_adj_tbl attribute5_tbl;

Line 1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;

1450: l_adj_trx_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_TRX_ID_TBL;
1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;
1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;
1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;
1457: l_out_of_period_adj_tbl attribute5_tbl;
1458: l_func_curr_line_amt_tbl numeric5_tbl;

Line 1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;

1451: l_adj_trx_line_id_tbl ZX_EXTRACT_PKG.applied_to_trx_line_id_tbl;
1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;
1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;
1457: l_out_of_period_adj_tbl attribute5_tbl;
1458: l_func_curr_line_amt_tbl numeric5_tbl;
1459: l_country_code_reg_num_tbl attribute1_tbl;

Line 1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;

1452: l_adj_application_id_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_APPL_ID_TBL;
1453: l_adj_event_class_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_EVENT_CLS_CD_TBL;
1454: l_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1455: l_adj_entity_code_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_ENTITY_CODE_TBL;
1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;
1457: l_out_of_period_adj_tbl attribute5_tbl;
1458: l_func_curr_line_amt_tbl numeric5_tbl;
1459: l_country_code_reg_num_tbl attribute1_tbl;
1460: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;

Line 1460: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;

1456: l_adj_doc_date_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_DATE_TBL;
1457: l_out_of_period_adj_tbl attribute5_tbl;
1458: l_func_curr_line_amt_tbl numeric5_tbl;
1459: l_country_code_reg_num_tbl attribute1_tbl;
1460: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
1461: l_tax_reg_num_tbl attribute6_tbl;
1462: l_territory_short_name_tbl ATTRIBUTE2_TBL;
1463: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;

Line 1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;

1460: l_country_code_tbl ZX_EXTRACT_PKG.BILLING_TP_COUNTRY_TBL;
1461: l_tax_reg_num_tbl attribute6_tbl;
1462: l_territory_short_name_tbl ATTRIBUTE2_TBL;
1463: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;
1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;
1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;

Line 1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;

1461: l_tax_reg_num_tbl attribute6_tbl;
1462: l_territory_short_name_tbl ATTRIBUTE2_TBL;
1463: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;
1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;
1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;

Line 1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;

1462: l_territory_short_name_tbl ATTRIBUTE2_TBL;
1463: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;
1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;
1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;

Line 1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;

1463: l_alternate_territory_name_tbl ATTRIBUTE3_TBL;
1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;
1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;
1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;

Line 1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;

1464: l_adj_tax_invoice_tbl ZX_EXTRACT_PKG.TAX_INVOICE_DATE_TBL;
1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;
1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;

Line 1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;

1465: l_adj_gl_date_tbl ZX_EXTRACT_PKG.GL_DATE_TBL;
1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;

Line 1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;

1466: l_adj_trx_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;

Line 1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;

1467: l_org_id_tbl ZX_EXTRACT_PKG.INTERNAL_ORGANIZATION_ID_TBL;
1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;

Line 1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;

1468: l_bill_to_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_TAX_REG_NUM_TBL;
1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;

Line 1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;

1469: l_bill_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.BILLING_TP_SITE_TX_REG_NUM_TBL;
1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;

Line 1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;

1470: l_ship_to_site_tax_reg_num_tbl ZX_EXTRACT_PKG.SHIPPING_TP_SITE_TX_RG_NUM_TBL;
1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;
1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;

Line 1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;

1471: l_billing_tp_name_tbl ZX_EXTRACT_PKG.BILLING_TP_NAME_TBL;
1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;
1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;
1479: l_disc_apply_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;

Line 1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;

1472: l_shipping_tp_name_tbl ZX_EXTRACT_PKG.SHIPPING_TP_NAME_TBL;
1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;
1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;
1479: l_disc_apply_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1480:

Line 1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;

1473: l_adj_trx_class_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;
1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;
1479: l_disc_apply_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1480:
1481: l_description VARCHAR2(240);

Line 1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;

1474: l_adj_trx_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;
1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;
1479: l_disc_apply_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1480:
1481: l_description VARCHAR2(240);
1482: l_meaning VARCHAR2(80);

Line 1479: l_disc_apply_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;

1475: l_disc_class_mng_tbl ZX_EXTRACT_PKG.TRX_CLASS_MNG_TBL;
1476: l_hq_estb_ptp_id_tbl ZX_EXTRACT_PKG.SHIP_TO_PARTY_TAX_PROF_ID_TBL;
1477: l_hq_estb_reg_num_tbl ZX_EXTRACT_PKG.HQ_ESTB_REG_NUMBER_TBL;
1478: l_receivable_app_id_tbl ZX_EXTRACT_PKG.APPLIED_FROM_TRX_ID_TBL;
1479: l_disc_apply_date_tbl ZX_EXTRACT_PKG.TRX_DATE_TBL;
1480:
1481: l_description VARCHAR2(240);
1482: l_meaning VARCHAR2(80);
1483:

Line 1601: ZX_EXTRACT_PKG.get_vat_transaction_code_name(

1597: dtl.trx_line_id,
1598: dtl.event_class_code,
1599: --rep_code.reporting_code_name,
1600: --assoc.reporting_code_char_value,
1601: ZX_EXTRACT_PKG.get_vat_transaction_code_name(
1602: dtl.tax_line_id,
1603: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE,
1604: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS,
1605: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES,

Line 1609: ZX_EXTRACT_PKG.get_vat_transaction_code_name(

1605: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES,
1606: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE1,
1607: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_ADDL_CODE2,
1608: 'NAME'),
1609: ZX_EXTRACT_PKG.get_vat_transaction_code_name(
1610: dtl.tax_line_id,
1611: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE,
1612: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS,
1613: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES,

Line 1677: and ZX_EXTRACT_PKG.get_vat_transaction_code_name(

1673: l_disc_class_mng_tbl,
1674: l_disc_apply_date_tbl
1675: FROM zx_rep_trx_detail_t dtl
1676: WHERE dtl.request_id = P_REQUEST_ID
1677: and ZX_EXTRACT_PKG.get_vat_transaction_code_name(
1678: dtl.tax_line_id,
1679: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE,
1680: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_GOODS,
1681: P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_SERVICES,