APPS.PSB_POS_SET_LINE_VALUES_PVT dependencies on PSB_POSITION_SET_LINE_VALUES

Line 39: FROM psb_position_set_line_values

35: l_api_version CONSTANT NUMBER := 1.0;
36: --
37: CURSOR C IS
38: SELECT rowid
39: FROM psb_position_set_line_values
40: WHERE value_sequence_id = p_value_sequence_id ;
41:
42: CURSOR C2 IS
43: SELECT psb_position_set_line_values_s.nextval

Line 43: SELECT psb_position_set_line_values_s.nextval

39: FROM psb_position_set_line_values
40: WHERE value_sequence_id = p_value_sequence_id ;
41:
42: CURSOR C2 IS
43: SELECT psb_position_set_line_values_s.nextval
44: FROM dual;
45: BEGIN
46: --
47: SAVEPOINT Insert_Row_Pvt ;

Line 72: INSERT INTO psb_position_set_line_values(

68: FETCH C2 INTO p_value_sequence_id ;
69: CLOSE C2;
70: END IF;
71:
72: INSERT INTO psb_position_set_line_values(
73: value_sequence_id,
74: line_sequence_id,
75: attribute_value_id,
76: attribute_value,

Line 175: FROM psb_position_set_line_values

171: --
172: Counter NUMBER;
173: CURSOR C IS
174: SELECT *
175: FROM psb_position_set_line_values
176: WHERE rowid = p_Row_Id
177: FOR UPDATE of value_sequence_id NOWAIT;
178: Recinfo C%ROWTYPE;
179:

Line 334: UPDATE psb_position_set_line_values

330: --
331: p_return_status := FND_API.G_RET_STS_SUCCESS ;
332: --
333:
334: UPDATE psb_position_set_line_values
335: SET
336: value_sequence_id = p_value_sequence_id,
337: line_sequence_id = p_line_sequence_id,
338: attribute_value_id = p_attribute_value_id,

Line 434: -- Deleting the record in psb_position_set_line_values.

430: p_return_status := FND_API.G_RET_STS_SUCCESS ;
431: --
432:
433: --
434: -- Deleting the record in psb_position_set_line_values.
435: --
436: DELETE FROM psb_position_set_line_values
437: WHERE rowid = p_Row_Id;
438:

Line 436: DELETE FROM psb_position_set_line_values

432:
433: --
434: -- Deleting the record in psb_position_set_line_values.
435: --
436: DELETE FROM psb_position_set_line_values
437: WHERE rowid = p_Row_Id;
438:
439: IF (SQL%NOTFOUND) THEN
440: RAISE NO_DATA_FOUND ;

Line 515: FROM psb_position_set_line_values

511:
512: /*
513: CURSOR c IS
514: SELECT '1'
515: FROM psb_position_set_line_values
516: WHERE attribute_value = p_attribute_value
517: AND ( (p_Row_Id IS NULL)
518: OR
519: (RowId <> p_Row_Id)

Line 525: FROM psb_position_set_line_values

521: */
522:
523: CURSOR c IS
524: SELECT '1'
525: FROM psb_position_set_line_values
526: WHERE line_sequence_id = p_line_sequence_id
527: AND ( p_attribute_value_id IS NULL
528: OR
529: attribute_value_id = p_attribute_value_id )