DBA Data[Home] [Help]

APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 64: p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL,

60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2,
63: p_hdr_rec IN program_header_rec_type,
64: p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL,
65: p_chrv_rec IN chrv_rec_type,
66: p_khrv_rec IN khrv_rec_type,
67: x_chrv_rec OUT NOCOPY chrv_rec_type,
68: x_khrv_rec OUT NOCOPY khrv_rec_type) IS

Line 452: p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL) RETURN VARCHAR2 IS

448: | DESC : Validation of Attributes |
449: | HISTORY: 20 March 2002 Created by Murthy |
450: *-------------------------------------------------------------------------- */
451: FUNCTION validate_attributes(p_hdr_rec program_header_rec_type,
452: p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL) RETURN VARCHAR2 IS
453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
454: l_dummy VARCHAR2(1);
455: l_found BOOLEAN;
456: BEGIN

Line 599: p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL,

595: x_return_status OUT NOCOPY VARCHAR2,
596: x_msg_count OUT NOCOPY NUMBER,
597: x_msg_data OUT NOCOPY VARCHAR2,
598: p_hdr_rec IN program_header_rec_type,
599: p_parent_agreement_number IN okl_k_headers_full_v.contract_number%TYPE DEFAULT NULL,
600: x_header_rec OUT NOCOPY chrv_rec_type,
601: x_k_header_rec OUT NOCOPY khrv_rec_type)
602: IS
603: l_api_version NUMBER := 1.0;

Line 1049: p_program_id IN okl_k_headers_full_v.id%TYPE,

1045: x_return_status OUT NOCOPY VARCHAR2,
1046: x_msg_count OUT NOCOPY NUMBER,
1047: x_msg_data OUT NOCOPY VARCHAR2,
1048: p_hdr_rec IN program_header_rec_type,
1049: p_program_id IN okl_k_headers_full_v.id%TYPE,
1050: p_parent_agreement_id IN okc_k_headers_v.ID%TYPE DEFAULT NULL)
1051: IS
1052:
1053: -- check for whether update is allowed for this contract

Line 1573: FUNCTION Is_Process_Active(p_chr_id IN okl_k_headers_full_v.id%TYPE) RETURN VARCHAR2 IS

1569: -- Function to check if a workflow is active for a contract
1570: -- Function Name: Is_Process_Active
1571: -- An item is considered active if its end_date is NULL
1572:
1573: FUNCTION Is_Process_Active(p_chr_id IN okl_k_headers_full_v.id%TYPE) RETURN VARCHAR2 IS
1574:
1575: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;
1576: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;
1577: l_return_code VARCHAR2(1) := 'N';