DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on CSP_REQUIREMENT_LINES_PUB

Line 595: l_RQL_TBL CSP_Requirement_lines_PUB.RQL_Tbl_Type;

591: SOURCED_FROM
592: */
593: FROM csp_requirement_lines
594: WHERE requirement_header_id = p_rqmt_header_id;
595: l_RQL_TBL CSP_Requirement_lines_PUB.RQL_Tbl_Type;
596: l_RQL_Rec CSP_Requirement_lines_PUB.RQL_Rec_Type;
597: BEGIN
598: -- Standard Start of API savepoint
599: SAVEPOINT DELETE_Requirement_Headers_PUB;

Line 596: l_RQL_Rec CSP_Requirement_lines_PUB.RQL_Rec_Type;

592: */
593: FROM csp_requirement_lines
594: WHERE requirement_header_id = p_rqmt_header_id;
595: l_RQL_TBL CSP_Requirement_lines_PUB.RQL_Tbl_Type;
596: l_RQL_Rec CSP_Requirement_lines_PUB.RQL_Rec_Type;
597: BEGIN
598: -- Standard Start of API savepoint
599: SAVEPOINT DELETE_Requirement_Headers_PUB;
600:

Line 651: CSP_requirement_lines_pub.Delete_requirement_lines(

647: I := I + 1;
648: END LOOP;
649:
650: IF (l_RQL_TBL.COUNT > 0) THEN
651: CSP_requirement_lines_pub.Delete_requirement_lines(
652: P_Api_Version_Number => 1.0,
653: P_Init_Msg_List => FND_API.G_FALSE,
654: P_Commit => p_commit,
655: P_RQL_TBL => l_RQL_TBL,