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_T_TXN_LINE_DTLS_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 31: p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

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,

Line 32: px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_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,

Line 33: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_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,

Line 34: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

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,

Line 35: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

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)

Line 36: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

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:

Line 58: l_txn_party_rec csi_t_datastructures_grp.txn_party_detail_rec;

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:

Line 59: l_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;

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

Line 60: l_txn_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;

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;

Line 61: l_txn_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;

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;

Line 64: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

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:

Line 938: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

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,

Line 939: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_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,

Line 940: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_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,

Line 941: px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_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,

Line 942: px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

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 ,

Line 943: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

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)

Line 944: px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_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)
948: IS

Line 971: l_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;

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;

Line 973: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;

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

Line 974: l_x_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;

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 *

Line 982: l_iir_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;

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:

Line 983: l_oa_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;

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

Line 992: l_ea_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;

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

Line 1001: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

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;

Line 1002: l_pty_acc_tbl csi_t_datastructures_grp.txn_pty_acct_detail_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;

Line 1005: l_u_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

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;

Line 1008: l_c_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:

Line 1009: l_u_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

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;

Line 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:

Line 1014: l_u_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_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:
1018: l_c_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 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:

Line 1019: l_u_oa_tbl csi_t_datastructures_grp.txn_org_assgn_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:
1023: l_c_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 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:

Line 1024: l_u_ii_tbl csi_t_datastructures_grp.txn_ii_rltns_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:
1028: l_tmp_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 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:

Line 1031: l_tmp_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

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

Line 2605: p_txn_line_query_rec in csi_t_datastructures_grp.txn_line_query_rec,

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

Line 2606: p_txn_line_detail_query_rec in csi_t_datastructures_grp.txn_line_detail_query_rec,

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:

Line 2821: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,

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)

Line 2822: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,

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

Line 2824: x_line_dtls_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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;

Line 2830: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

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:

Line 3028: p_txn_line_detail_query_rec in csi_t_datastructures_grp.txn_line_detail_query_rec,

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

Line 3212: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,

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

Line 3296: p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,

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

Line 3297: p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,

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:

Line 3298: x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

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);

Line 3366: p_txn_line_detail_ids_tbl IN csi_t_datastructures_grp.txn_line_detail_ids_tbl,

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

Line 3476: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,

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:

Line 3486: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

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;

Line 3487: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;

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: