APPS.CSFW_REQ_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 37

 cursor c_next_header is select CSP_REQUIREMENT_HEADERS_S1.nextval from dual;

Line: 182

PROCEDURE DELETE_REQUIREMENT_HEADER
(
  p_header_id IN NUMBER
, x_error_id  OUT NOCOPY NUMBER
, x_error     OUT NOCOPY VARCHAR2
)
IS
    l_req_hdr_rec CSP_Requirement_headers_PVT.REQUIREMENT_HEADER_Rec_Type;

Line: 199

	CSP_Requirement_headers_PVT.Delete_requirement_headers(
	P_Api_Version_Number         => 1.0,
	P_Init_Msg_List              => FND_API.G_FALSE,
	P_Commit                     => FND_API.G_TRUE,
	p_validation_level           => FND_API.G_VALID_LEVEL_FULL,
	P_REQUIREMENT_HEADER_Rec     => l_req_hdr_rec,
	X_Return_Status              => l_Return_Status,
	X_Msg_Count                  => l_Msg_Count,
	X_Msg_Data                   => l_Msg_Data
	);

Line: 236

END DELETE_REQUIREMENT_HEADER;

Line: 277

    cursor c_next_line is select CSP_REQUIREMENT_LINES_S1.nextval from dual;

Line: 424

PROCEDURE DELETE_REQUIREMENT_LINE
(
  p_LINE_ID   IN NUMBER
, x_error_id  OUT NOCOPY NUMBER
, x_error     OUT NOCOPY VARCHAR2
)
IS
    l_req_line_rec   CSP_Requirement_Lines_PVT.Requirement_Line_Rec_Type;

Line: 448

CSP_Requirement_Lines_PVT.Delete_requirement_lines(
    P_Api_Version_Number        => 1.0,
    P_Init_Msg_List             => FND_API.G_FALSE,
    P_Commit                    => FND_API.G_TRUE,
    p_validation_level          => FND_API.G_VALID_LEVEL_FULL,
    P_Requirement_Line_Tbl      => l_req_table,
    X_Return_Status             => l_Return_Status,
    X_Msg_Count                 => l_Msg_Count,
    X_Msg_Data                  => l_data
    );

Line: 480

	  delete CSP_requirement_lines where REQUIREMENT_LINE_ID = p_LINE_ID;

Line: 491

END DELETE_REQUIREMENT_LINE;