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_BILLING_PUB dependencies on OKS_USG_QP_CALL_TBL

Line 424: --Procedure to insert data into OKS_USG_QP_CALL_TBL for calling QP in bulk

420:
421: END Create_subline_for_report;
422:
423: --------------------------------------------------------------
424: --Procedure to insert data into OKS_USG_QP_CALL_TBL for calling QP in bulk
425: --skuchima 05-Jan-2012 Bug 13105205 Ceredian ER
426: --------------------------------------------------------------
427: Procedure Insert_usg_qp_dtls_prc
428: (p_detail_rec in oks_qp_pkg.input_details,

Line 445: Insert into oks_usg_qp_call_tbl(

441: pragma autonomous_transaction;
442:
443: Begin
444:
445: Insert into oks_usg_qp_call_tbl(
446: price_list ,
447: price_list_line_id,
448: chr_id ,
449: line_id ,

Line 1380: l_msg_data := 'Error inserting data into oks_usg_qp_call_tbl '||SQLERRM;

1376: l_amount
1377: );
1378: Exception
1379: WHEN OTHERS THEN
1380: l_msg_data := 'Error inserting data into oks_usg_qp_call_tbl '||SQLERRM;
1381: Raise USAGE_EXCEPTION;
1382:
1383: END;
1384:

Line 1479: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1475: If p_prv=1 Then
1476:
1477: Delete from OKS_BILL_SUB_LINE_DTLS
1478: where bsl_id in
1479: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1480:
1481: Delete from OKS_BILL_SUB_LINES
1482: where id in
1483: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

Line 1483: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1479: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1480:
1481: Delete from OKS_BILL_SUB_LINES
1482: where id in
1483: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1484:
1485: Delete from OKS_BILL_CONT_LINES
1486: where id in
1487: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

Line 1487: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1483: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1484:
1485: Delete from OKS_BILL_CONT_LINES
1486: where id in
1487: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1488:
1489: UPDATE oks_level_elements
1490: SET date_completed = null
1491: WHERE id in

Line 1492: (select level_element_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1488:
1489: UPDATE oks_level_elements
1490: SET date_completed = null
1491: WHERE id in
1492: (select level_element_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1493:
1494: UPDATE oks_level_elements
1495: SET date_completed = null
1496: WHERE id in

Line 1497: (select level_coverage_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1493:
1494: UPDATE oks_level_elements
1495: SET date_completed = null
1496: WHERE id in
1497: (select level_coverage_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1498:
1499: Else
1500:
1501: Delete from OKS_BSD_PR

Line 1503: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1499: Else
1500:
1501: Delete from OKS_BSD_PR
1502: where bsl_id in
1503: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1504:
1505: Delete from OKS_BSL_PR
1506: where id in
1507: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

Line 1507: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1503: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1504:
1505: Delete from OKS_BSL_PR
1506: where id in
1507: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1508:
1509: Delete from OKS_BCL_PR
1510: where id in
1511: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

Line 1511: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);

1507: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1508:
1509: Delete from OKS_BCL_PR
1510: where id in
1511: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1512:
1513: end if;
1514:
1515: Exception

Line 1727: FROM oks_usg_qp_call_tbl;

1723:
1724:
1725: CURSOR bulk_qp_hdr_id_csr is
1726: SELECT distinct dnz_chr_id
1727: FROM oks_usg_qp_call_tbl;
1728:
1729: CURSOR bulk_qp_call_csr(p_chr_id IN number) is
1730: SELECT price_list ,
1731: price_list_line_id,

Line 1755: FROM oks_usg_qp_call_tbl

1751: usg_bcl_id ,
1752: level_element_id,
1753: level_coverage_id ,
1754: amount
1755: FROM oks_usg_qp_call_tbl
1756: WHERE dnz_chr_id=p_chr_id;
1757:
1758: CURSOR usage_line_csr (p_dnz_chr_id IN number) is
1759: SELECT DISTINCT line_id,currency_code

Line 1760: FROM oks_usg_qp_call_tbl

1756: WHERE dnz_chr_id=p_chr_id;
1757:
1758: CURSOR usage_line_csr (p_dnz_chr_id IN number) is
1759: SELECT DISTINCT line_id,currency_code
1760: FROM oks_usg_qp_call_tbl
1761: WHERE dnz_Chr_id=p_dnz_chr_id;
1762:
1763: CURSOR bsl_cur (p_line_id IN NUMBER,p_dnz_chr_id IN number) is
1764: SELECT *

Line 1765: FROM oks_usg_qp_call_tbl

1761: WHERE dnz_Chr_id=p_dnz_chr_id;
1762:
1763: CURSOR bsl_cur (p_line_id IN NUMBER,p_dnz_chr_id IN number) is
1764: SELECT *
1765: FROM oks_usg_qp_call_tbl
1766: WHERE dnz_Chr_id=p_dnz_chr_id
1767: AND line_id=p_line_id;
1768:
1769: l_subline_id NUMBER;

Line 2032: update oks_usg_qp_call_tbl

2028: );
2029:
2030:
2031:
2032: update oks_usg_qp_call_tbl
2033: set line_index=g_line_tbl_ctr+1
2034: WHERE bsl_id= bulk_qp_call_rec.bsl_id;
2035:
2036: l_visit_cnt:=l_visit_cnt+1;

Line 3506: SELECT Count(DISTINCT line_id) INTO p_reject_counter FROM oks_usg_qp_call_tbl WHERE dnz_chr_id= bulk_qp_hdr_id_rec.DNZ_chr_id;

3502:
3503: EXCEPTION
3504: WHEN Bulk_contract_EXCEPTION THEN
3505: Rollback_usg_bill_dtls_prc(null,bulk_qp_hdr_id_rec.DNZ_chr_id,l_prv);
3506: SELECT Count(DISTINCT line_id) INTO p_reject_counter FROM oks_usg_qp_call_tbl WHERE dnz_chr_id= bulk_qp_hdr_id_rec.DNZ_chr_id;
3507: RETCODE := 1;
3508:
3509: WHEN OTHERS THEN
3510: Rollback_usg_bill_dtls_prc(null,bulk_qp_hdr_id_rec.DNZ_chr_id,l_prv);

Line 3511: SELECT Count(DISTINCT line_id) INTO p_reject_counter FROM oks_usg_qp_call_tbl WHERE dnz_chr_id= bulk_qp_hdr_id_rec.DNZ_chr_id;

3507: RETCODE := 1;
3508:
3509: WHEN OTHERS THEN
3510: Rollback_usg_bill_dtls_prc(null,bulk_qp_hdr_id_rec.DNZ_chr_id,l_prv);
3511: SELECT Count(DISTINCT line_id) INTO p_reject_counter FROM oks_usg_qp_call_tbl WHERE dnz_chr_id= bulk_qp_hdr_id_rec.DNZ_chr_id;
3512: RETCODE := 1;
3513:
3514: END;
3515: