[Home] [Help]
61: --+========================================================================+
62: --| API Name : Create_Allocation_Definition |
63: --| TYPE : Public |
64: --| Function : Creates a new Allocation Definition based on the input |
65: --| into table GL_ALOC_BAS |
66: --| Pre-reqa : None. |
67: --| Parameters : |
68: --| IN : |
69: --| p_api_version IN NUMBER - Required |
105: IS
106:
107: l_api_name CONSTANT VARCHAR2(30) := 'Create_Allocation_Definition' ;
108: l_api_version CONSTANT NUMBER := 3.0 ;
109: l_line_no gl_aloc_bas.line_no%TYPE ;
110:
111: BEGIN
112:
113: -- Standard Start of API savepoint
133:
134: -- Generate line_no for the alloc_id
135: SELECT NVL(MAX(line_no), 0)+1
136: INTO l_line_no
137: FROM gl_aloc_bas
138: WHERE alloc_id = p_allocation_definition_rec.alloc_id ;
139:
140: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
141: log_msg('Inserting record for alloc_id : ' ||
141: log_msg('Inserting record for alloc_id : ' ||
142: p_allocation_definition_rec.alloc_id || ' line_no : ' || l_line_no);
143: END IF;
144:
145: INSERT INTO gl_aloc_bas
146: (
147: alloc_id
148: , line_no
149: , alloc_method
238: --+========================================================================+
239: --| API Name : Update_Allocation_Definition |
240: --| TYPE : Public |
241: --| Function : Updates Allocation Definition based on the input |
242: --| into GL_ALOC_BAS |
243: --| Pre-reqa : None. |
244: --| Parameters : |
245: --| IN : |
246: --| p_api_version IN NUMBER - Required |
310: log_msg('Updating record for alloc_id : ' ||
311: p_allocation_definition_rec.alloc_id || ' line_no : ' || p_allocation_definition_rec.line_no);
312: END IF;
313:
314: update gl_aloc_bas
315: SET
316: inventory_item_id = decode(p_allocation_definition_rec.item_id,
317: FND_API.G_MISS_NUM, NULL,
318: NULL, inventory_item_id,