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_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 119: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(

115: FROM zx_rec_nrec_dist
116: WHERE NVL(reverse_flag,'N') = 'N'
117: AND tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
118: AND trx_line_dist_id =
119: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(
120: p_trx_line_dist_index)
121: ORDER BY rec_nrec_tax_dist_id, recoverable_flag;
122:
123: CURSOR get_maximum_tax_dist_num_csr is

Line 128: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(

124: SELECT max(rec_nrec_tax_dist_number)
125: FROM zx_rec_nrec_dist
126: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
127: AND trx_line_dist_id =
128: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(
129: p_trx_line_dist_index);
130:
131: BEGIN
132:

Line 201: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL

197: AND p_detail_tax_line_tbl(p_tax_line_index).manually_entered_flag = 'Y'
198: AND p_detail_tax_line_tbl(p_tax_line_index).freeze_until_overridden_flag ='Y')
199: )
200: AND p_event_class_rec.tax_event_type_code <> 'OVERRIDE_TAX'
201: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL
202: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL
203: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index) IS NOT NULL
204: THEN
205: -- If p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND

Line 202: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL

198: AND p_detail_tax_line_tbl(p_tax_line_index).freeze_until_overridden_flag ='Y')
199: )
200: AND p_event_class_rec.tax_event_type_code <> 'OVERRIDE_TAX'
201: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL
202: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL
203: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index) IS NOT NULL
204: THEN
205: -- If p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
206: -- trx_line_dist_tbl.ref_doc_application_id IS NOT NULL,

Line 203: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index) IS NOT NULL

199: )
200: AND p_event_class_rec.tax_event_type_code <> 'OVERRIDE_TAX'
201: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL
202: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL
203: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index) IS NOT NULL
204: THEN
205: -- If p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
206: -- trx_line_dist_tbl.ref_doc_application_id IS NOT NULL,
207: -- OR --

Line 491: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL) AND

487: RETURN;
488: END IF;
489:
490: IF (NVL(p_rec_nrec_dist_tbl(l_new_index).historical_flag, 'N') <> 'Y') AND
491: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL) AND
492: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL OR
493: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NOT NULL AND
494: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'
495: )

Line 492: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL OR

488: END IF;
489:
490: IF (NVL(p_rec_nrec_dist_tbl(l_new_index).historical_flag, 'N') <> 'Y') AND
491: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL) AND
492: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL OR
493: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NOT NULL AND
494: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'
495: )
496: )

Line 493: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NOT NULL AND

489:
490: IF (NVL(p_rec_nrec_dist_tbl(l_new_index).historical_flag, 'N') <> 'Y') AND
491: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index) IS NULL) AND
492: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NULL OR
493: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index) IS NOT NULL AND
494: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_detail_tax_line_tbl(p_tax_line_index).tax_id).applied_amt_handling_flag = 'R'
495: )
496: )
497: THEN

Line 508: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

504: l_max_tax_dist_number := l_max_tax_dist_number + 1;
505:
506: -- commented out for bug 5581573
507: --IF p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y' AND
508: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
509: -- p_trx_line_dist_index) IS NOT NULL
510: --THEN
511: -- set rec_nrec_rate to NULL
512: --

Line 824: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(

820: CURSOR get_maximum_tax_dist_num_csr is
821: SELECT max(rec_nrec_tax_dist_number)
822: FROM zx_rec_nrec_dist
823: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
824: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(
825: p_trx_line_dist_index);
826:
827: l_max_tax_dist_number NUMBER;
828:

Line 861: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

857:
858: -- for applied_from(prepayment)/adjusted_to(credit memo) document ,
859: -- get the recovery types from applied_from /adjusted_to document.
860: --
861: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
862: p_trx_line_dist_index) IS NOT NULL THEN
863: -- If applied_from_application_id IS NOT NULL,
864: -- get detail tax lines from applied_from document.
865: --

Line 891: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

887: END IF;
888: END IF;
889: RETURN;
890:
891: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
892: p_trx_line_dist_index) IS NOT NULL
893: THEN
894: -- If adjusted_to_application_id IS NOT NULL,
895: -- get detail tax lines from adjusted_to document.

Line 1074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_dist_index);

1070:
1071: FOR i IN p_rnd_begin_index..p_rnd_end_index LOOP
1072:
1073: p_rec_nrec_dist_tbl(i).application_id :=
1074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_dist_index);
1075:
1076: p_rec_nrec_dist_tbl(i).entity_code :=
1077: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_dist_index);
1078:

Line 1077: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_dist_index);

1073: p_rec_nrec_dist_tbl(i).application_id :=
1074: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_dist_index);
1075:
1076: p_rec_nrec_dist_tbl(i).entity_code :=
1077: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_dist_index);
1078:
1079: p_rec_nrec_dist_tbl(i).event_class_code :=
1080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_dist_index);
1081:

Line 1080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_dist_index);

1076: p_rec_nrec_dist_tbl(i).entity_code :=
1077: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_dist_index);
1078:
1079: p_rec_nrec_dist_tbl(i).event_class_code :=
1080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_dist_index);
1081:
1082: p_rec_nrec_dist_tbl(i).event_type_code :=
1083: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_type_code(p_trx_line_dist_index);
1084:

Line 1083: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_type_code(p_trx_line_dist_index);

1079: p_rec_nrec_dist_tbl(i).event_class_code :=
1080: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_dist_index);
1081:
1082: p_rec_nrec_dist_tbl(i).event_type_code :=
1083: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_type_code(p_trx_line_dist_index);
1084:
1085: p_rec_nrec_dist_tbl(i).tax_event_class_code :=
1086: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_class_code(p_trx_line_dist_index);
1087:

Line 1086: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_class_code(p_trx_line_dist_index);

1082: p_rec_nrec_dist_tbl(i).event_type_code :=
1083: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_type_code(p_trx_line_dist_index);
1084:
1085: p_rec_nrec_dist_tbl(i).tax_event_class_code :=
1086: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_class_code(p_trx_line_dist_index);
1087:
1088: p_rec_nrec_dist_tbl(i).tax_event_type_code :=
1089: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(p_trx_line_dist_index);
1090:

Line 1089: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(p_trx_line_dist_index);

1085: p_rec_nrec_dist_tbl(i).tax_event_class_code :=
1086: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_class_code(p_trx_line_dist_index);
1087:
1088: p_rec_nrec_dist_tbl(i).tax_event_type_code :=
1089: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(p_trx_line_dist_index);
1090:
1091: p_rec_nrec_dist_tbl(i).trx_id :=
1092: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_dist_index);
1093:

Line 1092: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_dist_index);

1088: p_rec_nrec_dist_tbl(i).tax_event_type_code :=
1089: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_event_type_code(p_trx_line_dist_index);
1090:
1091: p_rec_nrec_dist_tbl(i).trx_id :=
1092: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_id(p_trx_line_dist_index);
1093:
1094: p_rec_nrec_dist_tbl(i).trx_number :=
1095: p_detail_tax_line_tbl(p_tax_line_index).trx_number;
1096:

Line 1106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);

1102:
1103: p_rec_nrec_dist_tbl(i).trx_line_number :=
1104: p_detail_tax_line_tbl(p_tax_line_index).trx_line_number;
1105: p_rec_nrec_dist_tbl(i).trx_line_dist_id :=
1106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);
1107:
1108:
1109: p_rec_nrec_dist_tbl(i).item_dist_number :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.item_dist_number(p_trx_line_dist_index);

Line 1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.item_dist_number(p_trx_line_dist_index);

1106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);
1107:
1108:
1109: p_rec_nrec_dist_tbl(i).item_dist_number :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.item_dist_number(p_trx_line_dist_index);
1111:
1112: -- need to add later
1113: -- p_rec_nrec_dist_tbl(i).tax_line_dist_number :=
1114: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_line_dist_number(p_trx_line_dist_index);

Line 1114: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_line_dist_number(p_trx_line_dist_index);

1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.item_dist_number(p_trx_line_dist_index);
1111:
1112: -- need to add later
1113: -- p_rec_nrec_dist_tbl(i).tax_line_dist_number :=
1114: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_line_dist_number(p_trx_line_dist_index);
1115:
1116: p_rec_nrec_dist_tbl(i).content_owner_id :=
1117: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id;
1118:

Line 1120: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index);

1116: p_rec_nrec_dist_tbl(i).content_owner_id :=
1117: p_detail_tax_line_tbl(p_tax_line_index).content_owner_id;
1118:
1119: p_rec_nrec_dist_tbl(i).ref_doc_application_id :=
1120: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index);
1121:
1122: p_rec_nrec_dist_tbl(i).ref_doc_entity_code :=
1123: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_dist_index);
1124:

Line 1123: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_dist_index);

1119: p_rec_nrec_dist_tbl(i).ref_doc_application_id :=
1120: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index);
1121:
1122: p_rec_nrec_dist_tbl(i).ref_doc_entity_code :=
1123: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_dist_index);
1124:
1125: p_rec_nrec_dist_tbl(i).ref_doc_event_class_code :=
1126: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_dist_index);
1127:

Line 1126: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_dist_index);

1122: p_rec_nrec_dist_tbl(i).ref_doc_entity_code :=
1123: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(p_trx_line_dist_index);
1124:
1125: p_rec_nrec_dist_tbl(i).ref_doc_event_class_code :=
1126: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_dist_index);
1127:
1128: p_rec_nrec_dist_tbl(i).ref_doc_trx_id :=
1129: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_dist_index);
1130:

Line 1129: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_dist_index);

1125: p_rec_nrec_dist_tbl(i).ref_doc_event_class_code :=
1126: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_dist_index);
1127:
1128: p_rec_nrec_dist_tbl(i).ref_doc_trx_id :=
1129: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_dist_index);
1130:
1131: p_rec_nrec_dist_tbl(i).ref_doc_line_id :=
1132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_dist_index);
1133:

Line 1132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_dist_index);

1128: p_rec_nrec_dist_tbl(i).ref_doc_trx_id :=
1129: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(p_trx_line_dist_index);
1130:
1131: p_rec_nrec_dist_tbl(i).ref_doc_line_id :=
1132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_dist_index);
1133:
1134: p_rec_nrec_dist_tbl(i).ref_doc_trx_level_type :=
1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_dist_index);
1136:

Line 1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_dist_index);

1131: p_rec_nrec_dist_tbl(i).ref_doc_line_id :=
1132: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(p_trx_line_dist_index);
1133:
1134: p_rec_nrec_dist_tbl(i).ref_doc_trx_level_type :=
1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_dist_index);
1136:
1137: p_rec_nrec_dist_tbl(i).ref_doc_dist_id :=
1138: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(p_trx_line_dist_index);
1139:

Line 1138: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(p_trx_line_dist_index);

1134: p_rec_nrec_dist_tbl(i).ref_doc_trx_level_type :=
1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(p_trx_line_dist_index);
1136:
1137: p_rec_nrec_dist_tbl(i).ref_doc_dist_id :=
1138: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(p_trx_line_dist_index);
1139:
1140: /*
1141: p_rec_nrec_dist_tbl(i).hdr_trx_user_key1 :=
1142: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key1(p_trx_line_dist_index);

Line 1142: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key1(p_trx_line_dist_index);

1138: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(p_trx_line_dist_index);
1139:
1140: /*
1141: p_rec_nrec_dist_tbl(i).hdr_trx_user_key1 :=
1142: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key1(p_trx_line_dist_index);
1143: p_rec_nrec_dist_tbl(i).hdr_trx_user_key2 :=
1144: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key2(p_trx_line_dist_index);
1145: p_rec_nrec_dist_tbl(i).hdr_trx_user_key3 :=
1146: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key3(p_trx_line_dist_index);

Line 1144: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key2(p_trx_line_dist_index);

1140: /*
1141: p_rec_nrec_dist_tbl(i).hdr_trx_user_key1 :=
1142: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key1(p_trx_line_dist_index);
1143: p_rec_nrec_dist_tbl(i).hdr_trx_user_key2 :=
1144: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key2(p_trx_line_dist_index);
1145: p_rec_nrec_dist_tbl(i).hdr_trx_user_key3 :=
1146: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key3(p_trx_line_dist_index);
1147: p_rec_nrec_dist_tbl(i).hdr_trx_user_key4 :=
1148: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key4(p_trx_line_dist_index);

Line 1146: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key3(p_trx_line_dist_index);

1142: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key1(p_trx_line_dist_index);
1143: p_rec_nrec_dist_tbl(i).hdr_trx_user_key2 :=
1144: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key2(p_trx_line_dist_index);
1145: p_rec_nrec_dist_tbl(i).hdr_trx_user_key3 :=
1146: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key3(p_trx_line_dist_index);
1147: p_rec_nrec_dist_tbl(i).hdr_trx_user_key4 :=
1148: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key4(p_trx_line_dist_index);
1149: p_rec_nrec_dist_tbl(i).hdr_trx_user_key5 :=
1150: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key5(p_trx_line_dist_index);

Line 1148: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key4(p_trx_line_dist_index);

1144: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key2(p_trx_line_dist_index);
1145: p_rec_nrec_dist_tbl(i).hdr_trx_user_key3 :=
1146: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key3(p_trx_line_dist_index);
1147: p_rec_nrec_dist_tbl(i).hdr_trx_user_key4 :=
1148: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key4(p_trx_line_dist_index);
1149: p_rec_nrec_dist_tbl(i).hdr_trx_user_key5 :=
1150: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key5(p_trx_line_dist_index);
1151: p_rec_nrec_dist_tbl(i).hdr_trx_user_key6 :=
1152: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key6(p_trx_line_dist_index);

Line 1150: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key5(p_trx_line_dist_index);

1146: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key3(p_trx_line_dist_index);
1147: p_rec_nrec_dist_tbl(i).hdr_trx_user_key4 :=
1148: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key4(p_trx_line_dist_index);
1149: p_rec_nrec_dist_tbl(i).hdr_trx_user_key5 :=
1150: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key5(p_trx_line_dist_index);
1151: p_rec_nrec_dist_tbl(i).hdr_trx_user_key6 :=
1152: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key6(p_trx_line_dist_index);
1153: p_rec_nrec_dist_tbl(i).line_trx_user_key1 :=
1154: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key1(p_trx_line_dist_index);

Line 1152: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key6(p_trx_line_dist_index);

1148: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key4(p_trx_line_dist_index);
1149: p_rec_nrec_dist_tbl(i).hdr_trx_user_key5 :=
1150: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key5(p_trx_line_dist_index);
1151: p_rec_nrec_dist_tbl(i).hdr_trx_user_key6 :=
1152: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key6(p_trx_line_dist_index);
1153: p_rec_nrec_dist_tbl(i).line_trx_user_key1 :=
1154: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key1(p_trx_line_dist_index);
1155: p_rec_nrec_dist_tbl(i).line_trx_user_key2 :=
1156: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key2(p_trx_line_dist_index);

Line 1154: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key1(p_trx_line_dist_index);

1150: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key5(p_trx_line_dist_index);
1151: p_rec_nrec_dist_tbl(i).hdr_trx_user_key6 :=
1152: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key6(p_trx_line_dist_index);
1153: p_rec_nrec_dist_tbl(i).line_trx_user_key1 :=
1154: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key1(p_trx_line_dist_index);
1155: p_rec_nrec_dist_tbl(i).line_trx_user_key2 :=
1156: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key2(p_trx_line_dist_index);
1157: p_rec_nrec_dist_tbl(i).line_trx_user_key3 :=
1158: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key3(p_trx_line_dist_index);

Line 1156: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key2(p_trx_line_dist_index);

1152: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hdr_trx_user_key6(p_trx_line_dist_index);
1153: p_rec_nrec_dist_tbl(i).line_trx_user_key1 :=
1154: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key1(p_trx_line_dist_index);
1155: p_rec_nrec_dist_tbl(i).line_trx_user_key2 :=
1156: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key2(p_trx_line_dist_index);
1157: p_rec_nrec_dist_tbl(i).line_trx_user_key3 :=
1158: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key3(p_trx_line_dist_index);
1159: p_rec_nrec_dist_tbl(i).line_trx_user_key4 :=
1160: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key4(p_trx_line_dist_index);

Line 1158: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key3(p_trx_line_dist_index);

1154: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key1(p_trx_line_dist_index);
1155: p_rec_nrec_dist_tbl(i).line_trx_user_key2 :=
1156: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key2(p_trx_line_dist_index);
1157: p_rec_nrec_dist_tbl(i).line_trx_user_key3 :=
1158: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key3(p_trx_line_dist_index);
1159: p_rec_nrec_dist_tbl(i).line_trx_user_key4 :=
1160: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key4(p_trx_line_dist_index);
1161: p_rec_nrec_dist_tbl(i).line_trx_user_key5 :=
1162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key5(p_trx_line_dist_index);

Line 1160: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key4(p_trx_line_dist_index);

1156: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key2(p_trx_line_dist_index);
1157: p_rec_nrec_dist_tbl(i).line_trx_user_key3 :=
1158: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key3(p_trx_line_dist_index);
1159: p_rec_nrec_dist_tbl(i).line_trx_user_key4 :=
1160: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key4(p_trx_line_dist_index);
1161: p_rec_nrec_dist_tbl(i).line_trx_user_key5 :=
1162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key5(p_trx_line_dist_index);
1163: p_rec_nrec_dist_tbl(i).line_trx_user_key6 :=
1164: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key6(p_trx_line_dist_index);

Line 1162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key5(p_trx_line_dist_index);

1158: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key3(p_trx_line_dist_index);
1159: p_rec_nrec_dist_tbl(i).line_trx_user_key4 :=
1160: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key4(p_trx_line_dist_index);
1161: p_rec_nrec_dist_tbl(i).line_trx_user_key5 :=
1162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key5(p_trx_line_dist_index);
1163: p_rec_nrec_dist_tbl(i).line_trx_user_key6 :=
1164: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key6(p_trx_line_dist_index);
1165: p_rec_nrec_dist_tbl(i).dist_trx_user_key1 :=
1166: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key1(p_trx_line_dist_index);

Line 1164: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key6(p_trx_line_dist_index);

1160: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key4(p_trx_line_dist_index);
1161: p_rec_nrec_dist_tbl(i).line_trx_user_key5 :=
1162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key5(p_trx_line_dist_index);
1163: p_rec_nrec_dist_tbl(i).line_trx_user_key6 :=
1164: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key6(p_trx_line_dist_index);
1165: p_rec_nrec_dist_tbl(i).dist_trx_user_key1 :=
1166: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key1(p_trx_line_dist_index);
1167: p_rec_nrec_dist_tbl(i).dist_trx_user_key2 :=
1168: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key2(p_trx_line_dist_index);

Line 1166: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key1(p_trx_line_dist_index);

1162: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key5(p_trx_line_dist_index);
1163: p_rec_nrec_dist_tbl(i).line_trx_user_key6 :=
1164: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key6(p_trx_line_dist_index);
1165: p_rec_nrec_dist_tbl(i).dist_trx_user_key1 :=
1166: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key1(p_trx_line_dist_index);
1167: p_rec_nrec_dist_tbl(i).dist_trx_user_key2 :=
1168: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key2(p_trx_line_dist_index);
1169: p_rec_nrec_dist_tbl(i).dist_trx_user_key3 :=
1170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key3(p_trx_line_dist_index);

Line 1168: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key2(p_trx_line_dist_index);

1164: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_trx_user_key6(p_trx_line_dist_index);
1165: p_rec_nrec_dist_tbl(i).dist_trx_user_key1 :=
1166: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key1(p_trx_line_dist_index);
1167: p_rec_nrec_dist_tbl(i).dist_trx_user_key2 :=
1168: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key2(p_trx_line_dist_index);
1169: p_rec_nrec_dist_tbl(i).dist_trx_user_key3 :=
1170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key3(p_trx_line_dist_index);
1171: p_rec_nrec_dist_tbl(i).dist_trx_user_key4 :=
1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key4(p_trx_line_dist_index);

Line 1170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key3(p_trx_line_dist_index);

1166: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key1(p_trx_line_dist_index);
1167: p_rec_nrec_dist_tbl(i).dist_trx_user_key2 :=
1168: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key2(p_trx_line_dist_index);
1169: p_rec_nrec_dist_tbl(i).dist_trx_user_key3 :=
1170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key3(p_trx_line_dist_index);
1171: p_rec_nrec_dist_tbl(i).dist_trx_user_key4 :=
1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key4(p_trx_line_dist_index);
1173: p_rec_nrec_dist_tbl(i).dist_trx_user_key5 :=
1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key5(p_trx_line_dist_index);

Line 1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key4(p_trx_line_dist_index);

1168: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key2(p_trx_line_dist_index);
1169: p_rec_nrec_dist_tbl(i).dist_trx_user_key3 :=
1170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key3(p_trx_line_dist_index);
1171: p_rec_nrec_dist_tbl(i).dist_trx_user_key4 :=
1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key4(p_trx_line_dist_index);
1173: p_rec_nrec_dist_tbl(i).dist_trx_user_key5 :=
1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key5(p_trx_line_dist_index);
1175: p_rec_nrec_dist_tbl(i).dist_trx_user_key6 :=
1176: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key6(p_trx_line_dist_index);

Line 1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key5(p_trx_line_dist_index);

1170: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key3(p_trx_line_dist_index);
1171: p_rec_nrec_dist_tbl(i).dist_trx_user_key4 :=
1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key4(p_trx_line_dist_index);
1173: p_rec_nrec_dist_tbl(i).dist_trx_user_key5 :=
1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key5(p_trx_line_dist_index);
1175: p_rec_nrec_dist_tbl(i).dist_trx_user_key6 :=
1176: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key6(p_trx_line_dist_index);
1177: */
1178: p_rec_nrec_dist_tbl(i).tax_regime_id :=

Line 1176: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key6(p_trx_line_dist_index);

1172: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key4(p_trx_line_dist_index);
1173: p_rec_nrec_dist_tbl(i).dist_trx_user_key5 :=
1174: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key5(p_trx_line_dist_index);
1175: p_rec_nrec_dist_tbl(i).dist_trx_user_key6 :=
1176: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.dist_trx_user_key6(p_trx_line_dist_index);
1177: */
1178: p_rec_nrec_dist_tbl(i).tax_regime_id :=
1179: p_detail_tax_line_tbl(p_tax_line_index).tax_regime_id;
1180:

Line 1311: p_rec_nrec_dist_tbl(i).INTENDED_USE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_trx_line_dist_index);

1307: 'Reverse flag and freeze flag are not Y');
1308: END IF;
1309:
1310:
1311: p_rec_nrec_dist_tbl(i).INTENDED_USE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_trx_line_dist_index);
1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);
1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);

Line 1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);

1308: END IF;
1309:
1310:
1311: p_rec_nrec_dist_tbl(i).INTENDED_USE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_trx_line_dist_index);
1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);
1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);

Line 1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);

1309:
1310:
1311: p_rec_nrec_dist_tbl(i).INTENDED_USE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_trx_line_dist_index);
1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);
1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);

Line 1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);

1310:
1311: p_rec_nrec_dist_tbl(i).INTENDED_USE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_trx_line_dist_index);
1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);
1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);

Line 1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);

1311: p_rec_nrec_dist_tbl(i).INTENDED_USE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.LINE_INTENDED_USE(p_trx_line_dist_index);
1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);
1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);

Line 1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);

1312: p_rec_nrec_dist_tbl(i).PROJECT_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PROJECT_ID(p_trx_line_dist_index);
1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:

Line 1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);

1313: p_rec_nrec_dist_tbl(i).TASK_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TASK_ID(p_trx_line_dist_index);
1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:
1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);

Line 1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);

1314: p_rec_nrec_dist_tbl(i).AWARD_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.AWARD_ID(p_trx_line_dist_index);
1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:
1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);
1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);

Line 1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);

1315: p_rec_nrec_dist_tbl(i).EXPENDITURE_TYPE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_TYPE(p_trx_line_dist_index);
1316: p_rec_nrec_dist_tbl(i).EXPENDITURE_ORGANIZATION_ID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ORGANIZATION_ID(p_trx_line_dist_index);
1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:
1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);
1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);
1323: --p_rec_nrec_dist_tbl(i).GL_DATE := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index); -- copy gl date

Line 1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);

1317: p_rec_nrec_dist_tbl(i).EXPENDITURE_ITEM_DATE:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.EXPENDITURE_ITEM_DATE(p_trx_line_dist_index);
1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:
1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);
1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);
1323: --p_rec_nrec_dist_tbl(i).GL_DATE := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index); -- copy gl date
1324:
1325: /*AP_UTILITIES_PKG.get_open_gl_date(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),

Line 1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);

1318: p_rec_nrec_dist_tbl(i).ACCOUNT_CCID:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_trx_line_dist_index);
1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:
1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);
1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);
1323: --p_rec_nrec_dist_tbl(i).GL_DATE := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index); -- copy gl date
1324:
1325: /*AP_UTILITIES_PKG.get_open_gl_date(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),
1326: l_period_name,

Line 1323: --p_rec_nrec_dist_tbl(i).GL_DATE := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index); -- copy gl date

1319: p_rec_nrec_dist_tbl(i).ACCOUNT_STRING:= ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_trx_line_dist_index);
1320:
1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);
1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);
1323: --p_rec_nrec_dist_tbl(i).GL_DATE := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index); -- copy gl date
1324:
1325: /*AP_UTILITIES_PKG.get_open_gl_date(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),
1326: l_period_name,
1327: p_rec_nrec_dist_tbl(i).GL_DATE,

Line 1325: /*AP_UTILITIES_PKG.get_open_gl_date(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),

1321: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_AMT := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index);
1322: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_QTY := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index);
1323: --p_rec_nrec_dist_tbl(i).GL_DATE := ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index); -- copy gl date
1324:
1325: /*AP_UTILITIES_PKG.get_open_gl_date(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),
1326: l_period_name,
1327: p_rec_nrec_dist_tbl(i).GL_DATE,
1328: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1329:

Line 1328: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));

1324:
1325: /*AP_UTILITIES_PKG.get_open_gl_date(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),
1326: l_period_name,
1327: p_rec_nrec_dist_tbl(i).GL_DATE,
1328: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1329:
1330: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1331:
1332: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1334: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));

1330: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1331:
1332: p_return_status := FND_API.G_RET_STS_ERROR;
1333: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1334: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1335:
1336: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1338: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.tax_line_id := p_detail_tax_line_tbl(p_tax_line_index).tax_line_id;

Line 1377: NVL(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.total_inc_tax_amt(p_trx_line_dist_index), 0);

1373: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.GET_TAX_RELATED_COLUMNS_VAR',
1374: 'Prepayment Invoice application');
1375: END IF;
1376: l_temp_line_amt := p_detail_tax_line_tbl(p_tax_line_index).line_amt -
1377: NVL(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.total_inc_tax_amt(p_trx_line_dist_index), 0);
1378:
1379: ELSE
1380: -- bug 5019399
1381: -- bug 6670955

Line 1383: --NVL(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.total_inc_tax_amt(p_trx_line_dist_index), 0);

1379: ELSE
1380: -- bug 5019399
1381: -- bug 6670955
1382: l_temp_line_amt := p_detail_tax_line_tbl(p_tax_line_index).line_amt;
1383: --NVL(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.total_inc_tax_amt(p_trx_line_dist_index), 0);
1384: END IF;
1385:
1386: IF l_temp_line_amt <> 0 THEN -- Bug 4932210, 5019399
1387:

Line 1391: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;

1387:
1388: --Bug 15866615, use unrounded_tax_amt to stamp trx_line_dist_tax_amt so that unrounded_rec_nrec_tax_amt is correctly generated
1389: p_rec_nrec_dist_tbl(i).TRX_LINE_DIST_TAX_AMT :=
1390: NVL(p_detail_tax_line_tbl(p_tax_line_index).UNROUNDED_TAX_AMT, p_detail_tax_line_tbl(p_tax_line_index).TAX_AMT) *
1391: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;
1392:
1393: -- comment out for bug 3795178
1394: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /
1395: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */

Line 1394: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /

1390: NVL(p_detail_tax_line_tbl(p_tax_line_index).UNROUNDED_TAX_AMT, p_detail_tax_line_tbl(p_tax_line_index).TAX_AMT) *
1391: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;
1392:
1393: -- comment out for bug 3795178
1394: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /
1395: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */
1396:
1397: p_rec_nrec_dist_tbl(i).UNROUNDED_TAXABLE_AMT :=
1398: p_detail_tax_line_tbl(p_tax_line_index).TAXABLE_AMT *

Line 1395: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */

1391: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;
1392:
1393: -- comment out for bug 3795178
1394: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /
1395: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */
1396:
1397: p_rec_nrec_dist_tbl(i).UNROUNDED_TAXABLE_AMT :=
1398: p_detail_tax_line_tbl(p_tax_line_index).TAXABLE_AMT *
1399: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;

Line 1399: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;

1395: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */
1396:
1397: p_rec_nrec_dist_tbl(i).UNROUNDED_TAXABLE_AMT :=
1398: p_detail_tax_line_tbl(p_tax_line_index).TAXABLE_AMT *
1399: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;
1400:
1401: -- comment out for bug 3795178
1402: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /
1403: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */

Line 1402: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /

1398: p_detail_tax_line_tbl(p_tax_line_index).TAXABLE_AMT *
1399: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;
1400:
1401: -- comment out for bug 3795178
1402: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /
1403: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */
1404:
1405: ELSE
1406: -- Bug 5195602: For reversed item distributions, line_amt is 0,

Line 1403: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */

1399: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index) /l_temp_line_amt;
1400:
1401: -- comment out for bug 3795178
1402: /*ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_QUANTITY(p_trx_line_dist_index) /
1403: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_QUANTITY(p_trx_line_dist_index); */
1404:
1405: ELSE
1406: -- Bug 5195602: For reversed item distributions, line_amt is 0,
1407: -- but TRX_LINE_DIST_AMT might not be 0.

Line 1445: IF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_ID(p_trx_line_dist_index) = 200 THEN

1441: p_rec_nrec_dist_tbl(i).internal_organization_id := p_detail_tax_line_tbl(p_tax_line_index).internal_organization_id;
1442: p_rec_nrec_dist_tbl(i).tax_jurisdiction_id := p_detail_tax_line_tbl(p_tax_line_index).tax_jurisdiction_id;
1443:
1444: -- bug 6879755
1445: IF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_ID(p_trx_line_dist_index) = 200 THEN
1446: BEGIN
1447: IF p_rec_nrec_dist_tbl(i).orig_gl_date IS NOT NULL THEN
1448: p_rec_nrec_dist_tbl(i).gl_date :=
1449: AP_UTILITIES_PKG.get_reversal_gl_date(

Line 1451: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));

1447: IF p_rec_nrec_dist_tbl(i).orig_gl_date IS NOT NULL THEN
1448: p_rec_nrec_dist_tbl(i).gl_date :=
1449: AP_UTILITIES_PKG.get_reversal_gl_date(
1450: p_date => p_rec_nrec_dist_tbl(i).gl_date,
1451: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1452: ELSE
1453: p_rec_nrec_dist_tbl(i).gl_date :=
1454: AP_UTILITIES_PKG.get_reversal_gl_date(
1455: p_date => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),

Line 1455: p_date => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),

1451: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1452: ELSE
1453: p_rec_nrec_dist_tbl(i).gl_date :=
1454: AP_UTILITIES_PKG.get_reversal_gl_date(
1455: p_date => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),
1456: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1457: END IF;
1458: EXCEPTION
1459: WHEN OTHERS THEN

Line 1456: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));

1452: ELSE
1453: p_rec_nrec_dist_tbl(i).gl_date :=
1454: AP_UTILITIES_PKG.get_reversal_gl_date(
1455: p_date => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index),
1456: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1457: END IF;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN

Line 1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN

1456: p_org_id => ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.INTERNAL_ORGANIZATION_ID(p_trx_line_dist_index));
1457: END IF;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1461: p_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1463: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1464:

Line 1463: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));

1459: WHEN OTHERS THEN
1460: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1461: p_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1463: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1464:
1465: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1466: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1467: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.tax_line_id := p_detail_tax_line_tbl(p_tax_line_index).tax_line_id;

Line 1482: ELSIF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_ID(p_trx_line_dist_index) = 201 THEN

1478: END IF;
1479: RETURN;
1480: END IF;
1481: END;
1482: ELSIF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_ID(p_trx_line_dist_index) = 201 THEN
1483:
1484: p_rec_nrec_dist_tbl(i).gl_date :=
1485: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index);
1486:

Line 1485: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index);

