[Home] [Help]
608: begin
609:
610: csi_t_gen_utility_pvt.dump_api_info(
611: p_api_name => 'insert_row',
612: p_pkg_name => 'csi_t_txn_line_details_pkg');
613:
614: csi_t_txn_line_details_pkg.insert_row(
615: px_txn_line_detail_id => l_txn_line_detail_id,
616: p_transaction_line_id => p_txn_line_dtl_rec.transaction_line_id,
610: csi_t_gen_utility_pvt.dump_api_info(
611: p_api_name => 'insert_row',
612: p_pkg_name => 'csi_t_txn_line_details_pkg');
613:
614: csi_t_txn_line_details_pkg.insert_row(
615: px_txn_line_detail_id => l_txn_line_detail_id,
616: p_transaction_line_id => p_txn_line_dtl_rec.transaction_line_id,
617: p_sub_type_id => p_txn_line_dtl_rec.sub_type_id,
618: p_instance_exists_flag => p_txn_line_dtl_rec.instance_exists_flag,
694: exception
695: when others then
696: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
697: fnd_message.set_token('MESSAGE',
698: 'csi_t_txn_line_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
699: fnd_msg_pub.add;
700: raise fnd_api.g_exc_error;
701: end;
702:
954: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
955: l_msg_count NUMBER;
956: l_msg_data VARCHAR2(2000);
957:
958: l_td_rec csi_t_txn_line_details%ROWTYPE;
959: l_valid BOOLEAN;
960: l_creation_flag VARCHAR2(1) := 'N';
961: l_preserve_detail_flag varchar2(1);
962: l_found VARCHAR2(1) ;
963: l_src_transaction_type_id NUMBER;
964:
965: CURSOR td_cur (p_line_dtl_id in number) IS
966: SELECT *
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;
1648:
1649: /* I have to do this update statement here because all the child entities
1650: are processed before the txn line detail is updated */
1651:
1652: update csi_t_txn_line_details
1653: set instance_id = l_td_rec.instance_id,
1654: instance_exists_flag = l_td_rec.instance_exists_flag
1655: where txn_line_detail_id = l_td_rec.txn_line_detail_id;
1656:
2076: begin
2077:
2078: csi_t_gen_utility_pvt.dump_api_info(
2079: p_api_name => 'update_row',
2080: p_pkg_name => 'csi_t_txn_line_details_pkg');
2081:
2082: csi_t_txn_line_details_pkg.update_row(
2083: p_txn_line_detail_id => l_td_rec.txn_line_detail_id,
2084: p_transaction_line_id => l_td_rec.transaction_line_id,
2078: csi_t_gen_utility_pvt.dump_api_info(
2079: p_api_name => 'update_row',
2080: p_pkg_name => 'csi_t_txn_line_details_pkg');
2081:
2082: csi_t_txn_line_details_pkg.update_row(
2083: p_txn_line_detail_id => l_td_rec.txn_line_detail_id,
2084: p_transaction_line_id => l_td_rec.transaction_line_id,
2085: p_sub_type_id => l_td_rec.sub_type_id,
2086: p_instance_exists_flag => l_td_rec.instance_exists_flag,
2162: exception
2163: when others then
2164: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2165: fnd_message.set_token('MESSAGE',
2166: 'csi_t_txn_line_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
2167: fnd_msg_pub.add;
2168: raise fnd_api.g_exc_error;
2169: end;
2170:
3059: ' instance_description , config_inst_baseline_rev_num , reference_source_line_id, '||
3060: ' install_location_type_code,install_location_id, '|| ' cascade_owner_flag, '||
3061: ' parent_instance_id, assc_txn_line_detail_id, '||
3062: ' overriding_csi_txn_id, instance_status_id '||
3063: ' from csi_t_txn_line_details ';
3064:
3065: l_where_clause := null;
3066:
3067: IF nvl(p_txn_line_detail_query_rec.transaction_line_id, fnd_api.g_miss_num) <>
3414: FOR l_ind in p_txn_line_detail_ids_tbl.FIRST..
3415: p_txn_line_detail_ids_tbl.LAST
3416: LOOP
3417:
3418: csi_t_txn_line_details_pkg.delete_row(
3419: p_txn_line_detail_id => p_txn_line_detail_ids_tbl(l_ind).
3420: txn_line_detail_id);
3421:
3422: END LOOP;