DBA Data[Home] [Help]

APPS.CSI_T_TXN_OUS_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 15: p_txn_org_assgn_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_rec,

11: p_api_version IN number,
12: p_commit IN varchar2 := fnd_api.g_false,
13: p_init_msg_list IN varchar2 := fnd_api.g_false,
14: p_validation_level IN number := fnd_api.g_valid_level_full,
15: p_txn_org_assgn_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_rec,
16: x_return_status OUT NOCOPY varchar2,
17: x_msg_count OUT NOCOPY number,
18: x_msg_data OUT NOCOPY varchar2)
19:

Line 237: ,p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl

233: p_api_version IN NUMBER
234: ,p_commit IN VARCHAR2 := fnd_api.g_false
235: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
236: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
237: ,p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl
238: ,x_return_status OUT NOCOPY VARCHAR2
239: ,x_msg_count OUT NOCOPY NUMBER
240: ,x_msg_data OUT NOCOPY VARCHAR2)
241: IS

Line 533: ,p_txn_org_assgn_ids_tbl IN csi_t_datastructures_grp.txn_org_assgn_ids_tbl

529: p_api_version IN NUMBER
530: ,p_commit IN VARCHAR2 := fnd_api.g_false
531: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
532: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
533: ,p_txn_org_assgn_ids_tbl IN csi_t_datastructures_grp.txn_org_assgn_ids_tbl
534: ,x_return_status OUT NOCOPY VARCHAR2
535: ,x_msg_count OUT NOCOPY NUMBER
536: ,x_msg_data OUT NOCOPY VARCHAR2)
537: IS

Line 714: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

710: END delete_txn_org_assgn_dtls;
711:
712: PROCEDURE get_org_assgn_dtls(
713: p_line_dtl_id in number,
714: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
715: x_return_status OUT NOCOPY varchar2)
716: IS
717:
718: l_select_stmt varchar2(2000);

Line 720: l_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;

716: IS
717:
718: l_select_stmt varchar2(2000);
719: l_oa_cur_id integer;
720: l_oa_rec csi_t_datastructures_grp.txn_org_assgn_rec;
721: l_processed_rows number := 0;
722: l_ind binary_integer;
723:
724: BEGIN

Line 813: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

809: END IF;
810: END get_org_assgn_dtls;
811:
812: PROCEDURE get_all_org_assgn_dtls(
813: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
814: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
815: x_return_status OUT NOCOPY varchar2)
816: IS
817: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 814: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

810: END get_org_assgn_dtls;
811:
812: PROCEDURE get_all_org_assgn_dtls(
813: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
814: x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
815: x_return_status OUT NOCOPY varchar2)
816: IS
817: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
818: l_c_ind binary_integer := 0;

Line 819: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

815: x_return_status OUT NOCOPY varchar2)
816: IS
817: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
818: l_c_ind binary_integer := 0;
819: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
820: l_tmp_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
821: BEGIN
822: x_return_status := fnd_api.g_ret_sts_success;
823:

Line 820: l_tmp_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

816: IS
817: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
818: l_c_ind binary_integer := 0;
819: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
820: l_tmp_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
821: BEGIN
822: x_return_status := fnd_api.g_ret_sts_success;
823:
824: IF p_txn_line_detail_tbl.COUNT > 0 THEN