APPS.ZX_CONDITIONS_PKG dependencies on ZX_CONDITIONS

Line 1: package body ZX_CONDITIONS_PKG as

1: package body ZX_CONDITIONS_PKG as
2: /* $Header: zxdconditionsb.pls 120.5.12020000.2 2013/01/31 06:43:40 srajapar ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;

Line 2: /* $Header: zxdconditionsb.pls 120.5.12020000.2 2013/01/31 06:43:40 srajapar ship $ */

1: package body ZX_CONDITIONS_PKG as
2: /* $Header: zxdconditionsb.pls 120.5.12020000.2 2013/01/31 06:43:40 srajapar ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_CONDITIONS_PKG.';

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_CONDITIONS_PKG.';
13: -- Logging Infra
14:
15: procedure bulk_insert_conditions (
16: X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,

Line 47: INSERT INTO ZX_CONDITIONS

43: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
44:
45: If x_determining_factor_code.count <> 0 then
46: forall i in x_determining_factor_code.first..x_determining_factor_code.last
47: INSERT INTO ZX_CONDITIONS
48: (condition_id,
49: determining_factor_code,
50: condition_group_code,
51: tax_parameter_code,

Line 73: (zx_conditions_s.nextval,

69: program_application_id,
70: program_id,
71: program_login_id)
72: VALUES
73: (zx_conditions_s.nextval,
74: X_DETERMINING_FACTOR_CODE(i),
75: X_CONDITION_GROUP_CODE(i),
76: X_TAX_PARAMETER_CODE(i),
77: X_DATA_TYPE_CODE(i),

Line 164: -- repeating the query under two clauses to do complete index scan on ZX_CONDITIONS_N1

160: ': value_high :'||p_value_high
161: );
162: END IF;
163: -- bug 16211363 adding determining_factor_cq_code as well for duplicate check
164: -- repeating the query under two clauses to do complete index scan on ZX_CONDITIONS_N1
165: IF p_det_factor_cq_code IS NULL THEN
166: SELECT a.condition_group_code
167: INTO x_condition_group_code
168: FROM zx_condition_groups_b a, zx_conditions b

Line 168: FROM zx_condition_groups_b a, zx_conditions b

164: -- repeating the query under two clauses to do complete index scan on ZX_CONDITIONS_N1
165: IF p_det_factor_cq_code IS NULL THEN
166: SELECT a.condition_group_code
167: INTO x_condition_group_code
168: FROM zx_condition_groups_b a, zx_conditions b
169: WHERE a.det_factor_templ_code = p_det_factor_templ_code
170: AND a.condition_group_id <> p_condition_group_id
171: AND b.condition_id <> p_condition_id
172: AND b.condition_group_code = a.condition_group_code

Line 187: FROM zx_condition_groups_b a, zx_conditions b

183: AND rownum = 1;
184: ELSE
185: SELECT a.condition_group_code
186: INTO x_condition_group_code
187: FROM zx_condition_groups_b a, zx_conditions b
188: WHERE a.det_factor_templ_code = p_det_factor_templ_code
189: AND a.condition_group_id <> p_condition_group_id
190: AND b.condition_id <> p_condition_id
191: AND b.condition_group_code = a.condition_group_code

Line 231: END ZX_CONDITIONS_PKG;

227: END IF;
228:
229: END CHECK_DUP_TAX_CONDITIONS;
230:
231: END ZX_CONDITIONS_PKG;