38: -- Procedure Clear_Dependent_Attr
39:
40: PROCEDURE Clear_Dependent_Attr
41: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
43: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
44: QP_Attr_Map_PUB.G_MISS_FNA_REC
45: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
46: );
39:
40: PROCEDURE Clear_Dependent_Attr
41: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
43: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
44: QP_Attr_Map_PUB.G_MISS_FNA_REC
45: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
46: );
47:
40: PROCEDURE Clear_Dependent_Attr
41: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
43: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
44: QP_Attr_Map_PUB.G_MISS_FNA_REC
45: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
46: );
47:
48: -- Procedure Apply_Attribute_Changes
41: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
42: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
43: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
44: QP_Attr_Map_PUB.G_MISS_FNA_REC
45: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
46: );
47:
48: -- Procedure Apply_Attribute_Changes
49:
47:
48: -- Procedure Apply_Attribute_Changes
49:
50: PROCEDURE Apply_Attribute_Changes
51: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
52: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_REC
54: , p_called_from_ui IN VARCHAR2
55: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
48: -- Procedure Apply_Attribute_Changes
49:
50: PROCEDURE Apply_Attribute_Changes
51: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
52: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_REC
54: , p_called_from_ui IN VARCHAR2
55: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
56: );
49:
50: PROCEDURE Apply_Attribute_Changes
51: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
52: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_REC
54: , p_called_from_ui IN VARCHAR2
55: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
56: );
57:
51: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
52: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_REC
54: , p_called_from_ui IN VARCHAR2
55: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
56: );
57:
58: -- Function Complete_Record
59:
57:
58: -- Function Complete_Record
59:
60: FUNCTION Complete_Record
61: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
62: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
63: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
64:
65: -- Function Convert_Miss_To_Null
58: -- Function Complete_Record
59:
60: FUNCTION Complete_Record
61: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
62: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
63: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
64:
65: -- Function Convert_Miss_To_Null
66:
59:
60: FUNCTION Complete_Record
61: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
62: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
63: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
64:
65: -- Function Convert_Miss_To_Null
66:
67: FUNCTION Convert_Miss_To_Null
64:
65: -- Function Convert_Miss_To_Null
66:
67: FUNCTION Convert_Miss_To_Null
68: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
69: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
70:
71: -- Procedure Update_Row
72:
65: -- Function Convert_Miss_To_Null
66:
67: FUNCTION Convert_Miss_To_Null
68: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
69: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
70:
71: -- Procedure Update_Row
72:
73: PROCEDURE Update_Row
70:
71: -- Procedure Update_Row
72:
73: PROCEDURE Update_Row
74: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
75: );
76:
77: -- Procedure Insert_Row
78:
76:
77: -- Procedure Insert_Row
78:
79: PROCEDURE Insert_Row
80: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
81: );
82:
83: -- Procedure Delete_Row
84:
89: -- Function Query_Row
90:
91: FUNCTION Query_Row
92: ( p_pte_sourcesystem_fnarea_id IN NUMBER
93: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
94:
95: -- Function Query_Rows
96:
97: --
100: ( p_pte_sourcesystem_fnarea_id IN NUMBER :=
101: FND_API.G_MISS_NUM
102: , p_pte_source_system_id IN NUMBER :=
103: FND_API.G_MISS_NUM
104: ) RETURN QP_Attr_Map_PUB.Fna_Tbl_Type;
105:
106: -- Procedure lock_Row
107: --
108:
107: --
108:
109: PROCEDURE Lock_Row
110: ( x_return_status OUT NOCOPY VARCHAR2
111: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
112: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
113: );
114:
115: -- Function Get_Values
108:
109: PROCEDURE Lock_Row
110: ( x_return_status OUT NOCOPY VARCHAR2
111: , p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
112: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_Rec_Type
113: );
114:
115: -- Function Get_Values
116:
114:
115: -- Function Get_Values
116:
117: FUNCTION Get_Values
118: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
119: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
120: QP_Attr_Map_PUB.G_MISS_FNA_REC
121: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type;
122:
115: -- Function Get_Values
116:
117: FUNCTION Get_Values
118: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
119: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
120: QP_Attr_Map_PUB.G_MISS_FNA_REC
121: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type;
122:
123: -- Function Get_Ids
116:
117: FUNCTION Get_Values
118: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
119: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
120: QP_Attr_Map_PUB.G_MISS_FNA_REC
121: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type;
122:
123: -- Function Get_Ids
124:
117: FUNCTION Get_Values
118: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
119: , p_old_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type :=
120: QP_Attr_Map_PUB.G_MISS_FNA_REC
121: ) RETURN QP_Attr_Map_PUB.Fna_Val_Rec_Type;
122:
123: -- Function Get_Ids
124:
125: FUNCTION Get_Ids
122:
123: -- Function Get_Ids
124:
125: FUNCTION Get_Ids
126: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
127: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
128: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
129:
130: PROCEDURE Warn_Disable_Delete_Fna
123: -- Function Get_Ids
124:
125: FUNCTION Get_Ids
126: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
127: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
128: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
129:
130: PROCEDURE Warn_Disable_Delete_Fna
131: ( p_action IN VARCHAR2
124:
125: FUNCTION Get_Ids
126: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
127: , p_FNA_val_rec IN QP_Attr_Map_PUB.Fna_Val_Rec_Type
128: ) RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
129:
130: PROCEDURE Warn_Disable_Delete_Fna
131: ( p_action IN VARCHAR2
132: , p_called_from_ui IN VARCHAR2