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_CONTRACTS_PUB dependencies on OKC_K_REL_OBJS

Line 1510: FROM OKC_K_REL_OBJS

1506: Is
1507:
1508: Cursor l_kexists_csr (p_jtf_id VARCHAR2) is
1509: SELECT Chr_id
1510: FROM OKC_K_REL_OBJS
1511: WHERE OBJECT1_ID1 = P_Object_id
1512: AND jtot_object1_code = p_jtf_id;
1513:
1514: Cursor l_wexists_csr (p_jtf_id VARCHAR2) is

Line 1516: FROM OKC_K_REL_OBJS

1512: AND jtot_object1_code = p_jtf_id;
1513:
1514: Cursor l_wexists_csr (p_jtf_id VARCHAR2) is
1515: SELECT Chr_id
1516: FROM OKC_K_REL_OBJS
1517: WHERE OBJECT1_ID1 = P_Object_id
1518: AND jtot_object1_code = p_jtf_id
1519: AND rty_code = 'CONTRACTWARRANTYORDER';
1520:

Line 2661: l_crjv_tbl_in OKC_K_REL_OBJS_PUB.crjv_tbl_type;

2657:
2658: l_api_version CONSTANT NUMBER := 1.0;
2659: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';
2660: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2661: l_crjv_tbl_in OKC_K_REL_OBJS_PUB.crjv_tbl_type;
2662: l_crjv_tbl_out OKC_K_REL_OBJS_PUB.crjv_tbl_type;
2663:
2664: Begin
2665:

Line 2662: l_crjv_tbl_out OKC_K_REL_OBJS_PUB.crjv_tbl_type;

2658: l_api_version CONSTANT NUMBER := 1.0;
2659: l_init_msg_list CONSTANT VARCHAR2(1) := 'F';
2660: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2661: l_crjv_tbl_in OKC_K_REL_OBJS_PUB.crjv_tbl_type;
2662: l_crjv_tbl_out OKC_K_REL_OBJS_PUB.crjv_tbl_type;
2663:
2664: Begin
2665:
2666: x_return_status := l_return_status;

Line 2675: OKC_K_REL_OBJS_PUB.CREATE_ROW

2671: l_crjv_tbl_in(1).object1_id1 := p_orderhdrid;
2672: l_crjv_tbl_in(1).jtot_object1_code := 'OKX_ORDERHEAD';
2673: l_crjv_tbl_in(1).rty_code := 'CONTRACTSERVICESORDER';
2674:
2675: OKC_K_REL_OBJS_PUB.CREATE_ROW
2676: (
2677: P_API_VERSION => l_api_version,
2678: P_INIT_MSG_LIST => l_init_msg_list,
2679: X_RETURN_STATUS => l_return_status,

Line 2689: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'OKC_k_rel_objs Create row Error');

2685: x_return_status := l_return_status;
2686:
2687: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
2688:
2689: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'OKC_k_rel_objs Create row Error');
2690: Raise G_EXCEPTION_HALT_VALIDATION;
2691: End if;
2692:
2693: ElsIf p_orderlineid Is Not Null Then

Line 2700: OKC_K_REL_OBJS_PUB.CREATE_ROW

2696: l_crjv_tbl_in(1).object1_id1 := p_orderlineid;
2697: l_crjv_tbl_in(1).jtot_object1_code := 'OKX_ORDERLINE';
2698: l_crjv_tbl_in(1).rty_code := 'CONTRACTSERVICESORDER';
2699:
2700: OKC_K_REL_OBJS_PUB.CREATE_ROW
2701: (
2702: P_API_VERSION => l_api_version,
2703: P_INIT_MSG_LIST => l_init_msg_list,
2704: X_RETURN_STATUS => l_return_status,

Line 2713: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'OKC_k_rel_objs Create row Error');

2709: );
2710: x_return_status := l_return_status;
2711: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
2712:
2713: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'OKC_k_rel_objs Create row Error');
2714: Raise G_EXCEPTION_HALT_VALIDATION;
2715: End if;
2716:
2717: End If;

Line 3507: l_crjv_tbl_out OKC_K_REL_OBJS_PUB.crjv_tbl_type;

3503: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;
3504: l_scrv_tbl_out oks_sales_credit_pub.scrv_tbl_type;
3505:
3506: --Obj Rel
3507: l_crjv_tbl_out OKC_K_REL_OBJS_PUB.crjv_tbl_type;
3508:
3509: --Coverage
3510: l_cov_rec OKS_COVERAGES_PUB.ac_rec_type;
3511: