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.BIS_PMV_PARAMETERS_PVT dependencies on BISVIEWER

Line 58: pAttrNameList IN BISVIEWER.t_char,

54: /** Flattens the attrNameList for dimension and paramNumber into the xParameterTbl structure */
55: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation - Added pLovWhereList
56: PROCEDURE addToList(
57: pDImension IN VARCHAR2,
58: pAttrNameList IN BISVIEWER.t_char,
59: pLovWhereList IN BISVIEWER.t_char,
60:
61: pParamNumber In NUMBER,
62: xParameterTbl IN OUT NOCOPY parameter_group_tbl_type

Line 59: pLovWhereList IN BISVIEWER.t_char,

55: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation - Added pLovWhereList
56: PROCEDURE addToList(
57: pDImension IN VARCHAR2,
58: pAttrNameList IN BISVIEWER.t_char,
59: pLovWhereList IN BISVIEWER.t_char,
60:
61: pParamNumber In NUMBER,
62: xParameterTbl IN OUT NOCOPY parameter_group_tbl_type
63: ) IS

Line 101: pAttribute2Tbl BISVIEWER.t_char

97:
98: /* Proc to will group all the parameters into the parameter_group_tbl_type datastructure */
99: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation - Added pLovWhereTbl
100: PROCEDURE getParameterGroupForLists(
101: pAttribute2Tbl BISVIEWER.t_char
102: ,pAttribCodeTbl BISVIEWER.t_char
103: ,pDisplaySeqTbl BISVIEWER.t_num
104: ,pLovWhereTbl BISVIEWER.t_char
105: ,xParameterGroup IN OUT NOCOPY parameter_group_tbl_type

Line 102: ,pAttribCodeTbl BISVIEWER.t_char

98: /* Proc to will group all the parameters into the parameter_group_tbl_type datastructure */
99: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation - Added pLovWhereTbl
100: PROCEDURE getParameterGroupForLists(
101: pAttribute2Tbl BISVIEWER.t_char
102: ,pAttribCodeTbl BISVIEWER.t_char
103: ,pDisplaySeqTbl BISVIEWER.t_num
104: ,pLovWhereTbl BISVIEWER.t_char
105: ,xParameterGroup IN OUT NOCOPY parameter_group_tbl_type
106: ,xAsOfDateExists OUT NOCOPY BOOLEAN

Line 103: ,pDisplaySeqTbl BISVIEWER.t_num

99: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation - Added pLovWhereTbl
100: PROCEDURE getParameterGroupForLists(
101: pAttribute2Tbl BISVIEWER.t_char
102: ,pAttribCodeTbl BISVIEWER.t_char
103: ,pDisplaySeqTbl BISVIEWER.t_num
104: ,pLovWhereTbl BISVIEWER.t_char
105: ,xParameterGroup IN OUT NOCOPY parameter_group_tbl_type
106: ,xAsOfDateExists OUT NOCOPY BOOLEAN
107: ,xTimeCompTypeExists OUT NOCOPY BOOLEAN

Line 104: ,pLovWhereTbl BISVIEWER.t_char

100: PROCEDURE getParameterGroupForLists(
101: pAttribute2Tbl BISVIEWER.t_char
102: ,pAttribCodeTbl BISVIEWER.t_char
103: ,pDisplaySeqTbl BISVIEWER.t_num
104: ,pLovWhereTbl BISVIEWER.t_char
105: ,xParameterGroup IN OUT NOCOPY parameter_group_tbl_type
106: ,xAsOfDateExists OUT NOCOPY BOOLEAN
107: ,xTimeCompTypeExists OUT NOCOPY BOOLEAN
108: )IS

Line 110: lAttrNameList BISVIEWER.t_char;

106: ,xAsOfDateExists OUT NOCOPY BOOLEAN
107: ,xTimeCompTypeExists OUT NOCOPY BOOLEAN
108: )IS
109: lParamGrpRec parameter_group_rec_type;
110: lAttrNameList BISVIEWER.t_char;
111: lLovWhereList BISVIEWER.t_char;
112: l_index BINARY_INTEGER := 1;
113: l_grp_index BINARY_INTEGER := 1;
114: lPrevDimension VARCHAR2(80);

Line 111: lLovWhereList BISVIEWER.t_char;

107: ,xTimeCompTypeExists OUT NOCOPY BOOLEAN
108: )IS
109: lParamGrpRec parameter_group_rec_type;
110: lAttrNameList BISVIEWER.t_char;
111: lLovWhereList BISVIEWER.t_char;
112: l_index BINARY_INTEGER := 1;
113: l_grp_index BINARY_INTEGER := 1;
114: lPrevDimension VARCHAR2(80);
115: lDimension VARCHAR2(80);

Line 298: lDimensionTable BISVIEWER.t_char;

294: /* Assumption: When there is a nested region, then for the shared dimensions, the parameters
295: for grouping come from the nested region. Else they come from the default region
296: */
297: lNestedRegionCode VARCHAR2(80);
298: lDimensionTable BISVIEWER.t_char;
299: ldef_attr2_table BISVIEWER.t_char;
300: ldef_attr_code_table BISVIEWER.t_char;
301: ldef_disp_seq BISVIEWER.t_num;
302: lLov_where_table BISVIEWER.t_char;

Line 299: ldef_attr2_table BISVIEWER.t_char;

295: for grouping come from the nested region. Else they come from the default region
296: */
297: lNestedRegionCode VARCHAR2(80);
298: lDimensionTable BISVIEWER.t_char;
299: ldef_attr2_table BISVIEWER.t_char;
300: ldef_attr_code_table BISVIEWER.t_char;
301: ldef_disp_seq BISVIEWER.t_num;
302: lLov_where_table BISVIEWER.t_char;
303:

Line 300: ldef_attr_code_table BISVIEWER.t_char;

296: */
297: lNestedRegionCode VARCHAR2(80);
298: lDimensionTable BISVIEWER.t_char;
299: ldef_attr2_table BISVIEWER.t_char;
300: ldef_attr_code_table BISVIEWER.t_char;
301: ldef_disp_seq BISVIEWER.t_num;
302: lLov_where_table BISVIEWER.t_char;
303:
304: lParamGrpRec parameter_group_rec_type;

Line 301: ldef_disp_seq BISVIEWER.t_num;

297: lNestedRegionCode VARCHAR2(80);
298: lDimensionTable BISVIEWER.t_char;
299: ldef_attr2_table BISVIEWER.t_char;
300: ldef_attr_code_table BISVIEWER.t_char;
301: ldef_disp_seq BISVIEWER.t_num;
302: lLov_where_table BISVIEWER.t_char;
303:
304: lParamGrpRec parameter_group_rec_type;
305: lAttrNameList BISVIEWER.t_char;

Line 302: lLov_where_table BISVIEWER.t_char;

298: lDimensionTable BISVIEWER.t_char;
299: ldef_attr2_table BISVIEWER.t_char;
300: ldef_attr_code_table BISVIEWER.t_char;
301: ldef_disp_seq BISVIEWER.t_num;
302: lLov_where_table BISVIEWER.t_char;
303:
304: lParamGrpRec parameter_group_rec_type;
305: lAttrNameList BISVIEWER.t_char;
306: lLovWhereList BISVIEWER.t_char;

Line 305: lAttrNameList BISVIEWER.t_char;

301: ldef_disp_seq BISVIEWER.t_num;
302: lLov_where_table BISVIEWER.t_char;
303:
304: lParamGrpRec parameter_group_rec_type;
305: lAttrNameList BISVIEWER.t_char;
306: lLovWhereList BISVIEWER.t_char;
307: l_index BINARY_INTEGER := 1;
308: l_grp_index BINARY_INTEGER := 1;
309: lAsOfDateExists BOOLEAN;

Line 306: lLovWhereList BISVIEWER.t_char;

302: lLov_where_table BISVIEWER.t_char;
303:
304: lParamGrpRec parameter_group_rec_type;
305: lAttrNameList BISVIEWER.t_char;
306: lLovWhereList BISVIEWER.t_char;
307: l_index BINARY_INTEGER := 1;
308: l_grp_index BINARY_INTEGER := 1;
309: lAsOfDateExists BOOLEAN;
310: lTCTExists BOOLEAN;

Line 461: xAttributeNameList OUT NOCOPY BISVIEWER.t_char

457: pParamNumber IN NUMBER,
458: pDimension IN VARCHAR2,
459: pIndex In NUMBER,
460: pParameterGroup IN parameter_group_tbl_type,
461: xAttributeNameList OUT NOCOPY BISVIEWER.t_char
462: ) IS
463: lCount NUMBER := 1;
464: BEGIN
465:

Line 490: xAttributeNameList IN OUT NOCOPY BISVIEWER.t_char

486: pParamNumber IN NUMBER,
487: pDimension IN VARCHAR2,
488: pIndex In NUMBER,
489: pParameterGroup IN parameter_group_tbl_type,
490: xAttributeNameList IN OUT NOCOPY BISVIEWER.t_char
491: ) IS
492: lCount NUMBER := 1;
493: BEGIN
494:

