47: * will return old record in the old entity parameters
48: * with a success status.
49: *********************************************************************/
50: PROCEDURE Check_Existence
51: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
52: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
53: , x_old_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
54: , x_old_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
55: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
48: * with a success status.
49: *********************************************************************/
50: PROCEDURE Check_Existence
51: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
52: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
53: , x_old_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
54: , x_old_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
55: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56: , x_return_status OUT NOCOPY VARCHAR2
49: *********************************************************************/
50: PROCEDURE Check_Existence
51: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
52: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
53: , x_old_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
54: , x_old_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
55: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56: , x_return_status OUT NOCOPY VARCHAR2
57: )
50: PROCEDURE Check_Existence
51: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
52: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
53: , x_old_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
54: , x_old_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
55: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56: , x_return_status OUT NOCOPY VARCHAR2
57: )
58: IS
132: * trying to perform. If the required columns are not
133: * filled in, then the record would get an error.
134: ********************************************************************/
135: PROCEDURE Check_Required
136: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
137: , x_return_status OUT NOCOPY VARCHAR2
138: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
139: )
140: IS
230: * before the procedure returns with a Return_Status
231: * of 'E'.
232: *********************************************************************/
233: PROCEDURE Check_Attributes
234: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
235: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
236: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
237: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
238: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
231: * of 'E'.
232: *********************************************************************/
233: PROCEDURE Check_Attributes
234: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
235: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
236: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
237: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
238: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
239: , x_return_status OUT NOCOPY VARCHAR2
232: *********************************************************************/
233: PROCEDURE Check_Attributes
234: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
235: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
236: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
237: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
238: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
239: , x_return_status OUT NOCOPY VARCHAR2
240: )
233: PROCEDURE Check_Attributes
234: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
235: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
236: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
237: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
238: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
239: , x_return_status OUT NOCOPY VARCHAR2
240: )
241: IS
414: * Purpose : Check Conditionally Required Columns
415: *
416: ********************************************************************/
417: PROCEDURE Check_Conditionally_Required
418: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
419: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
420: , x_return_status OUT NOCOPY VARCHAR2
421: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
422: )
415: *
416: ********************************************************************/
417: PROCEDURE Check_Conditionally_Required
418: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
419: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
420: , x_return_status OUT NOCOPY VARCHAR2
421: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
422: )
423: IS
466: * Purpose : Check_Entity validate the entity for the correct
467: * business logic to delete the record.
468: **********************************************************************/
469: PROCEDURE Check_Entity_Delete
470: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
471: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
472: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
473: , x_return_status OUT NOCOPY VARCHAR2
474: )
467: * business logic to delete the record.
468: **********************************************************************/
469: PROCEDURE Check_Entity_Delete
470: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
471: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
472: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
473: , x_return_status OUT NOCOPY VARCHAR2
474: )
475: IS
554: * It will also verify that changes in one column value
555: * does not invalidate some other columns.
556: **********************************************************************/
557: PROCEDURE Check_Entity
558: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
559: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
560: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
561: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
562: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
555: * does not invalidate some other columns.
556: **********************************************************************/
557: PROCEDURE Check_Entity
558: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
559: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
560: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
561: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
562: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
563: , x_return_status OUT NOCOPY VARCHAR2
556: **********************************************************************/
557: PROCEDURE Check_Entity
558: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
559: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
560: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
561: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
562: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
563: , x_return_status OUT NOCOPY VARCHAR2
564: )
557: PROCEDURE Check_Entity
558: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
559: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
560: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
561: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
562: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
563: , x_return_status OUT NOCOPY VARCHAR2
564: )
565: IS
789: * Purpose : Procedure will verify that the line item
790: * is accessible to the user.
791: ********************************************************************/
792: PROCEDURE Check_Access
793: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
794: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
795: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
796: Error_Handler.G_MISS_MESG_TOKEN_TBL
797: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
790: * is accessible to the user.
791: ********************************************************************/
792: PROCEDURE Check_Access
793: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
794: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
795: , p_Mesg_Token_Tbl IN Error_Handler.Mesg_Token_Tbl_Type :=
796: Error_Handler.G_MISS_MESG_TOKEN_TBL
797: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
798: , x_Return_Status OUT NOCOPY VARCHAR2