APPS.OKL_SETUPPMVALUES_PVT dependencies on OKL_PTL_PTQ_VALS_V

Line 8: -- PROCEDURE get_rec for: OKL_PTL_PTQ_VALS_V

4: G_ITEM_NOT_FOUND_ERROR EXCEPTION;
5: G_COLUMN_TOKEN CONSTANT VARCHAR2(100) := 'COLUMN';
6: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME'; --- CHG001
7: ---------------------------------------------------------------------------
8: -- PROCEDURE get_rec for: OKL_PTL_PTQ_VALS_V
9: ---------------------------------------------------------------------------
10:
11: PROCEDURE get_rec (
12: p_pmvv_rec IN pmvv_rec_type,

Line 31: FROM Okl_Ptl_Ptq_Vals_V

27: CREATION_DATE,
28: LAST_UPDATED_BY,
29: LAST_UPDATE_DATE,
30: LAST_UPDATE_LOGIN
31: FROM Okl_Ptl_Ptq_Vals_V
32: WHERE okl_ptl_ptq_vals_v.id = p_id;
33: l_okl_pmvv_pk okl_pmvv_pk_csr%ROWTYPE;
34: l_pmvv_rec pmvv_rec_type;
35: BEGIN

Line 32: WHERE okl_ptl_ptq_vals_v.id = p_id;

28: LAST_UPDATED_BY,
29: LAST_UPDATE_DATE,
30: LAST_UPDATE_LOGIN
31: FROM Okl_Ptl_Ptq_Vals_V
32: WHERE okl_ptl_ptq_vals_v.id = p_id;
33: l_okl_pmvv_pk okl_pmvv_pk_csr%ROWTYPE;
34: l_pmvv_rec pmvv_rec_type;
35: BEGIN
36: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 123: -- PROCEDURE check_in_use for: Okl_Ptl_Ptq_Vals_V

119:
120: END get_parent_dates;
121:
122: -----------------------------------------------------------------------------
123: -- PROCEDURE check_in_use for: Okl_Ptl_Ptq_Vals_V
124: -----------------------------------------------------------------------------
125:
126: PROCEDURE Check_Constraints (
127: p_api_version IN NUMBER,

Line 164: CURSOR c1(p_ptl_id okl_ptl_ptq_vals_v.ptl_id%TYPE,

160: AND ((ptv.FROM_DATE > p_from_date OR
161: p_from_date > NVL(ptv.TO_DATE,p_from_date)) OR
162: NVL(ptv.TO_DATE, p_to_date) < p_to_date);
163:
164: CURSOR c1(p_ptl_id okl_ptl_ptq_vals_v.ptl_id%TYPE,
165: p_ptq_id okl_ptl_ptq_vals_v.ptq_id%TYPE) IS
166: SELECT '1'
167: FROM okl_ptl_ptq_vals_v
168: WHERE ptl_id = p_ptl_id

Line 165: p_ptq_id okl_ptl_ptq_vals_v.ptq_id%TYPE) IS

161: p_from_date > NVL(ptv.TO_DATE,p_from_date)) OR
162: NVL(ptv.TO_DATE, p_to_date) < p_to_date);
163:
164: CURSOR c1(p_ptl_id okl_ptl_ptq_vals_v.ptl_id%TYPE,
165: p_ptq_id okl_ptl_ptq_vals_v.ptq_id%TYPE) IS
166: SELECT '1'
167: FROM okl_ptl_ptq_vals_v
168: WHERE ptl_id = p_ptl_id
169: AND ptq_id = p_ptq_id

Line 167: FROM okl_ptl_ptq_vals_v

163:
164: CURSOR c1(p_ptl_id okl_ptl_ptq_vals_v.ptl_id%TYPE,
165: p_ptq_id okl_ptl_ptq_vals_v.ptq_id%TYPE) IS
166: SELECT '1'
167: FROM okl_ptl_ptq_vals_v
168: WHERE ptl_id = p_ptl_id
169: AND ptq_id = p_ptq_id
170: AND id <> NVL(p_pmvv_rec.id,-9999);
171:

Line 454: -- PROCEDURE insert_pmvalues for: OKL_PTL_PTQ_VALS_V

450:
451: END Validate_Attributes;
452:
453: ---------------------------------------------------------------------------
454: -- PROCEDURE insert_pmvalues for: OKL_PTL_PTQ_VALS_V
455: ---------------------------------------------------------------------------
456:
457: PROCEDURE insert_pmvalues(p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 622: -- PROCEDURE delete_pmvalues for: okl_ptl_ptq_vals_v

618: x_return_status := l_overall_status;
619: END insert_pmvalues;
620:
621: ---------------------------------------------------------------------------
622: -- PROCEDURE delete_pmvalues for: okl_ptl_ptq_vals_v
623: -- This allows the user to delete table of records
624: ---------------------------------------------------------------------------
625: PROCEDURE delete_pmvalues(
626: p_api_version IN NUMBER