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_EXTWARPRGM_PVT dependencies on OKC_K_HEADERS_B

Line 2492: UPDATE okc_k_headers_b

2488: IF l_sts_code = 'EXPIRED'
2489: THEN
2490: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
2491:
2492: UPDATE okc_k_headers_b
2493: SET sts_code = l_sts_code
2494: WHERE ID = l_chrid;
2495: END IF;
2496:

Line 5702: FROM okc_k_headers_b

5698:
5699: CURSOR l_hdrdates_csr (p_id NUMBER)
5700: IS
5701: SELECT start_date, end_date, sts_code
5702: FROM okc_k_headers_b
5703: WHERE ID = p_id;
5704:
5705: l_hdr_rec k_header_rec_type;
5706: l_line_rec k_line_service_rec_type;

Line 6254: UPDATE okc_k_headers_b

6250: FROM okc_k_lines_b
6251: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
6252: WHERE ID = l_lineid;
6253:
6254: UPDATE okc_k_headers_b
6255: SET estimated_amount =
6256: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
6257: FROM okc_k_lines_b
6258: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))

Line 7300: UPDATE okc_k_headers_b

7296: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
7297: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id)
7298: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
7299:
7300: UPDATE okc_k_headers_b
7301: SET estimated_amount =
7302: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7303: FROM okc_k_lines_b
7304: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id

Line 8193: UPDATE okc_k_headers_b

8189: SET price_negotiated = price_negotiated + l_newamt
8190: WHERE ID = l_lineid;
8191:
8192: -- Update header estimated amount
8193: UPDATE okc_k_headers_b
8194: SET estimated_amount = estimated_amount + l_newamt
8195: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
8196:
8197: -- Update topline tax amount

Line 9242: FROM okc_k_headers_b

9238:
9239: CURSOR l_qa_csr (p_id NUMBER)
9240: IS
9241: SELECT qcl_id
9242: FROM okc_k_headers_b
9243: WHERE ID = p_id;
9244:
9245: CURSOR l_hdrdt_csr (p_hdr_id NUMBER)
9246: IS

Line 9248: FROM okc_k_headers_b

9244:
9245: CURSOR l_hdrdt_csr (p_hdr_id NUMBER)
9246: IS
9247: SELECT start_date, end_date
9248: FROM okc_k_headers_b
9249: WHERE ID = p_hdr_id;
9250:
9251: CURSOR l_srvdt_csr (p_line_id NUMBER)
9252: IS

Line 9281: FROM okc_k_headers_b

9277:
9278: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
9279: IS
9280: SELECT sts_code
9281: FROM okc_k_headers_b
9282: WHERE ID = p_hdr_id;
9283:
9284:
9285: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)

Line 9288: FROM okc_k_headers_b Kh, oks_k_headers_b Ks

9284:
9285: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)
9286: IS
9287: SELECT 'Y'
9288: FROM okc_k_headers_b Kh, oks_k_headers_b Ks
9289: , okc_statuses_b sts
9290: WHERE Kh.ID = p_hdr_id
9291: And Ks.chr_id = Kh.id
9292: And kh.sts_code = sts.code

Line 9954: FROM okc_k_headers_b

9950: END IF;
9951:
9952: SELECT authoring_org_id
9953: INTO l_org_id
9954: FROM okc_k_headers_b
9955: WHERE ID = l_chrid;
9956:
9957: OPEN l_access_csr (p_kdtl_rec.hdr_id);
9958:

Line 10040: FROM okc_k_headers_b kh, okc_statuses_b st

10036:
10037: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
10038: IS
10039: SELECT st.ste_code, kh.sts_code
10040: FROM okc_k_headers_b kh, okc_statuses_b st
10041: WHERE kh.ID = p_hdr_id AND st.code = kh.sts_code;
10042:
10043: -- Fix for bug 3588355
10044: CURSOR l_get_bill_ship_csr (p_cp_id NUMBER)

