21: , p_organization_id IN NUMBER
22: , p_change_notice IN VARCHAR2
23: , p_change_line_name IN VARCHAR2
24: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
25: , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
26: , x_change_line_unexp_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
27: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
28: , x_return_status OUT NOCOPY VARCHAR2
29: )
22: , p_change_notice IN VARCHAR2
23: , p_change_line_name IN VARCHAR2
24: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
25: , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
26: , x_change_line_unexp_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
27: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
28: , x_return_status OUT NOCOPY VARCHAR2
29: )
30: IS
29: )
30: IS
31:
32: /* Define Variable */
33: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
34: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
35: l_bo_id VARCHAR2(3) ;
36: l_err_text VARCHAR2(2000);
37:
30: IS
31:
32: /* Define Variable */
33: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
34: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;
35: l_bo_id VARCHAR2(3) ;
36: l_err_text VARCHAR2(2000);
37:
38:
204: * Purpose : Perform any insert/update/deletes to the
205: * Change Line table.
206: *********************************************************************/
207: PROCEDURE Perform_Writes
208: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
209: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
210: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
211: , x_return_status OUT NOCOPY VARCHAR2
212: )
205: * Change Line table.
206: *********************************************************************/
207: PROCEDURE Perform_Writes
208: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
209: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
210: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
211: , x_return_status OUT NOCOPY VARCHAR2
212: )
213: IS
211: , x_return_status OUT NOCOPY VARCHAR2
212: )
213: IS
214:
215: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
216: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
217:
218: -- Error Handlig Variables
219: l_return_status VARCHAR2(1);
212: )
213: IS
214:
215: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
216: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
217:
218: -- Error Handlig Variables
219: l_return_status VARCHAR2(1);
220: l_temp_return_status VARCHAR2(1);
346: * table: ENG_CHANGE_LINES/_TL.
347: *
348: *****************************************************************************/
349: PROCEDURE Insert_Row
350: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
351: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
352: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , x_return_status OUT NOCOPY VARCHAR2
354: )
347: *
348: *****************************************************************************/
349: PROCEDURE Insert_Row
350: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
351: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
352: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , x_return_status OUT NOCOPY VARCHAR2
354: )
355: IS
538: * the user given values. Any errors will be returned by filling
539: * the Mesg_Token_Tbl and setting the return_status.
540: ****************************************************************************/
541: PROCEDURE Update_Row
542: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
543: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
544: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
545: , x_return_status OUT NOCOPY VARCHAR2
546: )
539: * the Mesg_Token_Tbl and setting the return_status.
540: ****************************************************************************/
541: PROCEDURE Update_Row
542: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
543: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
544: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
545: , x_return_status OUT NOCOPY VARCHAR2
546: )
547: IS
627: * Message Token Table
628: * Purpose : procedure will delete a change line record.
629: *********************************************************************/
630: PROCEDURE Delete_Row
631: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
632: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
633: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
634: , x_return_status OUT NOCOPY VARCHAR2
635: )
628: * Purpose : procedure will delete a change line record.
629: *********************************************************************/
630: PROCEDURE Delete_Row
631: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
632: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
633: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
634: , x_return_status OUT NOCOPY VARCHAR2
635: )
636: IS
634: , x_return_status OUT NOCOPY VARCHAR2
635: )
636: IS
637:
638: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
639: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
640:
641: -- Error Handlig Variables
642: l_return_status VARCHAR2(1);
635: )
636: IS
637:
638: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
639: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
640:
641: -- Error Handlig Variables
642: l_return_status VARCHAR2(1);
643: l_err_text VARCHAR2(2000) ;
703:
704:
705:
706: PROCEDURE Change_Subjects (
707: p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
708: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
709: , x_change_subject_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type
710: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
711: , x_return_status IN OUT NOCOPY VARCHAR2)
704:
705:
706: PROCEDURE Change_Subjects (
707: p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
708: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
709: , x_change_subject_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type
710: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
711: , x_return_status IN OUT NOCOPY VARCHAR2)
712: IS
705:
706: PROCEDURE Change_Subjects (
707: p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
708: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
709: , x_change_subject_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type
710: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
711: , x_return_status IN OUT NOCOPY VARCHAR2)
712: IS
713:
737: l_entity_name VARCHAR2(30);
738: l_parent_entity_name VARCHAR2(30);
739: l_item_catalog_group_id NUMBER;
740: l_subject_id NUMBER;
741: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;
742:
743: l_user_id NUMBER;
744: l_login_id NUMBER;
745: l_prog_appid NUMBER;