Line 518: xAttributeNameList IN OUT NOCOPY BISVIEWER.t_char

514: PROCEDURE getParametersWithParamNumber(
515: pParamNumber IN NUMBER,
516: pDimension IN VARCHAR2,
517: pParameterGroup IN parameter_group_tbl_type,
518: xAttributeNameList IN OUT NOCOPY BISVIEWER.t_char
519: ) IS
520: --lAttrNameList BISVIEWER.t_char;
521: lCount NUMBER := 1;
522: BEGIN

Line 520: --lAttrNameList BISVIEWER.t_char;

516: pDimension IN VARCHAR2,
517: pParameterGroup IN parameter_group_tbl_type,
518: xAttributeNameList IN OUT NOCOPY BISVIEWER.t_char
519: ) IS
520: --lAttrNameList BISVIEWER.t_char;
521: lCount NUMBER := 1;
522: BEGIN
523:
524: -- no check being done on the dimension since this the parameter numbers should be unique.

Line 540: xAttNameList OUT NOCOPY BISVIEWER.t_char

536: PROCEDURE getAttrNamesInSameGroup (
537: pAttributeName IN VARCHAR2,
538: pDimension IN VARCHAR2,
539: pParameterGroup IN parameter_group_tbl_type,
540: xAttNameList OUT NOCOPY BISVIEWER.t_char
541: ) IS
542: lAttrNameList BISVIEWER.t_char;
543: lAttributeName VARCHAR2(80) := pAttributeName;
544: BEGIN

Line 542: lAttrNameList BISVIEWER.t_char;

538: pDimension IN VARCHAR2,
539: pParameterGroup IN parameter_group_tbl_type,
540: xAttNameList OUT NOCOPY BISVIEWER.t_char
541: ) IS
542: lAttrNameList BISVIEWER.t_char;
543: lAttributeName VARCHAR2(80) := pAttributeName;
544: BEGIN
545:
546: IF pParameterGroup IS NOT NULL AND pParameterGroup.COUNT > 0 THEN

Line 628: pAttributeNameTbl IN BISVIEWER.t_char

624: PROCEDURE bulkDeleteFromSession(
625: pSessionId in varchar2,
626: pUserId in varchar2,
627: pFunctionName in varchar2,
628: pAttributeNameTbl IN BISVIEWER.t_char
629: ) IS
630: BEGIN
631: -- FIX FOR P1 2797318 : kiprabha
632: -- DELETE ONLY IF SCHEDULE_ID IS NULL

Line 649: pAttributeNameTbl IN BISVIEWER.t_char,

645: PROCEDURE bulkInsertIntoSession(
646: pSessionId in varchar2,
647: pUserId in varchar2,
648: pFunctionName in varchar2,
649: pAttributeNameTbl IN BISVIEWER.t_char,
650: pDimensionTbl IN BISVIEWER.t_char,
651: pSessionValueTbl IN BISVIEWER.t_char,
652: pSessionDescTbl IN BISVIEWER.t_char,
653: pPeriodDateTbl IN BISVIEWER.t_date

Line 650: pDimensionTbl IN BISVIEWER.t_char,

646: pSessionId in varchar2,
647: pUserId in varchar2,
648: pFunctionName in varchar2,
649: pAttributeNameTbl IN BISVIEWER.t_char,
650: pDimensionTbl IN BISVIEWER.t_char,
651: pSessionValueTbl IN BISVIEWER.t_char,
652: pSessionDescTbl IN BISVIEWER.t_char,
653: pPeriodDateTbl IN BISVIEWER.t_date
654: ) IS

Line 651: pSessionValueTbl IN BISVIEWER.t_char,

647: pUserId in varchar2,
648: pFunctionName in varchar2,
649: pAttributeNameTbl IN BISVIEWER.t_char,
650: pDimensionTbl IN BISVIEWER.t_char,
651: pSessionValueTbl IN BISVIEWER.t_char,
652: pSessionDescTbl IN BISVIEWER.t_char,
653: pPeriodDateTbl IN BISVIEWER.t_date
654: ) IS
655: BEGIN

Line 652: pSessionDescTbl IN BISVIEWER.t_char,

648: pFunctionName in varchar2,
649: pAttributeNameTbl IN BISVIEWER.t_char,
650: pDimensionTbl IN BISVIEWER.t_char,
651: pSessionValueTbl IN BISVIEWER.t_char,
652: pSessionDescTbl IN BISVIEWER.t_char,
653: pPeriodDateTbl IN BISVIEWER.t_date
654: ) IS
655: BEGIN
656: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN

Line 653: pPeriodDateTbl IN BISVIEWER.t_date

649: pAttributeNameTbl IN BISVIEWER.t_char,
650: pDimensionTbl IN BISVIEWER.t_char,
651: pSessionValueTbl IN BISVIEWER.t_char,
652: pSessionDescTbl IN BISVIEWER.t_char,
653: pPeriodDateTbl IN BISVIEWER.t_date
654: ) IS
655: BEGIN
656: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
657: FORALL i IN pAttributeNameTbl.FIRST..pAttributeNameTbl.LAST

Line 683: pAttributeNameTbl IN BISVIEWER.t_char

679: PROCEDURE bulkDeleteFromPage(
680: pPAgeId in VARCHAR2,
681: pUserId in VARCHAR2,
682: pFunctionName IN VARCHAR2,
683: pAttributeNameTbl IN BISVIEWER.t_char
684: ) IS
685: BEGIN
686: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
687:

Line 699: pAttrNameList IN BISVIEWER.t_char,

695: END IF;
696: END bulkDeleteFromPage;
697:
698: PROCEDURE getDeleteAtttrList(
699: pAttrNameList IN BISVIEWER.t_char,
700: pDimension IN VARCHAR2,
701: xAttrNameList OUT NOCOPY BISVIEWER.t_char
702: ) IS
703: l_index NUMBER := 1;

Line 701: xAttrNameList OUT NOCOPY BISVIEWER.t_char

697:
698: PROCEDURE getDeleteAtttrList(
699: pAttrNameList IN BISVIEWER.t_char,
700: pDimension IN VARCHAR2,
701: xAttrNameList OUT NOCOPY BISVIEWER.t_char
702: ) IS
703: l_index NUMBER := 1;
704: BEGIN
705: IF (pAttrNameList IS NOT NULL AND pAttrNameList.COUNT > 0) THEN

Line 737: pAttrNameList IN BISVIEWER.t_char,

733: PROCEDURE deletePageForGroup(
734: pUserId in varchar2,
735: pFunctionName in varchar2,
736: pPageId in varchar2,
737: pAttrNameList IN BISVIEWER.t_char,
738: pDimension IN VARCHAR2
739: ) IS
740: lAttrNameList BISVIEWER.t_char;
741:

Line 740: lAttrNameList BISVIEWER.t_char;

736: pPageId in varchar2,
737: pAttrNameList IN BISVIEWER.t_char,
738: pDimension IN VARCHAR2
739: ) IS
740: lAttrNameList BISVIEWER.t_char;
741:
742: BEGIN
743:
744: getDeleteAtttrList(

Line 767: pAttrNameList IN BISVIEWER.t_char,

763: PROCEDURE deleteSessionForGroup(
764: pSessionId in varchar2,
765: pUserId in varchar2,
766: pFunctionName in varchar2,
767: pAttrNameList IN BISVIEWER.t_char,
768: pDimension IN VARCHAR2
769: ) IS
770: lAttrNameList BISVIEWER.t_char;
771:

Line 770: lAttrNameList BISVIEWER.t_char;

766: pFunctionName in varchar2,
767: pAttrNameList IN BISVIEWER.t_char,
768: pDimension IN VARCHAR2
769: ) IS
770: lAttrNameList BISVIEWER.t_char;
771:
772: BEGIN
773:
774: getDeleteAtttrList(

Line 796: pAttributeNameTbl IN BISVIEWER.t_char,

792: /* This will sent the parameters to be deleted and corresponding parameters to be inserted for the same group as
793: pAttributeNameTbl being sent in. - these can then be deleted or inserted into session/page etc.*/
794: PROCEDURE getDeleteAndInsertTables(
795: pUserId in varchar2,
796: pAttributeNameTbl IN BISVIEWER.t_char,
797: pDimensionTbl IN BISVIEWER.t_char,
798: pSessionValueTbl IN BISVIEWER.t_char,
799: pSessionDescTbl IN BISVIEWER.t_char,
800: pPeriodDateTbl IN BISVIEWER.t_date,

Line 797: pDimensionTbl IN BISVIEWER.t_char,

793: pAttributeNameTbl being sent in. - these can then be deleted or inserted into session/page etc.*/
794: PROCEDURE getDeleteAndInsertTables(
795: pUserId in varchar2,
796: pAttributeNameTbl IN BISVIEWER.t_char,
797: pDimensionTbl IN BISVIEWER.t_char,
798: pSessionValueTbl IN BISVIEWER.t_char,
799: pSessionDescTbl IN BISVIEWER.t_char,
800: pPeriodDateTbl IN BISVIEWER.t_date,
801: pParameterGroup IN parameter_group_tbl_type,

Line 798: pSessionValueTbl IN BISVIEWER.t_char,

794: PROCEDURE getDeleteAndInsertTables(
795: pUserId in varchar2,
796: pAttributeNameTbl IN BISVIEWER.t_char,
797: pDimensionTbl IN BISVIEWER.t_char,
798: pSessionValueTbl IN BISVIEWER.t_char,
799: pSessionDescTbl IN BISVIEWER.t_char,
800: pPeriodDateTbl IN BISVIEWER.t_date,
801: pParameterGroup IN parameter_group_tbl_type,
802: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,

Line 799: pSessionDescTbl IN BISVIEWER.t_char,

795: pUserId in varchar2,
796: pAttributeNameTbl IN BISVIEWER.t_char,
797: pDimensionTbl IN BISVIEWER.t_char,
798: pSessionValueTbl IN BISVIEWER.t_char,
799: pSessionDescTbl IN BISVIEWER.t_char,
800: pPeriodDateTbl IN BISVIEWER.t_date,
801: pParameterGroup IN parameter_group_tbl_type,
802: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
803: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,

Line 800: pPeriodDateTbl IN BISVIEWER.t_date,

796: pAttributeNameTbl IN BISVIEWER.t_char,
797: pDimensionTbl IN BISVIEWER.t_char,
798: pSessionValueTbl IN BISVIEWER.t_char,
799: pSessionDescTbl IN BISVIEWER.t_char,
800: pPeriodDateTbl IN BISVIEWER.t_date,
801: pParameterGroup IN parameter_group_tbl_type,
802: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
803: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,
804: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE,

Line 805: xAttrNameForInsert OUT NOCOPY BISVIEWER.t_char,

801: pParameterGroup IN parameter_group_tbl_type,
802: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
803: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,
804: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE,
805: xAttrNameForInsert OUT NOCOPY BISVIEWER.t_char,
806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,
807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,
808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,

Line 806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,

802: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
803: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,
804: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE,
805: xAttrNameForInsert OUT NOCOPY BISVIEWER.t_char,
806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,
807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,
808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,
810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char

Line 807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,

803: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,
804: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE,
805: xAttrNameForInsert OUT NOCOPY BISVIEWER.t_char,
806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,
807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,
808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,
810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char
811: ) IS

Line 808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,

804: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE,
805: xAttrNameForInsert OUT NOCOPY BISVIEWER.t_char,
806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,
807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,
808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,
810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char
811: ) IS
812: lAttrNameList BISVIEWER.t_char;

Line 809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,

805: xAttrNameForInsert OUT NOCOPY BISVIEWER.t_char,
806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,
807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,
808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,
810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char
811: ) IS
812: lAttrNameList BISVIEWER.t_char;
813: insert_index NUMBER :=1;

Line 810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char

806: xDimensionForInsert OUT NOCOPY BISVIEWER.t_char,
807: xSessValueForInsert OUT NOCOPY BISVIEWER.t_char,
808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,
810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char
811: ) IS
812: lAttrNameList BISVIEWER.t_char;
813: insert_index NUMBER :=1;
814:

Line 812: lAttrNameList BISVIEWER.t_char;

808: xSessDescForInsert OUT NOCOPY BISVIEWER.t_char,
809: xPeriodDateForInsert OUT NOCOPY BISVIEWER.t_date,
810: xAttrNameForDelete OUT NOCOPY BISVIEWER.t_char
811: ) IS
812: lAttrNameList BISVIEWER.t_char;
813: insert_index NUMBER :=1;
814:
815: delete_index NUMBER :=1;
816: BEGIN

Line 906: pAttributeNameTbl IN BISVIEWER.t_char,

902: PROCEDURE deleteAndInsertIntoSession(
903: pSessionId in varchar2,
904: pUserId in varchar2,
905: pFunctionName in varchar2,
906: pAttributeNameTbl IN BISVIEWER.t_char,
907: pDimensionTbl IN BISVIEWER.t_char,
908: pSessionValueTbl IN BISVIEWER.t_char,
909: pSessionDescTbl IN BISVIEWER.t_char,
910: pPeriodDateTbl IN BISVIEWER.t_date,

Line 907: pDimensionTbl IN BISVIEWER.t_char,

903: pSessionId in varchar2,
904: pUserId in varchar2,
905: pFunctionName in varchar2,
906: pAttributeNameTbl IN BISVIEWER.t_char,
907: pDimensionTbl IN BISVIEWER.t_char,
908: pSessionValueTbl IN BISVIEWER.t_char,
909: pSessionDescTbl IN BISVIEWER.t_char,
910: pPeriodDateTbl IN BISVIEWER.t_date,
911: pParameterGroup IN parameter_group_tbl_type,

Line 908: pSessionValueTbl IN BISVIEWER.t_char,

904: pUserId in varchar2,
905: pFunctionName in varchar2,
906: pAttributeNameTbl IN BISVIEWER.t_char,
907: pDimensionTbl IN BISVIEWER.t_char,
908: pSessionValueTbl IN BISVIEWER.t_char,
909: pSessionDescTbl IN BISVIEWER.t_char,
910: pPeriodDateTbl IN BISVIEWER.t_date,
911: pParameterGroup IN parameter_group_tbl_type,
912: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,

Line 909: pSessionDescTbl IN BISVIEWER.t_char,

905: pFunctionName in varchar2,
906: pAttributeNameTbl IN BISVIEWER.t_char,
907: pDimensionTbl IN BISVIEWER.t_char,
908: pSessionValueTbl IN BISVIEWER.t_char,
909: pSessionDescTbl IN BISVIEWER.t_char,
910: pPeriodDateTbl IN BISVIEWER.t_date,
911: pParameterGroup IN parameter_group_tbl_type,
912: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
913: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,

Line 910: pPeriodDateTbl IN BISVIEWER.t_date,

906: pAttributeNameTbl IN BISVIEWER.t_char,
907: pDimensionTbl IN BISVIEWER.t_char,
908: pSessionValueTbl IN BISVIEWER.t_char,
909: pSessionDescTbl IN BISVIEWER.t_char,
910: pPeriodDateTbl IN BISVIEWER.t_date,
911: pParameterGroup IN parameter_group_tbl_type,
912: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
913: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,
914: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE

Line 916: lAttrNameList BISVIEWER.t_char;

912: pIncludeViewBy IN BOOLEAN DEFAULT FALSE,
913: pIncludeBusinessPlan IN BOOLEAN DEFAULT FALSE,
914: pIncludePrevAsOfDate IN BOOLEAN DEFAULT FALSE
915: ) IS
916: lAttrNameList BISVIEWER.t_char;
917: insert_index NUMBER :=1;
918:
919: lAttrNameForInsert BISVIEWER.t_char;
920: lDimensionForInsert BISVIEWER.t_char;

Line 919: lAttrNameForInsert BISVIEWER.t_char;

915: ) IS
916: lAttrNameList BISVIEWER.t_char;
917: insert_index NUMBER :=1;
918:
919: lAttrNameForInsert BISVIEWER.t_char;
920: lDimensionForInsert BISVIEWER.t_char;
921: lSessValueForInsert BISVIEWER.t_char;
922: lSessDescForInsert BISVIEWER.t_char;
923: lPeriodDateForInsert BISVIEWER.t_date;

Line 920: lDimensionForInsert BISVIEWER.t_char;

916: lAttrNameList BISVIEWER.t_char;
917: insert_index NUMBER :=1;
918:
919: lAttrNameForInsert BISVIEWER.t_char;
920: lDimensionForInsert BISVIEWER.t_char;
921: lSessValueForInsert BISVIEWER.t_char;
922: lSessDescForInsert BISVIEWER.t_char;
923: lPeriodDateForInsert BISVIEWER.t_date;
924:

Line 921: lSessValueForInsert BISVIEWER.t_char;

917: insert_index NUMBER :=1;
918:
919: lAttrNameForInsert BISVIEWER.t_char;
920: lDimensionForInsert BISVIEWER.t_char;
921: lSessValueForInsert BISVIEWER.t_char;
922: lSessDescForInsert BISVIEWER.t_char;
923: lPeriodDateForInsert BISVIEWER.t_date;
924:
925: delete_index NUMBER :=1;

Line 922: lSessDescForInsert BISVIEWER.t_char;

918:
919: lAttrNameForInsert BISVIEWER.t_char;
920: lDimensionForInsert BISVIEWER.t_char;
921: lSessValueForInsert BISVIEWER.t_char;
922: lSessDescForInsert BISVIEWER.t_char;
923: lPeriodDateForInsert BISVIEWER.t_date;
924:
925: delete_index NUMBER :=1;
926: lAttrNameForDelete BISVIEWER.t_char;

Line 923: lPeriodDateForInsert BISVIEWER.t_date;

919: lAttrNameForInsert BISVIEWER.t_char;
920: lDimensionForInsert BISVIEWER.t_char;
921: lSessValueForInsert BISVIEWER.t_char;
922: lSessDescForInsert BISVIEWER.t_char;
923: lPeriodDateForInsert BISVIEWER.t_date;
924:
925: delete_index NUMBER :=1;
926: lAttrNameForDelete BISVIEWER.t_char;
927: BEGIN

Line 926: lAttrNameForDelete BISVIEWER.t_char;

922: lSessDescForInsert BISVIEWER.t_char;
923: lPeriodDateForInsert BISVIEWER.t_date;
924:
925: delete_index NUMBER :=1;
926: lAttrNameForDelete BISVIEWER.t_char;
927: BEGIN
928:
929: -- for each attribute in the list sent
930: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN

Line 1055: vAttributeCodeTable BISVIEWER.t_char;

1051: SELECT attribute_name, dimension, session_value, session_description, period_date
1052: FROM bis_user_attributes
1053: WHERE schedule_id=pScheduleId;
1054:
1055: vAttributeCodeTable BISVIEWER.t_char;
1056: vDimensionTable BISVIEWER.t_char;
1057: vSessionValueTable BISVIEWER.t_char;
1058: vSessionDescTable BISVIEWER.t_char;
1059: vPeriodDateTable BISVIEWER.t_date;

Line 1056: vDimensionTable BISVIEWER.t_char;

1052: FROM bis_user_attributes
1053: WHERE schedule_id=pScheduleId;
1054:
1055: vAttributeCodeTable BISVIEWER.t_char;
1056: vDimensionTable BISVIEWER.t_char;
1057: vSessionValueTable BISVIEWER.t_char;
1058: vSessionDescTable BISVIEWER.t_char;
1059: vPeriodDateTable BISVIEWER.t_date;
1060:

Line 1057: vSessionValueTable BISVIEWER.t_char;

1053: WHERE schedule_id=pScheduleId;
1054:
1055: vAttributeCodeTable BISVIEWER.t_char;
1056: vDimensionTable BISVIEWER.t_char;
1057: vSessionValueTable BISVIEWER.t_char;
1058: vSessionDescTable BISVIEWER.t_char;
1059: vPeriodDateTable BISVIEWER.t_date;
1060:
1061: BEGIN

Line 1058: vSessionDescTable BISVIEWER.t_char;

1054:
1055: vAttributeCodeTable BISVIEWER.t_char;
1056: vDimensionTable BISVIEWER.t_char;
1057: vSessionValueTable BISVIEWER.t_char;
1058: vSessionDescTable BISVIEWER.t_char;
1059: vPeriodDateTable BISVIEWER.t_date;
1060:
1061: BEGIN
1062: IF getScheduleParameters%ISOPEN THEN

Line 1059: vPeriodDateTable BISVIEWER.t_date;

1055: vAttributeCodeTable BISVIEWER.t_char;
1056: vDimensionTable BISVIEWER.t_char;
1057: vSessionValueTable BISVIEWER.t_char;
1058: vSessionDescTable BISVIEWER.t_char;
1059: vPeriodDateTable BISVIEWER.t_date;
1060:
1061: BEGIN
1062: IF getScheduleParameters%ISOPEN THEN
1063: CLOSE getScheduleParameters;

Line 1104: vAttributeCodeTable BISVIEWER.t_char;

1100: WHERE function_name =pPreFunctionName
1101: AND session_id = pSessionId
1102: AND user_id = pUserId;
1103:
1104: vAttributeCodeTable BISVIEWER.t_char;
1105: vDimensionTable BISVIEWER.t_char;
1106: vSessionValueTable BISVIEWER.t_char;
1107: vSessionDescTable BISVIEWER.t_char;
1108: vPeriodDateTable BISVIEWER.t_date;

Line 1105: vDimensionTable BISVIEWER.t_char;

1101: AND session_id = pSessionId
1102: AND user_id = pUserId;
1103:
1104: vAttributeCodeTable BISVIEWER.t_char;
1105: vDimensionTable BISVIEWER.t_char;
1106: vSessionValueTable BISVIEWER.t_char;
1107: vSessionDescTable BISVIEWER.t_char;
1108: vPeriodDateTable BISVIEWER.t_date;
1109:

Line 1106: vSessionValueTable BISVIEWER.t_char;

1102: AND user_id = pUserId;
1103:
1104: vAttributeCodeTable BISVIEWER.t_char;
1105: vDimensionTable BISVIEWER.t_char;
1106: vSessionValueTable BISVIEWER.t_char;
1107: vSessionDescTable BISVIEWER.t_char;
1108: vPeriodDateTable BISVIEWER.t_date;
1109:
1110: l_time_attr_2 varchar2(2000);

Line 1107: vSessionDescTable BISVIEWER.t_char;

1103:
1104: vAttributeCodeTable BISVIEWER.t_char;
1105: vDimensionTable BISVIEWER.t_char;
1106: vSessionValueTable BISVIEWER.t_char;
1107: vSessionDescTable BISVIEWER.t_char;
1108: vPeriodDateTable BISVIEWER.t_date;
1109:
1110: l_time_attr_2 varchar2(2000);
1111: l_time_level_id VARCHAR2(2000);

Line 1108: vPeriodDateTable BISVIEWER.t_date;

1104: vAttributeCodeTable BISVIEWER.t_char;
1105: vDimensionTable BISVIEWER.t_char;
1106: vSessionValueTable BISVIEWER.t_char;
1107: vSessionDescTable BISVIEWER.t_char;
1108: vPeriodDateTable BISVIEWER.t_date;
1109:
1110: l_time_attr_2 varchar2(2000);
1111: l_time_level_id VARCHAR2(2000);
1112: l_time_level_value VARCHAR2(2000);

Line 1193: vAttributeCodeTable BISVIEWER.t_char;

1189: FROM bis_user_attributes
1190: WHERE page_id =pPageId
1191: AND user_id = pUserId;
1192:
1193: vAttributeCodeTable BISVIEWER.t_char;
1194: vDimensionTable BISVIEWER.t_char;
1195: vSessionValueTable BISVIEWER.t_char;
1196: vSessionDescTable BISVIEWER.t_char;
1197: vPeriodDateTable BISVIEWER.t_date;

Line 1194: vDimensionTable BISVIEWER.t_char;

1190: WHERE page_id =pPageId
1191: AND user_id = pUserId;
1192:
1193: vAttributeCodeTable BISVIEWER.t_char;
1194: vDimensionTable BISVIEWER.t_char;
1195: vSessionValueTable BISVIEWER.t_char;
1196: vSessionDescTable BISVIEWER.t_char;
1197: vPeriodDateTable BISVIEWER.t_date;
1198:

Line 1195: vSessionValueTable BISVIEWER.t_char;

1191: AND user_id = pUserId;
1192:
1193: vAttributeCodeTable BISVIEWER.t_char;
1194: vDimensionTable BISVIEWER.t_char;
1195: vSessionValueTable BISVIEWER.t_char;
1196: vSessionDescTable BISVIEWER.t_char;
1197: vPeriodDateTable BISVIEWER.t_date;
1198:
1199: BEGIN

Line 1196: vSessionDescTable BISVIEWER.t_char;

1192:
1193: vAttributeCodeTable BISVIEWER.t_char;
1194: vDimensionTable BISVIEWER.t_char;
1195: vSessionValueTable BISVIEWER.t_char;
1196: vSessionDescTable BISVIEWER.t_char;
1197: vPeriodDateTable BISVIEWER.t_date;
1198:
1199: BEGIN
1200: IF getPageParameters%ISOPEN THEN

Line 1197: vPeriodDateTable BISVIEWER.t_date;

1193: vAttributeCodeTable BISVIEWER.t_char;
1194: vDimensionTable BISVIEWER.t_char;
1195: vSessionValueTable BISVIEWER.t_char;
1196: vSessionDescTable BISVIEWER.t_char;
1197: vPeriodDateTable BISVIEWER.t_date;
1198:
1199: BEGIN
1200: IF getPageParameters%ISOPEN THEN
1201: CLOSE getPageParameters;

Line 1239: vAttributeCodeTable BISVIEWER.t_char;

1235: AND user_id = pUserId
1236: AND session_id IS NULL
1237: AND session_description = 'NULL';
1238:
1239: vAttributeCodeTable BISVIEWER.t_char;
1240: vDimensionTable BISVIEWER.t_char;
1241: vSessionValueTable BISVIEWER.t_char;
1242: vSessionDescTable BISVIEWER.t_char;
1243: vPeriodDateTable BISVIEWER.t_date;

Line 1240: vDimensionTable BISVIEWER.t_char;

1236: AND session_id IS NULL
1237: AND session_description = 'NULL';
1238:
1239: vAttributeCodeTable BISVIEWER.t_char;
1240: vDimensionTable BISVIEWER.t_char;
1241: vSessionValueTable BISVIEWER.t_char;
1242: vSessionDescTable BISVIEWER.t_char;
1243: vPeriodDateTable BISVIEWER.t_date;
1244:

Line 1241: vSessionValueTable BISVIEWER.t_char;

1237: AND session_description = 'NULL';
1238:
1239: vAttributeCodeTable BISVIEWER.t_char;
1240: vDimensionTable BISVIEWER.t_char;
1241: vSessionValueTable BISVIEWER.t_char;
1242: vSessionDescTable BISVIEWER.t_char;
1243: vPeriodDateTable BISVIEWER.t_date;
1244:
1245: BEGIN

Line 1242: vSessionDescTable BISVIEWER.t_char;

1238:
1239: vAttributeCodeTable BISVIEWER.t_char;
1240: vDimensionTable BISVIEWER.t_char;
1241: vSessionValueTable BISVIEWER.t_char;
1242: vSessionDescTable BISVIEWER.t_char;
1243: vPeriodDateTable BISVIEWER.t_date;
1244:
1245: BEGIN
1246: IF getSavedDefaultParameters%ISOPEN THEN

Line 1243: vPeriodDateTable BISVIEWER.t_date;

1239: vAttributeCodeTable BISVIEWER.t_char;
1240: vDimensionTable BISVIEWER.t_char;
1241: vSessionValueTable BISVIEWER.t_char;
1242: vSessionDescTable BISVIEWER.t_char;
1243: vPeriodDateTable BISVIEWER.t_date;
1244:
1245: BEGIN
1246: IF getSavedDefaultParameters%ISOPEN THEN
1247: CLOSE getSavedDefaultParameters;

Line 1271: xParameterName OUT NOCOPY BISVIEWER.t_char,

1267:
1268:
1269: -- Procedure to get Name Value pairs of the form name=value1&name2=value2
1270: PROCEDURE getNameValuePairs(pUrlString IN VARCHAR2,
1271: xParameterName OUT NOCOPY BISVIEWER.t_char,
1272: xParameterValue OUT NOCOPY BISVIEWER.t_char
1273: )
1274: IS
1275: index1 number;

Line 1272: xParameterValue OUT NOCOPY BISVIEWER.t_char

1268:
1269: -- Procedure to get Name Value pairs of the form name=value1&name2=value2
1270: PROCEDURE getNameValuePairs(pUrlString IN VARCHAR2,
1271: xParameterName OUT NOCOPY BISVIEWER.t_char,
1272: xParameterValue OUT NOCOPY BISVIEWER.t_char
1273: )
1274: IS
1275: index1 number;
1276: index2 number;

Line 1328: l_attr_code In OUT NOCOPY BISVIEWER.t_char

1324: END getNameValuePairs;
1325:
1326: -- procedure to get only the pParameters from the array
1327: PROCEDURE processDefaultParameters(
1328: l_attr_code In OUT NOCOPY BISVIEWER.t_char
1329: , l_attr_value IN OUT NOCOPY BISVIEWER.t_char
1330: ) IS
1331: BEGIN
1332: IF (l_attr_code IS NOT NULL AND l_attr_code.COUNT >0) THEN

Line 1329: , l_attr_value IN OUT NOCOPY BISVIEWER.t_char

1325:
1326: -- procedure to get only the pParameters from the array
1327: PROCEDURE processDefaultParameters(
1328: l_attr_code In OUT NOCOPY BISVIEWER.t_char
1329: , l_attr_value IN OUT NOCOPY BISVIEWER.t_char
1330: ) IS
1331: BEGIN
1332: IF (l_attr_code IS NOT NULL AND l_attr_code.COUNT >0) THEN
1333: FOR i IN l_attr_code.FIRST..l_attr_code.LAST LOOP

Line 1372: , l_attr_code In OUT NOCOPY BISVIEWER.t_char

1368: ,pFunctionName IN VARCHAR2
1369: ,pUserId IN VARCHAR2
1370: ,pSessionId IN VARCHAR2
1371: ,pResponsibilityId in varchar2 default NULL
1372: , l_attr_code In OUT NOCOPY BISVIEWER.t_char
1373: , l_attr_value IN OUT NOCOPY BISVIEWER.t_char
1374: , x_save_by_id OUT NOCOPY BOOLEAN
1375:
1376: ) IS

Line 1373: , l_attr_value IN OUT NOCOPY BISVIEWER.t_char

1369: ,pUserId IN VARCHAR2
1370: ,pSessionId IN VARCHAR2
1371: ,pResponsibilityId in varchar2 default NULL
1372: , l_attr_code In OUT NOCOPY BISVIEWER.t_char
1373: , l_attr_value IN OUT NOCOPY BISVIEWER.t_char
1374: , x_save_by_id OUT NOCOPY BOOLEAN
1375:
1376: ) IS
1377: l_vieW_by VARCHAR2(80);

Line 1455: l_param_code BISVIEWER.t_char;

1451: ,x_return_status OUT NOCOPY VARCHAR2
1452: ,x_msg_count OUT NOCOPY NUMBER
1453: ,x_msg_data OUT NOCOPY VARCHAR2
1454: ) IS
1455: l_param_code BISVIEWER.t_char;
1456: l_param_value BISVIEWER.t_char;
1457: l_attr_code BISVIEWER.t_char;
1458: l_attr_value BISVIEWER.t_char;
1459: lParameters VARCHAR2(2000);

Line 1456: l_param_value BISVIEWER.t_char;

1452: ,x_msg_count OUT NOCOPY NUMBER
1453: ,x_msg_data OUT NOCOPY VARCHAR2
1454: ) IS
1455: l_param_code BISVIEWER.t_char;
1456: l_param_value BISVIEWER.t_char;
1457: l_attr_code BISVIEWER.t_char;
1458: l_attr_value BISVIEWER.t_char;
1459: lParameters VARCHAR2(2000);
1460: lDefaultParameters VARCHAR2(2000);

Line 1457: l_attr_code BISVIEWER.t_char;

1453: ,x_msg_data OUT NOCOPY VARCHAR2
1454: ) IS
1455: l_param_code BISVIEWER.t_char;
1456: l_param_value BISVIEWER.t_char;
1457: l_attr_code BISVIEWER.t_char;
1458: l_attr_value BISVIEWER.t_char;
1459: lParameters VARCHAR2(2000);
1460: lDefaultParameters VARCHAR2(2000);
1461: l_dimension VARCHAR2(2000);

Line 1458: l_attr_value BISVIEWER.t_char;

1454: ) IS
1455: l_param_code BISVIEWER.t_char;
1456: l_param_value BISVIEWER.t_char;
1457: l_attr_code BISVIEWER.t_char;
1458: l_attr_value BISVIEWER.t_char;
1459: lParameters VARCHAR2(2000);
1460: lDefaultParameters VARCHAR2(2000);
1461: l_dimension VARCHAR2(2000);
1462: l_savebyid BOOLEAN := FALSE;

Line 2242: l_roleIds_tbl BISVIEWER.t_char;

2238: l_validated_value VARCHAR2(200) := NULL;
2239: l_delegation_param VARCHAR2(150);
2240: l_privilege VARCHAR2(150);
2241: l_attribute_code VARCHAR2(30);
2242: l_roleIds_tbl BISVIEWER.t_char;
2243: l_delegationIds_tbl BISVIEWER.t_char;
2244: l_delegationValues_tbl BISVIEWER.t_char;
2245: l_view_name VARCHAR2(150);
2246: l_dimension_level VARCHAR2(150);

Line 2243: l_delegationIds_tbl BISVIEWER.t_char;

2239: l_delegation_param VARCHAR2(150);
2240: l_privilege VARCHAR2(150);
2241: l_attribute_code VARCHAR2(30);
2242: l_roleIds_tbl BISVIEWER.t_char;
2243: l_delegationIds_tbl BISVIEWER.t_char;
2244: l_delegationValues_tbl BISVIEWER.t_char;
2245: l_view_name VARCHAR2(150);
2246: l_dimension_level VARCHAR2(150);
2247: l_level_type VARCHAR2(150);

Line 2244: l_delegationValues_tbl BISVIEWER.t_char;

2240: l_privilege VARCHAR2(150);
2241: l_attribute_code VARCHAR2(30);
2242: l_roleIds_tbl BISVIEWER.t_char;
2243: l_delegationIds_tbl BISVIEWER.t_char;
2244: l_delegationValues_tbl BISVIEWER.t_char;
2245: l_view_name VARCHAR2(150);
2246: l_dimension_level VARCHAR2(150);
2247: l_level_type VARCHAR2(150);
2248: l_sql_stmnt VARCHAR2(2000);

Line 2620: ,p_page_dims IN BISVIEWER.t_char

2616: PROCEDURE RETRIEVE_PAGE_PARAMETER
2617: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2618: ,p_schedule_id IN NUMBER
2619: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
2620: ,p_page_dims IN BISVIEWER.t_char
2621: ,x_return_status OUT NOCOPY VARCHAR2
2622: ,x_msg_count OUT NOCOPY NUMBER
2623: ,x_msg_data OUT NOCOPY VARCHAR2
2624: ) IS

Line 2626: l_page_dims BISVIEWER.t_char := p_page_dims;

2622: ,x_msg_count OUT NOCOPY NUMBER
2623: ,x_msg_data OUT NOCOPY VARCHAR2
2624: ) IS
2625:
2626: l_page_dims BISVIEWER.t_char := p_page_dims;
2627: BEGIN
2628:
2629: -- make sure there are max elements as they will be accessed
2630: IF l_page_dims IS NOT NULL AND l_page_dims.COUNT < MAX_BIND_VARIABLE_COUNT AND l_page_dims.COUNT>0 THEN

Line 2743: ,p_user_dims IN BISVIEWER.t_char

2739:
2740: PROCEDURE RETRIEVE_KPI_PARAMETER
2741: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2742: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
2743: ,p_user_dims IN BISVIEWER.t_char
2744: ,x_return_status OUT NOCOPY VARCHAR2
2745: ,x_msg_count OUT NOCOPY NUMBER
2746: ,x_msg_data OUT NOCOPY VARCHAR2
2747: ) IS

Line 2749: l_user_dims BISVIEWER.t_char := p_user_dims;

2745: ,x_msg_count OUT NOCOPY NUMBER
2746: ,x_msg_data OUT NOCOPY VARCHAR2
2747: ) IS
2748:
2749: l_user_dims BISVIEWER.t_char := p_user_dims;
2750:
2751: BEGIN
2752:
2753: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3224: lNullList BISVIEWER.t_char;

3220: IS
3221: l_parameter_rec parameter_rec_type;
3222: l_index NUMBER := 1;
3223: l_dimension varchar2(25) := 'TIME_COMPARISON_TYPE';
3224: lNullList BISVIEWER.t_char;
3225: BEGIN
3226: l_parameter_rec.parameter_name := 'AS_OF_DATE';
3227: RETRIEVE_PAGE_PARAMETER (p_parameter_rec => l_parameter_rec
3228: ,p_schedule_id => null

Line 5914: pAttributeNameTbl IN BISVIEWER.t_char,

5910: pSessionId IN VARCHAR2,
5911: pPageId in VARCHAR2,
5912: pUserId in VARCHAR2,
5913: pFunctionName IN VARCHAR2,
5914: pAttributeNameTbl IN BISVIEWER.t_char,
5915: pDimensionTbl IN BISVIEWER.t_char,
5916: pSessionValueTbl IN BISVIEWER.t_char,
5917: pSessionDescTbl IN BISVIEWER.t_char,
5918: pPeriodDateTbl IN BISVIEWER.t_date

Line 5915: pDimensionTbl IN BISVIEWER.t_char,

5911: pPageId in VARCHAR2,
5912: pUserId in VARCHAR2,
5913: pFunctionName IN VARCHAR2,
5914: pAttributeNameTbl IN BISVIEWER.t_char,
5915: pDimensionTbl IN BISVIEWER.t_char,
5916: pSessionValueTbl IN BISVIEWER.t_char,
5917: pSessionDescTbl IN BISVIEWER.t_char,
5918: pPeriodDateTbl IN BISVIEWER.t_date
5919: ) IS

Line 5916: pSessionValueTbl IN BISVIEWER.t_char,

5912: pUserId in VARCHAR2,
5913: pFunctionName IN VARCHAR2,
5914: pAttributeNameTbl IN BISVIEWER.t_char,
5915: pDimensionTbl IN BISVIEWER.t_char,
5916: pSessionValueTbl IN BISVIEWER.t_char,
5917: pSessionDescTbl IN BISVIEWER.t_char,
5918: pPeriodDateTbl IN BISVIEWER.t_date
5919: ) IS
5920: BEGIN

Line 5917: pSessionDescTbl IN BISVIEWER.t_char,

5913: pFunctionName IN VARCHAR2,
5914: pAttributeNameTbl IN BISVIEWER.t_char,
5915: pDimensionTbl IN BISVIEWER.t_char,
5916: pSessionValueTbl IN BISVIEWER.t_char,
5917: pSessionDescTbl IN BISVIEWER.t_char,
5918: pPeriodDateTbl IN BISVIEWER.t_date
5919: ) IS
5920: BEGIN
5921: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN

Line 5918: pPeriodDateTbl IN BISVIEWER.t_date

5914: pAttributeNameTbl IN BISVIEWER.t_char,
5915: pDimensionTbl IN BISVIEWER.t_char,
5916: pSessionValueTbl IN BISVIEWER.t_char,
5917: pSessionDescTbl IN BISVIEWER.t_char,
5918: pPeriodDateTbl IN BISVIEWER.t_date
5919: ) IS
5920: BEGIN
5921: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
5922: FORALL i IN pAttributeNameTbl.FIRST..pAttributeNameTbl.LAST

Line 6028: lAttributeCodeTable IN BISVIEWER.t_char,

6024: END GET_PARAM_LOV_WHERE;
6025:
6026: --nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
6027: PROCEDURE GET_VALIDATED_DRILL_PARAMS (
6028: lAttributeCodeTable IN BISVIEWER.t_char,
6029: lDimensionTable IN BISVIEWER.t_char,
6030: lSessionValueTable IN BISVIEWER.t_char,
6031: lSessionDescTable IN BISVIEWER.t_char,
6032: lPeriodDateTable IN BISVIEWER.t_date,

Line 6029: lDimensionTable IN BISVIEWER.t_char,

6025:
6026: --nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
6027: PROCEDURE GET_VALIDATED_DRILL_PARAMS (
6028: lAttributeCodeTable IN BISVIEWER.t_char,
6029: lDimensionTable IN BISVIEWER.t_char,
6030: lSessionValueTable IN BISVIEWER.t_char,
6031: lSessionDescTable IN BISVIEWER.t_char,
6032: lPeriodDateTable IN BISVIEWER.t_date,
6033: pParamRegionCode IN VARCHAR2,

Line 6030: lSessionValueTable IN BISVIEWER.t_char,

6026: --nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
6027: PROCEDURE GET_VALIDATED_DRILL_PARAMS (
6028: lAttributeCodeTable IN BISVIEWER.t_char,
6029: lDimensionTable IN BISVIEWER.t_char,
6030: lSessionValueTable IN BISVIEWER.t_char,
6031: lSessionDescTable IN BISVIEWER.t_char,
6032: lPeriodDateTable IN BISVIEWER.t_date,
6033: pParamRegionCode IN VARCHAR2,
6034: pParamFunctionName IN VARCHAR2,

Line 6031: lSessionDescTable IN BISVIEWER.t_char,

6027: PROCEDURE GET_VALIDATED_DRILL_PARAMS (
6028: lAttributeCodeTable IN BISVIEWER.t_char,
6029: lDimensionTable IN BISVIEWER.t_char,
6030: lSessionValueTable IN BISVIEWER.t_char,
6031: lSessionDescTable IN BISVIEWER.t_char,
6032: lPeriodDateTable IN BISVIEWER.t_date,
6033: pParamRegionCode IN VARCHAR2,
6034: pParamFunctionName IN VARCHAR2,
6035: pParamRegionGroup IN parameter_group_tbl_type,

Line 6032: lPeriodDateTable IN BISVIEWER.t_date,

6028: lAttributeCodeTable IN BISVIEWER.t_char,
6029: lDimensionTable IN BISVIEWER.t_char,
6030: lSessionValueTable IN BISVIEWER.t_char,
6031: lSessionDescTable IN BISVIEWER.t_char,
6032: lPeriodDateTable IN BISVIEWER.t_date,
6033: pParamRegionCode IN VARCHAR2,
6034: pParamFunctionName IN VARCHAR2,
6035: pParamRegionGroup IN parameter_group_tbl_type,
6036: pPageId IN VARCHAR2,

Line 6038: xAttributeCodeTable OUT NOCOPY BISVIEWER.t_char,

6034: pParamFunctionName IN VARCHAR2,
6035: pParamRegionGroup IN parameter_group_tbl_type,
6036: pPageId IN VARCHAR2,
6037: pUserId IN VARCHAR2,
6038: xAttributeCodeTable OUT NOCOPY BISVIEWER.t_char,
6039: xDimensionTable OUT NOCOPY BISVIEWER.t_char,
6040: xSessionValueTable OUT NOCOPY BISVIEWER.t_char,
6041: xSessionDescTable OUT NOCOPY BISVIEWER.t_char,
6042: xPeriodDateTable OUT NOCOPY BISVIEWER.t_date,

Line 6039: xDimensionTable OUT NOCOPY BISVIEWER.t_char,

6035: pParamRegionGroup IN parameter_group_tbl_type,
6036: pPageId IN VARCHAR2,
6037: pUserId IN VARCHAR2,
6038: xAttributeCodeTable OUT NOCOPY BISVIEWER.t_char,
6039: xDimensionTable OUT NOCOPY BISVIEWER.t_char,
6040: xSessionValueTable OUT NOCOPY BISVIEWER.t_char,
6041: xSessionDescTable OUT NOCOPY BISVIEWER.t_char,
6042: xPeriodDateTable OUT NOCOPY BISVIEWER.t_date,
6043: x_DrillDefaultParameters OUT NOCOPY VARCHAR2

Line 6040: xSessionValueTable OUT NOCOPY BISVIEWER.t_char,

6036: pPageId IN VARCHAR2,
6037: pUserId IN VARCHAR2,
6038: xAttributeCodeTable OUT NOCOPY BISVIEWER.t_char,
6039: xDimensionTable OUT NOCOPY BISVIEWER.t_char,
6040: xSessionValueTable OUT NOCOPY BISVIEWER.t_char,
6041: xSessionDescTable OUT NOCOPY BISVIEWER.t_char,
6042: xPeriodDateTable OUT NOCOPY BISVIEWER.t_date,
6043: x_DrillDefaultParameters OUT NOCOPY VARCHAR2
6044: )

Line 6041: xSessionDescTable OUT NOCOPY BISVIEWER.t_char,

6037: pUserId IN VARCHAR2,
6038: xAttributeCodeTable OUT NOCOPY BISVIEWER.t_char,
6039: xDimensionTable OUT NOCOPY BISVIEWER.t_char,
6040: xSessionValueTable OUT NOCOPY BISVIEWER.t_char,
6041: xSessionDescTable OUT NOCOPY BISVIEWER.t_char,
6042: xPeriodDateTable OUT NOCOPY BISVIEWER.t_date,
6043: x_DrillDefaultParameters OUT NOCOPY VARCHAR2
6044: )
6045: IS

Line 6042: xPeriodDateTable OUT NOCOPY BISVIEWER.t_date,

6038: xAttributeCodeTable OUT NOCOPY BISVIEWER.t_char,
6039: xDimensionTable OUT NOCOPY BISVIEWER.t_char,
6040: xSessionValueTable OUT NOCOPY BISVIEWER.t_char,
6041: xSessionDescTable OUT NOCOPY BISVIEWER.t_char,
6042: xPeriodDateTable OUT NOCOPY BISVIEWER.t_date,
6043: x_DrillDefaultParameters OUT NOCOPY VARCHAR2
6044: )
6045: IS
6046:

Line 6064: lValidationAttrList BISVIEWER.t_char;

6060: SELECT a.attribute2, c.attribute26
6061: FROM ak_region_items a, bis_ak_region_item_extension c
6062: WHERE a.region_code=pParamRegionCode AND a.attribute_code=c.attribute_code(+) AND a.region_code=c.region_code(+);
6063:
6064: lValidationAttrList BISVIEWER.t_char;
6065: lValidationReqList BISVIEWER.t_char;
6066: l_validation_req VARCHAR2(30);
6067: l_parameter_rec PARAMETER_REC_TYPE;
6068: l_parameter_Rec_tbl parameter_tbl_type;

Line 6065: lValidationReqList BISVIEWER.t_char;

6061: FROM ak_region_items a, bis_ak_region_item_extension c
6062: WHERE a.region_code=pParamRegionCode AND a.attribute_code=c.attribute_code(+) AND a.region_code=c.region_code(+);
6063:
6064: lValidationAttrList BISVIEWER.t_char;
6065: lValidationReqList BISVIEWER.t_char;
6066: l_validation_req VARCHAR2(30);
6067: l_parameter_rec PARAMETER_REC_TYPE;
6068: l_parameter_Rec_tbl parameter_tbl_type;
6069: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;

Line 6284: vAttributeCodeTable BISVIEWER.t_char;

6280: FROM bis_user_attributes
6281: WHERE page_id = pFromPageId
6282: AND user_id = pUserId;
6283:
6284: vAttributeCodeTable BISVIEWER.t_char;
6285: vDimensionTable BISVIEWER.t_char;
6286: vSessionValueTable BISVIEWER.t_char;
6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;

Line 6285: vDimensionTable BISVIEWER.t_char;

6281: WHERE page_id = pFromPageId
6282: AND user_id = pUserId;
6283:
6284: vAttributeCodeTable BISVIEWER.t_char;
6285: vDimensionTable BISVIEWER.t_char;
6286: vSessionValueTable BISVIEWER.t_char;
6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;
6289:

Line 6286: vSessionValueTable BISVIEWER.t_char;

6282: AND user_id = pUserId;
6283:
6284: vAttributeCodeTable BISVIEWER.t_char;
6285: vDimensionTable BISVIEWER.t_char;
6286: vSessionValueTable BISVIEWER.t_char;
6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;
6289:
6290: lAttributeCodeTable BISVIEWER.t_char;

Line 6287: vSessionDescTable BISVIEWER.t_char;

6283:
6284: vAttributeCodeTable BISVIEWER.t_char;
6285: vDimensionTable BISVIEWER.t_char;
6286: vSessionValueTable BISVIEWER.t_char;
6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;
6289:
6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;

Line 6288: vPeriodDateTable BISVIEWER.t_date;

6284: vAttributeCodeTable BISVIEWER.t_char;
6285: vDimensionTable BISVIEWER.t_char;
6286: vSessionValueTable BISVIEWER.t_char;
6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;
6289:
6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;
6292: lSessionValueTable BISVIEWER.t_char;

Line 6290: lAttributeCodeTable BISVIEWER.t_char;

6286: vSessionValueTable BISVIEWER.t_char;
6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;
6289:
6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;
6292: lSessionValueTable BISVIEWER.t_char;
6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;

Line 6291: lDimensionTable BISVIEWER.t_char;

6287: vSessionDescTable BISVIEWER.t_char;
6288: vPeriodDateTable BISVIEWER.t_date;
6289:
6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;
6292: lSessionValueTable BISVIEWER.t_char;
6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;
6295:

Line 6292: lSessionValueTable BISVIEWER.t_char;

6288: vPeriodDateTable BISVIEWER.t_date;
6289:
6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;
6292: lSessionValueTable BISVIEWER.t_char;
6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;
6295:
6296: lAttrNameForInsert BISVIEWER.t_char;

Line 6293: lSessionDescTable BISVIEWER.t_char;

6289:
6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;
6292: lSessionValueTable BISVIEWER.t_char;
6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;
6295:
6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;

Line 6294: lPeriodDateTable BISVIEWER.t_date;

6290: lAttributeCodeTable BISVIEWER.t_char;
6291: lDimensionTable BISVIEWER.t_char;
6292: lSessionValueTable BISVIEWER.t_char;
6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;
6295:
6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;

Line 6296: lAttrNameForInsert BISVIEWER.t_char;

6292: lSessionValueTable BISVIEWER.t_char;
6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;
6295:
6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;
6299: lSessDescForInsert BISVIEWER.t_char;
6300: lPeriodDateForInsert BISVIEWER.t_date;

Line 6297: lDimensionForInsert BISVIEWER.t_char;

6293: lSessionDescTable BISVIEWER.t_char;
6294: lPeriodDateTable BISVIEWER.t_date;
6295:
6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;
6299: lSessDescForInsert BISVIEWER.t_char;
6300: lPeriodDateForInsert BISVIEWER.t_date;
6301: lAttrNameForDelete BISVIEWER.t_char;

Line 6298: lSessValueForInsert BISVIEWER.t_char;

6294: lPeriodDateTable BISVIEWER.t_date;
6295:
6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;
6299: lSessDescForInsert BISVIEWER.t_char;
6300: lPeriodDateForInsert BISVIEWER.t_date;
6301: lAttrNameForDelete BISVIEWER.t_char;
6302:

Line 6299: lSessDescForInsert BISVIEWER.t_char;

6295:
6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;
6299: lSessDescForInsert BISVIEWER.t_char;
6300: lPeriodDateForInsert BISVIEWER.t_date;
6301: lAttrNameForDelete BISVIEWER.t_char;
6302:
6303: lTCTExists boolean := false;

Line 6300: lPeriodDateForInsert BISVIEWER.t_date;

6296: lAttrNameForInsert BISVIEWER.t_char;
6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;
6299: lSessDescForInsert BISVIEWER.t_char;
6300: lPeriodDateForInsert BISVIEWER.t_date;
6301: lAttrNameForDelete BISVIEWER.t_char;
6302:
6303: lTCTExists boolean := false;
6304: lNestedRegionCode VARCHAR2(250);

Line 6301: lAttrNameForDelete BISVIEWER.t_char;

6297: lDimensionForInsert BISVIEWER.t_char;
6298: lSessValueForInsert BISVIEWER.t_char;
6299: lSessDescForInsert BISVIEWER.t_char;
6300: lPeriodDateForInsert BISVIEWER.t_date;
6301: lAttrNameForDelete BISVIEWER.t_char;
6302:
6303: lTCTExists boolean := false;
6304: lNestedRegionCode VARCHAR2(250);
6305: lAsofDateExists boolean;

Line 6420: l_bind_values BISVIEWER.t_char;

6416: ,x_msg_count OUT NOCOPY NUMBER
6417: ,x_msg_data OUT NOCOPY VARCHAR2
6418: ) is
6419:
6420: l_bind_values BISVIEWER.t_char;
6421:
6422: begin
6423:
6424: if (length(p_bind_variables) > 0) then

Line 6481: ,p_bind_values in BISVIEWER.t_char

6477: END executeLovBindSQL;
6478:
6479: procedure executeLovDynamicSQL
6480: (p_bind_sql in varchar2
6481: ,p_bind_values in BISVIEWER.t_char
6482: ,p_time_flag in varchar2
6483: ,x_parameter_id out NOCOPY varchar2
6484: ,x_parameter_value out NOCOPY varchar2
6485: ,x_start_date out NOCOPY date

Line 6566: vAttributeCodeTable BISVIEWER.t_char;

6562: AND session_id = pSessionId
6563: AND user_id = pUserId
6564: AND schedule_id IS NULL;
6565:
6566: vAttributeCodeTable BISVIEWER.t_char;
6567: vDimensionTable BISVIEWER.t_char;
6568: vSessionValueTable BISVIEWER.t_char;
6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;

Line 6567: vDimensionTable BISVIEWER.t_char;

6563: AND user_id = pUserId
6564: AND schedule_id IS NULL;
6565:
6566: vAttributeCodeTable BISVIEWER.t_char;
6567: vDimensionTable BISVIEWER.t_char;
6568: vSessionValueTable BISVIEWER.t_char;
6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;
6571:

Line 6568: vSessionValueTable BISVIEWER.t_char;

6564: AND schedule_id IS NULL;
6565:
6566: vAttributeCodeTable BISVIEWER.t_char;
6567: vDimensionTable BISVIEWER.t_char;
6568: vSessionValueTable BISVIEWER.t_char;
6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;
6571:
6572: lAttributeCodeTable BISVIEWER.t_char;

Line 6569: vSessionDescTable BISVIEWER.t_char;

6565:
6566: vAttributeCodeTable BISVIEWER.t_char;
6567: vDimensionTable BISVIEWER.t_char;
6568: vSessionValueTable BISVIEWER.t_char;
6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;
6571:
6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;

Line 6570: vPeriodDateTable BISVIEWER.t_date;

6566: vAttributeCodeTable BISVIEWER.t_char;
6567: vDimensionTable BISVIEWER.t_char;
6568: vSessionValueTable BISVIEWER.t_char;
6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;
6571:
6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;
6574: lSessionValueTable BISVIEWER.t_char;

Line 6572: lAttributeCodeTable BISVIEWER.t_char;

6568: vSessionValueTable BISVIEWER.t_char;
6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;
6571:
6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;
6574: lSessionValueTable BISVIEWER.t_char;
6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;

Line 6573: lDimensionTable BISVIEWER.t_char;

6569: vSessionDescTable BISVIEWER.t_char;
6570: vPeriodDateTable BISVIEWER.t_date;
6571:
6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;
6574: lSessionValueTable BISVIEWER.t_char;
6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;
6577:

Line 6574: lSessionValueTable BISVIEWER.t_char;

6570: vPeriodDateTable BISVIEWER.t_date;
6571:
6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;
6574: lSessionValueTable BISVIEWER.t_char;
6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;
6577:
6578: lAttrNameForInsert BISVIEWER.t_char;

Line 6575: lSessionDescTable BISVIEWER.t_char;

6571:
6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;
6574: lSessionValueTable BISVIEWER.t_char;
6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;
6577:
6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;

Line 6576: lPeriodDateTable BISVIEWER.t_date;

6572: lAttributeCodeTable BISVIEWER.t_char;
6573: lDimensionTable BISVIEWER.t_char;
6574: lSessionValueTable BISVIEWER.t_char;
6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;
6577:
6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;

Line 6578: lAttrNameForInsert BISVIEWER.t_char;

6574: lSessionValueTable BISVIEWER.t_char;
6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;
6577:
6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;
6581: lSessDescForInsert BISVIEWER.t_char;
6582: lPeriodDateForInsert BISVIEWER.t_date;

Line 6579: lDimensionForInsert BISVIEWER.t_char;

6575: lSessionDescTable BISVIEWER.t_char;
6576: lPeriodDateTable BISVIEWER.t_date;
6577:
6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;
6581: lSessDescForInsert BISVIEWER.t_char;
6582: lPeriodDateForInsert BISVIEWER.t_date;
6583: lAttrNameForDelete BISVIEWER.t_char;

Line 6580: lSessValueForInsert BISVIEWER.t_char;

6576: lPeriodDateTable BISVIEWER.t_date;
6577:
6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;
6581: lSessDescForInsert BISVIEWER.t_char;
6582: lPeriodDateForInsert BISVIEWER.t_date;
6583: lAttrNameForDelete BISVIEWER.t_char;
6584:

Line 6581: lSessDescForInsert BISVIEWER.t_char;

6577:
6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;
6581: lSessDescForInsert BISVIEWER.t_char;
6582: lPeriodDateForInsert BISVIEWER.t_date;
6583: lAttrNameForDelete BISVIEWER.t_char;
6584:
6585: lTCTExists boolean := false;

Line 6582: lPeriodDateForInsert BISVIEWER.t_date;

6578: lAttrNameForInsert BISVIEWER.t_char;
6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;
6581: lSessDescForInsert BISVIEWER.t_char;
6582: lPeriodDateForInsert BISVIEWER.t_date;
6583: lAttrNameForDelete BISVIEWER.t_char;
6584:
6585: lTCTExists boolean := false;
6586: lNestedRegionCode VARCHAR2(250);

Line 6583: lAttrNameForDelete BISVIEWER.t_char;

6579: lDimensionForInsert BISVIEWER.t_char;
6580: lSessValueForInsert BISVIEWER.t_char;
6581: lSessDescForInsert BISVIEWER.t_char;
6582: lPeriodDateForInsert BISVIEWER.t_date;
6583: lAttrNameForDelete BISVIEWER.t_char;
6584:
6585: lTCTExists boolean := false;
6586: lNestedRegionCode VARCHAR2(250);
6587: lAsofDateExists boolean;

Line 6986: vAttributeCodeTable BISVIEWER.t_char;

6982: AND session_id = pSessionId
6983: AND user_id = pUserId
6984: AND (attribute_name ='AS_OF_DATE' OR dimension ='TIME');
6985:
6986: vAttributeCodeTable BISVIEWER.t_char;
6987: vDimensionTable BISVIEWER.t_char;
6988: vSessionValueTable BISVIEWER.t_char;
6989: vSessionDescTable BISVIEWER.t_char;
6990: vPeriodDateTable BISVIEWER.t_date;

Line 6987: vDimensionTable BISVIEWER.t_char;

6983: AND user_id = pUserId
6984: AND (attribute_name ='AS_OF_DATE' OR dimension ='TIME');
6985:
6986: vAttributeCodeTable BISVIEWER.t_char;
6987: vDimensionTable BISVIEWER.t_char;
6988: vSessionValueTable BISVIEWER.t_char;
6989: vSessionDescTable BISVIEWER.t_char;
6990: vPeriodDateTable BISVIEWER.t_date;
6991:

Line 6988: vSessionValueTable BISVIEWER.t_char;

6984: AND (attribute_name ='AS_OF_DATE' OR dimension ='TIME');
6985:
6986: vAttributeCodeTable BISVIEWER.t_char;
6987: vDimensionTable BISVIEWER.t_char;
6988: vSessionValueTable BISVIEWER.t_char;
6989: vSessionDescTable BISVIEWER.t_char;
6990: vPeriodDateTable BISVIEWER.t_date;
6991:
6992: l_time_attr_2 varchar2(2000);

Line 6989: vSessionDescTable BISVIEWER.t_char;

6985:
6986: vAttributeCodeTable BISVIEWER.t_char;
6987: vDimensionTable BISVIEWER.t_char;
6988: vSessionValueTable BISVIEWER.t_char;
6989: vSessionDescTable BISVIEWER.t_char;
6990: vPeriodDateTable BISVIEWER.t_date;
6991:
6992: l_time_attr_2 varchar2(2000);
6993: l_time_level_id VARCHAR2(2000);

Line 6990: vPeriodDateTable BISVIEWER.t_date;

6986: vAttributeCodeTable BISVIEWER.t_char;
6987: vDimensionTable BISVIEWER.t_char;
6988: vSessionValueTable BISVIEWER.t_char;
6989: vSessionDescTable BISVIEWER.t_char;
6990: vPeriodDateTable BISVIEWER.t_date;
6991:
6992: l_time_attr_2 varchar2(2000);
6993: l_time_level_id VARCHAR2(2000);
6994: l_time_level_value VARCHAR2(2000);