1124: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
1125: p_mtl_txn_tbl IN mtl_txn_tbl,
1126: p_item_control_rec IN item_control_rec,
1127: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1128: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1125: p_mtl_txn_tbl IN mtl_txn_tbl,
1126: p_item_control_rec IN item_control_rec,
1127: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1128: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1126: p_item_control_rec IN item_control_rec,
1127: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1128: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1127: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1128: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1135: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1128: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1135: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1136: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1129: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1135: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1136: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1137: x_return_status OUT NOCOPY varchar2)
1130: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1135: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1136: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1137: x_return_status OUT NOCOPY varchar2)
1138: IS
1131: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1135: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1136: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1137: x_return_status OUT NOCOPY varchar2)
1138: IS
1139:
1132: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1133: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1134: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1135: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1136: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1137: x_return_status OUT NOCOPY varchar2)
1138: IS
1139:
1140: --Hard Coded Values
1147: l_instance_quantity number;
1148:
1149: l_rma_order_rec mtl_trx_type;
1150: l_txn_rec csi_datastructures_pub.transaction_rec;
1151: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1148:
1149: l_rma_order_rec mtl_trx_type;
1150: l_txn_rec csi_datastructures_pub.transaction_rec;
1151: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1149: l_rma_order_rec mtl_trx_type;
1150: l_txn_rec csi_datastructures_pub.transaction_rec;
1151: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1150: l_txn_rec csi_datastructures_pub.transaction_rec;
1151: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1158: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1151: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1158: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1159: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1152: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1158: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1159: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1160: l_mtl_txn_rec mtl_txn_rec;
1153: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1158: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1159: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1160: l_mtl_txn_rec mtl_txn_rec;
1161:
1154: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1158: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1159: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1160: l_mtl_txn_rec mtl_txn_rec;
1161:
1162: -- get_transaction_details variables
1155: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1156: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1157: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1158: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1159: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1160: l_mtl_txn_rec mtl_txn_rec;
1161:
1162: -- get_transaction_details variables
1163:
1519: PROCEDURE build_process_tables_NOTD(
1520: p_mtl_txn_tbl IN mtl_txn_tbl,
1521: p_item_control_rec IN item_control_rec,
1522: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1523: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1520: p_mtl_txn_tbl IN mtl_txn_tbl,
1521: p_item_control_rec IN item_control_rec,
1522: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1523: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1521: p_item_control_rec IN item_control_rec,
1522: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1523: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1522: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
1523: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1530: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1523: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1530: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1531: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1524: x_i_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1530: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1531: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1532: x_return_status OUT NOCOPY varchar2)
1525: x_ip_accounts_tbl OUT NOCOPY csi_process_txn_grp.txn_ip_accounts_tbl,
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1530: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1531: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1532: x_return_status OUT NOCOPY varchar2)
1533: IS
1526: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1530: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1531: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1532: x_return_status OUT NOCOPY varchar2)
1533: IS
1534:
1527: x_ext_attrib_values_tbl OUT NOCOPY csi_process_txn_grp.txn_ext_attrib_values_tbl,
1528: x_pricing_attribs_tbl OUT NOCOPY csi_process_txn_grp.txn_pricing_attribs_tbl,
1529: x_instance_asset_tbl OUT NOCOPY csi_process_txn_grp.txn_instance_asset_tbl,
1530: x_ii_relationships_tbl OUT NOCOPY csi_process_txn_grp.txn_ii_relationships_tbl,
1531: x_dest_location_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
1532: x_return_status OUT NOCOPY varchar2)
1533: IS
1534:
1535: --Hard Coded Values
1544: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1545: l_error_message varchar2(2000);
1546:
1547: l_txn_rec csi_datastructures_pub.transaction_rec;
1548: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1545: l_error_message varchar2(2000);
1546:
1547: l_txn_rec csi_datastructures_pub.transaction_rec;
1548: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1546:
1547: l_txn_rec csi_datastructures_pub.transaction_rec;
1548: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1547: l_txn_rec csi_datastructures_pub.transaction_rec;
1548: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1555: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1548: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1555: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1556: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1549: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1555: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1556: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1557:
1550: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1555: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1556: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1557:
1558:
1551: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1555: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1556: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1557:
1558:
1559: BEGIN
1552: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
1553: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
1554: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
1555: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
1556: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
1557:
1558:
1559: BEGIN
1560:
2624: l_validate_only_flag VARCHAR2(1) := fnd_api.g_false;
2625: l_in_out_flag VARCHAR2(30) := 'IN';
2626:
2627: l_txn_rec csi_datastructures_pub.transaction_rec;
2628: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2625: l_in_out_flag VARCHAR2(30) := 'IN';
2626:
2627: l_txn_rec csi_datastructures_pub.transaction_rec;
2628: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2626:
2627: l_txn_rec csi_datastructures_pub.transaction_rec;
2628: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2627: l_txn_rec csi_datastructures_pub.transaction_rec;
2628: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2628: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2636: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2629: l_i_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2636: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2637:
2630: l_ip_accounts_tbl csi_process_txn_grp.txn_ip_accounts_tbl;
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2636: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2637:
2638: l_error_message varchar2(4000);
2631: l_org_units_tbl csi_process_txn_grp.txn_org_units_tbl;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2636: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2637:
2638: l_error_message varchar2(4000);
2639: l_error_rec csi_datastructures_pub.transaction_error_rec;
2632: l_ext_attrib_values_tbl csi_process_txn_grp.txn_ext_attrib_values_tbl;
2633: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
2634: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
2635: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
2636: l_dest_location_rec csi_process_txn_grp.dest_location_rec;
2637:
2638: l_error_message varchar2(4000);
2639: l_error_rec csi_datastructures_pub.transaction_error_rec;
2640:
3684: --
3685: debug('Calling Process Transaction Routine.');
3686:
3687: -- Call process transaction
3688: csi_process_txn_grp.process_transaction(
3689: p_api_version => l_api_version,
3690: p_commit => l_commit,
3691: p_init_msg_list => l_init_msg_list,
3692: p_validation_level => l_validation_level,