APPS.CSP_PARTS_LOOPS_PKG dependencies on CSP_PARTS_LOOPS_B

Line 46: CURSOR C2 IS SELECT CSP_PARTS_LOOPS_B_S1.nextval FROM sys.dual;

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;

Line 53: INSERT INTO CSP_PARTS_LOOPS_B(

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,

Line 172: Update CSP_PARTS_LOOPS_B

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),

Line 225: DELETE FROM CSP_PARTS_LOOPS_B

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;

Line 282: FROM CSP_PARTS_LOOPS_B

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

Line 412: from csp_parts_loops_b B

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 (