APPS.PSB_ACCOUNT_POSITION_SET_PVT dependencies on PSB_ACCOUNT_POSITION_SET_LINES

Line 496: psb_account_position_set_lines.account_position_set_id%TYPE;

492: l_msg_count NUMBER ;
493: l_msg_data VARCHAR2(2000) ;
494: --
495: l_account_position_set_id
496: psb_account_position_set_lines.account_position_set_id%TYPE;
497: --
498: BEGIN
499: --
500: SAVEPOINT Delete_Row_Pvt ;

Line 519: -- Deleting dependent detail records from psb_account_position_set_lines.

515: p_return_status := FND_API.G_RET_STS_SUCCESS ;
516: --
517:
518: --
519: -- Deleting dependent detail records from psb_account_position_set_lines.
520: -- ( To maintain ISOLATED master-detail form relation also. )
521: --
522:
523: SELECT account_position_set_id INTO l_account_position_set_id

Line 535: FROM psb_account_position_set_lines

531: --
532: FOR l_lines_rec IN
533: (
534: SELECT rowid
535: FROM psb_account_position_set_lines
536: WHERE account_position_set_id = l_account_position_set_id
537: )
538: LOOP
539: --

Line 1220: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE ;

1216: l_row_id VARCHAR2(50) ;
1217: l_account_position_set_id
1218: psb_account_position_sets.account_position_set_id%TYPE;
1219:
1220: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE ;
1221: l_value_sequence_id psb_position_set_line_values.value_sequence_id%TYPE ;
1222: l_target_attribute_id psb_account_position_set_lines.attribute_id%TYPE ;
1223:
1224: l_target_attribute_value_id

Line 1222: l_target_attribute_id psb_account_position_set_lines.attribute_id%TYPE ;

1218: psb_account_position_sets.account_position_set_id%TYPE;
1219:
1220: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE ;
1221: l_value_sequence_id psb_position_set_line_values.value_sequence_id%TYPE ;
1222: l_target_attribute_id psb_account_position_set_lines.attribute_id%TYPE ;
1223:
1224: l_target_attribute_value_id
1225: psb_position_set_line_values.attribute_value_id%TYPE ;
1226: --