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_SETUP_UTIL_PUB dependencies on OKS_K_HEADERS_B

Line 86: from oks_k_headers_b

82: ,cc_expiry_date
83: ,cc_bank_acct_id
84: ,cc_auth_code
85: ,object_version_number
86: from oks_k_headers_b
87: where chr_id=p_chr_id;
88:
89: get_ccr_rec get_ccr%rowtype;
90: l_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;

Line 280: -- Purpose: This procedure copies header attributes from the old cont-- ract and creates a row in the OKS_K_HEADERS_B table

276: END IF;
277: END ;
278: -------------------------------------------------------------------------------
279: -- Procedure: copy_hdr_attr
280: -- Purpose: This procedure copies header attributes from the old cont-- ract and creates a row in the OKS_K_HEADERS_B table
281: -- In Parameters: p_chr_id the contract id
282: -- p_new_chr_id new contract id
283: -- Out Parameters: x_return_status standard return status
284: -----------------------------------------------------------------------------

Line 304: FROM oks_k_headers_b

300: x_khrv_tbl OKS_KHR_PVT.khrv_tbl_type;
301:
302: CURSOR get_hdr_attr_csr (p_chr_id NUMBER) IS
303: SELECT *
304: FROM oks_k_headers_b
305: WHERE chr_id = p_chr_id;
306:
307: l_api_name CONSTANT VARCHAR2(30) := 'copy_hdr_attr';
308: l_module_name VARCHAR2(256) := G_APP_NAME ||'.plsql.' || G_PKG_NAME || '.' || l_api_name;

Line 2318: from oks_k_headers_b

2314: ,quote_to_email_id
2315: ,quote_to_phone_id
2316: ,quote_to_fax_id
2317: ,object_version_number
2318: from oks_k_headers_b
2319: where chr_id=p_chr_id;
2320:
2321: CURSOR get_toplines(p_chr_id number) IS
2322: SELECT id,object_version_number

Line 2599: FROM oks_k_headers_b

2595: ORDER BY lines.id;
2596: /*
2597: CURSOR Hdr_Billsch_type(p_chr_id NUMBER) IS
2598: SELECT billing_schedule_type
2599: FROM oks_k_headers_b
2600: where chr_id =p_chr_id;
2601: */
2602: -- Added for price lock project.
2603: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS

Line 2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;

2723: FROM okc_k_headers_b
2724: WHERE id = p_new_chr_id;
2725:
2726: -- New Variables
2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2728: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2729: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2730: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2731: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;

Line 2728: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;

2724: WHERE id = p_new_chr_id;
2725:
2726: -- New Variables
2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2728: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2729: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2730: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2731: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2732: l_period_start_equal VARCHAR2(1) := 'Y';

Line 2729: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;

2725:
2726: -- New Variables
2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2728: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2729: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2730: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2731: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2732: l_period_start_equal VARCHAR2(1) := 'Y';
2733:

Line 2730: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;

2726: -- New Variables
2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2728: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2729: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2730: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2731: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2732: l_period_start_equal VARCHAR2(1) := 'Y';
2733:
2734: -- End for partial periods --

Line 2731: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;

2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2728: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2729: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2730: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2731: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2732: l_period_start_equal VARCHAR2(1) := 'Y';
2733:
2734: -- End for partial periods --
2735:

Line 3764: FROM OKS_K_HEADERS_B

3760: ,QUOTE_TO_SITE_ID
3761: ,QUOTE_TO_EMAIL_ID
3762: ,QUOTE_TO_PHONE_ID
3763: ,QUOTE_TO_FAX_ID
3764: FROM OKS_K_HEADERS_B
3765: WHERE chr_id = p_chr_id;
3766:
3767: Cursor get_org_values IS
3768: SELECT inv_organization_id,

Line 4245: select id from oks_k_headers_b where chr_id = p_chr_id;

4241: WHERE dnz_chr_ID=p_chr_Id
4242: And cle_id Is Null;
4243:
4244: CURSOR get_oks_hdr(p_chr_id number) IS
4245: select id from oks_k_headers_b where chr_id = p_chr_id;
4246:
4247: cursor topline_csr(p_chr_id number) is
4248: select a.id, a.lse_id
4249: from okc_k_lines_b a