DBA Data[Home] [Help]

APPS.BIS_PMF_ALERT_REG_PVT dependencies on BIS_PMF_ALERT_REG_PUB

Line 41: , p_Param_Set_Rec IN OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

37:
38: PROCEDURE Create_Parameter_set
39: ( p_api_version IN NUMBER
40: , p_commit IN VARCHAR2 := FND_API.G_FALSE
41: , p_Param_Set_Rec IN OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )
45: IS

Line 211: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

207:
208: PROCEDURE Delete_Parameter_set
209: ( p_api_version IN NUMBER
210: , p_commit IN VARCHAR2 := FND_API.G_FALSE
211: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
212: , x_return_status OUT NOCOPY VARCHAR2
213: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
214: )
215: IS

Line 297: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

293: ( p_api_version IN NUMBER
294: , p_measure_id IN NUMBER
295: , p_time_dimension_level_id IN NUMBER
296: , p_current_row IN VARCHAR2 := NULL
297: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )
301: IS

Line 303: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )
301: IS
302:
303: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
304: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
305: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
306:
307: Cursor parameter_set_list is select

Line 391: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

387: -- values in the parameter set record.
388: --
389: PROCEDURE Retrieve_Parameter_set
390: ( p_api_version IN NUMBER
391: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
392: , p_current_row IN VARCHAR2 := NULL
393: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
394: , x_return_status OUT NOCOPY VARCHAR2
395: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 393: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

389: PROCEDURE Retrieve_Parameter_set
390: ( p_api_version IN NUMBER
391: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
392: , p_current_row IN VARCHAR2 := NULL
393: , x_Param_Set_Tbl OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
394: , x_return_status OUT NOCOPY VARCHAR2
395: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
396: )
397: IS

Line 399: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

395: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
396: )
397: IS
398:
399: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
400: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
401: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
402: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
403:

Line 400: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

396: )
397: IS
398:
399: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
400: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
401: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
402: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
403:
404: Cursor parameter_set_reg is

Line 575: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

571: , x_return_status OUT NOCOPY VARCHAR2
572: )
573: IS
574:
575: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
576: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
577: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579:

Line 576: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

572: )
573: IS
574:
575: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
576: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
577: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579:
580: BEGIN

Line 624: , p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

620: END Retrieve_Notifiers_Code;
621:
622: PROCEDURE Retrieve_Notifiers_Code
623: ( p_api_version IN NUMBER
624: , p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
625: , x_Notifiers_Code OUT NOCOPY VARCHAR2
626: , x_return_status OUT NOCOPY VARCHAR2
627: )
628: IS

Line 630: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

626: , x_return_status OUT NOCOPY VARCHAR2
627: )
628: IS
629:
630: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
631: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
632: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
633: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
634:

Line 631: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

627: )
628: IS
629:
630: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
631: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
632: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
633: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
634:
635: BEGIN

Line 675: ( p_Param_Set_Tbl IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type

671: -- is deleted from the Registration table and the ad hoc workflow role
672: -- is removed.
673: --
674: PROCEDURE Manage_Alert_Registrations
675: ( p_Param_Set_Tbl IN BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type
676: , x_request_scheduled OUT NOCOPY VARCHAR2
677: , x_return_status OUT NOCOPY VARCHAR2
678: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
679: )

Line 720: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

716: -- is deleted from the Registration table and the ad hoc workflow role
717: -- is removed.
718: --
719: PROCEDURE Manage_Alert_Registrations
720: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
721: , x_request_scheduled OUT NOCOPY VARCHAR2
722: , x_return_status OUT NOCOPY VARCHAR2
723: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
724: )

Line 766: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

762: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
763: )
764: IS
765:
766: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
767: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
768: l_request_scheduled VARCHAR2(1000);
769:
770: BEGIN

Line 767: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

763: )
764: IS
765:
766: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
767: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
768: l_request_scheduled VARCHAR2(1000);
769:
770: BEGIN
771:

Line 794: , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

790: END Manage_Alert_Registrations;
791:
792: Procedure Form_Param_Set_Rec
793: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
794: , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
795: )
796: IS
797:
798: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 798: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

794: , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
795: )
796: IS
797:
798: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
799: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
800: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
801: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
802: l_dimension_level_number NUMBER;

Line 799: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

795: )
796: IS
797:
798: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
799: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
800: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
801: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
802: l_dimension_level_number NUMBER;
803: l_return_status VARCHAR2(32000);

Line 830: , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

826:
827: Procedure Form_Param_Set_Rec
828: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
829: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
830: , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
831: )
832: IS
833:
834: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

Line 834: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;

830: , x_Param_Set_Rec OUT NOCOPY BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
831: )
832: IS
833:
834: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
835: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
836: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
837: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
838: l_dimension_level_number NUMBER;

Line 835: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

831: )
832: IS
833:
834: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
835: l_Param_Set_Tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
836: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
837: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
838: l_dimension_level_number NUMBER;
839: l_return_status VARCHAR2(32000);

Line 885: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

881: -- and will also return the notifiers_code
882: --
883: FUNCTION Parameter_set_exist
884: ( p_api_version IN NUMBER
885: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
886: , x_notifiers_code OUT NOCOPY VARCHAR2
887: , x_return_status OUT NOCOPY VARCHAR2
888: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
889: ) return boolean

Line 892: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

888: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
889: ) return boolean
890: IS
891:
892: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
893: l_p_exist boolean;
894: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
895:
896: BEGIN

Line 943: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type

939: --
940: PROCEDURE Validate_Parameter_set
941: ( p_api_version IN NUMBER
942: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
943: , p_Param_Set_Rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
944: , x_return_status OUT NOCOPY VARCHAR2
945: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
946: )
947: IS