1481: END;
1482: ELSIF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.APPLICATION_ID(p_trx_line_dist_index) = 201 THEN
1483:
1484: p_rec_nrec_dist_tbl(i).gl_date :=
1485: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index);
1486:
1487: END IF;
1488:
1489: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN

Line 1489: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN

1485: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index);
1486:
1487: END IF;
1488:
1489: IF nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_reporting_flag(p_trx_line_dist_index),'N') = 'Y' THEN
1490: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1491:
1492: p_return_status := FND_API.G_RET_STS_ERROR;
1493: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');

Line 1494: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));

1490: IF p_rec_nrec_dist_tbl(i).GL_DATE IS NULL THEN
1491:
1492: p_return_status := FND_API.G_RET_STS_ERROR;
1493: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
1494: FND_MESSAGE.SET_TOKEN('DATE', to_char(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_GL_DATE(p_trx_line_dist_index), 'dd-mon-yyyy'));
1495:
1496: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id := p_detail_tax_line_tbl(p_tax_line_index).trx_line_id;
1497: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type := p_detail_tax_line_tbl(p_tax_line_index).trx_level_type;
1498: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.tax_line_id := p_detail_tax_line_tbl(p_tax_line_index).tax_line_id;

Line 1823: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

1819: -- applied_amt_handling_flag = 'P'), or adjusted_doc_application_id is not
1820: -- null, copy tax recovery rate percentage from applied_from/adjusted_to
1821: -- document. Skip the tax recovery rate determination process.
1822: --
1823: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
1824: p_trx_line_dist_index) IS NOT NULL OR
1825: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1826: p_trx_line_dist_index) IS NOT NULL AND
1827: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag ='P')

Line 1825: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

1821: -- document. Skip the tax recovery rate determination process.
1822: --
1823: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
1824: p_trx_line_dist_index) IS NOT NULL OR
1825: (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1826: p_trx_line_dist_index) IS NOT NULL AND
1827: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag ='P')
1828: THEN
1829:

Line 1982: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index) IS NOT NULL

1978:
1979: ELSE
1980:
1981: IF ((NVL(p_event_class_rec.enforce_tax_from_ref_doc_flag,'N') = 'Y' AND
1982: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_dist_index) IS NOT NULL
1983: )
1984: OR -- Added following conditions for Bug#13012588
1985: (p_detail_tax_line_tbl(p_tax_line_index).other_doc_source = 'REFERENCE' AND
1986: p_detail_tax_line_tbl(p_tax_line_index).unrounded_tax_amt = 0 AND

Line 2324: IF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.overriding_recovery_rate(

2320:
2321: -- Bug 4012677: Support PO item distribution level tax recovery
2322: -- rate override
2323: --
2324: IF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.overriding_recovery_rate(
2325: p_trx_line_dist_index) IS NOT NULL AND
2326: p_rec_nrec_dist_tbl(i).recovery_type_code =
2327: g_tax_recovery_info_tbl(l_tax_id).primary_recovery_type_code AND
2328: l_rec_rate_adhoc_flag = 'Y'

Line 2333: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.overriding_recovery_rate(

2329: THEN
2330:
2331: p_rec_nrec_dist_tbl(i).orig_rec_nrec_rate := l_rec_rate;
2332: l_rec_rate :=
2333: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.overriding_recovery_rate(
2334: p_trx_line_dist_index);
2335: END IF;
2336:
2337: -- For invoice matched to PO and rec_nrec_rate overidden by user in PO,

Line 2341: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

2337: -- For invoice matched to PO and rec_nrec_rate overidden by user in PO,
2338: -- copy rec_nrec_rate if tax recovery rate is adhoc
2339: --
2340: IF NVL(p_event_class_rec.enforce_tax_from_ref_doc_flag,'N') = 'Y' AND
2341: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
2342: p_trx_line_dist_index) IS NOT NULL AND
2343: p_rec_nrec_dist_tbl(i).rec_nrec_rate IS NOT NULL AND
2344: l_rec_rate_adhoc_flag = 'Y'
2345: THEN

Line 5177: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

5173: def_rec_settlement_option_code,
5174: account_source_tax_rate_id
5175: FROM zx_rec_nrec_dist
5176: WHERE application_id =
5177: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
5178: p_trx_line_dist_index)
5179: AND entity_code =
5180: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(
5181: p_trx_line_dist_index)

Line 5180: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(

5176: WHERE application_id =
5177: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
5178: p_trx_line_dist_index)
5179: AND entity_code =
5180: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(
5181: p_trx_line_dist_index)
5182: AND event_class_code =
5183: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(
5184: p_trx_line_dist_index)

Line 5183: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(

5179: AND entity_code =
5180: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(
5181: p_trx_line_dist_index)
5182: AND event_class_code =
5183: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(
5184: p_trx_line_dist_index)
5185: AND trx_id =
5186: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(
5187: p_trx_line_dist_index)

Line 5186: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(

5182: AND event_class_code =
5183: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(
5184: p_trx_line_dist_index)
5185: AND trx_id =
5186: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(
5187: p_trx_line_dist_index)
5188: AND trx_line_id =
5189: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(
5190: p_trx_line_dist_index)

Line 5189: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(

5185: AND trx_id =
5186: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(
5187: p_trx_line_dist_index)
5188: AND trx_line_id =
5189: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(
5190: p_trx_line_dist_index)
5191: AND trx_level_type =
5192: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(
5193: p_trx_line_dist_index)

Line 5192: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(

5188: AND trx_line_id =
5189: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(
5190: p_trx_line_dist_index)
5191: AND trx_level_type =
5192: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(
5193: p_trx_line_dist_index)
5194: AND trx_line_dist_id =
5195: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(
5196: p_trx_line_dist_index)

Line 5195: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(

5191: AND trx_level_type =
5192: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(
5193: p_trx_line_dist_index)
5194: AND trx_line_dist_id =
5195: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(
5196: p_trx_line_dist_index)
5197: AND tax_id = p_tax_id
5198: -- Modified the condition for Bug#16601146
5199: AND NVL(tax_apportionment_line_number,p_tax_apportionment_line_num) = p_tax_apportionment_line_num

Line 5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||

5226: IF (g_level_statement >= g_current_runtime_level ) THEN
5227: FND_LOG.STRING(g_level_statement,
5228: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5229: 'Fetching Tax Dists for: '||
5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||
5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||
5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||

Line 5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||

5227: FND_LOG.STRING(g_level_statement,
5228: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5229: 'Fetching Tax Dists for: '||
5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||
5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||
5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||
5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||

Line 5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||

5228: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_applied',
5229: 'Fetching Tax Dists for: '||
5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||
5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||
5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||
5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||
5236: 'APPLIED_FROM_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)) ||', '||

Line 5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||

5229: 'Fetching Tax Dists for: '||
5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||
5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||
5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||
5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||
5236: 'APPLIED_FROM_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)) ||', '||
5237: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||

Line 5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||

5230: 'APPLIED_FROM_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)) ||', '||
5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||
5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||
5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||
5236: 'APPLIED_FROM_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)) ||', '||
5237: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||
5238: 'TAX_APPORTIONMENT_LINE_NUMBER : '||TO_CHAR(p_tax_apportionment_line_num)

Line 5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||

5231: 'APPLIED_FROM_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index) ||', '||
5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||
5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||
5236: 'APPLIED_FROM_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)) ||', '||
5237: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||
5238: 'TAX_APPORTIONMENT_LINE_NUMBER : '||TO_CHAR(p_tax_apportionment_line_num)
5239: );

Line 5236: 'APPLIED_FROM_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)) ||', '||

5232: 'APPLIED_FROM_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index) ||', '||
5233: 'APPLIED_FROM_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)) ||', '||
5234: 'APPLIED_FROM_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)) ||', '||
5235: 'APPLIED_FROM_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index) ||', '||
5236: 'APPLIED_FROM_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)) ||', '||
5237: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||
5238: 'TAX_APPORTIONMENT_LINE_NUMBER : '||TO_CHAR(p_tax_apportionment_line_num)
5239: );
5240: END IF;

Line 5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)

5249: SET tax_apportionment_line_number =
5250: (SELECT tax_apportionment_line_number
5251: FROM zx_lines zl
5252: WHERE zl.tax_line_id = zd.tax_line_id)
5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)
5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)

Line 5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)

5250: (SELECT tax_apportionment_line_number
5251: FROM zx_lines zl
5252: WHERE zl.tax_line_id = zd.tax_line_id)
5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)
5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)
5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)

