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 85: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 94: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

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

Line 95: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl

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

Line 96: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec

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

Line 104: ( x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec

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

Line 116: ( p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 213: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 240: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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

Line 262: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,

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

Line 266: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

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

Line 267: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

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

Line 273: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

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

Line 274: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

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

Line 281: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

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

Line 282: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 297: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 298: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

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

Line 313: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

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

Line 314: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

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

Line 315: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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

Line 331: p_txn_ii_rltns_tbl in csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 342: p_xtn_ii_rltns_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,

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

Line 347: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,

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

Line 348: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 353: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,

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

Line 354: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 355: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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

Line 362: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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

Line 363: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

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

Line 368: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

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

Line 386: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

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

Line 387: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

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

Line 388: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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