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.OKL_CONTRACT_STATUS_PVT dependencies on OKC_K_LINES_B

Line 29: TYPE clev_tbl_id_type IS TABLE OF OKC_K_LINES_B.ID%TYPE INDEX BY BINARY_INTEGER;

25: G_API_VERSION CONSTANT NUMBER := 1.0;
26: G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';
27: G_BULK_BATCH_SIZE CONSTANT NUMBER := 10000;
28:
29: TYPE clev_tbl_id_type IS TABLE OF OKC_K_LINES_B.ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE clev_tbl_sts_type IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE clev_tbl_start_date_type IS TABLE OF OKC_K_LINES_B.START_DATE%TYPE INDEX BY BINARY_INTEGER;
32: TYPE clev_tbl_end_date_type IS TABLE OF OKC_K_LINES_B.END_DATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE clev_tbl_currency_code_type IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 30: TYPE clev_tbl_sts_type IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE INDEX BY BINARY_INTEGER;

26: G_SCOPE CONSTANT VARCHAR2(4) := '_PVT';
27: G_BULK_BATCH_SIZE CONSTANT NUMBER := 10000;
28:
29: TYPE clev_tbl_id_type IS TABLE OF OKC_K_LINES_B.ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE clev_tbl_sts_type IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE clev_tbl_start_date_type IS TABLE OF OKC_K_LINES_B.START_DATE%TYPE INDEX BY BINARY_INTEGER;
32: TYPE clev_tbl_end_date_type IS TABLE OF OKC_K_LINES_B.END_DATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE clev_tbl_currency_code_type IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
34:

Line 31: TYPE clev_tbl_start_date_type IS TABLE OF OKC_K_LINES_B.START_DATE%TYPE INDEX BY BINARY_INTEGER;

27: G_BULK_BATCH_SIZE CONSTANT NUMBER := 10000;
28:
29: TYPE clev_tbl_id_type IS TABLE OF OKC_K_LINES_B.ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE clev_tbl_sts_type IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE clev_tbl_start_date_type IS TABLE OF OKC_K_LINES_B.START_DATE%TYPE INDEX BY BINARY_INTEGER;
32: TYPE clev_tbl_end_date_type IS TABLE OF OKC_K_LINES_B.END_DATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE clev_tbl_currency_code_type IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
34:
35: -- GLOBAL VARIABLES

Line 32: TYPE clev_tbl_end_date_type IS TABLE OF OKC_K_LINES_B.END_DATE%TYPE INDEX BY BINARY_INTEGER;

28:
29: TYPE clev_tbl_id_type IS TABLE OF OKC_K_LINES_B.ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE clev_tbl_sts_type IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE clev_tbl_start_date_type IS TABLE OF OKC_K_LINES_B.START_DATE%TYPE INDEX BY BINARY_INTEGER;
32: TYPE clev_tbl_end_date_type IS TABLE OF OKC_K_LINES_B.END_DATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE clev_tbl_currency_code_type IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
34:
35: -- GLOBAL VARIABLES
36: -----------------------------------------------------------------------------------

Line 33: TYPE clev_tbl_currency_code_type IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

29: TYPE clev_tbl_id_type IS TABLE OF OKC_K_LINES_B.ID%TYPE INDEX BY BINARY_INTEGER;
30: TYPE clev_tbl_sts_type IS TABLE OF OKC_K_LINES_B.STS_CODE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE clev_tbl_start_date_type IS TABLE OF OKC_K_LINES_B.START_DATE%TYPE INDEX BY BINARY_INTEGER;
32: TYPE clev_tbl_end_date_type IS TABLE OF OKC_K_LINES_B.END_DATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE clev_tbl_currency_code_type IS TABLE OF OKC_K_LINES_B.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
34:
35: -- GLOBAL VARIABLES
36: -----------------------------------------------------------------------------------
37:

Line 509: FROM OKC_K_LINES_B

505: SELECT STS_CODE,
506: ID,
507: START_DATE,
508: END_DATE
509: FROM OKC_K_LINES_B
510: WHERE DNZ_CHR_ID = p_chr_id;
511:
512: l_kle_sts OKC_K_LINES_B.STS_CODE%TYPE;
513: l_kle_id OKC_K_LINES_B.ID%TYPE;

Line 512: l_kle_sts OKC_K_LINES_B.STS_CODE%TYPE;

508: END_DATE
509: FROM OKC_K_LINES_B
510: WHERE DNZ_CHR_ID = p_chr_id;
511:
512: l_kle_sts OKC_K_LINES_B.STS_CODE%TYPE;
513: l_kle_id OKC_K_LINES_B.ID%TYPE;
514: l_kle_start_date OKC_K_LINES_B.START_DATE%TYPE;
515: l_kle_end_date OKC_K_LINES_B.END_DATE%TYPE;
516:

Line 513: l_kle_id OKC_K_LINES_B.ID%TYPE;

509: FROM OKC_K_LINES_B
510: WHERE DNZ_CHR_ID = p_chr_id;
511:
512: l_kle_sts OKC_K_LINES_B.STS_CODE%TYPE;
513: l_kle_id OKC_K_LINES_B.ID%TYPE;
514: l_kle_start_date OKC_K_LINES_B.START_DATE%TYPE;
515: l_kle_end_date OKC_K_LINES_B.END_DATE%TYPE;
516:
517: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses

Line 514: l_kle_start_date OKC_K_LINES_B.START_DATE%TYPE;

510: WHERE DNZ_CHR_ID = p_chr_id;
511:
512: l_kle_sts OKC_K_LINES_B.STS_CODE%TYPE;
513: l_kle_id OKC_K_LINES_B.ID%TYPE;
514: l_kle_start_date OKC_K_LINES_B.START_DATE%TYPE;
515: l_kle_end_date OKC_K_LINES_B.END_DATE%TYPE;
516:
517: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
518: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS

Line 515: l_kle_end_date OKC_K_LINES_B.END_DATE%TYPE;

511:
512: l_kle_sts OKC_K_LINES_B.STS_CODE%TYPE;
513: l_kle_id OKC_K_LINES_B.ID%TYPE;
514: l_kle_start_date OKC_K_LINES_B.START_DATE%TYPE;
515: l_kle_end_date OKC_K_LINES_B.END_DATE%TYPE;
516:
517: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
518: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS
519: SELECT ste_code

Line 539: p_currency_code IN OKC_K_LINES_B.CURRENCY_CODE%TYPE,

535: p_kle_start_date IN DATE,
536: p_khr_start_date IN DATE,
537: p_kle_end_date IN DATE,
538: p_khr_end_date IN DATE,
539: p_currency_code IN OKC_K_LINES_B.CURRENCY_CODE%TYPE,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2) is
543:

Line 544: l_start_date OKC_K_LINES_B.START_DATE%TYPE;

540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2) is
543:
544: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
545: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
546:
547: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
548: x_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 545: l_end_date OKC_K_LINES_B.END_DATE%TYPE;

541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2) is
543:
544: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
545: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
546:
547: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
548: x_clev_rec okl_okc_migration_pvt.clev_rec_type;
549:

Line 757: l_last_update_date okc_k_lines_b.last_update_date%type;

753: l_api_name CONSTANT VARCHAR2(30) := 'CASCADE_CONTRACT_STATUS';
754: l_api_version CONSTANT NUMBER := 1;
755: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
756: l_application_id fnd_application_vl.application_id%type;
757: l_last_update_date okc_k_lines_b.last_update_date%type;
758: l_last_updated_by okc_k_lines_b.last_updated_by%type;
759: l_last_update_login okc_k_lines_b.last_update_login%type;
760: begin
761: null;

Line 758: l_last_updated_by okc_k_lines_b.last_updated_by%type;

754: l_api_version CONSTANT NUMBER := 1;
755: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
756: l_application_id fnd_application_vl.application_id%type;
757: l_last_update_date okc_k_lines_b.last_update_date%type;
758: l_last_updated_by okc_k_lines_b.last_updated_by%type;
759: l_last_update_login okc_k_lines_b.last_update_login%type;
760: begin
761: null;
762:

Line 759: l_last_update_login okc_k_lines_b.last_update_login%type;

755: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
756: l_application_id fnd_application_vl.application_id%type;
757: l_last_update_date okc_k_lines_b.last_update_date%type;
758: l_last_updated_by okc_k_lines_b.last_updated_by%type;
759: l_last_update_login okc_k_lines_b.last_update_login%type;
760: begin
761: null;
762:
763: x_return_status := OKL_API.START_ACTIVITY(

Line 788: update okc_k_lines_b

784: l_last_updated_by := fnd_global.user_id;
785: l_last_update_login := fnd_global.login_id;
786:
787: forall i in p_clev_id_tbl.first..p_clev_id_tbl.last
788: update okc_k_lines_b
789: set sts_code = p_clev_sts_tbl(i),
790: start_date = p_clev_start_date_tbl(i),
791: end_date = p_clev_end_date_tbl(i),
792: currency_code = p_clev_curr_code_tbl(i),

Line 850: FROM OKC_K_LINES_B A,

846: SELECT A.STS_CODE,
847: A.ID,
848: A.START_DATE,
849: A.END_DATE
850: FROM OKC_K_LINES_B A,
851: OKC_STATUSES_B B
852: WHERE A.DNZ_CHR_ID = p_chr_id
853: AND A.STS_CODE = B.CODE
854: AND B.STE_CODE not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 861: FROM OKC_K_LINES_B A

857: SELECT A.STS_CODE,
858: A.ID,
859: A.START_DATE,
860: A.END_DATE
861: FROM OKC_K_LINES_B A
862: WHERE A.DNZ_CHR_ID = p_chr_id
863: AND NOT EXISTS (select 'x' from OKC_STATUSES_B B where B.CODE = A.STS_CODE);
864: */
865: