APPS.HZ_PER_PROFILES_EXT_PKG dependencies on HZ_PER_PROFILES_EXT_B

Line 86: cursor C is select ROWID from HZ_PER_PROFILES_EXT_B

82: X_LAST_UPDATE_DATE in DATE,
83: X_LAST_UPDATED_BY in NUMBER,
84: X_LAST_UPDATE_LOGIN in NUMBER
85: ) is
86: cursor C is select ROWID from HZ_PER_PROFILES_EXT_B
87: where EXTENSION_ID = X_EXTENSION_ID
88: ;
89: begin
90: insert into HZ_PER_PROFILES_EXT_B (

Line 90: insert into HZ_PER_PROFILES_EXT_B (

86: cursor C is select ROWID from HZ_PER_PROFILES_EXT_B
87: where EXTENSION_ID = X_EXTENSION_ID
88: ;
89: begin
90: insert into HZ_PER_PROFILES_EXT_B (
91: EXTENSION_ID,
92: PERSON_PROFILE_ID,
93: ATTR_GROUP_ID,
94: C_EXT_ATTR1,

Line 422: from HZ_PER_PROFILES_EXT_B

418: D_EXT_ATTR8,
419: D_EXT_ATTR9,
420: D_EXT_ATTR10,
421: OLD_EXTENSION_ID
422: from HZ_PER_PROFILES_EXT_B
423: where EXTENSION_ID = X_EXTENSION_ID
424: for update of EXTENSION_ID nowait;
425: recinfo c%rowtype;
426:

Line 706: update HZ_PER_PROFILES_EXT_B set

702: X_LAST_UPDATED_BY in NUMBER,
703: X_LAST_UPDATE_LOGIN in NUMBER
704: ) is
705: begin
706: update HZ_PER_PROFILES_EXT_B set
707: PERSON_PROFILE_ID = X_PERSON_PROFILE_ID,
708: ATTR_GROUP_ID = X_ATTR_GROUP_ID,
709: C_EXT_ATTR1 = X_C_EXT_ATTR1,
710: C_EXT_ATTR2 = X_C_EXT_ATTR2,

Line 812: delete from HZ_PER_PROFILES_EXT_B

808: if (sql%notfound) then
809: raise no_data_found;
810: end if;
811:
812: delete from HZ_PER_PROFILES_EXT_B
813: where EXTENSION_ID = X_EXTENSION_ID;
814:
815: if (sql%notfound) then
816: raise no_data_found;