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

Line 9: FUNCTION validate_total_residual(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS

5: G_RESIDU_NOT_POS_MSG CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INCORRECT_PERCENT';
6:
7: -- this function ensures that the sum of residual share percent on the program agreement is 100%
8: -- and is distributed among the parties of the PA
9: FUNCTION validate_total_residual(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
10: -- rule group VGLRS, rule information categor VGLRSP
11: CURSOR c_get_total_share(cp_chr_id okc_k_headers_b.id%TYPE)IS
12: SELECT NVL(SUM(to_number(rules.rule_information2)),0) total_share
13: FROM okc_rules_b rules

Line 11: CURSOR c_get_total_share(cp_chr_id okc_k_headers_b.id%TYPE)IS

7: -- this function ensures that the sum of residual share percent on the program agreement is 100%
8: -- and is distributed among the parties of the PA
9: FUNCTION validate_total_residual(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
10: -- rule group VGLRS, rule information categor VGLRSP
11: CURSOR c_get_total_share(cp_chr_id okc_k_headers_b.id%TYPE)IS
12: SELECT NVL(SUM(to_number(rules.rule_information2)),0) total_share
13: FROM okc_rules_b rules
14: ,okc_rule_groups_b rule_group
15: WHERE rule_group.id = rules.rgp_id

Line 38: FUNCTION validate_residual_positive(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS

34: RETURN lv_return_status;
35: END validate_total_residual;
36:
37: -- this function ensures that each residual share percent defined against the party in the Terms and Conditions page is a positive number
38: FUNCTION validate_residual_positive(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
39: CURSOR c_get_residual_share(cp_chr_id okc_k_headers_b.id%TYPE)IS
40: SELECT rules.rule_information2 share_percent
41: FROM okc_rules_b rules
42: ,okc_rule_groups_b rule_group

Line 39: CURSOR c_get_residual_share(cp_chr_id okc_k_headers_b.id%TYPE)IS

35: END validate_total_residual;
36:
37: -- this function ensures that each residual share percent defined against the party in the Terms and Conditions page is a positive number
38: FUNCTION validate_residual_positive(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
39: CURSOR c_get_residual_share(cp_chr_id okc_k_headers_b.id%TYPE)IS
40: SELECT rules.rule_information2 share_percent
41: FROM okc_rules_b rules
42: ,okc_rule_groups_b rule_group
43: WHERE rule_group.id = rules.rgp_id

Line 64: FUNCTION validate_residual_parties(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS

60: RETURN lv_return_status;
61: END validate_residual_positive;
62:
63: -- this function ensures that the pary information on the residual share terms and conditions page are valid parties on the program agreement
64: FUNCTION validate_residual_parties(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
65: lv_return_status VARCHAR2(1);
66: BEGIN
67: lv_return_status := 'S';
68: RETURN lv_return_status;

Line 113: ,cp_chr_id okc_k_headers_b.id%TYPE

109: (trunc(cp_start_date) BETWEEN trunc(start_date) AND trunc(nvl(end_date,okl_accounting_util.g_final_date)))
110: );
111:
112: CURSOR c_get_dup_obj_agr (cp_object_id okl_vp_associations.assoc_object_id%TYPE
113: ,cp_chr_id okc_k_headers_b.id%TYPE
114: ,cp_start_date okl_vp_associations.start_date%TYPE
115: ,cp_end_date okl_vp_associations.end_date%TYPE
116: ,cp_object_version okl_vp_associations.assoc_object_version%TYPE
117: ,cp_id okl_vp_associations.id%TYPE

Line 403: FROM OKC_K_HEADERS_B

399: end_date,
400: contract_number,
401: inv_organization_id,
402: sts_code
403: FROM OKC_K_HEADERS_B
404: WHERE id = cp_chr_id;
405:
406: -- Cursor to fetch lease application template record.
407: -- Manu 01-Sep-2005 Change reference_number to name

Line 428: ,okc_k_headers_b chr

424: vp_assoc.assoc_object_type_code,
425: vp_assoc.assoc_object_id,
426: vp_assoc.assoc_object_version
427: FROM okl_vp_associations vp_assoc
428: ,okc_k_headers_b chr
429: ,okc_statuses_b sts
430: WHERE vp_assoc.chr_id = cp_chr_id
431: AND vp_assoc.chr_id = chr.id
432: AND sts.code = chr.sts_code

Line 497: OKC_K_HEADERS_B chrb

493: chrb.sts_code,
494: chrb.start_date,
495: chrb.end_date
496: FROM OKC_GOVERNANCES govb,
497: OKC_K_HEADERS_B chrb
498: WHERE govb.chr_id = cp_chr_id
499: AND govb.chr_id_referred = chrb.id;
500:
501: -- Cursor to fetch the lease application template parameters.

Line 530: okc_k_headers_b chr,

526: cp_end_date IN DATE)IS
527: SELECT lat.name
528: FROM OKL_LEASEAPP_TMPLS lat,
529: okl_vp_associations_v vpa,
530: okc_k_headers_b chr,
531: okc_statuses_b sts
532: WHERE lat.id = vpa.assoc_object_id
533: AND chr.id = vpa.chr_id
534: AND chr.sts_code = sts.code

Line 591: CURSOR c_get_criteria_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

587: )
588: AND chreq.id = vpa.crs_id
589: AND chreq.status_code in ('PASSED','NEW','INCOMPLETE');
590:
591: CURSOR c_get_criteria_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
592: SELECT crit.effective_from_date
593: ,crit.effective_to_date
594: ,crit.match_criteria_code
595: ,cdef.crit_cat_name

Line 605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

601: AND source_id = cp_chr_id
602: AND source_object_code = 'VENDOR_PROGRAM';
603:
604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;

602: AND source_object_code = 'VENDOR_PROGRAM';
603:
604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

Line 607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

603:
604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;

Line 608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;

604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

605: l_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;

Line 610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

606: l_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
614: l_assoc_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;

607: l_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
614: l_assoc_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
615: l_assoc_name VARCHAR2(2000);

Line 612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

608: l_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
614: l_assoc_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
615: l_assoc_name VARCHAR2(2000);
616: p_api_version NUMBER;

Line 613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;

609: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
614: l_assoc_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
615: l_assoc_name VARCHAR2(2000);
616: p_api_version NUMBER;
617: p_init_msg_list VARCHAR2(256) DEFAULT OKC_API.G_FALSE;

Line 614: l_assoc_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

610: l_assoc_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
611: l_assoc_end_date OKC_K_HEADERS_B.END_DATE%TYPE;
612: l_assoc_agrmnt_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
613: l_assoc_inv_org_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%TYPE;
614: l_assoc_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
615: l_assoc_name VARCHAR2(2000);
616: p_api_version NUMBER;
617: p_init_msg_list VARCHAR2(256) DEFAULT OKC_API.G_FALSE;
618: x_msg_count NUMBER;