APPS.PSB_ACCT_POSITION_SET_LINE_PVT dependencies on PSB_ACCOUNT_POSITION_SET_LINES

Line 112: FROM psb_account_position_set_lines

108: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
109: l_api_version CONSTANT NUMBER := 1.0;
110: --
111: CURSOR C IS SELECT rowid
112: FROM psb_account_position_set_lines
113: WHERE line_sequence_id = p_Line_Sequence_Id;
114: CURSOR C2 IS SELECT psb_acct_position_set_lines_s.nextval
115: FROM dual;
116: BEGIN

Line 141: INSERT INTO psb_account_position_set_lines

137: FETCH C2 INTO p_Line_Sequence_Id;
138: CLOSE C2;
139: END IF;
140:
141: INSERT INTO psb_account_position_set_lines
142: (
143: line_sequence_id,
144: account_position_set_id,
145: description,

Line 464: FROM psb_account_position_set_lines

460: l_api_version CONSTANT NUMBER := 1.0;
461: --
462: CURSOR C IS
463: SELECT *
464: FROM psb_account_position_set_lines
465: WHERE rowid = p_Row_Id
466: FOR UPDATE of Line_Sequence_Id NOWAIT;
467: Recinfo C%ROWTYPE;
468:

Line 910: UPDATE psb_account_position_set_lines

906: --
907: p_return_status := FND_API.G_RET_STS_SUCCESS ;
908: --
909:
910: UPDATE psb_account_position_set_lines
911: SET
912: line_sequence_id = p_Line_Sequence_Id,
913: account_position_set_id = p_Account_Position_Set_Id,
914: description = p_Description,

Line 1061: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE;

1057: --
1058: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Row';
1059: l_api_version CONSTANT NUMBER := 1.0;
1060: --
1061: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE;
1062: --
1063: BEGIN
1064: --
1065: SAVEPOINT Delete_Row_Pvt ;

Line 1089: FROM psb_account_position_set_lines

1085: -- ( To maintain ISOLATED master-detail form relation also. )
1086: -- Get the line_sequence_id to perform the delete.
1087: --
1088: SELECT line_sequence_id INTO l_line_sequence_id
1089: FROM psb_account_position_set_lines
1090: WHERE rowid = p_Row_Id ;
1091:
1092: DELETE psb_position_set_line_values
1093: WHERE line_sequence_id = l_line_sequence_id ;

Line 1098: DELETE psb_account_position_set_lines

1094:
1095: --
1096: -- Deleting the record in psb_account_position_sets.
1097: --
1098: DELETE psb_account_position_set_lines
1099: WHERE rowid = p_Row_Id;
1100:
1101: IF (SQL%NOTFOUND) THEN
1102: RAISE NO_DATA_FOUND ;