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 2541: UPDATE okc_k_headers_b

2537: IF l_sts_code = 'EXPIRED'
2538: THEN
2539: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
2540:
2541: UPDATE okc_k_headers_b
2542: SET sts_code = l_sts_code
2543: WHERE ID = l_chrid;
2544: /*bugfix for 6882512*/
2545: /* Updating the status in okc_contacts table.*/

Line 5870: FROM okc_k_headers_b

5866:
5867: CURSOR l_hdrdates_csr (p_id NUMBER)
5868: IS
5869: SELECT start_date, end_date, sts_code
5870: FROM okc_k_headers_b
5871: WHERE ID = p_id;
5872:
5873: l_hdr_rec k_header_rec_type;
5874: l_line_rec k_line_service_rec_type;

Line 6422: UPDATE okc_k_headers_b

6418: FROM okc_k_lines_b
6419: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
6420: WHERE ID = l_lineid;
6421:
6422: UPDATE okc_k_headers_b
6423: SET estimated_amount =
6424: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
6425: FROM okc_k_lines_b
6426: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))

Line 7481: UPDATE okc_k_headers_b

7477: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
7478: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id)
7479: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
7480:
7481: UPDATE okc_k_headers_b
7482: SET estimated_amount =
7483: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7484: FROM okc_k_lines_b
7485: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id

Line 8411: UPDATE okc_k_headers_b

8407: SET price_negotiated = price_negotiated + l_newamt
8408: WHERE ID = l_lineid;
8409:
8410: -- Update header estimated amount
8411: UPDATE okc_k_headers_b
8412: SET estimated_amount = estimated_amount + l_newamt
8413: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
8414:
8415: -- Update topline tax amount

Line 9473: FROM okc_k_headers_b

9469:
9470: CURSOR l_qa_csr (p_id NUMBER)
9471: IS
9472: SELECT qcl_id
9473: FROM okc_k_headers_b
9474: WHERE ID = p_id;
9475:
9476: CURSOR l_hdrdt_csr (p_hdr_id NUMBER)
9477: IS

Line 9479: FROM okc_k_headers_b

9475:
9476: CURSOR l_hdrdt_csr (p_hdr_id NUMBER)
9477: IS
9478: SELECT start_date, end_date
9479: FROM okc_k_headers_b
9480: WHERE ID = p_hdr_id;
9481:
9482: CURSOR l_srvdt_csr (p_line_id NUMBER)
9483: IS

Line 9512: FROM okc_k_headers_b

9508:
9509: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
9510: IS
9511: SELECT sts_code
9512: FROM okc_k_headers_b
9513: WHERE ID = p_hdr_id;
9514:
9515:
9516: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)

Line 9519: FROM okc_k_headers_b Kh, oks_k_headers_b Ks

9515:
9516: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)
9517: IS
9518: SELECT 'Y'
9519: FROM okc_k_headers_b Kh, oks_k_headers_b Ks
9520: , okc_statuses_b sts
9521: WHERE Kh.ID = p_hdr_id
9522: And Ks.chr_id = Kh.id
9523: And kh.sts_code = sts.code

Line 10202: FROM okc_k_headers_b

10198: END IF;
10199:
10200: SELECT authoring_org_id
10201: INTO l_org_id
10202: FROM okc_k_headers_b
10203: WHERE ID = l_chrid;
10204:
10205: OPEN l_access_csr (p_kdtl_rec.hdr_id);
10206:

Line 10288: FROM okc_k_headers_b kh, okc_statuses_b st

10284:
10285: CURSOR l_hdr_sts_csr (p_hdr_id NUMBER)
10286: IS
10287: SELECT st.ste_code, kh.sts_code
10288: FROM okc_k_headers_b kh, okc_statuses_b st
10289: WHERE kh.ID = p_hdr_id AND st.code = kh.sts_code;
10290:
10291: -- Fix for bug 3588355
10292: CURSOR l_get_bill_ship_csr (p_cp_id NUMBER)

