42: p_DESCRIPTION VARCHAR2)
43:
44: IS
45:
46: CURSOR C2 IS SELECT CSP_PARTS_LOOPS_B_S1.nextval FROM sys.dual;
47: BEGIN
48: If (px_PARTS_LOOP_ID IS NULL) OR (px_PARTS_LOOP_ID = FND_API.G_MISS_NUM) then
49: OPEN C2;
50: FETCH C2 INTO px_PARTS_LOOP_ID;
49: OPEN C2;
50: FETCH C2 INTO px_PARTS_LOOP_ID;
51: CLOSE C2;
52: End If;
53: INSERT INTO CSP_PARTS_LOOPS_B(
54: PARTS_LOOP_ID,
55: CREATED_BY,
56: CREATION_DATE,
57: LAST_UPDATED_BY,
168: p_DESCRIPTION VARCHAR2)
169:
170: IS
171: BEGIN
172: Update CSP_PARTS_LOOPS_B
173: SET
174: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
175: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
176: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
221: PROCEDURE Delete_Row(
222: p_PARTS_LOOP_ID NUMBER)
223: IS
224: BEGIN
225: DELETE FROM CSP_PARTS_LOOPS_B
226: WHERE PARTS_LOOP_ID = p_PARTS_LOOP_ID;
227: If (SQL%NOTFOUND) then
228: RAISE NO_DATA_FOUND;
229: End If;
278:
279: IS
280: CURSOR C IS
281: SELECT *
282: FROM CSP_PARTS_LOOPS_B
283: WHERE PARTS_LOOP_ID = p_PARTS_LOOP_ID
284: FOR UPDATE of PARTS_LOOP_ID NOWAIT;
285:
286: cursor c1 is select
408: begin
409: delete from csp_parts_loops_tl T
410: where not exists
411: (select NULL
412: from csp_parts_loops_b B
413: where B.parts_loop_id = T.parts_loop_id
414: );
415:
416: update csp_parts_loops_tl T set (