APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on OKC_STATUSES_B

Line 1982: select code from okc_statuses_b

1978: l_scs_code VARCHAR2(30);
1979: l_sysdate DATE;
1980:
1981: cursor c1 is
1982: select code from okc_statuses_b
1983: where ste_code='SIGNED'
1984: and default_yn='Y';
1985: cursor c2 is
1986: select code from okc_statuses_b

Line 1986: select code from okc_statuses_b

1982: select code from okc_statuses_b
1983: where ste_code='SIGNED'
1984: and default_yn='Y';
1985: cursor c2 is
1986: select code from okc_statuses_b
1987: where ste_code='ACTIVE'
1988: and default_yn='Y';
1989: cursor c3 is
1990: select code from okc_statuses_b

Line 1990: select code from okc_statuses_b

1986: select code from okc_statuses_b
1987: where ste_code='ACTIVE'
1988: and default_yn='Y';
1989: cursor c3 is
1990: select code from okc_statuses_b
1991: where ste_code='EXPIRED'
1992: and default_yn='Y';
1993: --
1994: cursor lock1_csr is

Line 2001: , okc_statuses_b S

1997: decode(sign(months_between(p_date_signed-1,sysdate)),-1,
1998: decode(sign(months_between(L.start_date-1,sysdate)),-1,
1999: l_active_status,l_signed_status),l_signed_status),l_expired_status) STS_CODE
2000: from okc_k_lines_b L
2001: , okc_statuses_b S
2002: where L.dnz_chr_id = p_contract_id
2003: and S.code = L.sts_code
2004: and S.ste_code='ENTERED'
2005: ;

Line 2098: from okc_statuses_b

2094:
2095: --Bug:3675868 set L1_header_rec.old_ste_code
2096: select ste_code
2097: into L1_header_rec.old_ste_code
2098: from okc_statuses_b
2099: where code = L1_header_rec.old_sts_code;
2100:
2101: --Bug:3675868 set L1_header_rec.new_ste_code
2102: select ste_code

Line 2104: from okc_statuses_b

2100:
2101: --Bug:3675868 set L1_header_rec.new_ste_code
2102: select ste_code
2103: into L1_header_rec.new_ste_code
2104: from okc_statuses_b
2105: where code = l_new_status;
2106:
2107: --Bug:3675868 set L1_header_rec.new_sts_code
2108: L1_header_rec.new_sts_code := l_new_status;

Line 2169: FROM okc_k_lines_b l, okc_statuses_b s

2165: team has suggested to modify the product code in order to handle the error through bug12402762*/
2166:
2167: /*commented the below UPDATE statement and modified as per ATG suggestion
2168: UPDATE (SELECT l.sts_code, l.start_date, l.end_date, l.last_update_date, l.last_update_login, l.Last_updated_by
2169: FROM okc_k_lines_b l, okc_statuses_b s
2170: WHERE l.dnz_chr_id = p_contract_id
2171: AND s.code = l.sts_code
2172: AND s.ste_code = 'ENTERED') oks
2173: SET

Line 2196: FROM okc_statuses_b

2192: oks.last_update_date = l_sysdate,
2193: oks.last_update_login = FND_GLOBAL.LOGIN_ID,
2194: oks.last_updated_by = FND_GLOBAL.USER_ID
2195: WHERE oks.sts_code IN (SELECT code
2196: FROM okc_statuses_b
2197: WHERE ste_code = 'ENTERED');
2198:
2199: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2200: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',