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 831: FROM okc_k_headers_v

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

Line 1286: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

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

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

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

Line 1588: p_template_id IN okc_k_headers_v.id%type,

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

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

2741:
2742: FUNCTION check_contract_number (p_contract_number IN VARCHAR2)
2743: RETURN VARCHAR2 IS
2744:
2745: CURSOR khdr_csr (p_ontract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
2746: SELECT contract_number
2747: FROM okc_k_headers_v
2748: WHERE contract_number = p_contract_number;
2749:

Line 2747: FROM okc_k_headers_v

2743: RETURN VARCHAR2 IS
2744:
2745: CURSOR khdr_csr (p_ontract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
2746: SELECT contract_number
2747: FROM okc_k_headers_v
2748: WHERE contract_number = p_contract_number;
2749:
2750: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2751: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 2751: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

2747: FROM okc_k_headers_v
2748: WHERE contract_number = p_contract_number;
2749:
2750: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2751: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
2752:
2753: BEGIN
2754:
2755: OPEN khdr_csr(p_contract_number);

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

3256: --
3257: -- Cursor to fetch Line Interface Records for each contract header
3258: --
3259:
3260: CURSOR okl_line_csr (p_contract_number_old okc_k_headers_v.contract_number%TYPE) IS
3261: SELECT *
3262: FROM okl_lines_interface
3263: WHERE contract_number_old = p_contract_number_old
3264: ORDER BY line_number;

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

3266: --
3267: -- Cursor to fetch Party Role Records
3268: --
3269:
3270: CURSOR okl_party_role_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3271: SELECT *
3272: FROM okl_party_roles_interface
3273: WHERE contract_number_old = p_contract_number;
3274:

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

3275: --
3276: -- Cursor to fetch Terms Records
3277: --
3278:
3279: CURSOR okl_term_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3280: SELECT *
3281: FROM okl_terms_interface
3282: WHERE contract_number_old = p_contract_number;
3283:

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

3284: --
3285: -- Cursor to fetch Payments Records
3286: --
3287:
3288: CURSOR okl_payment_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3289: SELECT *
3290: FROM okl_payments_interface
3291: WHERE contract_number_old = p_contract_number;
3292:

Line 3914: p_scs_code IN okc_k_headers_v.scs_code%TYPE,

3910: -- load_input_record
3911: ------------------------------------------------------------------------------
3912:
3913: FUNCTION get_prog_agreement_id (
3914: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3915: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3916: p_agreement_id IN okc_k_headers_v.id%TYPE,
3917: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

Line 3915: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,

3911: ------------------------------------------------------------------------------
3912:
3913: FUNCTION get_prog_agreement_id (
3914: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3915: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3916: p_agreement_id IN okc_k_headers_v.id%TYPE,
3917: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3919: ) RETURN VARCHAR2 IS

Line 3916: p_agreement_id IN okc_k_headers_v.id%TYPE,

3912:
3913: FUNCTION get_prog_agreement_id (
3914: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3915: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3916: p_agreement_id IN okc_k_headers_v.id%TYPE,
3917: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3919: ) RETURN VARCHAR2 IS
3920:

Line 3917: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,

3913: FUNCTION get_prog_agreement_id (
3914: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3915: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3916: p_agreement_id IN okc_k_headers_v.id%TYPE,
3917: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3919: ) RETURN VARCHAR2 IS
3920:
3921: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

3914: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3915: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3916: p_agreement_id IN okc_k_headers_v.id%TYPE,
3917: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3919: ) RETURN VARCHAR2 IS
3920:
3921: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3922: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

Line 3922: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

3918: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3919: ) RETURN VARCHAR2 IS
3920:
3921: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3922: l_contract_id OKC_K_HEADERS_V.ID%TYPE;
3923: agreement_exception EXCEPTION;
3924:
3925: --Fixed Bug # 5484903
3926: CURSOR contract_csr (

Line 3927: p_scs_code okc_k_headers_v.scs_code%TYPE,

3923: agreement_exception EXCEPTION;
3924:
3925: --Fixed Bug # 5484903
3926: CURSOR contract_csr (
3927: p_scs_code okc_k_headers_v.scs_code%TYPE,
3928: p_agreement_id okc_k_headers_v.id%TYPE,
3929: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3930: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3931: ) IS

Line 3928: p_agreement_id okc_k_headers_v.id%TYPE,

3924:
3925: --Fixed Bug # 5484903
3926: CURSOR contract_csr (
3927: p_scs_code okc_k_headers_v.scs_code%TYPE,
3928: p_agreement_id okc_k_headers_v.id%TYPE,
3929: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3930: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3931: ) IS
3932: SELECT id

Line 3929: p_agreement_number okc_k_headers_v.contract_number%TYPE,

3925: --Fixed Bug # 5484903
3926: CURSOR contract_csr (
3927: p_scs_code okc_k_headers_v.scs_code%TYPE,
3928: p_agreement_id okc_k_headers_v.id%TYPE,
3929: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3930: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3931: ) IS
3932: SELECT id
3933: FROM okc_k_headers_all_b

Line 3930: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE

3926: CURSOR contract_csr (
3927: p_scs_code okc_k_headers_v.scs_code%TYPE,
3928: p_agreement_id okc_k_headers_v.id%TYPE,
3929: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3930: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3931: ) IS
3932: SELECT id
3933: FROM okc_k_headers_all_b
3934: WHERE ((contract_number = p_agreement_number

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

3980: END get_prog_agreement_id;
3981:
3982: ------------------------------------------------------------------------------
3983: -- FUNCTION get_agreement_id
3984: -- It gets Master Lease ID if any. It checks againts okc_k_headers_v for
3985: -- esistance of master contract as supplied in parameters
3986: -- Calls:
3987: -- None
3988: -- Called By:

Line 3993: p_scs_code IN okc_k_headers_v.scs_code%TYPE,

3989: -- load_input_record
3990: ------------------------------------------------------------------------------
3991:
3992: FUNCTION get_agreement_id (
3993: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3994: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3995: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3996: p_agreement_id IN okc_k_headers_v.id%TYPE,
3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

Line 3994: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,

3990: ------------------------------------------------------------------------------
3991:
3992: FUNCTION get_agreement_id (
3993: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3994: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3995: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3996: p_agreement_id IN okc_k_headers_v.id%TYPE,
3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3998: ) RETURN VARCHAR2 IS

Line 3995: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,

3991:
3992: FUNCTION get_agreement_id (
3993: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3994: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3995: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3996: p_agreement_id IN okc_k_headers_v.id%TYPE,
3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3998: ) RETURN VARCHAR2 IS
3999:

Line 3996: p_agreement_id IN okc_k_headers_v.id%TYPE,

3992: FUNCTION get_agreement_id (
3993: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3994: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3995: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3996: p_agreement_id IN okc_k_headers_v.id%TYPE,
3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3998: ) RETURN VARCHAR2 IS
3999:
4000: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE

3993: p_scs_code IN okc_k_headers_v.scs_code%TYPE,
3994: p_auth_org_id IN okc_k_headers_v.authoring_org_id%TYPE,
3995: p_agreement_number IN okc_k_headers_v.contract_number%TYPE,
3996: p_agreement_id IN okc_k_headers_v.id%TYPE,
3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3998: ) RETURN VARCHAR2 IS
3999:
4000: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
4001: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

Line 4001: l_contract_id OKC_K_HEADERS_V.ID%TYPE;

3997: x_agreement_id OUT NOCOPY okc_k_headers_v.contract_number%TYPE
3998: ) RETURN VARCHAR2 IS
3999:
4000: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
4001: l_contract_id OKC_K_HEADERS_V.ID%TYPE;
4002: agreement_exception EXCEPTION;
4003: --Fixed Bug #5484903
4004: CURSOR contract_csr (
4005: p_scs_code okc_k_headers_v.scs_code%TYPE,

Line 4005: p_scs_code okc_k_headers_v.scs_code%TYPE,

4001: l_contract_id OKC_K_HEADERS_V.ID%TYPE;
4002: agreement_exception EXCEPTION;
4003: --Fixed Bug #5484903
4004: CURSOR contract_csr (
4005: p_scs_code okc_k_headers_v.scs_code%TYPE,
4006: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
4007: p_agreement_id okc_k_headers_v.id%TYPE,
4008: p_agreement_number okc_k_headers_v.contract_number%TYPE
4009: ) IS

Line 4006: p_org_id okc_k_headers_v.authoring_org_id%TYPE,

4002: agreement_exception EXCEPTION;
4003: --Fixed Bug #5484903
4004: CURSOR contract_csr (
4005: p_scs_code okc_k_headers_v.scs_code%TYPE,
4006: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
4007: p_agreement_id okc_k_headers_v.id%TYPE,
4008: p_agreement_number okc_k_headers_v.contract_number%TYPE
4009: ) IS
4010: SELECT id

Line 4007: p_agreement_id okc_k_headers_v.id%TYPE,

4003: --Fixed Bug #5484903
4004: CURSOR contract_csr (
4005: p_scs_code okc_k_headers_v.scs_code%TYPE,
4006: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
4007: p_agreement_id okc_k_headers_v.id%TYPE,
4008: p_agreement_number okc_k_headers_v.contract_number%TYPE
4009: ) IS
4010: SELECT id
4011: FROM okc_k_headers_all_b

Line 4008: p_agreement_number okc_k_headers_v.contract_number%TYPE

4004: CURSOR contract_csr (
4005: p_scs_code okc_k_headers_v.scs_code%TYPE,
4006: p_org_id okc_k_headers_v.authoring_org_id%TYPE,
4007: p_agreement_id okc_k_headers_v.id%TYPE,
4008: p_agreement_number okc_k_headers_v.contract_number%TYPE
4009: ) IS
4010: SELECT id
4011: FROM okc_k_headers_all_b
4012: WHERE ((contract_number = p_agreement_number

Line 4379: p_contract_number_old IN okc_k_headers_v.orig_system_reference1%TYPE,

4375: x_return_status OUT NOCOPY VARCHAR2,
4376: x_msg_count OUT NOCOPY NUMBER,
4377: x_msg_data OUT NOCOPY VARCHAR2,
4378: p_contract_header_id IN okl_k_headers_v.id%TYPE,
4379: p_contract_number_old IN okc_k_headers_v.orig_system_reference1%TYPE,
4380: p_customer_id IN okl_header_interface.customer_id%TYPE,
4381: p_customer_number IN okl_header_interface.customer_number%TYPE,
4382: p_authoring_org_id IN okl_header_interface.authoring_org_id%TYPE,
4383: x_cplv_rec OUT NOCOPY cplv_rec_type ) IS

Line 5529: p_chr_id IN okc_k_headers_v.id%TYPE,

5525: PROCEDURE create_update_asset_rules(
5526: x_return_status OUT NOCOPY VARCHAR2,
5527: x_msg_count OUT NOCOPY NUMBER,
5528: x_msg_data OUT NOCOPY VARCHAR2,
5529: p_chr_id IN okc_k_headers_v.id%TYPE,
5530: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5531: p_cle_id IN okl_k_lines_v.id%TYPE,
5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,

Line 6044: p_chr_id IN okc_k_headers_v.id%TYPE,

6040: PROCEDURE create_line_rules(
6041: x_return_status OUT NOCOPY VARCHAR2,
6042: x_msg_count OUT NOCOPY NUMBER,
6043: x_msg_data OUT NOCOPY VARCHAR2,
6044: p_chr_id IN okc_k_headers_v.id%TYPE,
6045: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
6046: p_cle_id IN okl_k_lines_v.id%TYPE,
6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,

Line 7811: p_org_id IN OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE,

7807: x_return_status OUT NOCOPY VARCHAR2,
7808: x_msg_count OUT NOCOPY NUMBER,
7809: x_msg_data OUT NOCOPY VARCHAR2,
7810: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
7811: p_org_id IN OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE,
7812: p_cash_appl_rule_name IN OKL_HEADER_INTERFACE.CASH_APPL_RULE_NAME%TYPE,
7813: x_cash_appl_rule_id OUT NOCOPY OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE
7814: ) IS
7815:

Line 7906: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

7902: PROCEDURE create_header_rules(
7903: x_return_status OUT NOCOPY VARCHAR2,
7904: x_msg_count OUT NOCOPY NUMBER,
7905: x_msg_data OUT NOCOPY VARCHAR2,
7906: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
7907: p_template_id IN OKC_K_HEADERS_V.ID%TYPE,
7908: p_header_rec IN intf_h_rec_type
7909: ) IS
7910:

Line 7907: p_template_id IN OKC_K_HEADERS_V.ID%TYPE,

7903: x_return_status OUT NOCOPY VARCHAR2,
7904: x_msg_count OUT NOCOPY NUMBER,
7905: x_msg_data OUT NOCOPY VARCHAR2,
7906: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
7907: p_template_id IN OKC_K_HEADERS_V.ID%TYPE,
7908: p_header_rec IN intf_h_rec_type
7909: ) IS
7910:
7911: header_rule_failed EXCEPTION;

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

7942:
7943: l_rule_count NUMBER := 0;
7944: l_rulv_tbl rulv_tbl_type;
7945:
7946: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7947: --Fixed # Bug 5484903
7948: SELECT object1_id1
7949: FROM okc_k_party_roles_b
7950: WHERE dnz_chr_id = p_chr_id

Line 18434: p_contract_header_id IN okc_k_headers_v.id%TYPE,

18430: PROCEDURE create_contact(
18431: x_return_status OUT NOCOPY VARCHAR2,
18432: x_msg_count OUT NOCOPY NUMBER,
18433: x_msg_data OUT NOCOPY VARCHAR2,
18434: p_contract_header_id IN okc_k_headers_v.id%TYPE,
18435: p_contract_number_old IN okl_header_interface.contract_number_old%TYPE,
18436: p_salesperson_id IN okl_header_interface.salesperson_id%TYPE,
18437: p_salesperson_name IN okl_header_interface.salesperson_name%TYPE,
18438: p_authoring_org_id IN okl_header_interface.authoring_org_id%TYPE,

Line 18550: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

18546: PROCEDURE get_ship_to_site(
18547: x_return_status OUT NOCOPY VARCHAR2,
18548: x_msg_count OUT NOCOPY NUMBER,
18549: x_msg_data OUT NOCOPY VARCHAR2,
18550: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18551: p_line_number IN okc_k_lines_v.line_number%TYPE,
18552: p_auth_org_id IN NUMBER,
18553: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18554: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,

Line 18664: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

18660: PROCEDURE get_guarantor_address(
18661: x_return_status OUT NOCOPY VARCHAR2,
18662: x_msg_count OUT NOCOPY NUMBER,
18663: x_msg_data OUT NOCOPY VARCHAR2,
18664: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18665: p_line_number IN okc_k_lines_v.line_number%TYPE,
18666: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
18667: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
18668: x_guarantor_site_id OUT NOCOPY okl_party_roles_interface.guarantor_site_id%TYPE

Line 18782: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

18778: x_return_status OUT NOCOPY VARCHAR2,
18779: x_msg_count OUT NOCOPY NUMBER,
18780: x_msg_data OUT NOCOPY VARCHAR2,
18781: p_chr_id IN NUMBER,
18782: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18783: p_label_number IN VARCHAR2,
18784: p_label_id IN NUMBER,
18785: p_label_url IN VARCHAR2
18786: ) IS

Line 19282: p_chr_id IN okc_k_headers_v.id%TYPE,

19278: x_return_status OUT NOCOPY VARCHAR2,
19279: x_msg_count OUT NOCOPY NUMBER,
19280: x_msg_data OUT NOCOPY VARCHAR2,
19281: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
19282: p_chr_id IN okc_k_headers_v.id%TYPE,
19283: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
19284: p_line_number IN okc_k_lines_v.line_number%TYPE,
19285: p_line_type IN okl_lines_interface.line_type%TYPE,
19286: p_fin_cle_id IN NUMBER,

Line 21848: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

21844: PROCEDURE process_term(
21845: x_return_status OUT NOCOPY VARCHAR2,
21846: x_msg_count OUT NOCOPY NUMBER,
21847: x_msg_data OUT NOCOPY VARCHAR2,
21848: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21849: p_chr_id IN okc_k_headers_v.id%TYPE,
21850: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,

Line 21849: p_chr_id IN okc_k_headers_v.id%TYPE,

21845: x_return_status OUT NOCOPY VARCHAR2,
21846: x_msg_count OUT NOCOPY NUMBER,
21847: x_msg_data OUT NOCOPY VARCHAR2,
21848: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21849: p_chr_id IN okc_k_headers_v.id%TYPE,
21850: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,

Line 23066: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

23062: PROCEDURE get_asset_key_id(
23063: x_return_status OUT NOCOPY VARCHAR2,
23064: x_msg_count OUT NOCOPY NUMBER,
23065: x_msg_data OUT NOCOPY VARCHAR2,
23066: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23067: p_line_number IN okc_k_lines_v.line_number%TYPE,
23068: p_comb_id IN NUMBER,
23069: p_segment1 IN VARCHAR2,
23070: p_segment2 IN VARCHAR2,

Line 23223: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

23219: PROCEDURE get_flexid(
23220: x_return_status OUT NOCOPY VARCHAR2,
23221: x_msg_count OUT NOCOPY NUMBER,
23222: x_msg_data OUT NOCOPY VARCHAR2,
23223: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23224: p_line_number IN okc_k_lines_v.line_number%TYPE,
23225: p_type IN VARCHAR2,
23226: p_comb_id IN NUMBER,
23227: p_segment1 IN VARCHAR2,

Line 23643: p_contract_number IN okc_k_headers_v.contract_number%TYPE,

23639: x_return_status OUT NOCOPY VARCHAR2,
23640: x_msg_count OUT NOCOPY NUMBER,
23641: x_msg_data OUT NOCOPY VARCHAR2,
23642: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23643: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23644: p_chr_id IN okc_k_headers_v.id%TYPE,
23645: p_line_number IN okc_k_lines_v.line_number%TYPE,
23646: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23647: ) IS

Line 23644: p_chr_id IN okc_k_headers_v.id%TYPE,

23640: x_msg_count OUT NOCOPY NUMBER,
23641: x_msg_data OUT NOCOPY VARCHAR2,
23642: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23643: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23644: p_chr_id IN okc_k_headers_v.id%TYPE,
23645: p_line_number IN okc_k_lines_v.line_number%TYPE,
23646: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23647: ) IS
23648:

Line 24121: p_chr_id IN okc_k_headers_v.id%TYPE,

24117: x_return_status OUT NOCOPY VARCHAR2,
24118: x_msg_count OUT NOCOPY NUMBER,
24119: x_msg_data OUT NOCOPY VARCHAR2,
24120: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
24121: p_chr_id IN okc_k_headers_v.id%TYPE,
24122: p_line_number IN okl_lines_interface.line_number%TYPE,
24123: p_line_type IN okl_lines_interface.line_type%TYPE,
24124: p_line_type_prev IN okl_lines_interface.line_type%TYPE,
24125: p_inv_item_id IN okl_lines_interface.inventory_item_id%TYPE,

Line 24935: p_contract_number IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE,

24931: PROCEDURE validate_credit_line(
24932: x_return_status OUT NOCOPY VARCHAR2,
24933: x_msg_count OUT NOCOPY NUMBER,
24934: x_msg_data OUT NOCOPY VARCHAR2,
24935: p_contract_number IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE,
24936: p_template_id IN NUMBER,
24937: p_credit_line_id IN NUMBER,
24938: p_customer_id IN OKL_HEADER_INTERFACE.CUSTOMER_ID%TYPE,
24939: p_customer_number IN OKL_HEADER_INTERFACE.CUSTOMER_NUMBER%TYPE,

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

24957: p_customer_id IS NOT NULL
24958: )
24959: );
24960:
24961: CURSOR temp_st_dt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24962: SELECT start_date
24963: FROM okc_k_headers_v
24964: WHERE id = p_chr_id;
24965:

Line 24963: FROM okc_k_headers_v

24959: );
24960:
24961: CURSOR temp_st_dt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24962: SELECT start_date
24963: FROM okc_k_headers_v
24964: WHERE id = p_chr_id;
24965:
24966: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24967: --Fixed Bug # 5484903

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

24962: SELECT start_date
24963: FROM okc_k_headers_v
24964: WHERE id = p_chr_id;
24965:
24966: CURSOR temp_cust_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24967: --Fixed Bug # 5484903
24968: SELECT object1_id1
24969: FROM okc_k_party_roles_b
24970: WHERE dnz_chr_id = p_chr_id

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

24971: AND chr_id = dnz_chr_id
24972: AND jtot_object1_code = 'OKX_PARTY'
24973: AND rle_code = 'LESSEE' ;
24974:
24975: CURSOR temp_cust_acc_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24976: SELECT cust_acct_id
24977: FROM okc_k_headers_b
24978: WHERE id = p_chr_id;
24979:

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

24976: SELECT cust_acct_id
24977: FROM okc_k_headers_b
24978: WHERE id = p_chr_id;
24979:
24980: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24981: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS
24982: SELECT 'Y'
24983: FROM okc_k_headers_v
24984: WHERE id = p_chr_id

Line 24981: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS

24977: FROM okc_k_headers_b
24978: WHERE id = p_chr_id;
24979:
24980: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24981: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS
24982: SELECT 'Y'
24983: FROM okc_k_headers_v
24984: WHERE id = p_chr_id
24985: AND end_date >= p_main_start_date;

Line 24983: FROM okc_k_headers_v

24979:
24980: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24981: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS
24982: SELECT 'Y'
24983: FROM okc_k_headers_v
24984: WHERE id = p_chr_id
24985: AND end_date >= p_main_start_date;
24986:
24987: l_customer_id OKX_PARTIES_V.ID1%TYPE;

Line 25153: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

25149: p_init_msg_list IN VARCHAR2,
25150: x_return_status OUT NOCOPY VARCHAR2,
25151: x_msg_count OUT NOCOPY NUMBER,
25152: x_msg_data OUT NOCOPY VARCHAR2,
25153: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
25154: ) IS
25155:
25156: l_api_name VARCHAR2(35) := 'contract_after_yield';
25157: l_proc_name VARCHAR2(35) := 'CONTRACT_AFTER_YIELD';

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

25158: l_api_version NUMBER := 1.0;
25159:
25160: after_yield_failed EXCEPTION;
25161:
25162: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
25163: SELECT contract_number,
25164: orig_system_reference1
25165: FROM okc_k_headers_v
25166: WHERE id = p_chr_id

Line 25165: FROM okc_k_headers_v

25161:
25162: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
25163: SELECT contract_number,
25164: orig_system_reference1
25165: FROM okc_k_headers_v
25166: WHERE id = p_chr_id
25167: AND orig_system_source_code = 'OKL_IMPORT';
25168:
25169: CURSOR stage_csr (p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS

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

25165: FROM okc_k_headers_v
25166: WHERE id = p_chr_id
25167: AND orig_system_source_code = 'OKL_IMPORT';
25168:
25169: CURSOR stage_csr (p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
25170: SELECT import_request_stage
25171: FROM okl_header_interface
25172: WHERE contract_number = p_contract_number
25173: AND status = 'INTERFACED';

Line 25175: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

25171: FROM okl_header_interface
25172: WHERE contract_number = p_contract_number
25173: AND status = 'INTERFACED';
25174:
25175: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
25176: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;
25177: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;
25178: l_process_status VARCHAR2(1);
25179: BEGIN

Line 25176: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;

25172: WHERE contract_number = p_contract_number
25173: AND status = 'INTERFACED';
25174:
25175: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
25176: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;
25177: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;
25178: l_process_status VARCHAR2(1);
25179: BEGIN
25180:

Line 25177: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;

25173: AND status = 'INTERFACED';
25174:
25175: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
25176: l_orig_contract OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE;
25177: l_import_stage OKC_K_HEADERS_V.STS_CODE%TYPE;
25178: l_process_status VARCHAR2(1);
25179: BEGIN
25180:
25181: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 25453: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

25449: p_init_msg_list IN VARCHAR2,
25450: x_return_status OUT NOCOPY VARCHAR2,
25451: x_msg_count OUT NOCOPY NUMBER,
25452: x_msg_data OUT NOCOPY VARCHAR2,
25453: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
25454: p_import_stage IN VARCHAR2
25455: ) IS
25456: l_api_name VARCHAR2(35) := 'create_rebook_contract';
25457: l_proc_name VARCHAR2(35) := 'CREATE_REBOOK_CONTRACT';

Line 25657: x_program_agreement_id OKC_K_HEADERS_V.ID%TYPE;

25653: x_khrv_rec OUT NOCOPY khrv_rec_type
25654: ) IS
25655: l_proc_name VARCHAR2(35) := 'POPULATE_HEADER_REC';
25656: -- l_qcl_id NUMBER;
25657: x_program_agreement_id OKC_K_HEADERS_V.ID%TYPE;
25658: x_product_id NUMBER;
25659:
25660: CURSOR customer_csr (p_customer_number OKX_PARTIES_V.PARTY_NUMBER%TYPE,
25661: p_customer_id OKX_PARTIES_V.ID1%TYPE) IS

Line 27539: x_master_lease_id OKC_K_HEADERS_V.ID%TYPE;

27535:
27536: -- local variables
27537: l_proc_name VARCHAR2(35) := 'LOAD_INPUT_RECORD';
27538: l_progress VARCHAR2(3) := NULL;
27539: x_master_lease_id OKC_K_HEADERS_V.ID%TYPE;
27540: x_customer_account_id NUMBER;
27541: x_inventory_org_id NUMBER;
27542: x_inventory_item_id NUMBER;
27543: x_lse_id NUMBER;

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

28567: payment_schedule_number,
28568: start_date;
28569:
28570:
28571: CURSOR temp_role_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28572: --Fixed Bug # 5484903
28573: SELECT object1_id1
28574: FROM okc_k_party_roles_b
28575: WHERE dnz_chr_id = p_chr_id

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

28579:
28580: l_customer_id okc_k_party_roles_v.object1_id1%TYPE;
28581: l_customer_number okl_header_interface.customer_number%TYPE;
28582:
28583: CURSOR temp_sales_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
28584: SELECT sales.object1_id1
28585: FROM okc_contacts_v sales,
28586: okc_k_party_roles_v party
28587: WHERE sales.cpl_id = party.id

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

28592:
28593: l_salesperson_id okc_contacts_v.object1_id1%TYPE;
28594: l_salesperson_name okl_header_interface.salesperson_name%TYPE;
28595:
28596: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28597: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28598: SELECT head.id
28599: FROM okc_k_headers_v head,
28600: okc_governances gov

Line 28597: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS

28593: l_salesperson_id okc_contacts_v.object1_id1%TYPE;
28594: l_salesperson_name okl_header_interface.salesperson_name%TYPE;
28595:
28596: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28597: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28598: SELECT head.id
28599: FROM okc_k_headers_v head,
28600: okc_governances gov
28601: WHERE head.id = gov.chr_id_referred

Line 28599: FROM okc_k_headers_v head,

28595:
28596: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28597: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28598: SELECT head.id
28599: FROM okc_k_headers_v head,
28600: okc_governances gov
28601: WHERE head.id = gov.chr_id_referred
28602: AND head.scs_code = p_scs_code --'MASTER_LEASE'
28603: AND gov.dnz_chr_id = p_chr_id;