DBA Data[Home] [Help]

APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 32: p_txn_ext_attrib_vals_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_rec,

28: p_api_version IN number,
29: p_commit IN varchar2 := fnd_api.g_false,
30: p_init_msg_list IN varchar2 := fnd_api.g_false,
31: p_validation_level IN number := fnd_api.g_valid_level_full,
32: p_txn_ext_attrib_vals_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_rec,
33: x_return_status OUT NOCOPY varchar2,
34: x_msg_count OUT NOCOPY number,
35: x_msg_data OUT NOCOPY varchar2)
36:

Line 351: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

347: p_api_version IN number,
348: p_commit IN varchar2 := fnd_api.g_false,
349: p_init_msg_list IN varchar2 := fnd_api.g_false,
350: p_validation_level IN number := fnd_api.g_valid_level_full,
351: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
352: x_return_status OUT NOCOPY varchar2,
353: x_msg_count OUT NOCOPY number,
354: x_msg_data OUT NOCOPY varchar2)
355: IS

Line 357: l_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;

353: x_msg_count OUT NOCOPY number,
354: x_msg_data OUT NOCOPY varchar2)
355: IS
356:
357: l_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
358: l_ext_att_id number;
359: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
360:
361: l_api_name CONSTANT varchar2(30) := 'update_txn_ext_attrib_dtls';

Line 365: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;

361: l_api_name CONSTANT varchar2(30) := 'update_txn_ext_attrib_dtls';
362: l_api_version CONSTANT number := 1.0;
363: l_debug_level number;
364: l_return_status varchar2(1);
365: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
366: l_update_ext_attribs BOOLEAN ;
367: l_attribute_id NUMBER ;
368: l_error_msg VARCHAR2(2000);
369:

Line 778: ,p_txn_ext_attrib_ids_tbl IN csi_t_datastructures_grp.txn_ext_attrib_ids_tbl

774: p_api_version IN NUMBER
775: ,p_commit IN VARCHAR2 := fnd_api.g_false
776: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
777: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
778: ,p_txn_ext_attrib_ids_tbl IN csi_t_datastructures_grp.txn_ext_attrib_ids_tbl
779: ,x_return_status OUT NOCOPY VARCHAR2
780: ,x_msg_count OUT NOCOPY NUMBER
781: ,x_msg_data OUT NOCOPY VARCHAR2
782: )

Line 960: x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,

956: END delete_txn_ext_attrib_dtls;
957:
958: PROCEDURE get_csi_ext_attrib_vals(
959: p_instance_id in number,
960: x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
961: x_return_status OUT NOCOPY varchar2)
962: IS
963:
964: l_select_stmt varchar2(2000);

Line 966: l_iea_rec csi_t_datastructures_grp.csi_ext_attrib_vals_rec;

962: IS
963:
964: l_select_stmt varchar2(2000);
965: l_iea_cur_id integer;
966: l_iea_rec csi_t_datastructures_grp.csi_ext_attrib_vals_rec;
967: l_processed_rows number := 0;
968: l_ind binary_integer;
969:
970: BEGIN

Line 1058: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,

1054:
1055: PROCEDURE get_csi_ext_attribs(
1056: p_line_dtl_id in number,
1057: p_instance_id in number,
1058: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
1059: x_return_status OUT NOCOPY varchar2)
1060: IS
1061:
1062: l_select_stmt varchar2(2000);

Line 1065: l_ea_rec csi_t_datastructures_grp.csi_ext_attribs_rec;

1061:
1062: l_select_stmt varchar2(2000);
1063: l_inst_based_stmt varchar2(1000);
1064: l_ea_cur_id integer;
1065: l_ea_rec csi_t_datastructures_grp.csi_ext_attribs_rec;
1066: l_processed_rows number := 0;
1067: l_ind binary_integer;
1068:
1069: BEGIN

Line 1207: x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

