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.OKC_CONTRACT_APPROVAL_PVT dependencies on OKC_CONTRACT_PUB

Line 351: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;

347: L_PAR_VALUE VARCHAR2(2000);
348: --
349: L_NLS_VALUE VARCHAR2(30);
350: --
351: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
352: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
353: l_msg_count NUMBER;
354: l_msg_data VARCHAR2(2000);
355: l_err_name VARCHAR2(30);

Line 352: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;

348: --
349: L_NLS_VALUE VARCHAR2(30);
350: --
351: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
352: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
353: l_msg_count NUMBER;
354: l_msg_data VARCHAR2(2000);
355: l_err_name VARCHAR2(30);
356: l_err_stack VARCHAR2(2000);

Line 574: ' OKC_CONTRACT_PUB.update_contract_process L1_CPSV_REC.PROCESS_ID=>'||L1_CPSV_REC.PROCESS_ID);

570: end;
571: L1_CPSV_REC.PROCESS_ID := L_KEY;
572: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
574: ' OKC_CONTRACT_PUB.update_contract_process L1_CPSV_REC.PROCESS_ID=>'||L1_CPSV_REC.PROCESS_ID);
575: END IF;
576: OKC_CONTRACT_PUB.update_contract_process(
577: p_api_version => l_api_version,
578: x_return_status => l_return_status,

Line 576: OKC_CONTRACT_PUB.update_contract_process(

572: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
574: ' OKC_CONTRACT_PUB.update_contract_process L1_CPSV_REC.PROCESS_ID=>'||L1_CPSV_REC.PROCESS_ID);
575: END IF;
576: OKC_CONTRACT_PUB.update_contract_process(
577: p_api_version => l_api_version,
578: x_return_status => l_return_status,
579: x_msg_count => l_msg_count,
580: x_msg_data => l_msg_data,

Line 585: ' OKC_CONTRACT_PUB.update_contract_process x_return_status=>'||l_return_status);

581: p_cpsv_rec => L1_CPSV_REC,
582: x_cpsv_rec => L2_CPSV_REC);
583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.after',
585: ' OKC_CONTRACT_PUB.update_contract_process x_return_status=>'||l_return_status);
586: END IF;
587: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
588: rollback to BECAUSE_OF_BUG_IN_lock;
589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1715: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1711: p_contract_id IN number,
1712: p_date_approved IN date ,
1713: x_return_status OUT NOCOPY varchar2
1714: ) is
1715: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1716: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1717: cursor lock_csr(p number) is
1718: select object_version_number , org_id --mmadhavi added org_id for MOAC project
1719: from okc_k_headers_all_b

Line 1716: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1712: p_date_approved IN date ,
1713: x_return_status OUT NOCOPY varchar2
1714: ) is
1715: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1716: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1717: cursor lock_csr(p number) is
1718: select object_version_number , org_id --mmadhavi added org_id for MOAC project
1719: from okc_k_headers_all_b
1720: where ID = p

