20: PROCEDURE Default_Attributes
21: ( x_return_status OUT NOCOPY VARCHAR2
22: , x_msg_count OUT NOCOPY NUMBER
23: , x_msg_data OUT NOCOPY VARCHAR2
24: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
26: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
27: , p_transaction_phase_code IN VARCHAR2
28: );
21: ( x_return_status OUT NOCOPY VARCHAR2
22: , x_msg_count OUT NOCOPY NUMBER
23: , x_msg_data OUT NOCOPY VARCHAR2
24: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
26: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
27: , p_transaction_phase_code IN VARCHAR2
28: );
29:
22: , x_msg_count OUT NOCOPY NUMBER
23: , x_msg_data OUT NOCOPY VARCHAR2
24: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
26: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
27: , p_transaction_phase_code IN VARCHAR2
28: );
29:
30: -- Procedure : Change_Attribute
40: , p_attr_id_tbl IN Number_Tbl_Type
41: , p_attr_value_tbl IN Varchar2_Tbl_Type
42: , p_header_dff_rec IN Oe_Oe_Form_Header.Header_Dff_Rec_Type
43: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
44: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
45: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
46: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
47: );
48:
41: , p_attr_value_tbl IN Varchar2_Tbl_Type
42: , p_header_dff_rec IN Oe_Oe_Form_Header.Header_Dff_Rec_Type
43: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
44: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
45: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
46: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
47: );
48:
49: -- Procedure Validate_And_Write
42: , p_header_dff_rec IN Oe_Oe_Form_Header.Header_Dff_Rec_Type
43: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-RRRR HH24:MI:SS'
44: , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
45: , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
46: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
47: );
48:
49: -- Procedure Validate_And_Write
50: --
349: );
350:
351: PROCEDURE CASCADE_HEADER_ATTRIBUTES
352: (
353: p_old_db_header_rec IN OE_ORDER_PUB.Header_Rec_Type
354: , p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
355: , x_return_status OUT NOCOPY VARCHAR2
356: , x_msg_count OUT NOCOPY NUMBER
357: , x_msg_data OUT NOCOPY VARCHAR2
350:
351: PROCEDURE CASCADE_HEADER_ATTRIBUTES
352: (
353: p_old_db_header_rec IN OE_ORDER_PUB.Header_Rec_Type
354: , p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
355: , x_return_status OUT NOCOPY VARCHAR2
356: , x_msg_count OUT NOCOPY NUMBER
357: , x_msg_data OUT NOCOPY VARCHAR2
358: );
436: ( p_attr_id IN NUMBER
437: , p_attr_value IN VARCHAR2
438: , p_header_dff_rec IN OE_OE_FORM_HEADER.header_dff_rec_type
439: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
440: , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
441: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
442: );
443:
444: PROCEDURE Validate_Phone_Number(
437: , p_attr_value IN VARCHAR2
438: , p_header_dff_rec IN OE_OE_FORM_HEADER.header_dff_rec_type
439: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
440: , x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
441: , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
442: );
443:
444: PROCEDURE Validate_Phone_Number(
445: p_area_code IN VARCHAR2 default null,