6366: END wip_assy_completion;
6367:
6368:
6369: PROCEDURE build_ii_relation_rec(
6370: p_tiir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6371: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6372: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6373: x_iir_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
6374: x_return_status OUT NOCOPY varchar2)
6367:
6368:
6369: PROCEDURE build_ii_relation_rec(
6370: p_tiir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6371: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6372: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6373: x_iir_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
6374: x_return_status OUT NOCOPY varchar2)
6375: IS
6494: x_return_status := fnd_api.g_ret_sts_error;
6495: END build_ii_relation_rec;
6496:
6497: PROCEDURE update_tld_status(
6498: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6499: x_return_status OUT NOCOPY varchar2)
6500: IS
6501: BEGIN
6502:
6518: IS
6519:
6520: l_wip_entity_name varchar2(80);
6521:
6522: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6523: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6524:
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6519:
6520: l_wip_entity_name varchar2(80);
6521:
6522: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6523: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6524:
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6521:
6522: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6523: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6524:
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6522: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6523: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6524:
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6523: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6524:
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6524:
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6525: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6526: l_tpty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6527: l_tpacct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6528: l_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6536: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6529: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6530: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6536: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6537: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;