DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PVT dependencies on OKL_FMLA_OPRNDS_V

Line 11: -- PROCEDURE get_rec for: OKL_FMLA_OPRNDS_V

7: IS_DEBUG_PROCEDURE_ON BOOLEAN;
8: -- End of wraper code generated automatically by Debug code generator
9:
10: ---------------------------------------------------------------------------
11: -- PROCEDURE get_rec for: OKL_FMLA_OPRNDS_V
12: ---------------------------------------------------------------------------
13: PROCEDURE get_rec (
14: p_fodv_rec IN fodv_rec_type,
15: x_return_status OUT NOCOPY VARCHAR2,

Line 31: FROM Okl_Fmla_Oprnds_V

27: CREATION_DATE,
28: LAST_UPDATED_BY,
29: LAST_UPDATE_DATE,
30: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
31: FROM Okl_Fmla_Oprnds_V
32: WHERE okl_Fmla_Oprnds_V.id = p_id;
33: l_okl_fodv_pk okl_fodv_pk_csr%ROWTYPE;
34: l_fodv_rec fodv_rec_type;
35: BEGIN

Line 32: WHERE okl_Fmla_Oprnds_V.id = p_id;

28: LAST_UPDATED_BY,
29: LAST_UPDATE_DATE,
30: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
31: FROM Okl_Fmla_Oprnds_V
32: WHERE okl_Fmla_Oprnds_V.id = p_id;
33: l_okl_fodv_pk okl_fodv_pk_csr%ROWTYPE;
34: l_fodv_rec fodv_rec_type;
35: BEGIN
36: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 74: -- PROCEDURE check_operands for: OKL_FMLA_OPRNDS_V

70:
71: END get_rec;
72:
73: ---------------------------------------------------------------------------
74: -- PROCEDURE check_operands for: OKL_FMLA_OPRNDS_V
75: -- To verify whether the dates are valid for both formula and operands
76: -- attached to it
77: ---------------------------------------------------------------------------
78: PROCEDURE check_operands (

Line 114: p_token2_value => 'Okl_Fmla_Oprnds_V');

110: p_msg_name => G_DATES_MISMATCH,
111: p_token1 => G_PARENT_TABLE_TOKEN,
112: p_token1_value => 'Okl_Operands_V',
113: p_token2 => G_CHILD_TABLE_TOKEN,
114: p_token2_value => 'Okl_Fmla_Oprnds_V');
115: x_valid := FALSE;
116: x_return_status := OKL_API.G_RET_STS_ERROR;
117: END IF;
118:

Line 139: -- PROCEDURE insert_fmaconstraints for: OKL_FMLA_OPRNDS_V

135:
136: END check_operands;
137:
138: ---------------------------------------------------------------------------
139: -- PROCEDURE insert_fmaconstraints for: OKL_FMLA_OPRNDS_V
140: ---------------------------------------------------------------------------
141: PROCEDURE insert_fmaconstraints(p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,

Line 248: -- PROCEDURE update_fmaconstraints for: OKL_FMLA_OPRNDS_V

244:
245: END insert_fmaconstraints;
246:
247: ---------------------------------------------------------------------------
248: -- PROCEDURE update_fmaconstraints for: OKL_FMLA_OPRNDS_V
249: ---------------------------------------------------------------------------
250: PROCEDURE update_fmaconstraints(p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,

Line 357: -- PROCEDURE delete_fmaconstraints for: OKL_FMLA_OPRNDS_V

353: END update_fmaconstraints;
354:
355:
356: ---------------------------------------------------------------------------
357: -- PROCEDURE delete_fmaconstraints for: OKL_FMLA_OPRNDS_V
358: -- This allows the user to delete table of records
359: ---------------------------------------------------------------------------
360: PROCEDURE delete_fmaconstraints(
361: p_api_version IN NUMBER