APPS.HZ_PARTY_SITES_EXT_PKG dependencies on HZ_PARTY_SITES_EXT_B

Line 85: cursor C is select ROWID from HZ_PARTY_SITES_EXT_B

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

Line 89: insert into HZ_PARTY_SITES_EXT_B (

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

Line 417: from HZ_PARTY_SITES_EXT_B

413: D_EXT_ATTR7,
414: D_EXT_ATTR8,
415: D_EXT_ATTR9,
416: D_EXT_ATTR10
417: from HZ_PARTY_SITES_EXT_B
418: where EXTENSION_ID = X_EXTENSION_ID
419: for update of EXTENSION_ID nowait;
420: recinfo c%rowtype;
421:

Line 698: update HZ_PARTY_SITES_EXT_B set

694: X_LAST_UPDATED_BY in NUMBER,
695: X_LAST_UPDATE_LOGIN in NUMBER
696: ) is
697: begin
698: update HZ_PARTY_SITES_EXT_B set
699: PARTY_SITE_ID = X_PARTY_SITE_ID,
700: ATTR_GROUP_ID = X_ATTR_GROUP_ID,
701: C_EXT_ATTR1 = X_C_EXT_ATTR1,
702: C_EXT_ATTR2 = X_C_EXT_ATTR2,

Line 803: delete from HZ_PARTY_SITES_EXT_B

799: if (sql%notfound) then
800: raise no_data_found;
801: end if;
802:
803: delete from HZ_PARTY_SITES_EXT_B
804: where EXTENSION_ID = X_EXTENSION_ID;
805:
806: if (sql%notfound) then
807: raise no_data_found;