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 2327: from oks_k_headers_b

2323: ,quote_to_email_id
2324: ,quote_to_phone_id
2325: ,quote_to_fax_id
2326: ,object_version_number
2327: from oks_k_headers_b
2328: where chr_id=p_chr_id;
2329:
2330: CURSOR get_toplines(p_chr_id number) IS
2331: SELECT id,object_version_number

Line 2608: FROM oks_k_headers_b

2604: ORDER BY lines.id;
2605: /*
2606: CURSOR Hdr_Billsch_type(p_chr_id NUMBER) IS
2607: SELECT billing_schedule_type
2608: FROM oks_k_headers_b
2609: where chr_id =p_chr_id;
2610: */
2611: -- Added for price lock project.
2612: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS

Line 2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;

2732: FROM okc_k_headers_b
2733: WHERE id = p_new_chr_id;
2734:
2735: -- New Variables
2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2737: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2738: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2739: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2740: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;

Line 2737: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;

2733: WHERE id = p_new_chr_id;
2734:
2735: -- New Variables
2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2737: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2738: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2739: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2740: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2741: l_period_start_equal VARCHAR2(1) := 'Y';

Line 2738: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;

2734:
2735: -- New Variables
2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2737: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2738: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2739: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2740: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2741: l_period_start_equal VARCHAR2(1) := 'Y';
2742:

Line 2739: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;

2735: -- New Variables
2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2737: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2738: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2739: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2740: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2741: l_period_start_equal VARCHAR2(1) := 'Y';
2742:
2743: -- End for partial periods --

Line 2740: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;

2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;
2737: l_new_period_start OKS_K_HEADERS_B.period_start%TYPE;
2738: l_old_period_type OKS_K_HEADERS_B.period_type%TYPE;
2739: l_old_period_start OKS_K_HEADERS_B.period_start%TYPE;
2740: l_price_uom OKS_K_HEADERS_B.price_uom%TYPE;
2741: l_period_start_equal VARCHAR2(1) := 'Y';
2742:
2743: -- End for partial periods --
2744:

Line 3773: FROM OKS_K_HEADERS_B

3769: ,QUOTE_TO_SITE_ID
3770: ,QUOTE_TO_EMAIL_ID
3771: ,QUOTE_TO_PHONE_ID
3772: ,QUOTE_TO_FAX_ID
3773: FROM OKS_K_HEADERS_B
3774: WHERE chr_id = p_chr_id;
3775:
3776: Cursor get_org_values IS
3777: SELECT inv_organization_id,

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

4250: WHERE dnz_chr_ID=p_chr_Id
4251: And cle_id Is Null;
4252:
4253: CURSOR get_oks_hdr(p_chr_id number) IS
4254: select id from oks_k_headers_b where chr_id = p_chr_id;
4255:
4256: cursor topline_csr(p_chr_id number) is
4257: select a.id, a.lse_id
4258: from okc_k_lines_b a