APPS.ZX_REG_REL_PUB dependencies on ZX_REGIME_RELATIONS

Line 29: from zx_regime_relations

25: CURSOR C1 is
26: SELECT
27: PARENT_REGIME_CODE,
28: PARENT_REG_LEVEL+1 as lev
29: from zx_regime_relations
30: WHERE REGIME_CODE = p_parent;
31: R1 C1%rowtype;
32: l_level Number := 0;
33: BEGIN

Line 37: insert into zx_regime_relations (regime_rel_id,

33: BEGIN
34: -- Initialize API return status to success
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36: -- Insert a record with level zero
37: insert into zx_regime_relations (regime_rel_id,
38: regime_code,
39: parent_regime_code,
40: parent_reg_level,
41: CREATED_BY,

Line 50: values (zx_regime_relations_s.NEXTVAL,

46: REQUEST_ID,
47: PROGRAM_ID,
48: PROGRAM_LOGIN_ID,
49: PROGRAM_APPLICATION_ID)
50: values (zx_regime_relations_s.NEXTVAL,
51: p_child,
52: p_parent,
53: l_level,
54: X_CREATED_BY,

Line 71: insert into zx_regime_relations (regime_rel_id, regime_code,

67: IF C1%NOTFOUND THEN
68: exit;
69: END IF;
70: -- Generating the hierarchy for the child based on the parent hierarchy
71: insert into zx_regime_relations (regime_rel_id, regime_code,
72: parent_regime_code,
73: parent_reg_level,
74: CREATED_BY,
75: CREATION_DATE,

Line 83: values (zx_regime_relations_s.NEXTVAL,

79: REQUEST_ID,
80: PROGRAM_ID,
81: PROGRAM_LOGIN_ID,
82: PROGRAM_APPLICATION_ID)
83: values (zx_regime_relations_s.NEXTVAL,
84: p_child,
85: R1.PARENT_REGIME_CODE,
86: R1.LEV,
87: X_CREATED_BY,

Line 132: FROM zx_regime_relations

128: CURSOR C1 is
129: SELECT
130: REGIME_CODE ,
131: PARENT_REGIME_CODE
132: FROM zx_regime_relations
133: WHERE PARENT_REGIME_CODE = p_child AND
134: PARENT_REG_LEVEL = 0;
135: R1 C1%rowtype;
136: l_err_status VARCHAR2(1) ;

Line 142: from zx_regime_relations

138: -- Initialize API return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: -- Delete all the current records of the child
141: Delete
142: from zx_regime_relations
143: where regime_code = p_child;
144: -- Regenerate the child hierarchy with the new parent if the p_parent is not null
145: IF p_parent iS NOT NULL THEN
146: insert_rel(l_err_status,p_child,p_parent,

Line 532: from zx_REGIME_RELATIONS

528: SELECT
529: REGIME_CODE,
530: PARENT_REGIME_CODE,
531: PARENT_REG_LEVEL
532: from zx_REGIME_RELATIONS
533: WHERE REGIME_CODE = p_tax_regime_code;
534: R1 C1%rowtype;
535: l_num NUMBER := 1;
536: BEGIN