eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WORKFLOW_PVT dependencies on PSB_WORKSHEETS

Line 94: l_created_worksheet_id psb_worksheets.worksheet_id%TYPE ;

90: l_msg_count NUMBER ;
91: l_msg_data VARCHAR2(2000) ;
92: --
93: l_worksheet_id psb_ws_distributions.worksheet_id%TYPE ;
94: l_created_worksheet_id psb_worksheets.worksheet_id%TYPE ;
95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;
98: l_distribution_option_flag

Line 95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

91: l_msg_data VARCHAR2(2000) ;
92: --
93: l_worksheet_id psb_ws_distributions.worksheet_id%TYPE ;
94: l_created_worksheet_id psb_worksheets.worksheet_id%TYPE ;
95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;
98: l_distribution_option_flag
99: psb_ws_distributions.distribution_option_flag%TYPE ;

Line 96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;

92: --
93: l_worksheet_id psb_ws_distributions.worksheet_id%TYPE ;
94: l_created_worksheet_id psb_worksheets.worksheet_id%TYPE ;
95: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
96: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
97: l_distribution_rule_id psb_ws_distributions.distribution_rule_id%TYPE ;
98: l_distribution_option_flag
99: psb_ws_distributions.distribution_option_flag%TYPE ;
100: --

Line 151: FROM psb_worksheets

147: budget_calendar_id
148: INTO
149: l_global_worksheet_id ,
150: l_budget_calendar_id
151: FROM psb_worksheets
152: WHERE worksheet_id = l_worksheet_id ;
153:
154: --
155: -- Get budget calendar related info to find all the budget groups down in

Line 382: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

378: (
379: errbuf OUT NOCOPY VARCHAR2,
380: retcode OUT NOCOPY VARCHAR2,
381: --
382: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
383: p_submitter_id IN NUMBER ,
384: p_operation_type IN VARCHAR2 ,
385: p_review_group_flag IN VARCHAR2 := 'N' ,
386: p_orig_system IN VARCHAR2 ,

Line 387: p_merge_to_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

383: p_submitter_id IN NUMBER ,
384: p_operation_type IN VARCHAR2 ,
385: p_review_group_flag IN VARCHAR2 := 'N' ,
386: p_orig_system IN VARCHAR2 ,
387: p_merge_to_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
388: p_comments IN VARCHAR2 ,
389: p_operation_id IN NUMBER ,
390: p_constraint_set_id IN NUMBER
391: )

Line 403: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

399: l_msg_count NUMBER ;
400: l_msg_data VARCHAR2(2000) ;
401: l_msg_index_out NUMBER;
402: --
403: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
404: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
405: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
406: --
407: l_lock_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 404: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

400: l_msg_data VARCHAR2(2000) ;
401: l_msg_index_out NUMBER;
402: --
403: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
404: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
405: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
406: --
407: l_lock_worksheet_id psb_worksheets.worksheet_id%TYPE ;
408: l_tmp_number NUMBER ;

Line 407: l_lock_worksheet_id psb_worksheets.worksheet_id%TYPE ;

403: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
404: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
405: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
406: --
407: l_lock_worksheet_id psb_worksheets.worksheet_id%TYPE ;
408: l_tmp_number NUMBER ;
409: l_item_key VARCHAR2(240) ;
410: /*For Bug No : 2115869 Start*/
411: l_review_group_exists VARCHAR2(1);

Line 481: FROM psb_worksheets

477: --
478: -- Find budget_group_id for the worksheet.
479: --
480: SELECT budget_group_id INTO l_budget_group_id
481: FROM psb_worksheets
482: WHERE worksheet_id = p_worksheet_id ;
483:
484: --
485: -- Find budget_group users information.

Line 595: l_child_worksheet_id psb_worksheets.worksheet_id%TYPE ;

591: p_return_status OUT NOCOPY VARCHAR2
592: )
593: IS
594: --
595: l_child_worksheet_id psb_worksheets.worksheet_id%TYPE ;
596: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
597: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;
598: l_return_status VARCHAR2(1) ;
599: l_msg_count NUMBER ;

Line 620: FROM psb_worksheets

616: -- ( Bug#2832148 )
617: --
618: CURSOR l_child_worksheet_csr IS
619: SELECT worksheet_id
620: FROM psb_worksheets
621: WHERE global_worksheet_id = p_global_worksheet_id
622: AND budget_group_id = p_budget_group_id
623: AND worksheet_type = 'O' ;
624:

Line 652: FROM psb_worksheets

648:
649: -- To find if the worksheet is frozen.
650: CURSOR l_ws_csr IS
651: SELECT freeze_flag
652: FROM psb_worksheets
653: WHERE worksheet_id = l_child_worksheet_id ;
654: --
655: BEGIN
656: