eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AUTO_REMINDER dependencies on OKC_STATUSES_B

Line 662: okc_statuses_b s

658: -- bug 5161013 check STE_CODE for the contract
659: CURSOR csr_k_ste_code IS
660: SELECT s.ste_code
661: FROM okc_k_headers_all_b k,
662: okc_statuses_b s
663: WHERE k.sts_code = s.code
664: AND k.id = p_chr_id;
665:
666: l_ste_code okc_statuses_b.ste_code%TYPE;

Line 666: l_ste_code okc_statuses_b.ste_code%TYPE;

662: okc_statuses_b s
663: WHERE k.sts_code = s.code
664: AND k.id = p_chr_id;
665:
666: l_ste_code okc_statuses_b.ste_code%TYPE;
667:
668: BEGIN
669: -- bug 5161013
670: -- check if the STE_CODE of the contract is ENTERED and only then update the status

Line 738: OKC_STATUSES_B sts

734: /*start of bug8345674*/
735: CURSOR c_old_sts is
736: SELECT STS_CODE
737: FROM OKC_K_HEADERS_ALL_B okck,
738: OKC_STATUSES_B sts
739: WHERE id = p_chr_id
740: AND sts.code = okck.sts_code;
741:
742: l_old_sts OKC_STATUSES_B.CODE%TYPE;

Line 742: l_old_sts OKC_STATUSES_B.CODE%TYPE;

738: OKC_STATUSES_B sts
739: WHERE id = p_chr_id
740: AND sts.code = okck.sts_code;
741:
742: l_old_sts OKC_STATUSES_B.CODE%TYPE;
743: /*end of bug8345674*/
744:
745: FUNCTION GET_STATUS(pcode IN VARCHAR2) RETURN VARCHAR2
746: IS

Line 749: SELECT STE_CODE INTO lcode FROM okc_statuses_b WHERE code = pcode;

745: FUNCTION GET_STATUS(pcode IN VARCHAR2) RETURN VARCHAR2
746: IS
747: lcode VARCHAR2(40);
748: BEGIN
749: SELECT STE_CODE INTO lcode FROM okc_statuses_b WHERE code = pcode;
750: RETURN lcode;
751: EXCEPTION
752: WHEN OTHERS THEN
753: RETURN pcode;