APPS.CSI_T_TXN_DETAILS_PVT dependencies on CSI_T_TXN_LINE_DETAILS

Line 1075: FROM csi_t_txn_line_details

1071: BEGIN
1072:
1073: SELECT instance_id
1074: INTO px_txn_line_detail_tbl(i).instance_id
1075: FROM csi_t_txn_line_details
1076: WHERE txn_line_detail_id = px_txn_line_detail_tbl(i).txn_line_detail_id
1077: AND instance_id is NOT null;
1078:
1079: Debug('Instance ID ('||px_txn_line_detail_tbl(i).instance_id||') - Source Txn Type ID ('||

Line 1674: FROM csi_t_txn_line_details

1670:
1671:
1672: CURSOR td_cur IS
1673: SELECT txn_line_detail_id
1674: FROM csi_t_txn_line_details
1675: WHERE transaction_line_id = p_transaction_line_id
1676: AND decode(txn_line_detail_id, p_txn_line_detail_id,p_txn_line_detail_id,-99999)
1677: = nvl(p_txn_line_detail_id,-99999); -- Added for Mass update R12
1678:

Line 1697: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit

1693: /* Added for M-M since transaction line id no longer carries importance now Start */
1694:
1695: CURSOR txn_hdr_cur1 (p_txn_line_dtl_id in number) IS
1696: SELECT csit.transaction_line_id, csii.txn_relationship_id
1697: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit
1698: WHERE csit.txn_line_detail_id = csii.subject_id
1699: AND csii.subject_type = 'T'
1700: AND csii.subject_id in ( SELECT subject_id
1701: FROM csi_t_ii_relationships

Line 1707: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit

1703: AND csii.object_id = p_txn_line_dtl_id ;
1704:
1705: CURSOR txn_hdr_cur2 (p_txn_line_dtl_id in number) IS
1706: SELECT csit.transaction_line_id, csii.txn_relationship_id
1707: FROM csi_t_ii_relationships csii , csi_t_txn_line_details csit
1708: WHERE csit.txn_line_detail_id = csii.object_id
1709: AND csii.object_type = 'T'
1710: AND csii.object_id in ( SELECT object_id
1711: FROM csi_t_ii_relationships

Line 3134: UPDATE csi_t_txn_line_details

3130:
3131: FOR l_ind in l_line_dtl_ids_tbl.FIRST .. l_line_dtl_ids_tbl.LAST
3132: LOOP
3133:
3134: UPDATE csi_t_txn_line_details
3135: SET transaction_line_id = l_txn_line_id
3136: WHERE txn_line_detail_id = l_line_dtl_ids_tbl(l_ind).txn_line_detail_id;
3137:
3138: END LOOP;