Line 12667: UPDATE okc_k_headers_b

12663: 0
12664: )
12665: WHERE cle_id = l_merge_line_id;
12666:
12667: UPDATE okc_k_headers_b
12668: SET estimated_amount =
12669: (SELECT NVL
12670: (SUM
12671: (NVL

Line 12794: UPDATE okc_k_headers_b

12790: l_ste_code,
12791: l_sts_code
12792: );
12793:
12794: UPDATE okc_k_headers_b
12795: SET sts_code = l_sts_code,
12796: date_approved = NULL,
12797: date_signed = NULL
12798: WHERE ID = l_merge_chr_id;

Line 13214: UPDATE okc_k_headers_b

13210: 0
13211: )
13212: WHERE cle_id = l_line_id;
13213:
13214: UPDATE okc_k_headers_b
13215: SET estimated_amount =
13216: (SELECT NVL
13217: (SUM
13218: (NVL

Line 13338: UPDATE okc_k_headers_b

13334: l_ste_code,
13335: l_sts_code
13336: );
13337:
13338: UPDATE okc_k_headers_b
13339: SET sts_code = l_sts_code,
13340: date_approved = NULL,
13341: date_signed = NULL
13342: WHERE ID = l_merge_chr_id;

Line 13714: UPDATE okc_k_headers_b

13710: FROM oks_k_lines_b
13711: WHERE cle_id = l_subline_id), 0)
13712: WHERE cle_id = l_line_id;
13713:
13714: UPDATE okc_k_headers_b
13715: SET estimated_amount =
13716: (SELECT NVL (SUM (NVL (price_negotiated,
13717: 0
13718: )

Line 13784: UPDATE okc_k_headers_b

13780: WHERE cle_id = l_line_id
13781: AND dnz_chr_id = l_chr_id)
13782: WHERE id = l_line_id;
13783:
13784: UPDATE okc_k_headers_b
13785: SET estimated_amount = ( SELECT NVL( SUM( NVL(price_negotiated,0) ), 0 )
13786: FROM okc_k_lines_b
13787: WHERE dnz_chr_id = l_chr_id
13788: AND lse_id in (1,19) )

Line 13885: UPDATE okc_k_headers_b

13881: l_ste_code,
13882: l_sts_code
13883: );
13884:
13885: UPDATE okc_k_headers_b
13886: SET sts_code = l_sts_code,
13887: date_approved = NULL,
13888: date_signed = NULL
13889: WHERE ID = l_chr_id;

Line 14932: FROM okc_k_headers_b

14928: -- Cursor to get the line dates and status
14929: CURSOR l_hdrdates_csr (p_id NUMBER)
14930: IS
14931: SELECT start_date, end_date, sts_code
14932: FROM okc_k_headers_b
14933: WHERE ID = p_id;
14934:
14935: --mmadhavi bug 3761489
14936: CURSOR get_oks_line_dtls (p_id NUMBER)

Line 16138: UPDATE okc_k_headers_b

16134: AND lse_id IN (9,25)
16135: AND date_cancelled IS NULL ))
16136: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;
16137:
16138: UPDATE okc_k_headers_b
16139: SET estimated_amount =
16140: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0 )
16141: FROM okc_k_lines_b
16142: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id

Line 16612: UPDATE okc_k_headers_b

16608: AND lse_id IN (9,25)
16609: AND date_cancelled IS NULL ))
16610: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;
16611:
16612: UPDATE okc_k_headers_b
16613: SET estimated_amount =
16614: (SELECT NVL (SUM (NVL (price_negotiated,
16615: 0
16616: )

Line 16825: UPDATE okc_k_headers_b

16821: AND lse_id IN (9,25)
16822: AND date_cancelled IS NULL ))
16823: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;
16824:
16825: UPDATE okc_k_headers_b
16826: SET estimated_amount =
16827: (SELECT NVL (SUM (NVL (price_negotiated,
16828: 0
16829: )