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.CSI_UTL_PKG dependencies on CSI_T_DATASTRUCTURES_GRP

Line 87: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

83: p_inv_item_id IN NUMBER,
84: p_inv_org_id IN NUMBER) RETURN VARCHAR2;
85:
86: FUNCTION Check_relation_exists(
87: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
88: p_txn_line_detail_id IN NUMBER) RETURN BOOLEAN;
89:
90: PROCEDURE Get_Pricing_Attribs(
91: p_line_id IN NUMBER,

Line 96: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

92: x_pricing_attb_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
93: x_return_status OUT NOCOPY VARCHAR2 );
94:
95: PROCEDURE split_ship_rec(
96: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec

Line 97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

93: x_return_status OUT NOCOPY VARCHAR2 );
94:
95: PROCEDURE split_ship_rec(
96: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
101: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec

Line 98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec

94:
95: PROCEDURE split_ship_rec(
96: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
101: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
102: ,p_proc_qty IN NUMBER

Line 106: ( x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec

102: ,p_proc_qty IN NUMBER
103: ,x_return_status OUT NOCOPY VARCHAR2);
104:
105: PROCEDURE create_txn_details
106: ( x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
107: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
108: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
109: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
110: ,x_return_status OUT NOCOPY VARCHAR2 );

Line 118: ( p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

114: x_party_id OUT NOCOPY number,
115: x_return_status OUT NOCOPY varchar2);
116:
117: FUNCTION Check_config_exists
118: ( p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
119: p_txn_detail_id IN NUMBER ) RETURN BOOLEAN ;
120:
121:
122: FUNCTION validate_inst_party

Line 215: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

211: x_return_status OUT NOCOPY VARCHAR2 );
212:
213: PROCEDURE build_inst_ii_tbl
214: ( p_orig_inst_id IN NUMBER,
215: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
216: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,
217: x_return_status OUT NOCOPY VARCHAR2);
218:
219: PROCEDURE update_txn_line_dtl

Line 242: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

238: PROCEDURE conv_to_prim_uom(
239: p_inv_organization_id IN number,
240: p_inventory_item_id IN number,
241: p_uom IN varchar2,
242: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
243: x_return_status OUT NOCOPY varchar2);
244:
245: PROCEDURE get_source_trx_dtls(
246: p_mtl_transaction_id IN NUMBER,

Line 264: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,

260: x_return_status OUT NOCOPY varchar2);
261:
262:
263: PROCEDURE get_system_tbl(
264: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
265: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec );
266:
267: PROCEDURE get_org_assignment_tbl(
268: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

Line 268: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

264: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
265: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec );
266:
267: PROCEDURE get_org_assignment_tbl(
268: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
269: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
270: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
271: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
272: x_return_status OUT NOCOPY VARCHAR2 );

Line 269: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

265: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec );
266:
267: PROCEDURE get_org_assignment_tbl(
268: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
269: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
270: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
271: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
272: x_return_status OUT NOCOPY VARCHAR2 );
273:

Line 275: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

271: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
272: x_return_status OUT NOCOPY VARCHAR2 );
273:
274: PROCEDURE get_ext_attribs_tbl(
275: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
276: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
277: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
278: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
279: x_return_status OUT NOCOPY VARCHAR2 );

Line 276: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

272: x_return_status OUT NOCOPY VARCHAR2 );
273:
274: PROCEDURE get_ext_attribs_tbl(
275: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
276: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
277: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
278: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
279: x_return_status OUT NOCOPY VARCHAR2 );
280:

Line 283: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