Line 5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)

5251: FROM zx_lines zl
5252: WHERE zl.tax_line_id = zd.tax_line_id)
5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)
5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)
5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)
5259: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)

Line 5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)

5252: WHERE zl.tax_line_id = zd.tax_line_id)
5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)
5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)
5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)
5259: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)
5260: AND tax_apportionment_line_number IS NULL

Line 5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)

5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)
5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)
5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)
5259: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)
5260: AND tax_apportionment_line_number IS NULL
5261: AND NVL(reverse_flag, 'N') <> 'Y';

Line 5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)

5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)
5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)
5259: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)
5260: AND tax_apportionment_line_number IS NULL
5261: AND NVL(reverse_flag, 'N') <> 'Y';
5262:

Line 5259: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)

5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)
5256: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_dist_index)
5257: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_dist_index)
5258: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_dist_index)
5259: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_dist_id(p_trx_line_dist_index)
5260: AND tax_apportionment_line_number IS NULL
5261: AND NVL(reverse_flag, 'N') <> 'Y';
5262:
5263: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5339: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index)/

5335: tax_dist_rec.recovery_rate_code;
5336:
5337: p_rec_nrec_dist_tbl(p_rnd_end_index).prd_tax_amt :=
5338: tax_dist_rec.rec_nrec_tax_amt *
5339: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index)/
5340: tax_dist_rec.trx_line_dist_amt;
5341:
5342: p_rec_nrec_dist_tbl(p_rnd_end_index).prd_tax_amt_tax_curr :=
5343: tax_dist_rec.rec_nrec_tax_amt_tax_curr *

Line 5344: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index)/

5340: tax_dist_rec.trx_line_dist_amt;
5341:
5342: p_rec_nrec_dist_tbl(p_rnd_end_index).prd_tax_amt_tax_curr :=
5343: tax_dist_rec.rec_nrec_tax_amt_tax_curr *
5344: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index)/
5345: tax_dist_rec.trx_line_dist_amt;
5346:
5347: IF tax_dist_rec.rec_nrec_tax_amt_funcl_curr IS NOT NULL THEN
5348: p_rec_nrec_dist_tbl(p_rnd_end_index).prd_tax_amt_funcl_curr :=

Line 5350: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index)/

5346:
5347: IF tax_dist_rec.rec_nrec_tax_amt_funcl_curr IS NOT NULL THEN
5348: p_rec_nrec_dist_tbl(p_rnd_end_index).prd_tax_amt_funcl_curr :=
5349: tax_dist_rec.rec_nrec_tax_amt_funcl_curr *
5350: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.TRX_LINE_DIST_AMT(p_trx_line_dist_index)/
5351: tax_dist_rec.trx_line_dist_amt;
5352: END IF;
5353: END IF;
5354:

Line 5403: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

5399: def_rec_settlement_option_code,
5400: account_source_tax_rate_id
5401: FROM zx_rec_nrec_dist
5402: WHERE application_id =
5403: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
5404: p_trx_line_dist_index)
5405: AND entity_code =
5406: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
5407: p_trx_line_dist_index)

Line 5406: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(

5402: WHERE application_id =
5403: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
5404: p_trx_line_dist_index)
5405: AND entity_code =
5406: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
5407: p_trx_line_dist_index)
5408: AND event_class_code =
5409: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
5410: p_trx_line_dist_index)

Line 5409: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(

5405: AND entity_code =
5406: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
5407: p_trx_line_dist_index)
5408: AND event_class_code =
5409: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
5410: p_trx_line_dist_index)
5411: AND trx_id =
5412: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
5413: p_trx_line_dist_index)

Line 5412: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(

5408: AND event_class_code =
5409: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
5410: p_trx_line_dist_index)
5411: AND trx_id =
5412: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
5413: p_trx_line_dist_index)
5414: AND trx_line_id =
5415: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
5416: p_trx_line_dist_index)

Line 5415: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(

5411: AND trx_id =
5412: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
5413: p_trx_line_dist_index)
5414: AND trx_line_id =
5415: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
5416: p_trx_line_dist_index)
5417: AND trx_level_type =
5418: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
5419: p_trx_line_dist_index)

Line 5418: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(

5414: AND trx_line_id =
5415: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
5416: p_trx_line_dist_index)
5417: AND trx_level_type =
5418: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
5419: p_trx_line_dist_index)
5420: AND trx_line_dist_id =
5421: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(
5422: p_trx_line_dist_index)

Line 5421: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(

5417: AND trx_level_type =
5418: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
5419: p_trx_line_dist_index)
5420: AND trx_line_dist_id =
5421: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(
5422: p_trx_line_dist_index)
5423: AND tax_id = p_tax_id
5424: -- Modified the following condition for Bug#16601146
5425: AND NVL(tax_apportionment_line_number,p_tax_apportionment_line_num) = p_tax_apportionment_line_num

Line 5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||