Line 1755: OKC_CONTRACT_PUB.lock_contract_header(

1751: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(p_org_id => L1_header_rec.org_id) ;
1752: --
1753: --end npalepu
1754:
1755: OKC_CONTRACT_PUB.lock_contract_header(
1756: p_api_version => l_api_version,
1757: x_return_status => x_return_status,
1758: x_msg_count => l_msg_count,
1759: x_msg_data => l_msg_data,

Line 1770: --npalepu moved the context setting code to above the OKC_CONTRACT_PUB.lock_contract_header API.

1766:
1767: --update
1768: L1_header_rec.date_approved := p_date_approved;
1769:
1770: --npalepu moved the context setting code to above the OKC_CONTRACT_PUB.lock_contract_header API.
1771: --for bug # 4775848 on 02-DEC-2005.
1772: /*--/Rules Migration/
1773: --Set context before validation, new rules columns require context for validations
1774: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(p_org_id => L1_header_rec.org_id) ;

Line 1778: OKC_CONTRACT_PUB.update_contract_header(

1774: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(p_org_id => L1_header_rec.org_id) ;
1775: --*/
1776: --end npalepu
1777:
1778: OKC_CONTRACT_PUB.update_contract_header(
1779: p_api_version => l_api_version,
1780: x_return_status => x_return_status,
1781: p_init_msg_list => OKC_API.G_TRUE,
1782: x_msg_count => l_msg_count,

Line 1838: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1834: procedure k_erase_approved(
1835: p_contract_id IN number,
1836: x_return_status OUT NOCOPY VARCHAR2
1837: ) is
1838: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1839: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1840: dummy varchar2(1) := '?';
1841: cursor c1 is
1842: select '!'

Line 1839: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1835: p_contract_id IN number,
1836: x_return_status OUT NOCOPY VARCHAR2
1837: ) is
1838: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1839: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1840: dummy varchar2(1) := '?';
1841: cursor c1 is
1842: select '!'
1843: from okc_k_headers_all_b

Line 1885: OKC_CONTRACT_PUB.lock_contract_header(

1881: L1_header_rec.id := p_contract_id;
1882: open lock_csr(p_contract_id);
1883: fetch lock_csr into L1_header_rec.object_version_number;
1884: close lock_csr;
1885: OKC_CONTRACT_PUB.lock_contract_header(
1886: p_api_version => l_api_version,
1887: x_return_status => x_return_status,
1888: x_msg_count => l_msg_count,
1889: x_msg_data => l_msg_data,

Line 1899: OKC_CONTRACT_PUB.update_contract_header(

1895: END IF;
1896:
1897: --update
1898: L1_header_rec.date_approved := NULL;
1899: OKC_CONTRACT_PUB.update_contract_header(
1900: p_api_version => l_api_version,
1901: x_return_status => x_return_status,
1902: x_msg_count => l_msg_count,
1903: x_msg_data => l_msg_data,

Line 1965: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1962: l_msg_count NUMBER;
1963: l_msg_data varchar2(2000);
1964:
1965: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1966: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1967: --Bug:3675868 fetch sts_code to set L1_header_rec.old_sts_code
1968: cursor lock_csr(p number) is
1969: select object_version_number, START_DATE, END_DATE, sts_code, scs_code

Line 1966: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1962: l_msg_count NUMBER;
1963: l_msg_data varchar2(2000);
1964:
1965: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1966: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1967: --Bug:3675868 fetch sts_code to set L1_header_rec.old_sts_code
1968: cursor lock_csr(p number) is
1969: select object_version_number, START_DATE, END_DATE, sts_code, scs_code
1970: from okc_k_headers_all_b

Line 2010: l1_lines okc_contract_pub.clev_tbl_type;

2006: --
2007: loc1_rec lock1_csr%ROWTYPE;
2008: i number :=0;
2009: --
2010: l1_lines okc_contract_pub.clev_tbl_type;
2011: l2_lines okc_contract_pub.clev_tbl_type;
2012: l3_lines okc_contract_pub.clev_tbl_type;
2013: --
2014: call_time varchar2(1);

Line 2011: l2_lines okc_contract_pub.clev_tbl_type;

2007: loc1_rec lock1_csr%ROWTYPE;
2008: i number :=0;
2009: --
2010: l1_lines okc_contract_pub.clev_tbl_type;
2011: l2_lines okc_contract_pub.clev_tbl_type;
2012: l3_lines okc_contract_pub.clev_tbl_type;
2013: --
2014: call_time varchar2(1);
2015:

Line 2012: l3_lines okc_contract_pub.clev_tbl_type;

2008: i number :=0;
2009: --
2010: l1_lines okc_contract_pub.clev_tbl_type;
2011: l2_lines okc_contract_pub.clev_tbl_type;
2012: l3_lines okc_contract_pub.clev_tbl_type;
2013: --
2014: call_time varchar2(1);
2015:
2016: begin

Line 2052: ' OKC_CONTRACT_PUB.lock_contract_header');

2048: L1_header_rec.object_version_number,L1_header_rec.START_DATE,L1_header_rec.END_DATE,L1_header_rec.old_sts_code,l_scs_code;
2049: close lock_csr;
2050: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2051: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2052: ' OKC_CONTRACT_PUB.lock_contract_header');
2053: END IF;
2054: OKC_CONTRACT_PUB.lock_contract_header(
2055: p_api_version => l_api_version,
2056: x_return_status => x_return_status,

Line 2054: OKC_CONTRACT_PUB.lock_contract_header(

2050: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2051: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2052: ' OKC_CONTRACT_PUB.lock_contract_header');
2053: END IF;
2054: OKC_CONTRACT_PUB.lock_contract_header(
2055: p_api_version => l_api_version,
2056: x_return_status => x_return_status,
2057: x_msg_count => l_msg_count,
2058: x_msg_data => l_msg_data,

Line 2062: ' OKC_CONTRACT_PUB.lock_contract_header(x_return_status=>'||x_return_status||')');

2058: x_msg_data => l_msg_data,
2059: p_chrv_rec => L1_header_rec);
2060: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2061: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2062: ' OKC_CONTRACT_PUB.lock_contract_header(x_return_status=>'||x_return_status||')');
2063: END IF;
2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2114: 'OKC_CONTRACT_PUB.update_contract_header');

2110: L1_header_rec.STS_CODE := l_new_status;
2111:
2112: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2113: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2114: 'OKC_CONTRACT_PUB.update_contract_header');
2115: END IF;
2116: OKC_CONTRACT_PUB.update_contract_header(
2117: p_api_version => l_api_version,
2118: x_return_status => x_return_status,

Line 2116: OKC_CONTRACT_PUB.update_contract_header(

2112: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2113: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2114: 'OKC_CONTRACT_PUB.update_contract_header');
2115: END IF;
2116: OKC_CONTRACT_PUB.update_contract_header(
2117: p_api_version => l_api_version,
2118: x_return_status => x_return_status,
2119: x_msg_count => l_msg_count,
2120: x_msg_data => l_msg_data,

Line 2131: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status=>'||x_return_status||')');

2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2131: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status=>'||x_return_status||')');
2132: END IF;
2133:
2134:
2135:

Line 2142: --Note: When we call OKC_CONTRACT_PUB.update_contract_line, there is some logic

2138:
2139: --for service contracts directly update the status of all lines in the contract
2140: --using the exact same logic to derive sts_code
2141:
2142: --Note: When we call OKC_CONTRACT_PUB.update_contract_line, there is some logic
2143: --inside it to call OKC_KL_STS_CHG_ASMBLR_PVT.Acn_Assemble, action assembler
2144: --for line status change. However, currently this call is not made because
2145: --we never pass values for old/new sts/ste_code.
2146:

Line 2193: OKC_CONTRACT_PUB.lock_contract_line(

2189: l2_lines(i).id := lock1_rec.id;
2190: l2_lines(i).object_version_number := lock1_rec.object_version_number;
2191: l2_lines(i).sts_code := lock1_rec.sts_code;
2192: end LOOP;
2193: OKC_CONTRACT_PUB.lock_contract_line(
2194: p_api_version => l_api_version,
2195: x_return_status => x_return_status,
2196: x_msg_count => l_msg_count,
2197: x_msg_data => l_msg_data,

Line 2207: 'OKC_CONTRACT_PUB.update_contract_line');

2203: END IF;
2204:
2205: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2206: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2207: 'OKC_CONTRACT_PUB.update_contract_line');
2208: END IF;
2209: -- update lines
2210: OKC_CONTRACT_PUB.update_contract_line(
2211: p_api_version => l_api_version,

Line 2210: OKC_CONTRACT_PUB.update_contract_line(

2206: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2207: 'OKC_CONTRACT_PUB.update_contract_line');
2208: END IF;
2209: -- update lines
2210: OKC_CONTRACT_PUB.update_contract_line(
2211: p_api_version => l_api_version,
2212: x_return_status => x_return_status,
2213: x_msg_count => l_msg_count,
2214: x_msg_data => l_msg_data,

Line 2220: 'OKC_CONTRACT_PUB.update_contract_line(x_return_status=>'||x_return_status||')');

2216: p_clev_tbl => l2_lines,
2217: x_clev_tbl => l3_lines);
2218: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2219: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2220: 'OKC_CONTRACT_PUB.update_contract_line(x_return_status=>'||x_return_status||')');
2221: END IF;
2222: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2224: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2388: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

2384: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2385: l_msg_count NUMBER;
2386: l_msg_data varchar2(2000);
2387: --
2388: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
2389: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
2390:
2391: cursor lock_csr is
2392: select object_version_number

Line 2389: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

2385: l_msg_count NUMBER;
2386: l_msg_data varchar2(2000);
2387: --
2388: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
2389: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
2390:
2391: cursor lock_csr is
2392: select object_version_number
2393: from okc_k_headers_all_b

Line 2420: OKC_CONTRACT_PUB.lock_contract_header(

2416: open lock_csr;
2417: fetch lock_csr into
2418: L1_header_rec.object_version_number;
2419: close lock_csr;
2420: OKC_CONTRACT_PUB.lock_contract_header(
2421: p_api_version => l_api_version,
2422: x_return_status => x_return_status,
2423: x_msg_count => l_msg_count,
2424: x_msg_data => l_msg_data,

Line 2436: OKC_CONTRACT_PUB.update_contract_header(

2432:
2433:
2434: L1_header_rec.STS_CODE := l_active_status;
2435:
2436: OKC_CONTRACT_PUB.update_contract_header(
2437: p_api_version => l_api_version,
2438: x_return_status => x_return_status,
2439: x_msg_count => l_msg_count,
2440: x_msg_data => l_msg_data,