APPS.OZF_SD_REQUEST_HEADERS_ALL_PKG dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 70: cursor C is select ROWID from OZF_SD_REQUEST_HEADERS_ALL_B

66: X_LAST_UPDATE_DATE in DATE,
67: X_LAST_UPDATED_BY in NUMBER,
68: X_LAST_UPDATE_LOGIN in NUMBER
69: ) is
70: cursor C is select ROWID from OZF_SD_REQUEST_HEADERS_ALL_B
71: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
72: ;
73: begin
74: insert into OZF_SD_REQUEST_HEADERS_ALL_B (

Line 74: insert into OZF_SD_REQUEST_HEADERS_ALL_B (

70: cursor C is select ROWID from OZF_SD_REQUEST_HEADERS_ALL_B
71: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
72: ;
73: begin
74: insert into OZF_SD_REQUEST_HEADERS_ALL_B (
75: USER_STATUS_ID,
76: REQUEST_HEADER_ID,
77: OBJECT_VERSION_NUMBER,
78: REQUEST_ID,

Line 365: from OZF_SD_REQUEST_HEADERS_ALL_B

361: INTERNAL_SUBMISSION_DATE,
362: ASIGNEE_RESPONSE_BY_DATE,
363: ASIGNEE_RESPONSE_DATE,
364: SUBMTD_BY_FOR_SUPP_APPROVAL
365: from OZF_SD_REQUEST_HEADERS_ALL_B
366: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
367: for update of REQUEST_HEADER_ID nowait;
368: recinfo c%rowtype;
369:

Line 583: update OZF_SD_REQUEST_HEADERS_ALL_B set

579: X_LAST_UPDATED_BY in NUMBER,
580: X_LAST_UPDATE_LOGIN in NUMBER
581: ) is
582: begin
583: update OZF_SD_REQUEST_HEADERS_ALL_B set
584: USER_STATUS_ID = X_USER_STATUS_ID,
585: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
586: REQUEST_ID = X_REQUEST_ID,
587: CREATED_FROM = X_CREATED_FROM,

Line 675: delete from OZF_SD_REQUEST_HEADERS_ALL_B

671: if (sql%notfound) then
672: raise no_data_found;
673: end if;
674:
675: delete from OZF_SD_REQUEST_HEADERS_ALL_B
676: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
677:
678: if (sql%notfound) then
679: raise no_data_found;

Line 689: from OZF_SD_REQUEST_HEADERS_ALL_B B

685: begin
686: delete from OZF_SD_REQUEST_HEADERS_ALL_TL T
687: where not exists
688: (select NULL
689: from OZF_SD_REQUEST_HEADERS_ALL_B B
690: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
691: );
692:
693: update OZF_SD_REQUEST_HEADERS_ALL_TL T set (