APPS.HZ_ORG_PROFILES_EXT_PKG dependencies on HZ_ORG_PROFILES_EXT_B

Line 86: cursor C is select ROWID from HZ_ORG_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_ORG_PROFILES_EXT_B
87: where EXTENSION_ID = X_EXTENSION_ID
88: ;
89: begin
90: insert into HZ_ORG_PROFILES_EXT_B (

Line 90: insert into HZ_ORG_PROFILES_EXT_B (

86: cursor C is select ROWID from HZ_ORG_PROFILES_EXT_B
87: where EXTENSION_ID = X_EXTENSION_ID
88: ;
89: begin
90: insert into HZ_ORG_PROFILES_EXT_B (
91: N_EXT_ATTR19,
92: N_EXT_ATTR20,
93: D_EXT_ATTR1,
94: D_EXT_ATTR2,

Line 422: from HZ_ORG_PROFILES_EXT_B

418: N_EXT_ATTR15,
419: N_EXT_ATTR16,
420: N_EXT_ATTR17,
421: N_EXT_ATTR18
422: from HZ_ORG_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_ORG_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_ORG_PROFILES_EXT_B set
707: N_EXT_ATTR19 = X_N_EXT_ATTR19,
708: N_EXT_ATTR20 = X_N_EXT_ATTR20,
709: D_EXT_ATTR1 = X_D_EXT_ATTR1,
710: D_EXT_ATTR2 = X_D_EXT_ATTR2,

Line 812: delete from HZ_ORG_PROFILES_EXT_B

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