27: p_commit IN varchar2 := fnd_api.g_false,
28: p_init_msg_list IN varchar2 := fnd_api.g_false,
29: p_validation_level IN number := fnd_api.g_valid_level_full,
30: p_txn_line_dtl_index IN number,
31: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
28: p_init_msg_list IN varchar2 := fnd_api.g_false,
29: p_validation_level IN number := fnd_api.g_valid_level_full,
30: p_txn_line_dtl_index IN number,
31: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
36: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
29: p_validation_level IN number := fnd_api.g_valid_level_full,
30: p_txn_line_dtl_index IN number,
31: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
36: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
37: x_return_status OUT NOCOPY varchar2,
30: p_txn_line_dtl_index IN number,
31: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
36: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
37: x_return_status OUT NOCOPY varchar2,
38: x_msg_count OUT NOCOPY number,
31: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
36: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
37: x_return_status OUT NOCOPY varchar2,
38: x_msg_count OUT NOCOPY number,
39: x_msg_data OUT NOCOPY varchar2)
32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
36: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
37: x_return_status OUT NOCOPY varchar2,
38: x_msg_count OUT NOCOPY number,
39: x_msg_data OUT NOCOPY varchar2)
40:
54: l_preserve_detail_flag varchar2(1);
55: l_valid boolean := TRUE;
56: l_creation_flag varchar2(1) := 'N';
57:
58: l_txn_party_rec csi_t_datastructures_grp.txn_party_detail_rec;
59: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
60: l_txn_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;
61: l_txn_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
62:
55: l_valid boolean := TRUE;
56: l_creation_flag varchar2(1) := 'N';
57:
58: l_txn_party_rec csi_t_datastructures_grp.txn_party_detail_rec;
59: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
60: l_txn_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;
61: l_txn_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
62:
63: --contact party id variables
56: l_creation_flag varchar2(1) := 'N';
57:
58: l_txn_party_rec csi_t_datastructures_grp.txn_party_detail_rec;
59: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
60: l_txn_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;
61: l_txn_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
62:
63: --contact party id variables
64: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
57:
58: l_txn_party_rec csi_t_datastructures_grp.txn_party_detail_rec;
59: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
60: l_txn_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;
61: l_txn_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
62:
63: --contact party id variables
64: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
65: l_contact_party_id number;
60: l_txn_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;
61: l_txn_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
62:
63: --contact party id variables
64: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
65: l_contact_party_id number;
66: l_cascade_owner_flag varchar2(1);-- bug 2972082
67: l_contact_party_index varchar2(1) := 'N';
68:
934: p_api_version IN NUMBER,
935: p_commit IN VARCHAR2 := fnd_api.g_false,
936: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
937: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
938: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
935: p_commit IN VARCHAR2 := fnd_api.g_false,
936: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
937: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
938: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
936: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
937: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
938: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
944: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
937: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
938: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
944: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
945: x_return_status OUT NOCOPY VARCHAR2,
938: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
944: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
945: x_return_status OUT NOCOPY VARCHAR2,
946: x_msg_count OUT NOCOPY NUMBER ,
939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
944: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
945: x_return_status OUT NOCOPY VARCHAR2,
946: x_msg_count OUT NOCOPY NUMBER ,
947: x_msg_data OUT NOCOPY VARCHAR2)
940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
944: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
945: x_return_status OUT NOCOPY VARCHAR2,
946: x_msg_count OUT NOCOPY NUMBER ,
947: x_msg_data OUT NOCOPY VARCHAR2)
948: IS
967: FROM csi_t_txn_line_details
968: WHERE txn_line_detail_id = p_line_dtl_id;
969:
970: l_instance_party_id csi_i_parties.instance_party_id%TYPE;
971: l_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
972: l_pty_ind binary_integer;
973: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
974: l_x_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
975: l_pty_acc_ind binary_integer;
969:
970: l_instance_party_id csi_i_parties.instance_party_id%TYPE;
971: l_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
972: l_pty_ind binary_integer;
973: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
974: l_x_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
975: l_pty_acc_ind binary_integer;
976:
977: CURSOR pty_cur (p_line_dtl_id in number) IS
970: l_instance_party_id csi_i_parties.instance_party_id%TYPE;
971: l_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
972: l_pty_ind binary_integer;
973: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
974: l_x_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
975: l_pty_acc_ind binary_integer;
976:
977: CURSOR pty_cur (p_line_dtl_id in number) IS
978: SELECT *
978: SELECT *
979: FROM csi_t_party_details
980: WHERE txn_line_detail_id = p_line_dtl_id;
981:
982: l_iir_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
983: l_oa_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
984: l_oa_ind binary_integer;
985: l_instance_ou_id csi_t_org_assignments.instance_ou_id%type;
986:
979: FROM csi_t_party_details
980: WHERE txn_line_detail_id = p_line_dtl_id;
981:
982: l_iir_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
983: l_oa_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
984: l_oa_ind binary_integer;
985: l_instance_ou_id csi_t_org_assignments.instance_ou_id%type;
986:
987: CURSOR oa_cur(p_line_dtl_id in number) IS
988: SELECT *
989: FROM csi_t_org_assignments
990: WHERE txn_line_detail_id = p_line_dtl_id;
991:
992: l_ea_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
993: l_ea_ind binary_integer;
994: l_attrib_source_id csi_t_extend_attribs.attrib_source_id%type;
995:
996: CURSOR ea_cur(p_line_dtl_id in number) IS
997: SELECT *
998: FROM csi_t_extend_attribs
999: WHERE txn_line_detail_id = p_line_dtl_id;
1000:
1001: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1002: l_pty_acc_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1003: l_pty_upd_ind binary_integer;
1004:
1005: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
998: FROM csi_t_extend_attribs
999: WHERE txn_line_detail_id = p_line_dtl_id;
1000:
1001: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1002: l_pty_acc_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1003: l_pty_upd_ind binary_integer;
1004:
1005: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1006: l_u_ea_ind binary_integer;
1001: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1002: l_pty_acc_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1003: l_pty_upd_ind binary_integer;
1004:
1005: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1006: l_u_ea_ind binary_integer;
1007:
1008: l_c_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1009: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1004:
1005: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1006: l_u_ea_ind binary_integer;
1007:
1008: l_c_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1009: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1010: l_c_pty_ind binary_integer;
1011: l_u_pty_ind binary_integer;
1012:
1005: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1006: l_u_ea_ind binary_integer;
1007:
1008: l_c_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1009: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1010: l_c_pty_ind binary_integer;
1011: l_u_pty_ind binary_integer;
1012:
1013: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1009: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1010: l_c_pty_ind binary_integer;
1011: l_u_pty_ind binary_integer;
1012:
1013: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1014: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1015: l_c_pa_ind binary_integer;
1016: l_u_pa_ind binary_integer;
1017:
1010: l_c_pty_ind binary_integer;
1011: l_u_pty_ind binary_integer;
1012:
1013: l_c_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1014: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1015: l_c_pa_ind binary_integer;
1016: l_u_pa_ind binary_integer;
1017:
1018: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1014: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1015: l_c_pa_ind binary_integer;
1016: l_u_pa_ind binary_integer;
1017:
1018: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1019: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1020: l_c_oa_ind binary_integer;
1021: l_u_oa_ind binary_integer;
1022:
1015: l_c_pa_ind binary_integer;
1016: l_u_pa_ind binary_integer;
1017:
1018: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1019: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1020: l_c_oa_ind binary_integer;
1021: l_u_oa_ind binary_integer;
1022:
1023: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1019: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1020: l_c_oa_ind binary_integer;
1021: l_u_oa_ind binary_integer;
1022:
1023: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1024: l_u_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1025: l_c_ii_ind binary_integer;
1026: l_u_ii_ind binary_integer;
1027:
1020: l_c_oa_ind binary_integer;
1021: l_u_oa_ind binary_integer;
1022:
1023: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1024: l_u_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1025: l_c_ii_ind binary_integer;
1026: l_u_ii_ind binary_integer;
1027:
1028: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1024: l_u_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1025: l_c_ii_ind binary_integer;
1026: l_u_ii_ind binary_integer;
1027:
1028: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1029: l_contact_party_id number;
1030: l_contact_party_index VARCHAR2(1) := 'N';
1031: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1032:
1027:
1028: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1029: l_contact_party_id number;
1030: l_contact_party_index VARCHAR2(1) := 'N';
1031: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1032:
1033: BEGIN
1034:
1035: -- Standard Start of API savepoint
2601: END update_txn_line_dtls;
2602:
2603: PROCEDURE bind_query_variables(
2604: p_dtl_qry_cur_id in integer,
2605: p_txn_line_query_rec in csi_t_datastructures_grp.txn_line_query_rec,
2606: p_txn_line_detail_query_rec in csi_t_datastructures_grp.txn_line_detail_query_rec,
2607: x_return_status OUT NOCOPY varchar2)
2608: IS
2609: BEGIN
2602:
2603: PROCEDURE bind_query_variables(
2604: p_dtl_qry_cur_id in integer,
2605: p_txn_line_query_rec in csi_t_datastructures_grp.txn_line_query_rec,
2606: p_txn_line_detail_query_rec in csi_t_datastructures_grp.txn_line_detail_query_rec,
2607: x_return_status OUT NOCOPY varchar2)
2608: IS
2609: BEGIN
2610:
2817:
2818: END bind_query_variables;
2819:
2820: PROCEDURE get_dtls_dynamic(
2821: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
2822: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
2823: p_dtl_select_stmt IN varchar2,
2824: x_line_dtls_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2825: x_return_status OUT NOCOPY varchar2)
2818: END bind_query_variables;
2819:
2820: PROCEDURE get_dtls_dynamic(
2821: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
2822: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
2823: p_dtl_select_stmt IN varchar2,
2824: x_line_dtls_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2825: x_return_status OUT NOCOPY varchar2)
2826: IS
2820: PROCEDURE get_dtls_dynamic(
2821: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
2822: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
2823: p_dtl_select_stmt IN varchar2,
2824: x_line_dtls_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2825: x_return_status OUT NOCOPY varchar2)
2826: IS
2827:
2828: l_dtl_qry_cur_id integer;
2826: IS
2827:
2828: l_dtl_qry_cur_id integer;
2829: l_dtl_qry_cur_rows number;
2830: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2831: l_processed_rows number := 0;
2832: l_ind binary_integer;
2833: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2834:
3024:
3025: END get_dtls_dynamic;
3026:
3027: PROCEDURE build_line_dtls_select(
3028: p_txn_line_detail_query_rec in csi_t_datastructures_grp.txn_line_detail_query_rec,
3029: x_dtl_select_stmt OUT NOCOPY varchar2,
3030: x_dtl_where_clause OUT NOCOPY varchar2,
3031: x_return_status OUT NOCOPY varchar2)
3032: IS
3208:
3209: END build_line_dtls_select;
3210:
3211: PROCEDURE build_txn_lines_select(
3212: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
3213: x_lines_select_stmt OUT NOCOPY varchar2,
3214: x_lines_restrict OUT NOCOPY varchar2,
3215: x_return_status OUT NOCOPY varchar2)
3216: IS
3292: END build_txn_lines_select;
3293:
3294:
3295: PROCEDURE get_txn_line_dtls(
3296: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
3297: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
3298: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3299: x_return_status OUT NOCOPY varchar2)
3300: IS
3293:
3294:
3295: PROCEDURE get_txn_line_dtls(
3296: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
3297: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
3298: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3299: x_return_status OUT NOCOPY varchar2)
3300: IS
3301:
3294:
3295: PROCEDURE get_txn_line_dtls(
3296: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
3297: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
3298: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3299: x_return_status OUT NOCOPY varchar2)
3300: IS
3301:
3302: l_dtl_select_stmt varchar2(32767);
3362: p_api_version IN NUMBER,
3363: p_commit IN VARCHAR2 := fnd_api.g_false,
3364: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3365: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3366: p_txn_line_detail_ids_tbl IN csi_t_datastructures_grp.txn_line_detail_ids_tbl,
3367: x_return_status OUT NOCOPY VARCHAR2,
3368: x_msg_count OUT NOCOPY NUMBER,
3369: x_msg_data OUT NOCOPY VARCHAR2)
3370: IS
3472:
3473: END delete_txn_line_dtls;
3474:
3475: PROCEDURE update_txn_line(
3476: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
3477: x_return_status OUT NOCOPY varchar2)
3478: IS
3479:
3480:
3482: SELECT *
3483: FROM csi_t_transaction_lines
3484: WHERE transaction_line_id = p_txn_line_id;
3485:
3486: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3487: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
3488: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3489: l_api_name varchar2(30) := 'update_txn_line';
3490: l_debug_level number;
3483: FROM csi_t_transaction_lines
3484: WHERE transaction_line_id = p_txn_line_id;
3485:
3486: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3487: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
3488: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3489: l_api_name varchar2(30) := 'update_txn_line';
3490: l_debug_level number;
3491: