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

Line 604: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

600: PROCEDURE get_cust_account(
601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2,
604: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
605: x_cust_acc_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE
606: ) IS
607:
608: l_proc_name VARCHAR2(35) := 'GET_CUST_ACCOUNT';

Line 605: x_cust_acc_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE

601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2,
604: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
605: x_cust_acc_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE
606: ) IS
607:
608: l_proc_name VARCHAR2(35) := 'GET_CUST_ACCOUNT';
609:

Line 610: CURSOR cust_acc_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

606: ) IS
607:
608: l_proc_name VARCHAR2(35) := 'GET_CUST_ACCOUNT';
609:
610: CURSOR cust_acc_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
611: SELECT cust_acct_id
612: FROM okc_k_headers_b
613: WHERE id = p_chr_id;
614:

Line 612: FROM okc_k_headers_b

608: l_proc_name VARCHAR2(35) := 'GET_CUST_ACCOUNT';
609:
610: CURSOR cust_acc_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
611: SELECT cust_acct_id
612: FROM okc_k_headers_b
613: WHERE id = p_chr_id;
614:
615: cust_acc_failed EXCEPTION;
616:

Line 679: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

675: PROCEDURE get_bill_to(
676: x_return_status OUT NOCOPY VARCHAR2,
677: x_msg_count OUT NOCOPY NUMBER,
678: x_msg_data OUT NOCOPY VARCHAR2,
679: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
680: x_bill_to_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE
681: ) IS
682:
683: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';

Line 680: x_bill_to_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE

676: x_return_status OUT NOCOPY VARCHAR2,
677: x_msg_count OUT NOCOPY NUMBER,
678: x_msg_data OUT NOCOPY VARCHAR2,
679: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
680: x_bill_to_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE
681: ) IS
682:
683: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';
684:

Line 685: CURSOR bill_to_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

681: ) IS
682:
683: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';
684:
685: CURSOR bill_to_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
686: SELECT bill_to_site_use_id
687: FROM okc_k_headers_b
688: WHERE id = p_chr_id;
689:

Line 687: FROM okc_k_headers_b

683: l_proc_name VARCHAR2(35) := 'GET_BILL_TO';
684:
685: CURSOR bill_to_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
686: SELECT bill_to_site_use_id
687: FROM okc_k_headers_b
688: WHERE id = p_chr_id;
689:
690: bill_to_failed EXCEPTION;
691:

Line 784: l_bill_to_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;

780: SELECT id
781: FROM okc_process_defs_b
782: WHERE wf_name = p_name;
783:
784: l_bill_to_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;
785:
786: BEGIN
787: IF (G_DEBUG_ENABLED = 'Y') THEN
788: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 1015: l_bill_to_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;

1011: FROM ra_rules
1012: WHERE name = p_name;
1013: */
1014:
1015: l_bill_to_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;
1016: l_cust_acc_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
1017:
1018: BEGIN
1019: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1016: l_cust_acc_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;

1012: WHERE name = p_name;
1013: */
1014:
1015: l_bill_to_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;
1016: l_cust_acc_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
1017:
1018: BEGIN
1019: IF (G_DEBUG_ENABLED = 'Y') THEN
1020: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);