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_OPEN_INTERFACE_PVT dependencies on OKC_K_HEADERS_V

Line 828: FROM okc_k_headers_v

824:
825: CURSOR can_bto_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
826: SELECT bill_to_site_use_id,
827: cust_acct_id
828: FROM okc_k_headers_v
829: WHERE id = p_chr_id;
830:
831: BEGIN
832: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1283: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1279: PROCEDURE get_contract_rules(
1280: x_return_status OUT NOCOPY VARCHAR2,
1281: x_msg_count OUT NOCOPY NUMBER,
1282: x_msg_data OUT NOCOPY VARCHAR2,
1283: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1284: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
1285: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1286: p_rule_code IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
1287: x_rulv_tbl OUT NOCOPY rulv_tbl_type,

Line 1292: CURSOR rulv_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

1288: x_rule_count OUT NOCOPY NUMBER
1289: ) IS
1290: l_proc_name VARCHAR2(35) := 'GET_CONTRACT_RULES';
1291:
1292: CURSOR rulv_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1293: p_cle_id OKC_K_LINES_V.ID%TYPE,
1294: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1295: p_rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE) IS
1296: SELECT

Line 1585: p_template_id IN okc_k_headers_v.id%type,

1581: ------------------------------------------------------------------------------
1582:
1583: FUNCTION check_header_literal (
1584: p_contract_number IN okl_header_interface.contract_number_old%type,
1585: p_template_id IN okc_k_headers_v.id%type,
1586: p_application_code IN okl_header_interface.application_code%type,
1587: p_contract_category IN okl_header_interface.contract_category%type,
1588: p_import_request_stage IN okl_header_interface.import_request_stage%type,
1589: p_converted_account IN okl_header_interface.converted_account%type,

Line 2580: CURSOR khdr_csr (p_ontract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS

2576:
2577: FUNCTION check_contract_number (p_contract_number IN VARCHAR2)
2578: RETURN VARCHAR2 IS
2579:
2580: CURSOR khdr_csr (p_ontract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
2581: SELECT contract_number
2582: FROM okc_k_headers_v
2583: WHERE contract_number = p_contract_number;
2584:

Line 2582: FROM okc_k_headers_v

2578: RETURN VARCHAR2 IS
2579:
2580: CURSOR khdr_csr (p_ontract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
2581: SELECT contract_number
2582: FROM okc_k_headers_v
2583: WHERE contract_number = p_contract_number;
2584:
2585: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2586: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 2586: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

2582: FROM okc_k_headers_v
2583: WHERE contract_number = p_contract_number;
2584:
2585: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2586: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
2587:
2588: BEGIN
2589:
2590: OPEN khdr_csr(p_contract_number);

Line 3095: CURSOR okl_line_csr (p_contract_number_old okc_k_headers_v.contract_number%TYPE) IS

3091: --
3092: -- Cursor to fetch Line Interface Records for each contract header
3093: --
3094:
3095: CURSOR okl_line_csr (p_contract_number_old okc_k_headers_v.contract_number%TYPE) IS
3096: SELECT *
3097: FROM okl_lines_interface
3098: WHERE contract_number_old = p_contract_number_old
3099: ORDER BY line_number;

Line 3105: CURSOR okl_party_role_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS

3101: --
3102: -- Cursor to fetch Party Role Records
3103: --
3104:
3105: CURSOR okl_party_role_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3106: SELECT *
3107: FROM okl_party_roles_interface
3108: WHERE contract_number_old = p_contract_number;
3109:

Line 3114: CURSOR okl_term_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS

3110: --
3111: -- Cursor to fetch Terms Records
3112: --
3113:
3114: CURSOR okl_term_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3115: SELECT *
3116: FROM okl_terms_interface
3117: WHERE contract_number_old = p_contract_number;
3118:

Line 3123: CURSOR okl_payment_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS

3119: --
3120: -- Cursor to fetch Payments Records
3121: --
3122:
3123: CURSOR okl_payment_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3124: SELECT *
3125: FROM okl_payments_interface
3126: WHERE contract_number_old = p_contract_number;
3127:

Line 3746: p_scs_code IN okc_k_headers_v.scs_code%TYPE,

3742: -- load_input_record
3743: ------------------------------------------------------------------------------
3744:
3745: FUNCTION get_prog_agreement_id (
3746: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3747: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3748: p_agreement_id IN okc_k_headers_v.id%TYPE,
3749: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

Line 3747: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,

3743: ------------------------------------------------------------------------------
3744:
3745: FUNCTION get_prog_agreement_id (
3746: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3747: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3748: p_agreement_id IN okc_k_headers_v.id%TYPE,
3749: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3751: ) RETURN VARCHAR2 IS

Line 3748: p_agreement_id IN okc_k_headers_v.id%TYPE,

3744:
3745: FUNCTION get_prog_agreement_id (
3746: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3747: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3748: p_agreement_id IN okc_k_headers_v.id%TYPE,
3749: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3751: ) RETURN VARCHAR2 IS
3752:

Line 3749: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,

3745: FUNCTION get_prog_agreement_id (
3746: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3747: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3748: p_agreement_id IN okc_k_headers_v.id%TYPE,
3749: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3751: ) RETURN VARCHAR2 IS
3752:
3753: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

3746: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3747: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3748: p_agreement_id IN okc_k_headers_v.id%TYPE,
3749: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3751: ) RETURN VARCHAR2 IS
3752:
3753: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3754: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

Line 3754: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

3750: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3751: ) RETURN VARCHAR2 IS
3752:
3753: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3754: l_contract_id OKC_K_HEADERS_V.ID%TYPE;
3755: agreement_exception EXCEPTION;
3756:
3757: --Fixed Bug # 5484903
3758: CURSOR contract_csr (

Line 3759: p_scs_code okc_k_headers_v.scs_code%TYPE,

3755: agreement_exception EXCEPTION;
3756:
3757: --Fixed Bug # 5484903
3758: CURSOR contract_csr (
3759: p_scs_code okc_k_headers_v.scs_code%TYPE,
3760: p_agreement_id okc_k_headers_v.id%TYPE,
3761: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3762: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3763: ) IS

Line 3760: p_agreement_id okc_k_headers_v.id%TYPE,

3756:
3757: --Fixed Bug # 5484903
3758: CURSOR contract_csr (
3759: p_scs_code okc_k_headers_v.scs_code%TYPE,
3760: p_agreement_id okc_k_headers_v.id%TYPE,
3761: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3762: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3763: ) IS
3764: SELECT id

Line 3761: p_agreement_number okc_k_headers_v.contract_number%TYPE,

3757: --Fixed Bug # 5484903
3758: CURSOR contract_csr (
3759: p_scs_code okc_k_headers_v.scs_code%TYPE,
3760: p_agreement_id okc_k_headers_v.id%TYPE,
3761: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3762: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3763: ) IS
3764: SELECT id
3765: FROM okc_k_headers_all_b

Line 3762: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE

3758: CURSOR contract_csr (
3759: p_scs_code okc_k_headers_v.scs_code%TYPE,
3760: p_agreement_id okc_k_headers_v.id%TYPE,
3761: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3762: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3763: ) IS
3764: SELECT id
3765: FROM okc_k_headers_all_b
3766: WHERE ((contract_number = p_agreement_number

Line 3816: -- It gets Master Lease ID if any. It checks againts okc_k_headers_v for

3812: END get_prog_agreement_id;
3813:
3814: ------------------------------------------------------------------------------
3815: -- FUNCTION get_agreement_id
3816: -- It gets Master Lease ID if any. It checks againts okc_k_headers_v for
3817: -- esistance of master contract as supplied in parameters
3818: -- Calls:
3819: -- None
3820: -- Called By:

Line 3825: p_scs_code IN okc_k_headers_v.scs_code%TYPE,

3821: -- load_input_record
3822: ------------------------------------------------------------------------------
3823:
3824: FUNCTION get_agreement_id (
3825: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3826: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3827: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3828: p_agreement_id IN okc_k_headers_v.id%TYPE,
3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

Line 3826: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,

3822: ------------------------------------------------------------------------------
3823:
3824: FUNCTION get_agreement_id (
3825: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3826: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3827: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3828: p_agreement_id IN okc_k_headers_v.id%TYPE,
3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3830: ) RETURN VARCHAR2 IS

Line 3827: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,

3823:
3824: FUNCTION get_agreement_id (
3825: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3826: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3827: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3828: p_agreement_id IN okc_k_headers_v.id%TYPE,
3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3830: ) RETURN VARCHAR2 IS
3831:

Line 3828: p_agreement_id IN okc_k_headers_v.id%TYPE,

3824: FUNCTION get_agreement_id (
3825: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3826: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3827: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3828: p_agreement_id IN okc_k_headers_v.id%TYPE,
3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3830: ) RETURN VARCHAR2 IS
3831:
3832: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

3825: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3826: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3827: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3828: p_agreement_id IN okc_k_headers_v.id%TYPE,
3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3830: ) RETURN VARCHAR2 IS
3831:
3832: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3833: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

Line 3833: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

3829: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3830: ) RETURN VARCHAR2 IS
3831:
3832: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3833: l_contract_id OKC_K_HEADERS_V.ID%TYPE;
3834: agreement_exception EXCEPTION;
3835: --Fixed Bug #5484903
3836: CURSOR contract_csr (
3837: p_scs_code okc_k_headers_v.scs_code%TYPE,

Line 3837: p_scs_code okc_k_headers_v.scs_code%TYPE,

3833: l_contract_id OKC_K_HEADERS_V.ID%TYPE;
3834: agreement_exception EXCEPTION;
3835: --Fixed Bug #5484903
3836: CURSOR contract_csr (
3837: p_scs_code okc_k_headers_v.scs_code%TYPE,
3838: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
3839: p_agreement_id okc_k_headers_v.id%TYPE,
3840: p_agreement_number okc_k_headers_v.contract_number%TYPE
3841: ) IS

Line 3838: p_org_id okc_k_headers_v.authoring_org_id%TYPE,

3834: agreement_exception EXCEPTION;
3835: --Fixed Bug #5484903
3836: CURSOR contract_csr (
3837: p_scs_code okc_k_headers_v.scs_code%TYPE,
3838: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
3839: p_agreement_id okc_k_headers_v.id%TYPE,
3840: p_agreement_number okc_k_headers_v.contract_number%TYPE
3841: ) IS
3842: SELECT id

Line 3839: p_agreement_id okc_k_headers_v.id%TYPE,

3835: --Fixed Bug #5484903
3836: CURSOR contract_csr (
3837: p_scs_code okc_k_headers_v.scs_code%TYPE,
3838: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
3839: p_agreement_id okc_k_headers_v.id%TYPE,
3840: p_agreement_number okc_k_headers_v.contract_number%TYPE
3841: ) IS
3842: SELECT id
3843: FROM okc_k_headers_all_b

Line 3840: p_agreement_number okc_k_headers_v.contract_number%TYPE

3836: CURSOR contract_csr (
3837: p_scs_code okc_k_headers_v.scs_code%TYPE,
3838: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
3839: p_agreement_id okc_k_headers_v.id%TYPE,
3840: p_agreement_number okc_k_headers_v.contract_number%TYPE
3841: ) IS
3842: SELECT id
3843: FROM okc_k_headers_all_b
3844: WHERE ((contract_number = p_agreement_number

Line 4211: p_contract_number_old IN okc_k_headers_v.orig_system_reference1%TYPE,

4207: x_return_status OUT NOCOPY VARCHAR2,
4208: x_msg_count OUT NOCOPY NUMBER,
4209: x_msg_data OUT NOCOPY VARCHAR2,
4210: p_contract_header_id IN okl_k_headers_v.id%TYPE,
4211: p_contract_number_old IN okc_k_headers_v.orig_system_reference1%TYPE,
4212: p_customer_id IN okl_header_interface.customer_id%TYPE,
4213: p_customer_number IN okl_header_interface.customer_number%TYPE,
4214: p_authoring_org_id IN okl_header_interface.authoring_org_id%TYPE,
4215: x_cplv_rec OUT NOCOPY cplv_rec_type ) IS

Line 5361: p_chr_id IN okc_k_headers_v.id%TYPE,

5357: PROCEDURE create_update_asset_rules(
5358: x_return_status OUT NOCOPY VARCHAR2,
5359: x_msg_count OUT NOCOPY NUMBER,
5360: x_msg_data OUT NOCOPY VARCHAR2,
5361: p_chr_id IN okc_k_headers_v.id%TYPE,
5362: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5363: p_cle_id IN okl_k_lines_v.id%TYPE,
5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,

Line 5876: p_chr_id IN okc_k_headers_v.id%TYPE,

5872: PROCEDURE create_line_rules(
5873: x_return_status OUT NOCOPY VARCHAR2,
5874: x_msg_count OUT NOCOPY NUMBER,
5875: x_msg_data OUT NOCOPY VARCHAR2,
5876: p_chr_id IN okc_k_headers_v.id%TYPE,
5877: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5878: p_cle_id IN okl_k_lines_v.id%TYPE,
5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,

Line 7643: p_org_id IN OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE,

7639: x_return_status OUT NOCOPY VARCHAR2,
7640: x_msg_count OUT NOCOPY NUMBER,
7641: x_msg_data OUT NOCOPY VARCHAR2,
7642: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
7643: p_org_id IN OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE,
7644: p_cash_appl_rule_name IN OKL_HEADER_INTERFACE.CASH_APPL_RULE_NAME%TYPE,
7645: x_cash_appl_rule_id OUT NOCOPY OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE
7646: ) IS
7647:

Line 7738: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

7734: PROCEDURE create_header_rules(
7735: x_return_status OUT NOCOPY VARCHAR2,
7736: x_msg_count OUT NOCOPY NUMBER,
7737: x_msg_data OUT NOCOPY VARCHAR2,
7738: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
7739: p_template_id IN OKC_K_HEADERS_V.ID%TYPE,
7740: p_header_rec IN intf_h_rec_type
7741: ) IS
7742:

Line 7739: p_template_id IN OKC_K_HEADERS_V.ID%TYPE,

7735: x_return_status OUT NOCOPY VARCHAR2,
7736: x_msg_count OUT NOCOPY NUMBER,
7737: x_msg_data OUT NOCOPY VARCHAR2,
7738: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
7739: p_template_id IN OKC_K_HEADERS_V.ID%TYPE,
7740: p_header_rec IN intf_h_rec_type
7741: ) IS
7742:
7743: header_rule_failed EXCEPTION;

Line 7778: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

7774:
7775: l_rule_count NUMBER := 0;
7776: l_rulv_tbl rulv_tbl_type;
7777:
7778: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7779: --Fixed # Bug 5484903
7780: SELECT object1_id1
7781: FROM okc_k_party_roles_b
7782: WHERE dnz_chr_id = p_chr_id

Line 18253: p_contract_header_id IN okc_k_headers_v.id%TYPE,

18249: PROCEDURE create_contact(
18250: x_return_status OUT NOCOPY VARCHAR2,
18251: x_msg_count OUT NOCOPY NUMBER,
18252: x_msg_data OUT NOCOPY VARCHAR2,
18253: p_contract_header_id IN okc_k_headers_v.id%TYPE,
18254: p_contract_number_old IN okl_header_interface.contract_number_old%TYPE,
18255: p_salesperson_id IN okl_header_interface.salesperson_id%TYPE,
18256: p_salesperson_name IN okl_header_interface.salesperson_name%TYPE,
18257: p_authoring_org_id IN okl_header_interface.authoring_org_id%TYPE,

Line 18369: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

18365: PROCEDURE get_ship_to_site(
18366: x_return_status OUT NOCOPY VARCHAR2,
18367: x_msg_count OUT NOCOPY NUMBER,
18368: x_msg_data OUT NOCOPY VARCHAR2,
18369: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18370: p_line_number IN okc_k_lines_v.line_number%TYPE,
18371: p_auth_org_id IN NUMBER,
18372: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18373: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,

Line 18483: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

18479: PROCEDURE get_guarantor_address(
18480: x_return_status OUT NOCOPY VARCHAR2,
18481: x_msg_count OUT NOCOPY NUMBER,
18482: x_msg_data OUT NOCOPY VARCHAR2,
18483: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18484: p_line_number IN okc_k_lines_v.line_number%TYPE,
18485: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
18486: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
18487: x_guarantor_site_id OUT NOCOPY okl_party_roles_interface.guarantor_site_id%TYPE

Line 18601: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

18597: x_return_status OUT NOCOPY VARCHAR2,
18598: x_msg_count OUT NOCOPY NUMBER,
18599: x_msg_data OUT NOCOPY VARCHAR2,
18600: p_chr_id IN NUMBER,
18601: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18602: p_label_number IN VARCHAR2,
18603: p_label_id IN NUMBER,
18604: p_label_url IN VARCHAR2
18605: ) IS

Line 19100: p_chr_id IN okc_k_headers_v.id%TYPE,

19096: x_return_status OUT NOCOPY VARCHAR2,
19097: x_msg_count OUT NOCOPY NUMBER,
19098: x_msg_data OUT NOCOPY VARCHAR2,
19099: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
19100: p_chr_id IN okc_k_headers_v.id%TYPE,
19101: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
19102: p_line_number IN okc_k_lines_v.line_number%TYPE,
19103: p_line_type IN okl_lines_interface.line_type%TYPE,
19104: p_fin_cle_id IN NUMBER,

Line 21662: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

21658: PROCEDURE process_term(
21659: x_return_status OUT NOCOPY VARCHAR2,
21660: x_msg_count OUT NOCOPY NUMBER,
21661: x_msg_data OUT NOCOPY VARCHAR2,
21662: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21663: p_chr_id IN okc_k_headers_v.id%TYPE,
21664: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21665: p_line_number IN okc_k_lines_v.line_number%TYPE,
21666: p_line_type IN okl_lines_interface.line_type%TYPE,

Line 21663: p_chr_id IN okc_k_headers_v.id%TYPE,

21659: x_return_status OUT NOCOPY VARCHAR2,
21660: x_msg_count OUT NOCOPY NUMBER,
21661: x_msg_data OUT NOCOPY VARCHAR2,
21662: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21663: p_chr_id IN okc_k_headers_v.id%TYPE,
21664: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21665: p_line_number IN okc_k_lines_v.line_number%TYPE,
21666: p_line_type IN okl_lines_interface.line_type%TYPE,
21667: p_cle_id IN okc_k_lines_v.id%TYPE,

Line 22877: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

22873: PROCEDURE get_asset_key_id(
22874: x_return_status OUT NOCOPY VARCHAR2,
22875: x_msg_count OUT NOCOPY NUMBER,
22876: x_msg_data OUT NOCOPY VARCHAR2,
22877: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
22878: p_line_number IN okc_k_lines_v.line_number%TYPE,
22879: p_comb_id IN NUMBER,
22880: p_segment1 IN VARCHAR2,
22881: p_segment2 IN VARCHAR2,

Line 23034: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

23030: PROCEDURE get_flexid(
23031: x_return_status OUT NOCOPY VARCHAR2,
23032: x_msg_count OUT NOCOPY NUMBER,
23033: x_msg_data OUT NOCOPY VARCHAR2,
23034: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23035: p_line_number IN okc_k_lines_v.line_number%TYPE,
23036: p_type IN VARCHAR2,
23037: p_comb_id IN NUMBER,
23038: p_segment1 IN VARCHAR2,

Line 23454: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

23450: x_return_status OUT NOCOPY VARCHAR2,
23451: x_msg_count OUT NOCOPY NUMBER,
23452: x_msg_data OUT NOCOPY VARCHAR2,
23453: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23454: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23455: p_chr_id IN okc_k_headers_v.id%TYPE,
23456: p_line_number IN okc_k_lines_v.line_number%TYPE,
23457: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23458: ) IS

Line 23455: p_chr_id IN okc_k_headers_v.id%TYPE,

23451: x_msg_count OUT NOCOPY NUMBER,
23452: x_msg_data OUT NOCOPY VARCHAR2,
23453: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23454: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23455: p_chr_id IN okc_k_headers_v.id%TYPE,
23456: p_line_number IN okc_k_lines_v.line_number%TYPE,
23457: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23458: ) IS
23459:

Line 23932: p_chr_id IN okc_k_headers_v.id%TYPE,

23928: x_return_status OUT NOCOPY VARCHAR2,
23929: x_msg_count OUT NOCOPY NUMBER,
23930: x_msg_data OUT NOCOPY VARCHAR2,
23931: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
23932: p_chr_id IN okc_k_headers_v.id%TYPE,
23933: p_line_number IN okl_lines_interface.line_number%TYPE,
23934: p_line_type IN okl_lines_interface.line_type%TYPE,
23935: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
23936: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,

Line 24693: p_contract_number IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE,

24689: PROCEDURE validate_credit_line(
24690: x_return_status OUT NOCOPY VARCHAR2,
24691: x_msg_count OUT NOCOPY NUMBER,
24692: x_msg_data OUT NOCOPY VARCHAR2,
24693: p_contract_number IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE,
24694: p_template_id IN NUMBER,
24695: p_credit_line_id IN NUMBER,
24696: p_customer_id IN OKL_HEADER_INTERFACE.CUSTOMER_ID%TYPE,
24697: p_customer_number IN OKL_HEADER_INTERFACE.CUSTOMER_NUMBER%TYPE,

Line 24719: CURSOR temp_st_dt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

24715: p_customer_id IS NOT NULL
24716: )
24717: );
24718:
24719: CURSOR temp_st_dt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24720: SELECT start_date
24721: FROM okc_k_headers_v
24722: WHERE id = p_chr_id;
24723:

Line 24721: FROM okc_k_headers_v

24717: );
24718:
24719: CURSOR temp_st_dt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24720: SELECT start_date
24721: FROM okc_k_headers_v
24722: WHERE id = p_chr_id;
24723:
24724: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24725: --Fixed Bug # 5484903

Line 24724: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

24720: SELECT start_date
24721: FROM okc_k_headers_v
24722: WHERE id = p_chr_id;
24723:
24724: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24725: --Fixed Bug # 5484903
24726: SELECT object1_id1
24727: FROM okc_k_party_roles_b
24728: WHERE dnz_chr_id = p_chr_id

Line 24733: CURSOR temp_cust_acc_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

24729: AND chr_id = dnz_chr_id
24730: AND jtot_object1_code = 'OKX_PARTY'
24731: AND rle_code = 'LESSEE' ;
24732:
24733: CURSOR temp_cust_acc_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24734: SELECT cust_acct_id
24735: FROM okc_k_headers_b
24736: WHERE id = p_chr_id;
24737:

Line 24738: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

24734: SELECT cust_acct_id
24735: FROM okc_k_headers_b
24736: WHERE id = p_chr_id;
24737:
24738: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24739: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS
24740: SELECT 'Y'
24741: FROM okc_k_headers_v
24742: WHERE id = p_chr_id

Line 24739: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS

24735: FROM okc_k_headers_b
24736: WHERE id = p_chr_id;
24737:
24738: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24739: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS
24740: SELECT 'Y'
24741: FROM okc_k_headers_v
24742: WHERE id = p_chr_id
24743: AND end_date >= p_main_start_date;

Line 24741: FROM okc_k_headers_v

24737:
24738: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24739: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS
24740: SELECT 'Y'
24741: FROM okc_k_headers_v
24742: WHERE id = p_chr_id
24743: AND end_date >= p_main_start_date;
24744:
24745: l_customer_id OKX_PARTIES_V.ID1%TYPE;

Line 24911: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

24907: p_init_msg_list IN VARCHAR2,
24908: x_return_status OUT NOCOPY VARCHAR2,
24909: x_msg_count OUT NOCOPY NUMBER,
24910: x_msg_data OUT NOCOPY VARCHAR2,
24911: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
24912: ) IS
24913:
24914: l_api_name VARCHAR2(35) := 'contract_after_yield';
24915: l_proc_name VARCHAR2(35) := 'CONTRACT_AFTER_YIELD';

Line 24920: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

24916: l_api_version NUMBER := 1.0;
24917:
24918: after_yield_failed EXCEPTION;
24919:
24920: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24921: SELECT contract_number,
24922: orig_system_reference1
24923: FROM okc_k_headers_v
24924: WHERE id = p_chr_id

Line 24923: FROM okc_k_headers_v

24919:
24920: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24921: SELECT contract_number,
24922: orig_system_reference1
24923: FROM okc_k_headers_v
24924: WHERE id = p_chr_id
24925: AND orig_system_source_code = 'OKL_IMPORT';
24926:
24927: CURSOR stage_csr (p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS

Line 24927: CURSOR stage_csr (p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS

24923: FROM okc_k_headers_v
24924: WHERE id = p_chr_id
24925: AND orig_system_source_code = 'OKL_IMPORT';
24926:
24927: CURSOR stage_csr (p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
24928: SELECT import_request_stage
24929: FROM okl_header_interface
24930: WHERE contract_number = p_contract_number
24931: AND status = 'INTERFACED';

Line 24933: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

24929: FROM okl_header_interface
24930: WHERE contract_number = p_contract_number
24931: AND status = 'INTERFACED';
24932:
24933: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
24934: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;
24935: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;
24936: BEGIN
24937:

Line 24934: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;

24930: WHERE contract_number = p_contract_number
24931: AND status = 'INTERFACED';
24932:
24933: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
24934: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;
24935: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;
24936: BEGIN
24937:
24938: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 24935: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;

24931: AND status = 'INTERFACED';
24932:
24933: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
24934: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;
24935: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;
24936: BEGIN
24937:
24938: x_return_status := OKL_API.G_RET_STS_SUCCESS;
24939: debug_message(l_proc_name);

Line 25203: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

25199: p_init_msg_list IN VARCHAR2,
25200: x_return_status OUT NOCOPY VARCHAR2,
25201: x_msg_count OUT NOCOPY NUMBER,
25202: x_msg_data OUT NOCOPY VARCHAR2,
25203: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
25204: p_import_stage IN VARCHAR2
25205: ) IS
25206: l_api_name VARCHAR2(35) := 'create_rebook_contract';
25207: l_proc_name VARCHAR2(35) := 'CREATE_REBOOK_CONTRACT';

Line 25407: x_program_agreement_id OKC_K_HEADERS_V.ID%TYPE;

25403: x_khrv_rec OUT NOCOPY khrv_rec_type
25404: ) IS
25405: l_proc_name VARCHAR2(35) := 'POPULATE_HEADER_REC';
25406: -- l_qcl_id NUMBER;
25407: x_program_agreement_id OKC_K_HEADERS_V.ID%TYPE;
25408: x_product_id NUMBER;
25409:
25410: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
25411: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS

Line 27267: x_master_lease_id OKC_K_HEADERS_V.ID%TYPE;

27263:
27264: -- local variables
27265: l_proc_name VARCHAR2(35) := 'LOAD_INPUT_RECORD';
27266: l_progress VARCHAR2(3) := NULL;
27267: x_master_lease_id OKC_K_HEADERS_V.ID%TYPE;
27268: x_customer_account_id NUMBER;
27269: x_inventory_org_id NUMBER;
27270: x_inventory_item_id NUMBER;
27271: x_lse_id NUMBER;

Line 28274: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

28270: payment_schedule_number,
28271: start_date;
28272:
28273:
28274: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28275: --Fixed Bug # 5484903
28276: SELECT object1_id1
28277: FROM okc_k_party_roles_b
28278: WHERE dnz_chr_id = p_chr_id

Line 28286: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

28282:
28283: l_customer_id okc_k_party_roles_v.object1_id1%TYPE;
28284: l_customer_number okl_header_interface.customer_number%TYPE;
28285:
28286: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28287: SELECT sales.object1_id1
28288: FROM okc_contacts_v sales,
28289: okc_k_party_roles_v party
28290: WHERE sales.cpl_id = party.id

Line 28299: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

28295:
28296: l_salesperson_id okc_contacts_v.object1_id1%TYPE;
28297: l_salesperson_name okl_header_interface.salesperson_name%TYPE;
28298:
28299: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28300: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28301: SELECT head.id
28302: FROM okc_k_headers_v head,
28303: okc_governances gov

Line 28300: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS

28296: l_salesperson_id okc_contacts_v.object1_id1%TYPE;
28297: l_salesperson_name okl_header_interface.salesperson_name%TYPE;
28298:
28299: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28300: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28301: SELECT head.id
28302: FROM okc_k_headers_v head,
28303: okc_governances gov
28304: WHERE head.id = gov.chr_id_referred

Line 28302: FROM okc_k_headers_v head,

28298:
28299: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28300: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28301: SELECT head.id
28302: FROM okc_k_headers_v head,
28303: okc_governances gov
28304: WHERE head.id = gov.chr_id_referred
28305: AND head.scs_code = p_scs_code --'MASTER_LEASE'
28306: AND gov.dnz_chr_id = p_chr_id;