APPS.ENG_CHANGE_LINE_UTIL dependencies on ENG_ECO_PUB

Line 25: , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type

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: )

Line 26: , x_change_line_unexp_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

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

Line 33: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;

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:

Line 34: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type;

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:

Line 208: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

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: )

Line 209: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

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

Line 215: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;

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);

Line 216: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

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);

Line 350: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

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: )

Line 351: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

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

Line 542: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

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: )

Line 543: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

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

Line 631: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

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: )

Line 632: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

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

Line 638: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;

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);

Line 639: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

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) ;

Line 707: p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type

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)

Line 708: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type

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

Line 709: , x_change_subject_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type

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:

Line 741: l_change_subject_unexp_rec Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type;

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;