APPS.PSB_POSITIONS_I_PVT dependencies on PSB_POSITIONS

Line 1: PACKAGE BODY PSB_POSITIONS_I_PVT AS

1: PACKAGE BODY PSB_POSITIONS_I_PVT AS
2: /* $Header: PSBWPOIB.pls 120.7 2006/02/18 08:12:10 matthoma ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_I_PVT';
5: G_DBUG VARCHAR2(2000) := 'start';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_I_PVT';

1: PACKAGE BODY PSB_POSITIONS_I_PVT AS
2: /* $Header: PSBWPOIB.pls 120.7 2006/02/18 08:12:10 matthoma ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_POSITIONS_I_PVT';
5: G_DBUG VARCHAR2(2000) := 'start';
6:
7: PROCEDURE Initialize_View ( p_worksheet_id IN NUMBER,
8: p_start_date IN DATE,

Line 16: PSB_POSITIONS_PVT.Initialize_View(

12:
13:
14: BEGIN
15:
16: PSB_POSITIONS_PVT.Initialize_View(
17: p_worksheet_id => p_worksheet_id,
18: p_start_date => p_start_date,
19: p_end_date => p_end_date,
20: p_select_date => p_select_date

Line 45: PSB_POSITIONS_PVT.Define_Worksheet_Values (

41: p_out_end_date OUT NOCOPY date) IS
42:
43: BEGIN
44:
45: PSB_POSITIONS_PVT.Define_Worksheet_Values (
46: p_api_version => p_api_version,
47: p_init_msg_list => p_init_msg_list,
48: p_commit => p_commit,
49: p_validation_level=> p_validation_level,

Line 104: PSB_POSITIONS_PVT.Modify_Assignment (

100: ) IS
101:
102: BEGIN
103:
104: PSB_POSITIONS_PVT.Modify_Assignment (
105: p_api_version => p_api_version,
106: p_init_msg_list => p_init_msg_list,
107: p_commit => p_commit,
108: p_validation_level => p_validation_level,

Line 225: FROM psb_positions

221:
222: CURSOR c_Position IS
223: SELECT effective_start_date,
224: effective_end_date
225: FROM psb_positions
226: WHERE position_id = p_position_id ;
227:
228: -- Bug 5040737 used order by 2 clause in the following cursor
229: CURSOR c_Priority_ruleset IS

Line 390: psb_positions_pvt.Apply_Position_Default_Rules

386:
387: FOR c_Assignments_Rec in c_Assignment_Ruleset
388: LOOP
389:
390: psb_positions_pvt.Apply_Position_Default_Rules
391: (p_api_version => 1.0,
392: x_return_status => l_return_status,
393: x_msg_count => l_msg_count,
394: x_msg_data => l_msg_data,

Line 463: PSB_POSITIONS_PVT.g_distr_percent_total:= 0;

459: END;
460: END IF;
461: END IF;
462:
463: PSB_POSITIONS_PVT.g_distr_percent_total:= 0;
464:
465: FOR l_distribution_id_csr_rec IN l_distribution_id_csr
466: LOOP
467: PSB_POSITIONS_PVT.g_distr_percent_total

Line 467: PSB_POSITIONS_PVT.g_distr_percent_total

463: PSB_POSITIONS_PVT.g_distr_percent_total:= 0;
464:
465: FOR l_distribution_id_csr_rec IN l_distribution_id_csr
466: LOOP
467: PSB_POSITIONS_PVT.g_distr_percent_total
468: := PSB_POSITIONS_PVT.g_distr_percent_total + l_distribution_id_csr_rec.distribution_percent;
469: END LOOP;
470:
471:

Line 468: := PSB_POSITIONS_PVT.g_distr_percent_total + l_distribution_id_csr_rec.distribution_percent;

464:
465: FOR l_distribution_id_csr_rec IN l_distribution_id_csr
466: LOOP
467: PSB_POSITIONS_PVT.g_distr_percent_total
468: := PSB_POSITIONS_PVT.g_distr_percent_total + l_distribution_id_csr_rec.distribution_percent;
469: END LOOP;
470:
471:
472: FOR c_Dist_Rec in c_Dist LOOP

Line 508: Return PSB_POSITIONS_PVT.Get_Select_Date ;

504: END Create_Default_Assignments;
505:
506: FUNCTION Get_Select_Date RETURN DATE IS
507: BEGIN
508: Return PSB_POSITIONS_PVT.Get_Select_Date ;
509: END Get_Select_Date;
510:
511:
512: FUNCTION Check_Allowed

Line 626: RETURN PSB_POSITIONS_PVT.Rev_Check_Allowed

622:
623:
624: -- Call Private Function
625:
626: RETURN PSB_POSITIONS_PVT.Rev_Check_Allowed
627: (p_api_version => p_api_version,
628: p_validation_level => p_validation_level,
629: p_startdate_pp => p_startdate_pp,
630: p_enddate_cy => p_enddate_cy,

Line 794: END PSB_POSITIONS_I_PVT;

790:
791:
792: /* ----------------------------------------------------------------------- */
793:
794: END PSB_POSITIONS_I_PVT;