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_SETUPOVERULES_PVT dependencies on OKL_OPV_RULES_V

Line 6: -- PROCEDURE get_rec for: OKL_OPV_RULES_V

2: /* $Header: OKLRSODB.pls 115.9 2003/07/23 18:32:50 sgorantl noship $ */
3: G_ITEM_NOT_FOUND_ERROR EXCEPTION;
4: G_COLUMN_TOKEN CONSTANT VARCHAR2(100) := 'COLUMN';
5: ---------------------------------------------------------------------------
6: -- PROCEDURE get_rec for: OKL_OPV_RULES_V
7: ---------------------------------------------------------------------------
8: PROCEDURE get_rec (
9: p_ovdv_rec IN ovdv_rec_type,
10: x_return_status OUT NOCOPY VARCHAR2,

Line 31: FROM Okl_Opv_Rules_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_Opv_Rules_V
32: WHERE Okl_Opv_Rules_V.id = p_id;
33: l_okl_ovdv_pk okl_ovdv_pk_csr%ROWTYPE;
34: l_ovdv_rec ovdv_rec_type;
35: BEGIN

Line 32: WHERE Okl_Opv_Rules_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_Opv_Rules_V
32: WHERE Okl_Opv_Rules_V.id = p_id;
33: l_okl_ovdv_pk okl_ovdv_pk_csr%ROWTYPE;
34: l_ovdv_rec ovdv_rec_type;
35: BEGIN
36: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 79: -- PROCEDURE check_constraints for: OKL_OPV_RULES_V

75:
76: END get_rec;
77:
78: ---------------------------------------------------------------------------
79: -- PROCEDURE check_constraints for: OKL_OPV_RULES_V
80: -- To verify whether an addition of new option value rule is ok with rest
81: -- of the product - contract relationships
82: ---------------------------------------------------------------------------
83: PROCEDURE Check_Constraints (

Line 126: CURSOR okl_ovd_ovt_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE

122: WHERE ove.ID = p_ove_id
123: AND NVL(ove.TO_DATE, p_date) < p_date;
124:
125:
126: CURSOR okl_ovd_ovt_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE
127: ) IS
128: SELECT '1'
129: FROM Okl_Ovd_Rul_Tmls_V ovt
130: WHERE ovt.OVD_ID = p_ovd_id;

Line 132: CURSOR c1(p_orl_id okl_opv_rules_v.orl_id%TYPE,

128: SELECT '1'
129: FROM Okl_Ovd_Rul_Tmls_V ovt
130: WHERE ovt.OVD_ID = p_ovd_id;
131:
132: CURSOR c1(p_orl_id okl_opv_rules_v.orl_id%TYPE,
133: p_ove_id okl_opv_rules_v.ove_id%TYPE,
134: p_context_intent okl_opv_rules_v.context_intent%TYPE,
135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,

Line 133: p_ove_id okl_opv_rules_v.ove_id%TYPE,

129: FROM Okl_Ovd_Rul_Tmls_V ovt
130: WHERE ovt.OVD_ID = p_ovd_id;
131:
132: CURSOR c1(p_orl_id okl_opv_rules_v.orl_id%TYPE,
133: p_ove_id okl_opv_rules_v.ove_id%TYPE,
134: p_context_intent okl_opv_rules_v.context_intent%TYPE,
135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,
137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS

Line 134: p_context_intent okl_opv_rules_v.context_intent%TYPE,

130: WHERE ovt.OVD_ID = p_ovd_id;
131:
132: CURSOR c1(p_orl_id okl_opv_rules_v.orl_id%TYPE,
133: p_ove_id okl_opv_rules_v.ove_id%TYPE,
134: p_context_intent okl_opv_rules_v.context_intent%TYPE,
135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,
137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS
138: SELECT '1'

Line 135: p_context_org okl_opv_rules_v.context_org%TYPE,

131:
132: CURSOR c1(p_orl_id okl_opv_rules_v.orl_id%TYPE,
133: p_ove_id okl_opv_rules_v.ove_id%TYPE,
134: p_context_intent okl_opv_rules_v.context_intent%TYPE,
135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,
137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS
138: SELECT '1'
139: FROM okl_opv_rules_v

Line 136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,

132: CURSOR c1(p_orl_id okl_opv_rules_v.orl_id%TYPE,
133: p_ove_id okl_opv_rules_v.ove_id%TYPE,
134: p_context_intent okl_opv_rules_v.context_intent%TYPE,
135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,
137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS
138: SELECT '1'
139: FROM okl_opv_rules_v
140: WHERE orl_id = p_orl_id

Line 137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS

133: p_ove_id okl_opv_rules_v.ove_id%TYPE,
134: p_context_intent okl_opv_rules_v.context_intent%TYPE,
135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,
137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS
138: SELECT '1'
139: FROM okl_opv_rules_v
140: WHERE orl_id = p_orl_id
141: AND ove_id = p_ove_id

Line 139: FROM okl_opv_rules_v

135: p_context_org okl_opv_rules_v.context_org%TYPE,
136: p_context_inv_org okl_opv_rules_v.context_inv_org%TYPE,
137: p_context_asset_book okl_opv_rules_v.context_asset_book%TYPE) IS
138: SELECT '1'
139: FROM okl_opv_rules_v
140: WHERE orl_id = p_orl_id
141: AND ove_id = p_ove_id
142: AND context_intent = p_context_intent
143: AND (context_org IS NULL OR context_org = p_context_org)

Line 286: p_token1_value => 'Okl_Opv_Rules_V',

282: IF l_row_not_found = FALSE THEN
283: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
284: p_msg_name => G_DATES_MISMATCH,
285: p_token1 => G_PARENT_TABLE_TOKEN,
286: p_token1_value => 'Okl_Opv_Rules_V',
287: p_token2 => G_CHILD_TABLE_TOKEN,
288: p_token2_value => 'Okl_Lse_Scs_Rules_V');
289: x_valid := FALSE;
290: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 614: -- PROCEDURE insert_overules for: OKL_OPV_RULES_V

610: END Validate_Attributes;
611:
612:
613: ---------------------------------------------------------------------------
614: -- PROCEDURE insert_overules for: OKL_OPV_RULES_V
615: ---------------------------------------------------------------------------
616: PROCEDURE insert_overules(p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
618: x_return_status OUT NOCOPY VARCHAR2,

Line 713: -- PROCEDURE delete_overules for: OKL_OPV_RULES_V

709:
710: END insert_overules;
711:
712: ---------------------------------------------------------------------------
713: -- PROCEDURE delete_overules for: OKL_OPV_RULES_V
714: -- This allows the user to delete table of records
715: ---------------------------------------------------------------------------
716: PROCEDURE delete_overules(p_api_version IN NUMBER,
717: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,