DBA Data[Home] [Help]

APPS.CSI_T_TXN_RLTNSHPS_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 15: p_txn_ii_rltns_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_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_ii_rltns_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_rec,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2)
19:

Line 27: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;

23: l_api_version CONSTANT NUMBER := 1.0;
24: l_debug_level NUMBER;
25: l_txn_relationship_id NUMBER;
26: l_return_status VARCHAR2(1);
27: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
28: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
29: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
30: l_sub_instance_id NUMBER ;
31: l_sub_tld_id NUMBER ;

Line 28: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;

24: l_debug_level NUMBER;
25: l_txn_relationship_id NUMBER;
26: l_return_status VARCHAR2(1);
27: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
28: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
29: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
30: l_sub_instance_id NUMBER ;
31: l_sub_tld_id NUMBER ;
32: l_obj_instance_id NUMBER ;

Line 29: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;

25: l_txn_relationship_id NUMBER;
26: l_return_status VARCHAR2(1);
27: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
28: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
29: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
30: l_sub_instance_id NUMBER ;
31: l_sub_tld_id NUMBER ;
32: l_obj_instance_id NUMBER ;
33: l_obj_tld_id NUMBER ;

Line 476: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

472: p_api_version IN NUMBER,
473: p_commit IN VARCHAR2 := fnd_api.g_false,
474: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
475: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
476: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,
479: x_msg_data OUT NOCOPY VARCHAR2)
480: IS

Line 489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;

485:
486: l_return_status VARCHAR2(1);
487: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead
489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
492: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
493: l_sub_instance_id NUMBER ;

Line 490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;

486: l_return_status VARCHAR2(1);
487: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead
489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
492: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
493: l_sub_instance_id NUMBER ;
494: l_sub_tld_id NUMBER ;

Line 491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;

487: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead
489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
492: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
493: l_sub_instance_id NUMBER ;
494: l_sub_tld_id NUMBER ;
495: l_obj_instance_id NUMBER ;

Line 492: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;

488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead
489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
492: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;
493: l_sub_instance_id NUMBER ;
494: l_sub_tld_id NUMBER ;
495: l_obj_instance_id NUMBER ;
496: l_obj_tld_id NUMBER ;

Line 1024: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl

1020: p_api_version IN NUMBER
1021: ,p_commit IN VARCHAR2 := fnd_api.g_false
1022: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1023: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1024: ,p_txn_ii_rltns_ids_tbl IN csi_t_datastructures_grp.txn_ii_rltns_ids_tbl
1025: ,x_return_status OUT NOCOPY VARCHAR2
1026: ,x_msg_count OUT NOCOPY NUMBER
1027: ,x_msg_data OUT NOCOPY VARCHAR2)
1028:

Line 1196: x_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

1192: END delete_txn_ii_rltns_dtls;
1193:
1194: PROCEDURE get_ii_rltns_dtls(
1195: p_txn_line_id_list in varchar2,
1196: x_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
1197: x_return_status OUT NOCOPY varchar2)
1198: IS
1199:
1200: l_select_stmt varchar2(2000);

Line 1202: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;

1198: IS
1199:
1200: l_select_stmt varchar2(2000);
1201: l_iir_cur_id integer;
1202: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
1203: l_processed_rows number := 0;
1204: l_ind binary_integer;
1205:
1206: BEGIN