Line 12419: UPDATE okc_k_headers_b

12415: 0
12416: )
12417: WHERE cle_id = l_merge_line_id;
12418:
12419: UPDATE okc_k_headers_b
12420: SET estimated_amount =
12421: (SELECT NVL
12422: (SUM
12423: (NVL

Line 12546: UPDATE okc_k_headers_b

12542: l_ste_code,
12543: l_sts_code
12544: );
12545:
12546: UPDATE okc_k_headers_b
12547: SET sts_code = l_sts_code,
12548: date_approved = NULL,
12549: date_signed = NULL
12550: WHERE ID = l_merge_chr_id;

Line 12958: UPDATE okc_k_headers_b

12954: 0
12955: )
12956: WHERE cle_id = l_line_id;
12957:
12958: UPDATE okc_k_headers_b
12959: SET estimated_amount =
12960: (SELECT NVL
12961: (SUM
12962: (NVL

Line 13082: UPDATE okc_k_headers_b

13078: l_ste_code,
13079: l_sts_code
13080: );
13081:
13082: UPDATE okc_k_headers_b
13083: SET sts_code = l_sts_code,
13084: date_approved = NULL,
13085: date_signed = NULL
13086: WHERE ID = l_merge_chr_id;

Line 13451: UPDATE okc_k_headers_b

13447: FROM oks_k_lines_b
13448: WHERE cle_id = l_subline_id), 0)
13449: WHERE cle_id = l_line_id;
13450:
13451: UPDATE okc_k_headers_b
13452: SET estimated_amount =
13453: (SELECT NVL (SUM (NVL (price_negotiated,
13454: 0
13455: )

Line 13521: UPDATE okc_k_headers_b

13517: WHERE cle_id = l_line_id
13518: AND dnz_chr_id = l_chr_id)
13519: WHERE id = l_line_id;
13520:
13521: UPDATE okc_k_headers_b
13522: SET estimated_amount = ( SELECT NVL( SUM( NVL(price_negotiated,0) ), 0 )
13523: FROM okc_k_lines_b
13524: WHERE dnz_chr_id = l_chr_id
13525: AND lse_id in (1,19) )

Line 13622: UPDATE okc_k_headers_b

13618: l_ste_code,
13619: l_sts_code
13620: );
13621:
13622: UPDATE okc_k_headers_b
13623: SET sts_code = l_sts_code,
13624: date_approved = NULL,
13625: date_signed = NULL
13626: WHERE ID = l_chr_id;

Line 14647: FROM okc_k_headers_b

14643: -- Cursor to get the line dates and status
14644: CURSOR l_hdrdates_csr (p_id NUMBER)
14645: IS
14646: SELECT start_date, end_date, sts_code
14647: FROM okc_k_headers_b
14648: WHERE ID = p_id;
14649:
14650: --mmadhavi bug 3761489
14651: CURSOR get_oks_line_dtls (p_id NUMBER)

Line 15840: UPDATE okc_k_headers_b

15836: AND lse_id IN (9,25)
15837: AND date_cancelled IS NULL ))
15838: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;
15839:
15840: UPDATE okc_k_headers_b
15841: SET estimated_amount =
15842: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0 )
15843: FROM okc_k_lines_b
15844: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id

Line 16314: UPDATE okc_k_headers_b

16310: AND lse_id IN (9,25)
16311: AND date_cancelled IS NULL ))
16312: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;
16313:
16314: UPDATE okc_k_headers_b
16315: SET estimated_amount =
16316: (SELECT NVL (SUM (NVL (price_negotiated,
16317: 0
16318: )

Line 16527: UPDATE okc_k_headers_b

16523: AND lse_id IN (9,25)
16524: AND date_cancelled IS NULL ))
16525: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;
16526:
16527: UPDATE okc_k_headers_b
16528: SET estimated_amount =
16529: (SELECT NVL (SUM (NVL (price_negotiated,
16530: 0
16531: )