5453: IF (g_level_statement >= g_current_runtime_level ) THEN
5454: FND_LOG.STRING(g_level_statement,
5455: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5456: 'Fetching Tax Dists for: '||
5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||
5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||
5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||

Line 5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||

5454: FND_LOG.STRING(g_level_statement,
5455: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5456: 'Fetching Tax Dists for: '||
5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||
5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||
5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||
5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||

Line 5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||

5455: 'ZX.PLSQL.ZX_TRD_INTERNAL_SERVICES_PVT.get_recovery_from_adjusted',
5456: 'Fetching Tax Dists for: '||
5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||
5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||
5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||
5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||
5463: 'ADJUSTED_DOC_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)) ||', '||

Line 5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||

5456: 'Fetching Tax Dists for: '||
5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||
5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||
5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||
5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||
5463: 'ADJUSTED_DOC_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)) ||', '||
5464: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||

Line 5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||

5457: 'ADJUSTED_DOC_APPLICATION_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)) ||', '||
5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||
5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||
5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||
5463: 'ADJUSTED_DOC_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)) ||', '||
5464: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||
5465: 'TAX_APPORTIONMENT_LINE_NUMBER : '||TO_CHAR(p_tax_apportionment_line_num)

Line 5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||

5458: 'ADJUSTED_DOC_ENTITY_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index) ||', '||
5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||
5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||
5463: 'ADJUSTED_DOC_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)) ||', '||
5464: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||
5465: 'TAX_APPORTIONMENT_LINE_NUMBER : '||TO_CHAR(p_tax_apportionment_line_num)
5466: );

Line 5463: 'ADJUSTED_DOC_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)) ||', '||

5459: 'ADJUSTED_DOC_EVENT_CLASS_CODE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index) ||', '||
5460: 'ADJUSTED_DOC_TRX_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)) ||', '||
5461: 'ADJUSTED_DOC_LINE_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)) ||', '||
5462: 'ADJUSTED_DOC_TRX_LEVEL_TYPE : '||ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index) ||', '||
5463: 'ADJUSTED_DOC_DIST_ID : '||TO_CHAR(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)) ||', '||
5464: 'TAX_ID : '||TO_CHAR(p_tax_id) ||', '||
5465: 'TAX_APPORTIONMENT_LINE_NUMBER : '||TO_CHAR(p_tax_apportionment_line_num)
5466: );
5467: END IF;

Line 5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)

5476: SET tax_apportionment_line_number =
5477: (SELECT tax_apportionment_line_number
5478: FROM zx_lines zl
5479: WHERE zl.tax_line_id = zd.tax_line_id)
5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)
5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)

Line 5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)

5477: (SELECT tax_apportionment_line_number
5478: FROM zx_lines zl
5479: WHERE zl.tax_line_id = zd.tax_line_id)
5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)
5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)
5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)

Line 5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)

5478: FROM zx_lines zl
5479: WHERE zl.tax_line_id = zd.tax_line_id)
5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)
5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)
5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)
5486: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)

Line 5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)

5479: WHERE zl.tax_line_id = zd.tax_line_id)
5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)
5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)
5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)
5486: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)
5487: AND tax_apportionment_line_number IS NULL

Line 5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)

5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)
5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)
5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)
5486: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)
5487: AND tax_apportionment_line_number IS NULL
5488: AND NVL(reverse_flag, 'N') <> 'Y';

Line 5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)

5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)
5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)
5486: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)
5487: AND tax_apportionment_line_number IS NULL
5488: AND NVL(reverse_flag, 'N') <> 'Y';
5489:

Line 5486: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)

5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)
5483: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_dist_index)
5484: AND trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(p_trx_line_dist_index)
5485: AND trx_level_type = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(p_trx_line_dist_index)
5486: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_dist_id(p_trx_line_dist_index)
5487: AND tax_apportionment_line_number IS NULL
5488: AND NVL(reverse_flag, 'N') <> 'Y';
5489:
5490: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5589: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(

5585: rec_rate_result_id,
5586: recovery_rate_id
5587: FROM zx_rec_nrec_dist
5588: WHERE application_id =
5589: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
5590: p_trx_line_dist_index)
5591: AND entity_code =
5592: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(
5593: p_trx_line_dist_index)

Line 5592: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(

5588: WHERE application_id =
5589: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(
5590: p_trx_line_dist_index)
5591: AND entity_code =
5592: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(
5593: p_trx_line_dist_index)
5594: AND event_class_code =
5595: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(
5596: p_trx_line_dist_index)

Line 5595: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(

5591: AND entity_code =
5592: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_entity_code(
5593: p_trx_line_dist_index)
5594: AND event_class_code =
5595: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(
5596: p_trx_line_dist_index)
5597: AND trx_id =
5598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(
5599: p_trx_line_dist_index)

Line 5598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(

5594: AND event_class_code =
5595: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(
5596: p_trx_line_dist_index)
5597: AND trx_id =
5598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(
5599: p_trx_line_dist_index)
5600: AND trx_line_id =
5601: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(
5602: p_trx_line_dist_index)

Line 5601: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(

5597: AND trx_id =
5598: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_id(
5599: p_trx_line_dist_index)
5600: AND trx_line_id =
5601: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(
5602: p_trx_line_dist_index)
5603: AND trx_level_type =
5604: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(
5605: p_trx_line_dist_index)

Line 5604: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(

5600: AND trx_line_id =
5601: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_line_id(
5602: p_trx_line_dist_index)
5603: AND trx_level_type =
5604: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(
5605: p_trx_line_dist_index)
5606: AND trx_line_dist_id =
5607: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(
5608: p_trx_line_dist_index)

Line 5607: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(

5603: AND trx_level_type =
5604: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_trx_level_type(
5605: p_trx_line_dist_index)
5606: AND trx_line_dist_id =
5607: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_dist_id(
5608: p_trx_line_dist_index)
5609: AND tax = p_detail_tax_line_tbl(p_tax_line_index).tax
5610: AND tax_regime_code = p_detail_tax_line_tbl(p_tax_line_index).tax_regime_code
5611: AND NVL(reverse_flag, 'N') <> 'Y'

Line 5636: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);

5632: CURSOR get_maximum_tax_dist_num_csr is
5633: SELECT max(rec_nrec_tax_dist_number)
5634: FROM zx_rec_nrec_dist
5635: WHERE tax_line_id = p_detail_tax_line_tbl(p_tax_line_index).tax_line_id
5636: AND trx_line_dist_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_dist_id(p_trx_line_dist_index);
5637:
5638: l_rec_nrec_tax_dist_number NUMBER;
5639: l_po_dist_count NUMBER;
5640: l_rnd_begin_index NUMBER;