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_CONTRACT_HDR_PUB dependencies on OKC_API

Line 49: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_khrv_tbl IN khrv_tbl_type,
48: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
49: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
50: p_validate_yn IN VARCHAR2) IS
51: BEGIN
52: x_return_status := G_RET_STS_SUCCESS;
53: IF p_validate_yn = 'Y' THEN

Line 160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_khrv_tbl IN khrv_tbl_type,
159: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
161: p_validate_yn IN VARCHAR2) IS
162: BEGIN
163: x_return_status := G_RET_STS_SUCCESS;
164: IF p_validate_yn = 'Y' THEN

Line 253: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_khrv_tbl IN khrv_tbl_type,
253: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
254: BEGIN
255: oks_khr_pvt.lock_row
256: (
257: p_api_version => p_api_version,

Line 312: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_khrv_tbl IN khrv_tbl_type,
312: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
313: BEGIN
314: oks_khr_pvt.delete_row
315: (
316: p_api_version => p_api_version,

Line 363: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_khrv_tbl IN khrv_tbl_type,
363: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
364: BEGIN
365: x_return_status := G_RET_STS_SUCCESS;
366: END validate_header;
367:

Line 388: OKC_API.init_msg_list(p_init_msg_list);

384: x_msg_data OUT NOCOPY VARCHAR2,
385: p_chr_id IN NUMBER,
386: p_major_version IN NUMBER) IS
387: BEGIN
388: OKC_API.init_msg_list(p_init_msg_list);
389: x_return_status := G_RET_STS_SUCCESS;
390:
391: -- Versioning OKS_K_HEADERS_B
392: -- Inserting single record

Line 842: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

838: );
839:
840: EXCEPTION
841: WHEN OTHERS THEN
842: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
843: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
844: p_msg_name => G_UNEXPECTED_ERROR,
845: p_token1 => G_SQLCODE_TOKEN,
846: p_token1_value => SQLCODE,

Line 843: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

839:
840: EXCEPTION
841: WHEN OTHERS THEN
842: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
843: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
844: p_msg_name => G_UNEXPECTED_ERROR,
845: p_token1 => G_SQLCODE_TOKEN,
846: p_token1_value => SQLCODE,
847: p_token2 => G_SQLERRM_TOKEN,

Line 886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

882: p_major_version => l_major_version
883: );
884: EXCEPTION
885: WHEN invalid_version THEN
886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
887: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
888: p_msg_name => G_UNEXPECTED_ERROR,
889: p_token1 => G_SQLCODE_TOKEN,
890: p_token1_value => SQLCODE,

Line 887: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

883: );
884: EXCEPTION
885: WHEN invalid_version THEN
886: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
887: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
888: p_msg_name => G_UNEXPECTED_ERROR,
889: p_token1 => G_SQLCODE_TOKEN,
890: p_token1_value => SQLCODE,
891: p_token2 => G_SQLERRM_TOKEN,

Line 895: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

891: p_token2 => G_SQLERRM_TOKEN,
892: p_token2_value => SQLERRM
893: );
894: WHEN OTHERS THEN
895: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
896: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => G_UNEXPECTED_ERROR,
898: p_token1 => G_SQLCODE_TOKEN,
899: p_token1_value => SQLCODE,

Line 896: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

892: p_token2_value => SQLERRM
893: );
894: WHEN OTHERS THEN
895: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
896: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => G_UNEXPECTED_ERROR,
898: p_token1 => G_SQLCODE_TOKEN,
899: p_token1_value => SQLCODE,
900: p_token2 => G_SQLERRM_TOKEN,

Line 943: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

939: p_major_version => - 1
940: );
941: EXCEPTION
942: WHEN OTHERS THEN
943: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
944: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
945: p_msg_name => G_UNEXPECTED_ERROR,
946: p_token1 => G_SQLCODE_TOKEN,
947: p_token1_value => SQLCODE,

Line 944: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

940: );
941: EXCEPTION
942: WHEN OTHERS THEN
943: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
944: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
945: p_msg_name => G_UNEXPECTED_ERROR,
946: p_token1 => G_SQLCODE_TOKEN,
947: p_token1_value => SQLCODE,
948: p_token2 => G_SQLERRM_TOKEN,

Line 961: OKC_API.init_msg_list(p_init_msg_list);

957: x_msg_count OUT NOCOPY NUMBER,
958: x_msg_data OUT NOCOPY VARCHAR2,
959: p_chr_id IN NUMBER) IS
960: BEGIN
961: OKC_API.init_msg_list(p_init_msg_list);
962: x_return_status := G_RET_STS_SUCCESS;
963: DELETE oks_k_lines_tlh
964: WHERE id IN
965: (SELECT id FROM oks_k_lines_bh

Line 989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

985: );
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
990: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
991: p_msg_name => G_UNEXPECTED_ERROR,
992: p_token1 => G_SQLCODE_TOKEN,
993: p_token1_value => SQLCODE,

Line 990: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
990: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
991: p_msg_name => G_UNEXPECTED_ERROR,
992: p_token1 => G_SQLCODE_TOKEN,
993: p_token1_value => SQLCODE,
994: p_token2 => G_SQLERRM_TOKEN,

Line 1025: OKC_API.init_msg_list(p_init_msg_list);

1021: x_msg_count OUT NOCOPY NUMBER,
1022: x_msg_data OUT NOCOPY VARCHAR2,
1023: p_chr_id IN NUMBER) IS
1024: BEGIN
1025: OKC_API.init_msg_list(p_init_msg_list);
1026: x_return_status := G_RET_STS_SUCCESS;
1027:
1028: DELETE oks_k_lines_tl
1029: WHERE id IN

Line 1485: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1481: );
1482:
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1486: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1487: p_msg_name => G_UNEXPECTED_ERROR,
1488: p_token1 => G_SQLCODE_TOKEN,
1489: p_token1_value => SQLCODE,

Line 1486: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1482:
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1486: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1487: p_msg_name => G_UNEXPECTED_ERROR,
1488: p_token1 => G_SQLCODE_TOKEN,
1489: p_token1_value => SQLCODE,
1490: p_token2 => G_SQLERRM_TOKEN,

Line 1503: OKC_API.init_msg_list(p_init_msg_list);

1499: x_msg_count OUT NOCOPY NUMBER,
1500: x_msg_data OUT NOCOPY VARCHAR2,
1501: p_chr_id IN NUMBER) IS
1502: BEGIN
1503: OKC_API.init_msg_list(p_init_msg_list);
1504: x_return_status := G_RET_STS_SUCCESS;
1505: DELETE oks_k_lines_tlh
1506: WHERE id IN
1507: (SELECT id FROM oks_k_lines_bh

Line 1528: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1524: );
1525:
1526: EXCEPTION
1527: WHEN OTHERS THEN
1528: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1529: p_msg_name => G_UNEXPECTED_ERROR,
1530: p_token1 => G_SQLCODE_TOKEN,
1531: p_token1_value => SQLCODE,
1532: p_token2 => G_SQLERRM_TOKEN,

Line 1535: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1531: p_token1_value => SQLCODE,
1532: p_token2 => G_SQLERRM_TOKEN,
1533: p_token2_value => SQLERRM
1534: );
1535: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1536: END delete_history;
1537:
1538: ---------------------------------------------------------------
1539: -- Procedure for mass insert in OKS_K_HEADERS_B table

Line 1638: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1634: j NUMBER;
1635:
1636: BEGIN
1637: -- Initialize return status
1638: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1639:
1640: i := p_khrv_tbl.FIRST; j := 0;
1641: WHILE i IS NOT NULL
1642: LOOP

Line 1915: OKC_API.SET_MESSAGE(

1911: EXCEPTION
1912: WHEN OTHERS THEN
1913:
1914: -- store SQL error message on message stack
1915: OKC_API.SET_MESSAGE(
1916: p_app_name => G_APP_NAME,
1917: p_msg_name => G_UNEXPECTED_ERROR,
1918: p_token1 => G_SQLCODE_TOKEN,
1919: p_token1_value => SQLCODE,

Line 1923: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1919: p_token1_value => SQLCODE,
1920: p_token2 => G_SQLERRM_TOKEN,
1921: p_token2_value => SQLERRM);
1922: -- notify caller of an error as UNEXPETED error
1923: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1924: --RAISE;
1925: END INSERT_ROW_UPG;
1926:
1927: ---------------------------------------------------------------

Line 2029: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2025:
2026:
2027: BEGIN
2028: -- Initialize return status
2029: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2030:
2031: i := p_khrhv_tbl.FIRST;
2032: j := 0;
2033:

Line 2319: OKC_API.SET_MESSAGE(

2315:
2316: EXCEPTION
2317: WHEN OTHERS THEN
2318: -- store SQL error message on message stack
2319: OKC_API.SET_MESSAGE(
2320: p_app_name => G_APP_NAME,
2321: p_msg_name => G_UNEXPECTED_ERROR,
2322: p_token1 => G_SQLCODE_TOKEN,
2323: p_token1_value => SQLCODE,

Line 2327: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2323: p_token1_value => SQLCODE,
2324: p_token2 => G_SQLERRM_TOKEN,
2325: p_token2_value => SQLERRM);
2326: -- notify caller of an error as UNEXPETED error
2327: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2328:
2329: END CREATE_HDR_VERSION_UPG;
2330:
2331: