[Home] [Help]
1: PACKAGE BODY POA_REPORT_UTIL AS
2: /* $Header: poarutlb.pls 115.12 2003/01/23 18:59:15 rvickrey ship $ */
3:
4: PROCEDURE Build_OrderDates(
5: p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
976: )
977: IS
978: l_user_id NUMBER;
979: l_Responsibility_tbl BIS_Responsibility_PVT.Responsibility_Tbl_Type;
980: l_SOB_tbl POA_REPORT_UTIL.SOB_Tbl_Type;
981: l_where_clause BIS_LEVELS.WHERE_CLAUSE%TYPE;
982: l_comma VARCHAR2(2) := ',';
983: l_database_object VARCHAR2(30);
984:
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: BIS_UTILITIES_PVT.Add_Error_Message
1052: (p_error_msg_id => SQLCODE
1053: ,p_error_description => SQLERRM
1054: ,p_error_proc_name => 'POA_REPORT_UTIL.Retrieve_Org_Where_Clause'
1055: ,p_error_table => x_error_tbl
1056: ,x_error_table => x_error_tbl
1057: );
1058:
1060:
1061: --Retrieve the set of books id associated with each responsibility id
1062: PROCEDURE Retrieve_Set_of_Books_Id
1063: (x_Responsibility_tbl IN BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type
1064: ,x_SOB_tbl OUT NOCOPY POA_REPORT_UTIL.SOB_Tbl_Type
1065: ,x_return_status OUT NOCOPY VARCHAR2
1066: )
1067: IS
1068: CURSOR sob_cur(p_resp_id NUMBER) IS
1069: SELECT id
1070: FROM bis_sets_of_books_v
1071: WHERE responsibility_id = p_resp_id;
1072:
1073: l_rec POA_REPORT_UTIL.SOB_Rec_Type;
1074:
1075: BEGIN
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077:
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: BIS_UTILITIES_PVT.Add_Error_Message
1096: ( p_error_msg_id => SQLCODE
1097: ,p_error_description => SQLERRM
1098: ,p_error_proc_name => 'POA_REPORT_UTIL.Retrieve_Set_of_Books_Id'
1099: );
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101:
1102: END Retrieve_Set_of_Books_Id;
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101:
1102: END Retrieve_Set_of_Books_Id;
1103:
1104: END POA_REPORT_UTIL;