279: x_return_status OUT NOCOPY VARCHAR2 );
280:
281: /* Added p_trx_rec for ER 2581101 */
282: PROCEDURE get_ii_relation_tbl(
283: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
284: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
285: p_trx_rec IN csi_datastructures_pub.transaction_rec,
286: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
287: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

Line 284: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

280:
281: /* Added p_trx_rec for ER 2581101 */
282: PROCEDURE get_ii_relation_tbl(
283: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
284: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
285: p_trx_rec IN csi_datastructures_pub.transaction_rec,
286: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
287: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
288: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

Line 299: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

295: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
296: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
297: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
298: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
299: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
300: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
301: x_return_status OUT NOCOPY VARCHAR2 );
302:
303: PROCEDURE cascade_txn_dtls(

Line 300: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

296: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
297: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
298: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
299: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
300: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
301: x_return_status OUT NOCOPY VARCHAR2 );
302:
303: PROCEDURE cascade_txn_dtls(
304: p_source_trx_id IN NUMBER,

Line 315: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

311: x_party_id OUT NOCOPY NUMBER,
312: x_return_status OUT NOCOPY VARCHAR2);
313:
314: PROCEDURE get_party_owner(
315: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
316: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
317: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
318: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
319: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

Line 316: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

312: x_return_status OUT NOCOPY VARCHAR2);
313:
314: PROCEDURE get_party_owner(
315: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
316: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
317: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
318: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
319: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
320: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

Line 317: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

313:
314: PROCEDURE get_party_owner(
315: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
316: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
317: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
318: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
319: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
320: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

Line 333: p_txn_ii_rltns_tbl in csi_t_datastructures_grp.txn_ii_rltns_tbl,

329: x_return_status OUT NOCOPY varchar2);
330:
331: PROCEDURE call_contracts_chk(
332: p_txn_line_detail_id in number,
333: p_txn_ii_rltns_tbl in csi_t_datastructures_grp.txn_ii_rltns_tbl,
334: x_call_contracts OUT NOCOPY varchar2,
335: x_return_status OUT NOCOPY varchar2);
336:
337: PROCEDURE get_item_control_rec(

Line 344: p_xtn_ii_rltns_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,

340: x_return_status OUT NOCOPY varchar2);
341:
342: ---Added (Start) for m-to-m enhancements
343: PROCEDURE rltns_xfaced_to_IB (
344: p_xtn_ii_rltns_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
345: x_xface_to_IB_flag OUT NOCOPY VARCHAR2,
346: x_return_status OUT NOCOPY VARCHAR2);
347:
348: PROCEDURE build_txn_relations (

Line 349: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,

345: x_xface_to_IB_flag OUT NOCOPY VARCHAR2,
346: x_return_status OUT NOCOPY VARCHAR2);
347:
348: PROCEDURE build_txn_relations (
349: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,
350: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
351: x_return_status OUT NOCOPY VARCHAR2) ;
352:
353:

Line 350: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

346: x_return_status OUT NOCOPY VARCHAR2);
347:
348: PROCEDURE build_txn_relations (
349: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,
350: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
351: x_return_status OUT NOCOPY VARCHAR2) ;
352:
353:
354: PROCEDURE get_partner_rltns (

Line 355: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,

351: x_return_status OUT NOCOPY VARCHAR2) ;
352:
353:
354: PROCEDURE get_partner_rltns (
355: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
356: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
357: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
358: x_return_status OUT NOCOPY VARCHAR2) ;
359: ---Added (End) for m-to-m enhancements

Line 356: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

352:
353:
354: PROCEDURE get_partner_rltns (
355: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
356: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
357: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
358: x_return_status OUT NOCOPY VARCHAR2) ;
359: ---Added (End) for m-to-m enhancements
360:

Line 357: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

353:
354: PROCEDURE get_partner_rltns (
355: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
356: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
357: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
358: x_return_status OUT NOCOPY VARCHAR2) ;
359: ---Added (End) for m-to-m enhancements
360:
361: PROCEDURE build_parent_relation (

Line 364: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

360:
361: PROCEDURE build_parent_relation (
362: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
363: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
364: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
365: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
366: x_return_status OUT NOCOPY VARCHAR2);
367:
368: PROCEDURE build_child_relation(

Line 365: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

361: PROCEDURE build_parent_relation (
362: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
363: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
364: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
365: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
366: x_return_status OUT NOCOPY VARCHAR2);
367:
368: PROCEDURE build_child_relation(
369: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

Line 370: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

366: x_return_status OUT NOCOPY VARCHAR2);
367:
368: PROCEDURE build_child_relation(
369: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
370: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
371: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
372: x_return_status OUT NOCOPY varchar2);
373:
374: PROCEDURE get_ib_trackable_children(

Line 388: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

384: x_return_status OUT NOCOPY varchar2);
385:
386: PROCEDURE get_parties_and_accounts(
387: p_instance_id IN number,
388: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
389: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
390: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
391: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
392: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,

Line 389: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

385:
386: PROCEDURE get_parties_and_accounts(
387: p_instance_id IN number,
388: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
389: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
390: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
391: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
392: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
393: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

Line 390: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

386: PROCEDURE get_parties_and_accounts(
387: p_instance_id IN number,
388: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
389: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
390: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
391: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
392: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
393: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
394: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,