APPS.JTF_PERZ_DATA_PVT dependencies on JTF_PERZ_DATA_ATTRIB

Line 42: -- 2. insert_jtf_perz_data_attrib

38: -- *****************************************************************************
39: -- *****************************************************************************
40: -- TABLE HANDLERS
41: -- 1. insert_jtf_perz_data
42: -- 2. insert_jtf_perz_data_attrib
43: -- 3. update_jtf_perz_data
44: -- *****************************************************************************
45: -- *****************************************************************************
46: --

Line 89: PROCEDURE insert_jtf_perz_data_attrib(

85: 1, G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID);
86: End insert_jtf_perz_data;
87:
88: -- *****************************************************************************
89: PROCEDURE insert_jtf_perz_data_attrib(
90: px_PERZ_DATA_ATTRIB_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
91: p_PERZ_DATA_ID NUMBER,
92: p_ATTRIBUTE_NAME VARCHAR2,
93: p_ATTRIBUTE_TYPE VARCHAR2,

Line 98: CURSOR C2 IS SELECT JTF_PERZ_DATA_ATTRIBUTES_S.nextval FROM sys.dual;

94: p_ATTRIBUTE_VALUE VARCHAR2,
95: p_ATTRIBUTE_CONTEXT VARCHAR2)
96:
97: IS
98: CURSOR C2 IS SELECT JTF_PERZ_DATA_ATTRIBUTES_S.nextval FROM sys.dual;
99: BEGIN
100: If (px_PERZ_DATA_ATTRIB_ID IS NULL) OR (px_PERZ_DATA_ATTRIB_ID = FND_API.G_MISS_NUM) then
101: OPEN C2;
102: FETCH C2 INTO px_PERZ_DATA_ATTRIB_ID;

Line 105: INSERT INTO JTF_PERZ_DATA_ATTRIB(

101: OPEN C2;
102: FETCH C2 INTO px_PERZ_DATA_ATTRIB_ID;
103: CLOSE C2;
104: End If;
105: INSERT INTO JTF_PERZ_DATA_ATTRIB(
106: PERZ_DATA_ATTRIB_ID,
107: PERZ_DATA_ID,
108: ATTRIBUTE_NAME,
109: ATTRIBUTE_TYPE,

Line 125: End insert_jtf_perz_data_attrib;

121: decode( p_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_VALUE),
122: decode( p_ATTRIBUTE_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CONTEXT),
123: G_USER_ID, SYSDATE, G_USER_ID, G_LOGIN_ID );
124:
125: End insert_jtf_perz_data_attrib;
126:
127: -- *****************************************************************************
128:
129: PROCEDURE update_jtf_perz_data(

Line 609: insert_jtf_perz_data_attrib(

605:
606: l_PERZ_DATA_ATTRIB_ID :=p_data_attrib_tbl(l_curr_row).PERZ_DATA_ATTRIB_ID ;
607: --dbms_output.put_line('attribute count ' || p_data_attrib_tbl.count);
608:
609: insert_jtf_perz_data_attrib(
610: l_PERZ_DATA_ATTRIB_ID,
611: l_perz_data_id,
612: p_data_attrib_tbl(l_curr_row).ATTRIBUTE_NAME,
613: p_data_attrib_tbl(l_curr_row).ATTRIBUTE_TYPE,

Line 716: FROM jtf_perz_data_attrib

712: -- cursors
713: CURSOR C_Get_Perz_Data (p_perz_data_id NUMBER ) IS
714: SELECT perz_data_attrib_id, perz_data_id, attribute_name,
715: attribute_type, attribute_value, attribute_context
716: FROM jtf_perz_data_attrib
717: WHERE perz_data_id = p_perz_data_id;
718:
719:
720: BEGIN

Line 1309: DELETE FROM JTF_PERZ_DATA_ATTRIB WHERE

1305:
1306: IF (FND_API.To_Boolean(l_is_duplicate)) THEN
1307: -- 2. Delete all the attributes for that Perz Data ID
1308:
1309: DELETE FROM JTF_PERZ_DATA_ATTRIB WHERE
1310: PERZ_DATA_ID = l_perz_data_id;
1311:
1312: -- 3. Update Perz Data header information
1313: update_jtf_perz_data(

Line 1329: insert_jtf_perz_data_attrib(

1325: IF (p_data_attrib_tbl.COUNT > 0) THEN
1326: FOR l_curr_row in 1..p_data_attrib_tbl.COUNT LOOP
1327:
1328: l_PERZ_DATA_ATTRIB_ID :=p_data_attrib_tbl(l_curr_row).PERZ_DATA_ATTRIB_ID ;
1329: insert_jtf_perz_data_attrib(
1330: l_PERZ_DATA_ATTRIB_ID,
1331: l_perz_data_id,
1332: p_data_attrib_tbl(l_curr_row).ATTRIBUTE_NAME,
1333: p_data_attrib_tbl(l_curr_row).ATTRIBUTE_TYPE,

Line 1445: DELETE FROM JTF_PERZ_DATA_ATTRIB WHERE

1441: -- CALL FLOW
1442: --1 Delete all the attributes
1443: --2 Delete the Perz Data
1444:
1445: DELETE FROM JTF_PERZ_DATA_ATTRIB WHERE
1446: PERZ_DATA_ID = p_perz_data_id;
1447: DELETE FROM JTF_PERZ_DATA WHERE
1448: PERZ_DATA_ID = p_perz_data_id;
1449: