APPS.CSI_JAVA_INTERFACE_PKG dependencies on CSI_SEARCH_OKS_TEMP

Line 559: l_search_oks_temp csi_search_oks_temp%ROWTYPE;

555: l_debug_level NUMBER;
556:
557: l_Seq Number;
558: l_Creation_Date DATE ;
559: l_search_oks_temp csi_search_oks_temp%ROWTYPE;
560: l_found BOOLEAN;
561:
562: Cursor c_search_oks_temp IS
563: Select *

Line 564: From csi_search_oks_temp

560: l_found BOOLEAN;
561:
562: Cursor c_search_oks_temp IS
563: Select *
564: From csi_search_oks_temp
565: Where creation_date < sysdate
566: and rownum <= 1
567: For Update NoWait;
568:

Line 596: DELETE csi_search_oks_temp

592: /*-- Purging Temp Table before Further Operation bug 4736062-- */
593: OPEN c_search_oks_temp;
594: FETCH c_search_oks_temp INTO l_search_oks_temp;
595: IF c_search_oks_temp%FOUND THEN
596: DELETE csi_search_oks_temp
597: WHERE creation_date < sysdate -1;
598: END IF;
599: CLOSE c_search_oks_temp;
600: --- End changes for bug 4736062

Line 631: SELECT csi_search_oks_temp_S.NEXTVAL, sysdate

627:
628: l_rec_count := l_ent_contracts.FIRST;
629:
630: IF l_rec_count > 0 THEN
631: SELECT csi_search_oks_temp_S.NEXTVAL, sysdate
632: INTO l_Seq, l_Creation_Date
633: FROM dual;
634: x_sequence_id := l_Seq;
635: END IF;

Line 657: Insert into csi_search_oks_temp

653: ELSE
654: x_coverage_tbl(1).covered_level_code := l_ent_contracts(l_rec_count).coverage_level_code;
655: END IF;
656:
657: Insert into csi_search_oks_temp
658: (
659: id,
660: creation_date,
661: covered_level_id,

Line 2031: DELETE csi_search_oks_temp where id = p_sequence_id ;

2027: ( p_count => x_msg_count,
2028: p_data => x_msg_data
2029: );
2030: ELSE
2031: DELETE csi_search_oks_temp where id = p_sequence_id ;
2032: COMMIT;
2033: END IF;
2034:
2035: EXCEPTION