46: -- Procedure Clear_Dependent_Attr
47:
48: PROCEDURE clear_dependent_attr(
49: p_attr_id IN NUMBER := fnd_api.g_miss_num
50: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
51: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
52: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
53: );
54:
47:
48: PROCEDURE clear_dependent_attr(
49: p_attr_id IN NUMBER := fnd_api.g_miss_num
50: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
51: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
52: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
53: );
54:
55: -- Procedure Apply_Attribute_Changes
48: PROCEDURE clear_dependent_attr(
49: p_attr_id IN NUMBER := fnd_api.g_miss_num
50: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
51: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
52: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
53: );
54:
55: -- Procedure Apply_Attribute_Changes
56:
53: );
54:
55: -- Procedure Apply_Attribute_Changes
56:
57: PROCEDURE apply_attribute_changes(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type);
58:
59: -- Function Complete_Record
60:
61: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
57: PROCEDURE apply_attribute_changes(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type);
58:
59: -- Function Complete_Record
60:
61: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
62: RETURN inv_move_order_pub.trohdr_rec_type;
63:
64: -- Function Convert_Miss_To_Null for TROHDR_REC_TYPE
65:
58:
59: -- Function Complete_Record
60:
61: FUNCTION complete_record(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
62: RETURN inv_move_order_pub.trohdr_rec_type;
63:
64: -- Function Convert_Miss_To_Null for TROHDR_REC_TYPE
65:
66: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
62: RETURN inv_move_order_pub.trohdr_rec_type;
63:
64: -- Function Convert_Miss_To_Null for TROHDR_REC_TYPE
65:
66: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
67: RETURN inv_move_order_pub.trohdr_rec_type;
68:
69: -- Bug#2536932: Function Convert_Miss_To_Null for TROHDR_VAL_REC_TYPE
70: -- This converts all the Miss Char or Number or Date to NULL Values.
63:
64: -- Function Convert_Miss_To_Null for TROHDR_REC_TYPE
65:
66: FUNCTION convert_miss_to_null(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type)
67: RETURN inv_move_order_pub.trohdr_rec_type;
68:
69: -- Bug#2536932: Function Convert_Miss_To_Null for TROHDR_VAL_REC_TYPE
70: -- This converts all the Miss Char or Number or Date to NULL Values.
71:
68:
69: -- Bug#2536932: Function Convert_Miss_To_Null for TROHDR_VAL_REC_TYPE
70: -- This converts all the Miss Char or Number or Date to NULL Values.
71:
72: FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
73: RETURN inv_move_order_pub.trohdr_val_rec_type;
74:
75: -- Procedure Update_Row
76:
69: -- Bug#2536932: Function Convert_Miss_To_Null for TROHDR_VAL_REC_TYPE
70: -- This converts all the Miss Char or Number or Date to NULL Values.
71:
72: FUNCTION convert_miss_to_null(p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
73: RETURN inv_move_order_pub.trohdr_val_rec_type;
74:
75: -- Procedure Update_Row
76:
77: PROCEDURE update_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type);
73: RETURN inv_move_order_pub.trohdr_val_rec_type;
74:
75: -- Procedure Update_Row
76:
77: PROCEDURE update_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type);
78:
79: -- Procedure Update_Row_Status
80:
81: PROCEDURE update_row_status(p_header_id IN NUMBER, p_status IN NUMBER);
81: PROCEDURE update_row_status(p_header_id IN NUMBER, p_status IN NUMBER);
82:
83: -- Procedure Insert_Row
84:
85: PROCEDURE insert_row(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type);
86:
87: -- Procedure Delete_Row
88:
89: PROCEDURE delete_row(p_header_id IN NUMBER);
90:
91: -- Function Query_Row
92:
93: FUNCTION query_row(p_header_id IN NUMBER)
94: RETURN inv_move_order_pub.trohdr_rec_type;
95:
96: -- Procedure lock_Row
97: --
98:
95:
96: -- Procedure lock_Row
97: --
98:
99: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type);
100:
101: -- Function Get_Values
102:
103: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
99: PROCEDURE lock_row(x_return_status OUT NOCOPY VARCHAR2, p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type);
100:
101: -- Function Get_Values
102:
103: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
104: RETURN inv_move_order_pub.trohdr_val_rec_type;
105:
106: -- Function Get_Ids
107:
100:
101: -- Function Get_Values
102:
103: FUNCTION get_values(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec)
104: RETURN inv_move_order_pub.trohdr_val_rec_type;
105:
106: -- Function Get_Ids
107:
108: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
104: RETURN inv_move_order_pub.trohdr_val_rec_type;
105:
106: -- Function Get_Ids
107:
108: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
109: RETURN inv_move_order_pub.trohdr_rec_type;
110: END inv_trohdr_util;
105:
106: -- Function Get_Ids
107:
108: FUNCTION get_ids(p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type, p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type)
109: RETURN inv_move_order_pub.trohdr_rec_type;
110: END inv_trohdr_util;