APPS.PSB_BUDGET_POSITION_PVT dependencies on PSB_BUDGET_POSITIONS

Line 248: -- this information in psb_budget_positions table.

244: | PROCEDURE Add_Position_To_Position_Sets |
245: +===========================================================================*/
246: --
247: -- This API finds all the position sets a position belongs to, and the adds
248: -- this information in psb_budget_positions table.
249: --
250: PROCEDURE Add_Position_To_Position_Sets
251: (
252: p_api_version IN NUMBER ,

Line 393: -- If match found, put the information in psb_budget_positions table.

389: END LOOP; -- End processing the current account set.
390:
391: pd('Found flag ' || l_match_found_in_set_flag );
392:
393: -- If match found, put the information in psb_budget_positions table.
394: IF l_match_found_in_set_flag = 'Y' THEN
395: INSERT INTO psb_budget_positions
396: (
397: account_position_set_id ,

Line 395: INSERT INTO psb_budget_positions

391: pd('Found flag ' || l_match_found_in_set_flag );
392:
393: -- If match found, put the information in psb_budget_positions table.
394: IF l_match_found_in_set_flag = 'Y' THEN
395: INSERT INTO psb_budget_positions
396: (
397: account_position_set_id ,
398: position_id ,
399: data_extract_id ,

Line 419: FROM psb_budget_positions

415: g_current_date
416: FROM dual
417: WHERE NOT EXISTS
418: ( SELECT '1'
419: FROM psb_budget_positions
420: WHERE account_position_set_id
421: = l_set_rec.account_position_set_id
422: AND position_id = p_position_id
423: ) ;

Line 563: -- Delete from psb_budget_positions. You must delete as everytime you run

559: SET maintain_status = 'C'
560: WHERE account_position_set_id = p_position_set_id ;
561:
562: --
563: -- Delete from psb_budget_positions. You must delete as everytime you run
564: -- the program, some positions may have been created, modified or deleted.
565: --
566: DELETE psb_budget_positions
567: WHERE account_position_set_id = p_position_set_id ;

Line 566: DELETE psb_budget_positions

562: --
563: -- Delete from psb_budget_positions. You must delete as everytime you run
564: -- the program, some positions may have been created, modified or deleted.
565: --
566: DELETE psb_budget_positions
567: WHERE account_position_set_id = p_position_set_id ;
568:
569:
570: -- Reset the table.

Line 736: INSERT INTO psb_budget_positions

732: --
733: FOR i IN 1..l_position_set_tbl.COUNT
734: LOOP
735: --
736: INSERT INTO psb_budget_positions
737: (
738: account_position_set_id ,
739: position_id ,
740: data_extract_id ,

Line 760: FROM psb_budget_positions

756: g_current_date
757: FROM dual
758: WHERE NOT EXISTS
759: ( SELECT '1'
760: FROM psb_budget_positions
761: WHERE account_position_set_id = g_position_set_id
762: AND position_id =
763: l_position_set_tbl(i).position_id
764: ) ;

Line 950: -- Insert positions into psb_budget_positions from l_position_output_tbl.

946:
947: END LOOP ; /* To process all the position in l_position_input_tbl */
948:
949: --
950: -- Insert positions into psb_budget_positions from l_position_output_tbl.
951: --
952: FOR i in 1..l_position_output_tbl.COUNT
953: LOOP
954: --

Line 955: INSERT INTO psb_budget_positions

951: --
952: FOR i in 1..l_position_output_tbl.COUNT
953: LOOP
954: --
955: INSERT INTO psb_budget_positions
956: (
957: account_position_set_id ,
958: position_id ,
959: data_extract_id ,

Line 979: FROM psb_budget_positions

975: g_current_date
976: FROM dual
977: WHERE NOT EXISTS
978: ( SELECT '1'
979: FROM psb_budget_positions
980: WHERE account_position_set_id = g_position_set_id
981: AND position_id =
982: l_position_output_tbl(i)
983: ) ;