1203: END get_csi_ext_attribs;
1204:
1205: PROCEDURE get_ext_attrib_dtls(
1206: p_line_dtl_id in number,
1207: x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1208: x_return_status OUT NOCOPY varchar2)
1209: IS
1210:
1211: l_select_stmt varchar2(2000);

Line 1213: l_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;

1209: IS
1210:
1211: l_select_stmt varchar2(2000);
1212: l_ea_cur_id integer;
1213: l_ea_rec csi_t_datastructures_grp.txn_ext_attrib_vals_rec;
1214: l_processed_rows number := 0;
1215: l_ind binary_integer;
1216:
1217: BEGIN

Line 1312: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

1308: END IF;
1309: END get_ext_attrib_dtls;
1310:
1311: PROCEDURE get_all_csi_ext_attrib_vals(
1312: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
1313: x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
1314: x_return_status OUT NOCOPY varchar2)
1315: IS
1316: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1313: x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,

1309: END get_ext_attrib_dtls;
1310:
1311: PROCEDURE get_all_csi_ext_attrib_vals(
1312: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
1313: x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
1314: x_return_status OUT NOCOPY varchar2)
1315: IS
1316: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1317: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1317: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1313: x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
1314: x_return_status OUT NOCOPY varchar2)
1315: IS
1316: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1317: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1318: l_tmp_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1319: l_c_ind binary_integer := 0;
1320:
1321: BEGIN

Line 1318: l_tmp_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1314: x_return_status OUT NOCOPY varchar2)
1315: IS
1316: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1317: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1318: l_tmp_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1319: l_c_ind binary_integer := 0;
1320:
1321: BEGIN
1322: x_return_status := fnd_api.g_ret_sts_success;

Line 1364: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

1360: x_return_status := fnd_api.g_ret_sts_error;
1361: END get_all_csi_ext_attrib_vals;
1362:
1363: PROCEDURE get_all_csi_ext_attribs(
1364: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
1365: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
1366: x_return_status OUT NOCOPY varchar2)
1367: IS
1368:

Line 1365: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,

1361: END get_all_csi_ext_attrib_vals;
1362:
1363: PROCEDURE get_all_csi_ext_attribs(
1364: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
1365: x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
1366: x_return_status OUT NOCOPY varchar2)
1367: IS
1368:
1369: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1370: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1366: x_return_status OUT NOCOPY varchar2)
1367: IS
1368:
1369: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1370: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1371: l_tmp_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1372: l_c_ind binary_integer := 0;
1373: l_instance_id number := null;
1374:

Line 1371: l_tmp_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1367: IS
1368:
1369: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1370: l_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1371: l_tmp_cea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1372: l_c_ind binary_integer := 0;
1373: l_instance_id number := null;
1374:
1375: BEGIN

Line 1421: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

1417: x_return_status := fnd_api.g_ret_sts_error;
1418: END get_all_csi_ext_attribs;
1419:
1420: PROCEDURE get_all_ext_attrib_dtls(
1421: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
1422: x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1423: x_return_status OUT NOCOPY varchar2)
1424: IS
1425: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1422: x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

1418: END get_all_csi_ext_attribs;
1419:
1420: PROCEDURE get_all_ext_attrib_dtls(
1421: p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
1422: x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
1423: x_return_status OUT NOCOPY varchar2)
1424: IS
1425: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1426: l_c_ind binary_integer := 0;

Line 1427: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1423: x_return_status OUT NOCOPY varchar2)
1424: IS
1425: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1426: l_c_ind binary_integer := 0;
1427: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1428: l_tmp_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1429:
1430: BEGIN
1431: x_return_status := fnd_api.g_ret_sts_success;

Line 1428: l_tmp_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1424: IS
1425: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1426: l_c_ind binary_integer := 0;
1427: l_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1428: l_tmp_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1429:
1430: BEGIN
1431: x_return_status := fnd_api.g_ret_sts_success;
1432: api_log('get_all_ext_attrib_dtls');