26: END Get_Change_Line_Id ;
27:
28: /* Comment Out
29: PROCEDURE Get_Flex_Change_Line
30: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
31: , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
32: )
33: IS
34: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
27:
28: /* Comment Out
29: PROCEDURE Get_Flex_Change_Line
30: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
31: , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
32: )
33: IS
34: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
35:
30: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
31: , x_change_line_rec OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
32: )
33: IS
34: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
35:
36: BEGIN
37: -- Initialize change line exp and unexp record
38: l_change_line_rec := p_change_line_rec ;
121: * appropriate values. Defualting will happen for
122: * exposed as well as unexposed columns.
123: *********************************************************************/
124: PROCEDURE Attribute_Defaulting
125: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
126: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
127: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
128: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
129: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
122: * exposed as well as unexposed columns.
123: *********************************************************************/
124: PROCEDURE Attribute_Defaulting
125: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
126: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
127: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
128: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
129: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130: , x_return_status OUT NOCOPY VARCHAR2
123: *********************************************************************/
124: PROCEDURE Attribute_Defaulting
125: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
126: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
127: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
128: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
129: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130: , x_return_status OUT NOCOPY VARCHAR2
131: )
124: PROCEDURE Attribute_Defaulting
125: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
126: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
127: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
128: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
129: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130: , x_return_status OUT NOCOPY VARCHAR2
131: )
132:
131: )
132:
133: IS
134:
135: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
136: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
137:
138: l_return_status VARCHAR2(1);
139: l_temp_return_status VARCHAR2(1);
132:
133: IS
134:
135: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
136: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
137:
138: l_return_status VARCHAR2(1);
139: l_temp_return_status VARCHAR2(1);
140: l_err_text VARCHAR2(2000) ;
254: * record with values from the database record, for all
255: * columns that the user has left NULL.
256: ********************************************************************/
257: PROCEDURE Populate_Null_Columns
258: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
259: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
260: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
261: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
262: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
255: * columns that the user has left NULL.
256: ********************************************************************/
257: PROCEDURE Populate_Null_Columns
258: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
259: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
260: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
261: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
262: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
263: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
256: ********************************************************************/
257: PROCEDURE Populate_Null_Columns
258: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
259: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
260: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
261: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
262: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
263: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
264: )
257: PROCEDURE Populate_Null_Columns
258: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
259: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
260: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
261: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
262: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
263: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
264: )
265: IS
258: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
259: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
260: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
261: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
262: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
263: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
264: )
265: IS
266:
259: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
260: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
261: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
262: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
263: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
264: )
265: IS
266:
267: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
263: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
264: )
265: IS
266:
267: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
268: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
269:
270: BEGIN
271:
264: )
265: IS
266:
267: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
268: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
269:
270: BEGIN
271:
272: IF BOM_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
508: * appropriate values. Defualting will happen for
509: * exposed as well as unexposed columns.
510: *********************************************************************/
511: PROCEDURE Entity_Defaulting
512: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
513: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
514: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
515: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
516: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
509: * exposed as well as unexposed columns.
510: *********************************************************************/
511: PROCEDURE Entity_Defaulting
512: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
513: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
514: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
515: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
516: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
517: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
510: *********************************************************************/
511: PROCEDURE Entity_Defaulting
512: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
513: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
514: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
515: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
516: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
517: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
518: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
511: PROCEDURE Entity_Defaulting
512: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
513: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
514: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
515: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
516: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
517: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
518: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
519: , x_return_status OUT NOCOPY VARCHAR2
512: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
513: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
514: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
515: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
516: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
517: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
518: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
519: , x_return_status OUT NOCOPY VARCHAR2
520: )
513: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
514: , p_old_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
515: , p_old_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
516: , x_change_line_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Rec_Type
517: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
518: , x_mesg_token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
519: , x_return_status OUT NOCOPY VARCHAR2
520: )
521:
520: )
521:
522: IS
523:
524: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
525: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
526:
527: l_return_status VARCHAR2(1);
528: l_err_text VARCHAR2(2000) ;
521:
522: IS
523:
524: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
525: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
526:
527: l_return_status VARCHAR2(1);
528: l_err_text VARCHAR2(2000) ;
529: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;