APPS.OZF_REQUEST_HEADERS_ALL_PKG dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 119: cursor C is select ROWID from OZF_REQUEST_HEADERS_ALL_B

115: X_SECURITY_GROUP_ID in NUMBER,
116: X_REQUEST_NAME in VARCHAR2,
117: X_REQUEST_DESCRIPTION in VARCHAR2, X_COMMENTS in VARCHAR2
118: ) is
119: cursor C is select ROWID from OZF_REQUEST_HEADERS_ALL_B
120: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
121: ;
122: begin
123: insert into OZF_REQUEST_HEADERS_ALL_B (

Line 123: insert into OZF_REQUEST_HEADERS_ALL_B (

119: cursor C is select ROWID from OZF_REQUEST_HEADERS_ALL_B
120: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
121: ;
122: begin
123: insert into OZF_REQUEST_HEADERS_ALL_B (
124: REQUEST_HEADER_ID,
125: OBJECT_VERSION_NUMBER,
126: CREATION_DATE,
127: CREATED_BY,

Line 614: from OZF_REQUEST_HEADERS_ALL_B

610: ATTRIBUTE14,
611: ATTRIBUTE15,
612: SECURITY_GROUP_ID,
613: ORG_ID
614: from OZF_REQUEST_HEADERS_ALL_B
615: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
616: for update of REQUEST_HEADER_ID nowait;
617: recinfo c%rowtype;
618:

Line 953: update OZF_REQUEST_HEADERS_ALL_B set

949: X_PROGRAM_UPDATE_DATE date,
950: X_ORG_ID NUMBER
951: ) is
952: begin
953: update OZF_REQUEST_HEADERS_ALL_B set
954: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
955: REQUEST_ID = X_REQUEST_ID,
956: program_application_id = X_program_application_id,
957: program_update_date = X_program_update_date,

Line 1095: delete from OZF_REQUEST_HEADERS_ALL_B

1091: if (sql%notfound) then
1092: raise no_data_found;
1093: end if;
1094:
1095: delete from OZF_REQUEST_HEADERS_ALL_B
1096: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
1097:
1098: if (sql%notfound) then
1099: raise no_data_found;

Line 1109: from OZF_REQUEST_HEADERS_ALL_B B

1105: begin
1106: delete from OZF_REQUEST_HEADERS_ALL_TL T
1107: where not exists
1108: (select NULL
1109: from OZF_REQUEST_HEADERS_ALL_B B
1110: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
1111: );
1112:
1113: update OZF_REQUEST_HEADERS_ALL_TL T set (