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 BIS_USER_ATTRIBUTES

Line 635: DELETE FROM bis_user_attributes

631: -- FIX FOR P1 2797318 : kiprabha
632: -- DELETE ONLY IF SCHEDULE_ID IS NULL
633: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
634: FORALL i IN pAttributeNameTbl.FIRST..pAttributeNameTbl.LAST
635: DELETE FROM bis_user_attributes
636: WHERE function_name=pFunctionName
637: AND session_id = pSessionId
638: AND user_id = pUserId
639: AND attribute_name = pAttributeNameTbl(i)

Line 658: insert into bis_user_attributes (USER_ID,

654: ) IS
655: BEGIN
656: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
657: FORALL i IN pAttributeNameTbl.FIRST..pAttributeNameTbl.LAST
658: insert into bis_user_attributes (USER_ID,
659: FUNCTION_NAME,
660: SESSION_ID,
661: SESSION_VALUE,
662: SESSION_DESCRIPTION,

Line 689: DELETE FROM bis_user_attributes

685: BEGIN
686: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
687:
688: FORALL i IN pAttributeNameTbl.FIRST..pAttributeNameTbl.LAST
689: DELETE FROM bis_user_attributes
690: WHERE page_id = pPageId
691: AND user_id = pUserId
692: AND function_name = pFunctionName
693: AND attribute_name = pAttributeNameTbl(i);

Line 1052: FROM bis_user_attributes

1048: ) IS
1049:
1050: CURSOR getScheduleParameters IS
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;

Line 1099: FROM bis_user_attributes

1095: ) IS
1096:
1097: CURSOR getPreFunctionParameters IS
1098: SELECT attribute_name, dimension, session_value, session_description, period_date
1099: FROM bis_user_attributes
1100: WHERE function_name =pPreFunctionName
1101: AND session_id = pSessionId
1102: AND user_id = pUserId;
1103:

Line 1189: FROM bis_user_attributes

1185: ) IS
1186:
1187: CURSOR getPageParameters IS
1188: SELECT attribute_name, dimension, session_value, session_description, period_date
1189: FROM bis_user_attributes
1190: WHERE page_id =pPageId
1191: AND user_id = pUserId;
1192:
1193: vAttributeCodeTable BISVIEWER.t_char;

Line 1233: FROM bis_user_attributes

1229: ) IS
1230:
1231: CURSOR getSavedDefaultParameters IS
1232: SELECT attribute_name, dimension, default_value, default_description, period_date
1233: FROM bis_user_attributes
1234: WHERE function_name = pFunctionName
1235: AND user_id = pUserId
1236: AND session_id IS NULL
1237: AND session_description = 'NULL';

Line 1412: FROM bis_user_attributes

1408: ELSIF (l_attr_code(i)='VIEW_BY') THEN
1409:
1410: BEGIN
1411: SELECT attribute_name INTO l_view_by
1412: FROM bis_user_attributes
1413: WHERE function_name=pFunctionName
1414: AND session_id=pSessionId
1415: AND user_id = pUserId
1416: AND attribute_name ='VIEW_BY';

Line 1512: --for each of the names, find if it a parameter and if it already present in bis_user_attributes

1508: lDefaultParameters := l_param_value(l_param_value.FIRST);
1509: END IF;
1510:
1511:
1512: --for each of the names, find if it a parameter and if it already present in bis_user_attributes
1513: IF (lDefaultParameters IS NOT NULL) THEN
1514:
1515: -- replace the ~, ^ and the @
1516: lDefaultParameters := replace (lDefaultParameters, '~', '&');

Line 1757: INSERT INTO BIS_USER_ATTRIBUTES (USER_ID,

1753: ) IS
1754:
1755: BEGIN
1756:
1757: INSERT INTO BIS_USER_ATTRIBUTES (USER_ID,
1758: FUNCTION_NAME,
1759: SESSION_ID,
1760: SESSION_VALUE,
1761: SESSION_DESCRIPTION,

Line 1775: FROM BIS_USER_ATTRIBUTES

1771: ATTRIBUTE_NAME,
1772: DIMENSION,
1773: PERIOD_DATE,
1774: OPERATOR
1775: FROM BIS_USER_ATTRIBUTES
1776: WHERE function_name = pFunctionName
1777: AND user_id = pUserId
1778: AND session_id IS NULL
1779: AND session_description = 'NULL'

Line 1782: FROM bis_user_attributes

1778: AND session_id IS NULL
1779: AND session_description = 'NULL'
1780: AND nvl(substr(attribute_name,1,instr(attribute_name,'+')-1), attribute_name) NOT IN (
1781: SELECT nvl(substr(attribute_name,1,instr(attribute_name,'+')-1), attribute_name)
1782: FROM bis_user_attributes
1783: WHERE function_name=pFunctionName
1784: AND user_id=pUserId
1785: AND session_id= pSessionId
1786: AND schedule_id IS NULL

Line 1801: DELETE BIS_USER_ATTRIBUTES

1797: ,x_msg_data OUT NOCOPY VARCHAR2
1798: ) IS
1799: BEGIN
1800:
1801: DELETE BIS_USER_ATTRIBUTES
1802: WHERE session_id is null and
1803: function_name = pFunctionName
1804: AND user_id= pUserId;
1805: --BugFix 3464708

Line 1806: INSERT INTO BIS_USER_ATTRIBUTES (USER_ID,

1802: WHERE session_id is null and
1803: function_name = pFunctionName
1804: AND user_id= pUserId;
1805: --BugFix 3464708
1806: INSERT INTO BIS_USER_ATTRIBUTES (USER_ID,
1807: FUNCTION_NAME,
1808: ATTRIBUTE_NAME,
1809: SESSION_DESCRIPTION,
1810: DEFAULT_VALUE,

Line 1824: FROM BIS_USER_ATTRIBUTES

1820: SESSION_DESCRIPTION,
1821: PERIOD_DATE,
1822: DIMENSION,
1823: OPERATOR
1824: FROM BIS_USER_ATTRIBUTES
1825: WHERE session_id = pSessionId
1826: AND function_name = pFunctionName
1827: AND user_id = pUserId
1828: AND schedule_id IS NULL;

Line 2507: INSERT INTO BIS_USER_ATTRIBUTES (user_id, function_name,

2503: end if;
2504:
2505: IF p_parameter_rec.default_flag = 'Y' THEN
2506:
2507: INSERT INTO BIS_USER_ATTRIBUTES (user_id, function_name,
2508: attribute_name, session_description,
2509: default_value, default_description,
2510: period_date, dimension, operator,
2511: creation_date, created_by,

Line 2521: INSERT INTO BIS_USER_ATTRIBUTES (user_id, function_name,

2517: p_parameter_rec.operator,
2518: sysdate, -1, sysdate, -1);
2519: ELSE
2520: IF p_user_session_rec.page_id IS NULL OR p_user_session_rec.page_id = '' THEN
2521: INSERT INTO BIS_USER_ATTRIBUTES (user_id, function_name,
2522: session_id, attribute_name,
2523: session_value, session_description,
2524: period_date, dimension, operator,
2525: creation_date, created_by,

Line 2535: INSERT INTO BIS_USER_ATTRIBUTES (user_id, page_id, attribute_name, function_name, session_id,

2531: p_parameter_rec.operator,
2532: sysdate, -1, sysdate, -1);
2533: ELSE
2534:
2535: INSERT INTO BIS_USER_ATTRIBUTES (user_id, page_id, attribute_name, function_name, session_id,
2536: session_value, session_description,
2537: period_date, dimension, operator,
2538: creation_date, created_by,
2539: last_update_Date, last_updated_by)

Line 2580: FROM BIS_USER_ATTRIBUTES

2576: p_parameter_rec.parameter_value,
2577: p_parameter_rec.period_date,
2578: p_parameter_rec.dimension,
2579: p_parameter_rec.operator
2580: FROM BIS_USER_ATTRIBUTES
2581: WHERE attribute_name = p_parameter_rec.parameter_name
2582: AND function_name = p_user_session_rec.function_name
2583: AND user_id = p_user_session_rec.user_id
2584: AND session_description = 'NULL'

Line 2597: FROM BIS_USER_ATTRIBUTES

2593: p_parameter_rec.parameter_value,
2594: p_parameter_rec.period_date,
2595: p_parameter_rec.dimension,
2596: p_parameter_rec.operator
2597: FROM BIS_USER_ATTRIBUTES
2598: WHERE attribute_name = p_parameter_rec.parameter_name
2599: AND function_name = p_user_session_rec.function_name
2600: AND user_id = p_user_session_rec.user_id
2601: AND session_id = p_user_session_rec.session_id

Line 2648: FROM BIS_USER_ATTRIBUTES

2644: p_parameter_rec.parameter_value,
2645: p_parameter_rec.period_date,
2646: p_parameter_rec.dimension,
2647: p_parameter_rec.operator
2648: FROM BIS_USER_ATTRIBUTES
2649: WHERE attribute_name = p_parameter_rec.parameter_name
2650: AND user_id = p_user_session_rec.user_id
2651: AND page_id = p_user_session_rec.page_id;
2652: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2665: FROM BIS_USER_ATTRIBUTES

2661: p_parameter_rec.parameter_value,
2662: p_parameter_rec.period_date,
2663: p_parameter_rec.dimension,
2664: p_parameter_rec.operator
2665: FROM BIS_USER_ATTRIBUTES
2666: WHERE attribute_name = p_parameter_rec.parameter_name
2667: AND schedule_id = p_schedule_id
2668: AND attribute_name not in (l_page_dims(1), l_page_dims(2), l_page_dims(3), l_page_dims(4),
2669: l_page_dims(5), l_page_dims(6), l_page_dims(7), l_page_dims(8), l_page_dims(9),

Line 2684: FROM BIS_USER_ATTRIBUTES

2680: p_parameter_rec.parameter_value,
2681: p_parameter_rec.period_date,
2682: p_parameter_rec.dimension,
2683: p_parameter_rec.operator
2684: FROM BIS_USER_ATTRIBUTES
2685: WHERE attribute_name = p_parameter_rec.parameter_name
2686: AND schedule_id = p_schedule_id;
2687: end if;
2688: else

Line 2700: FROM BIS_USER_ATTRIBUTES

2696: p_parameter_rec.parameter_value,
2697: p_parameter_rec.period_date,
2698: p_parameter_rec.dimension,
2699: p_parameter_rec.operator
2700: FROM BIS_USER_ATTRIBUTES
2701: WHERE attribute_name = p_parameter_rec.parameter_name
2702: AND user_id = p_user_session_Rec.user_id
2703: AND session_id = p_user_session_Rec.session_id
2704: AND function_name = p_user_session_rec.function_name

Line 2720: FROM BIS_USER_ATTRIBUTES

2716: p_parameter_rec.parameter_value,
2717: p_parameter_rec.period_date,
2718: p_parameter_rec.dimension,
2719: p_parameter_rec.operator
2720: FROM BIS_USER_ATTRIBUTES
2721: WHERE attribute_name = p_parameter_rec.parameter_name
2722: AND user_id = p_user_session_Rec.user_id
2723: AND session_id = p_user_session_Rec.session_id
2724: AND function_name = p_user_session_rec.function_name;

Line 2774: FROM BIS_USER_ATTRIBUTES

2770: p_parameter_rec.parameter_value,
2771: p_parameter_rec.period_date,
2772: p_parameter_rec.dimension,
2773: p_parameter_rec.operator
2774: FROM BIS_USER_ATTRIBUTES
2775: WHERE attribute_name = p_parameter_rec.parameter_name
2776: AND user_id = p_user_session_Rec.user_id
2777: AND session_id = p_user_session_Rec.session_id
2778: AND function_name = p_user_session_rec.function_name;

Line 2791: FROM BIS_USER_ATTRIBUTES

2787: p_parameter_rec.parameter_value,
2788: p_parameter_rec.period_date,
2789: p_parameter_rec.dimension,
2790: p_parameter_rec.operator
2791: FROM BIS_USER_ATTRIBUTES
2792: WHERE attribute_name = p_parameter_rec.parameter_name
2793: AND user_id = p_user_session_rec.user_id
2794: AND page_id = p_user_session_rec.page_id
2795: AND attribute_name not in (l_user_dims(1), l_user_dims(2), l_user_dims(3), l_user_dims(4),

Line 2810: FROM BIS_USER_ATTRIBUTES

2806: p_parameter_rec.parameter_value,
2807: p_parameter_rec.period_date,
2808: p_parameter_rec.dimension,
2809: p_parameter_rec.operator
2810: FROM BIS_USER_ATTRIBUTES
2811: WHERE attribute_name = p_parameter_rec.parameter_name
2812: AND user_id = p_user_session_rec.user_id
2813: AND page_id = p_user_session_rec.page_id;
2814: end if;

Line 2846: FROM BIS_USER_ATTRIBUTES

2842: p_parameter_rec.parameter_value,
2843: p_parameter_rec.period_date,
2844: p_parameter_rec.dimension,
2845: p_parameter_rec.operator
2846: FROM BIS_USER_ATTRIBUTES
2847: WHERE attribute_name = p_parameter_rec.parameter_name
2848: AND schedule_id = p_schedule_id;
2849: EXCEPTION
2850: WHEN FND_API.G_EXC_ERROR THEN

Line 2871: DELETE FROM BIS_USER_ATTRIBUTES

2867: ,x_msg_data OUT NOCOPY VARCHAR2
2868: ) IS
2869: BEGIN
2870: IF p_schedule_option = 'NULL' THEN
2871: DELETE FROM BIS_USER_ATTRIBUTES
2872: WHERE user_id = p_user_session_rec.user_id
2873: AND session_id = p_user_session_rec.session_id
2874: AND function_name = p_user_session_rec.function_name
2875: AND attribute_name = p_parameter_name

Line 2878: DELETE FROM BIS_USER_ATTRIBUTES

2874: AND function_name = p_user_session_rec.function_name
2875: AND attribute_name = p_parameter_name
2876: AND schedule_id IS NULL;
2877: ELSIF p_schedule_option = 'NOT_NULL' THEN
2878: DELETE FROM BIS_USER_ATTRIBUTES
2879: WHERE user_id = p_user_session_rec.user_id
2880: AND session_id = p_user_session_rec.session_id
2881: AND function_name = p_user_session_rec.function_name
2882: AND attribute_name = p_parameter_name

Line 2885: DELETE FROM BIS_USER_ATTRIBUTES

2881: AND function_name = p_user_session_rec.function_name
2882: AND attribute_name = p_parameter_name
2883: AND schedule_id IS NOT NULL;
2884: ELSE
2885: DELETE FROM BIS_USER_ATTRIBUTES
2886: WHERE user_id = p_user_session_rec.user_id
2887: AND session_id = p_user_session_rec.session_id
2888: AND function_name = p_user_session_rec.function_name
2889: AND attribute_name = p_parameter_name;

Line 2915: DELETE FROM BIS_USER_ATTRIBUTES

2911: ,x_msg_count OUT NOCOPY NUMBER
2912: ,x_msg_data OUT NOCOPY VARCHAR2
2913: ) IS
2914: BEGIN
2915: DELETE FROM BIS_USER_ATTRIBUTES
2916: WHERE attribute_name = p_parameter_name
2917: AND schedule_id = p_schedule_id;
2918: COMMIT;
2919: EXCEPTION

Line 3040: FROM BIS_USER_ATTRIBUTES

3036: session_value,
3037: period_date,
3038: dimension,
3039: operator
3040: FROM BIS_USER_ATTRIBUTES
3041: WHERE user_id = p_user_session_rec.user_id
3042: AND page_id = p_user_session_rec.page_id;
3043:
3044: CURSOR c_sched_portlet_params_cursor IS

Line 3051: FROM BIS_USER_ATTRIBUTES

3047: session_value,
3048: period_date,
3049: dimension,
3050: operator
3051: FROM BIS_USER_ATTRIBUTES
3052: WHERE schedule_id = p_schedule_id
3053: AND ((dimension IS NULL AND attribute_name not in (SELECT nvl(attribute_name,'-11')
3054: FROM BIS_USER_ATTRIBUTES
3055: WHERE page_id=p_user_session_rec.page_id

Line 3054: FROM BIS_USER_ATTRIBUTES

3050: operator
3051: FROM BIS_USER_ATTRIBUTES
3052: WHERE schedule_id = p_schedule_id
3053: AND ((dimension IS NULL AND attribute_name not in (SELECT nvl(attribute_name,'-11')
3054: FROM BIS_USER_ATTRIBUTES
3055: WHERE page_id=p_user_session_rec.page_id
3056: AND user_id=p_user_session_rec.user_id))
3057: OR (dimension IS NOT NULL AND dimension not in (SELECT nvl(dimension,'-11')
3058: FROM BIS_USER_ATTRIBUTES

Line 3058: FROM BIS_USER_ATTRIBUTES

3054: FROM BIS_USER_ATTRIBUTES
3055: WHERE page_id=p_user_session_rec.page_id
3056: AND user_id=p_user_session_rec.user_id))
3057: OR (dimension IS NOT NULL AND dimension not in (SELECT nvl(dimension,'-11')
3058: FROM BIS_USER_ATTRIBUTES
3059: WHERE page_id=p_user_session_rec.page_id
3060: AND user_id=p_user_session_rec.user_id)));
3061:
3062: CURSOR c_sess_portlet_params_cursor IS

Line 3069: FROM BIS_USER_ATTRIBUTES

3065: session_value,
3066: period_date,
3067: dimension,
3068: operator
3069: FROM BIS_USER_ATTRIBUTES
3070: WHERE user_id = p_user_session_rec.user_id
3071: AND session_id = p_user_session_rec.session_id
3072: AND function_name = p_user_session_rec.function_name
3073: AND ((dimension IS NULL AND attribute_name not in (SELECT nvl(attribute_name,'-11')

Line 3074: FROM BIS_USER_ATTRIBUTES

3070: WHERE user_id = p_user_session_rec.user_id
3071: AND session_id = p_user_session_rec.session_id
3072: AND function_name = p_user_session_rec.function_name
3073: AND ((dimension IS NULL AND attribute_name not in (SELECT nvl(attribute_name,'-11')
3074: FROM BIS_USER_ATTRIBUTES
3075: WHERE page_id=p_user_session_rec.page_id
3076: AND user_id=p_user_session_rec.user_id))
3077: OR (dimension IS NOT NULL AND dimension not in (SELECT nvl(dimension, '-11')
3078: FROM BIS_USER_ATTRIBUTES

Line 3078: FROM BIS_USER_ATTRIBUTES

3074: FROM BIS_USER_ATTRIBUTES
3075: WHERE page_id=p_user_session_rec.page_id
3076: AND user_id=p_user_session_rec.user_id))
3077: OR (dimension IS NOT NULL AND dimension not in (SELECT nvl(dimension, '-11')
3078: FROM BIS_USER_ATTRIBUTES
3079: WHERE page_id=p_user_session_rec.page_id
3080: AND user_id=p_user_session_rec.user_id)));
3081:
3082: BEGIN

Line 3151: FROM BIS_USER_ATTRIBUTES

3147: session_value,
3148: period_date,
3149: dimension,
3150: operator
3151: FROM BIS_USER_ATTRIBUTES
3152: WHERE user_id = p_user_session_rec.user_id
3153: AND session_id = p_user_session_rec.session_id
3154: AND function_name = p_user_session_rec.function_name;
3155:

Line 3163: FROM BIS_USER_ATTRIBUTES

3159: session_value,
3160: period_date,
3161: dimension,
3162: operator
3163: FROM BIS_USER_ATTRIBUTES
3164: WHERE user_id = p_user_session_rec.user_id
3165: AND page_id = p_user_session_rec.page_id
3166: AND ((dimension IS NULL AND attribute_name not in (SELECT nvl(attribute_name, '-11')
3167: FROM BIS_USER_ATTRIBUTES

Line 3167: FROM BIS_USER_ATTRIBUTES

3163: FROM BIS_USER_ATTRIBUTES
3164: WHERE user_id = p_user_session_rec.user_id
3165: AND page_id = p_user_session_rec.page_id
3166: AND ((dimension IS NULL AND attribute_name not in (SELECT nvl(attribute_name, '-11')
3167: FROM BIS_USER_ATTRIBUTES
3168: WHERE user_id = p_user_session_rec.user_id
3169: AND session_id = p_user_session_rec.session_id
3170: AND function_name = p_user_session_rec.function_name))
3171: OR (dimension IS NOT NULL AND dimension not in (SELECT nvl(dimension,'-11')

Line 3172: FROM BIS_USER_ATTRIBUTES

3168: WHERE user_id = p_user_session_rec.user_id
3169: AND session_id = p_user_session_rec.session_id
3170: AND function_name = p_user_session_rec.function_name))
3171: OR (dimension IS NOT NULL AND dimension not in (SELECT nvl(dimension,'-11')
3172: FROM BIS_USER_ATTRIBUTES
3173: WHERE user_id = p_user_session_rec.user_id
3174: AND session_id = p_user_session_rec.session_id
3175: AND function_name = p_user_session_rec.function_name)));
3176:

Line 3313: FROM BIS_USER_ATTRIBUTES

3309: l_parameter_rec.parameter_value,
3310: l_parameter_rec.period_date,
3311: l_parameter_rec.dimension,
3312: l_parameter_rec.operator
3313: FROM BIS_USER_ATTRIBUTES
3314: WHERE dimension = l_dimension
3315: AND user_id = p_user_session_rec.user_id
3316: AND page_id = p_user_session_rec.page_id;
3317: END;

Line 3345: FROM BIS_USER_ATTRIBUTES

3341: l_index NUMBER := 1;
3342: l_parameter_rec parameter_rec_type;
3343: CURSOR c_parameter_cursor IS
3344: SELECT attribute_name
3345: FROM BIS_USER_ATTRIBUTES
3346: WHERE schedule_id = p_schedule_id;
3347: BEGIN
3348: FOR c_parameter_rec in c_parameter_cursor LOOP
3349: l_parameter_rec.parameter_name := c_parameter_rec.attribute_name;

Line 3370: FROM BIS_USER_ATTRIBUTES

3366: session_value,
3367: period_date,
3368: dimension,
3369: operator
3370: FROM BIS_USER_ATTRIBUTES
3371: WHERE schedule_id = p_schedule_id;
3372:
3373: BEGIN
3374:

Line 3411: FROM BIS_USER_ATTRIBUTES

3407: l_index NUMBER := 1;
3408: l_parameter_rec parameter_rec_type;
3409: CURSOR c_parameter_cursor IS
3410: SELECT attribute_name
3411: FROM BIS_USER_ATTRIBUTES
3412: WHERE user_id = p_user_session_rec.user_id
3413: AND session_id = p_user_session_rec.session_id
3414: AND function_name = p_user_session_rec.function_name;
3415: BEGIN

Line 3439: FROM BIS_USER_ATTRIBUTES

3435: session_value,
3436: period_date,
3437: dimension,
3438: operator
3439: FROM BIS_USER_ATTRIBUTES
3440: WHERE function_name = p_user_session_rec.function_name
3441: AND user_id = p_user_session_rec.user_id
3442: AND session_id = p_user_session_rec.session_id
3443: AND schedule_id IS NULL;

Line 3483: FROM BIS_USER_ATTRIBUTES

3479: l_index NUMBER := 1;
3480: l_parameter_rec parameter_rec_type;
3481: CURSOR c_parameter_cursor IS
3482: SELECT attribute_name
3483: FROM BIS_USER_ATTRIBUTES
3484: WHERE user_id = p_user_session_rec.user_id
3485: AND session_id = p_user_session_rec.session_id
3486: AND function_name = p_user_session_rec.function_name;
3487: BEGIN

Line 3511: FROM BIS_USER_ATTRIBUTES

3507: default_value,
3508: period_date,
3509: dimension,
3510: operator
3511: FROM BIS_USER_ATTRIBUTES
3512: WHERE function_name = p_user_session_rec.function_name
3513: AND user_id = p_user_session_rec.user_id
3514: AND session_description = 'NULL'
3515: AND session_id IS NULL;

Line 3551: DELETE FROM BIS_USER_ATTRIBUTES

3547: ,x_msg_data OUT NOCOPY VARCHAR2
3548: ) IS
3549: BEGIN
3550: IF p_schedule_option = 'NULL' THEN
3551: DELETE FROM BIS_USER_ATTRIBUTES
3552: WHERE user_id = p_user_session_rec.user_id
3553: AND session_id = p_user_session_rec.session_id
3554: AND function_name = p_user_session_rec.function_name
3555: AND schedule_id IS NULL;

Line 3557: DELETE FROM BIS_USER_ATTRIBUTES

3553: AND session_id = p_user_session_rec.session_id
3554: AND function_name = p_user_session_rec.function_name
3555: AND schedule_id IS NULL;
3556: ELSIF p_schedule_option = 'NOT_NULL' THEN
3557: DELETE FROM BIS_USER_ATTRIBUTES
3558: WHERE user_id = p_user_session_rec.user_id
3559: AND session_id = p_user_session_rec.session_id
3560: AND function_name = p_user_session_rec.function_name
3561: AND schedule_id IS NOT NULL;

Line 3563: DELETE FROM BIS_USER_ATTRIBUTES

3559: AND session_id = p_user_session_rec.session_id
3560: AND function_name = p_user_session_rec.function_name
3561: AND schedule_id IS NOT NULL;
3562: ELSE
3563: DELETE FROM BIS_USER_ATTRIBUTES
3564: WHERE user_id = p_user_session_rec.user_id
3565: AND session_id = p_user_session_rec.session_id
3566: AND function_name = p_user_session_rec.function_name;
3567: END IF;

Line 3589: DELETE BIS_USER_ATTRIBUTES

3585: ,x_msg_data OUT NOCOPY VARCHAR2
3586: )
3587: IS
3588: BEGIN
3589: DELETE BIS_USER_ATTRIBUTES
3590: WHERE user_id = p_user_session_rec.user_id
3591: AND page_id = p_user_session_rec.page_id;
3592: COMMIT;
3593: EXCEPTION

Line 3614: DELETE BIS_USER_ATTRIBUTES

3610: ,x_msg_data OUT NOCOPY VARCHAR2
3611: )
3612: IS
3613: BEGIN
3614: DELETE BIS_USER_ATTRIBUTES
3615: WHERE session_id is null and
3616: function_name = p_user_session_rec.function_name
3617: AND user_id=p_user_session_rec.user_id;
3618: COMMIT;

Line 3639: DELETE FROM BIS_USER_ATTRIBUTES

3635: ,x_msg_count OUT NOCOPY NUMBER
3636: ,x_msg_data OUT NOCOPY VARCHAR2
3637: ) IS
3638: BEGIN
3639: DELETE FROM BIS_USER_ATTRIBUTES
3640: WHERE schedule_id = p_schedule_id;
3641: COMMIT;
3642: EXCEPTION
3643: WHEN FND_API.G_EXC_ERROR THEN

Line 5703: select session_value from bis_user_attributes

5699: p_function_name in varchar2,
5700: x_graph_file_id out NOCOPY varchar2)
5701: IS
5702: cursor cGraphFileId is
5703: select session_value from bis_user_attributes
5704: where user_id = p_user_id
5705: and schedule_id = p_schedule_id
5706: and attribute_name = p_attribute_name
5707: and function_name = p_function_name;

Line 5741: insert into bis_user_attributes

5737: p_function_name in varchar2,
5738: p_graph_file_id in varchar2)
5739: IS
5740: BEGIN
5741: insert into bis_user_attributes
5742: (user_id, function_name, attribute_name, session_value,
5743: schedule_id,creation_date, created_by,
5744: last_update_Date, last_updated_by)
5745: VALUES

Line 5760: select session_value from bis_user_attributes

5756: p_function_name in varchar2,
5757: x_context_values out NOCOPY varchar2)
5758: IS
5759: cursor cContextValues is
5760: select session_value from bis_user_attributes
5761: where user_id = p_user_id
5762: and schedule_id = p_schedule_id
5763: and attribute_name = p_attribute_name
5764: and function_name = p_function_name;

Line 5798: insert into bis_user_attributes

5794: p_function_name in varchar2,
5795: p_context_values in varchar2)
5796: IS
5797: BEGIN
5798: insert into bis_user_attributes
5799: (user_id, function_name, attribute_name, session_value,
5800: schedule_id,creation_date, created_by,
5801: last_update_Date, last_updated_by)
5802: VALUES

Line 5923: insert into bis_user_attributes (

5919: ) IS
5920: BEGIN
5921: IF pAttributeNameTbl IS NOT NULL AND pAttributeNameTbl.COUNT >0 THEN
5922: FORALL i IN pAttributeNameTbl.FIRST..pAttributeNameTbl.LAST
5923: insert into bis_user_attributes (
5924: SESSION_ID,
5925: USER_ID,
5926: FUNCTION_NAME,
5927: PAGE_ID,

Line 6054: FROM bis_user_attributes

6050: WHERE function_name = pParamFunctionName;
6051: /*
6052: CURSOR getPageParams IS
6053: SELECt attribute_name, session_value, session_description, dimension, period_date, operator
6054: FROM bis_user_attributes
6055: WHERE page_id = pPageId
6056: AND user_id = pUserId;
6057: */
6058: -- nbarik - 03/29/04 - Parameter Validation while navigating through related links

Line 6239: FROM bis_user_attributes

6235: )
6236: IS
6237: CURSOR getPageToFunctionName IS
6238: SELECT function_name
6239: FROM bis_user_attributes
6240: WHERE page_id=pPageId
6241: AND user_id = pUserId
6242: AND function_name IS NOT NULL
6243: AND rownum < 2;

Line 6280: FROM bis_user_attributes

6276: ) IS
6277:
6278: CURSOR getPageFromParams IS
6279: SELECT attribute_name, dimension, session_value, session_description, period_date
6280: FROM bis_user_attributes
6281: WHERE page_id = pFromPageId
6282: AND user_id = pUserId;
6283:
6284: vAttributeCodeTable BISVIEWER.t_char;

Line 6560: FROM bis_user_attributes

6556:
6557:
6558: CURSOR getParamsFromReport IS
6559: SELECT attribute_name, dimension, session_value, session_description, period_date
6560: FROM bis_user_attributes
6561: WHERE function_name = pFunctionName
6562: AND session_id = pSessionId
6563: AND user_id = pUserId
6564: AND schedule_id IS NULL;

Line 6980: FROM bis_user_attributes

6976: x_time_attribute OUT NOCOPY VARCHAR2
6977: )IS
6978: CURSOR getFunctionParameters IS
6979: SELECT attribute_name, dimension, session_value, session_description, period_date
6980: FROM bis_user_attributes
6981: WHERE function_name =pFunctionName
6982: AND session_id = pSessionId
6983: AND user_id = pUserId
6984: AND (attribute_name ='AS_OF_DATE' OR dimension ='TIME');

Line 7269: --update bis_user_attributes for schedule_id -ansingh

7265: x_prev_eff_end_date_char := to_char(l_PrevEffEndDate, l_canonical_format);
7266:
7267:
7268: IF p_page_id IS NULL THEN
7269: --update bis_user_attributes for schedule_id -ansingh
7270: IF getScheduleId%ISOPEN THEN
7271: CLOSE getScheduleId;
7272: END IF;
7273: OPEN getScheduleId(p_plug_id, p_user_id);

Line 7278: UPDATE BIS_USER_ATTRIBUTES SET

7274: FETCH getScheduleId INTO l_schedule_id;
7275: CLOSE getScheduleId;
7276:
7277:
7278: UPDATE BIS_USER_ATTRIBUTES SET
7279: session_value = DECODE(attribute_name, 'AS_OF_DATE', l_AsOfDate_Char, 'BIS_P_ASOF_DATE', l_PrevAsOfDate_Char,
7280: 'BIS_CUR_REPORT_START_DATE', l_CurrReportStartDate_Char, 'BIS_PREV_REPORT_START_DATE', l_PrevReportStartDate_Char,
7281: 'BIS_PREVIOUS_EFFECTIVE_START_DATE', l_PrevTimeLevelId, 'BIS_PREVIOUS_EFFECTIVE_END_DATE', l_PrevTimeLevelId,
7282: p_time_level || '_FROM', l_TimeLevelId, p_time_level || '_TO', l_TimeLevelId),

Line 7302: --update bis_user_attributes for page_id -ansingh

7298: 'BIS_PREVIOUS_EFFECTIVE_START_DATE','BIS_PREVIOUS_EFFECTIVE_END_DATE',p_time_level || '_FROM', p_time_level || '_TO');
7299: COMMIT;
7300:
7301: ELSE
7302: --update bis_user_attributes for page_id -ansingh
7303: UPDATE BIS_USER_ATTRIBUTES SET
7304: session_value = DECODE(attribute_name, 'AS_OF_DATE', l_AsOfDate_Char, 'BIS_P_ASOF_DATE', l_PrevAsOfDate_Char,
7305: 'BIS_CUR_REPORT_START_DATE', l_CurrReportStartDate_Char, 'BIS_PREV_REPORT_START_DATE', l_PrevReportStartDate_Char,
7306: 'BIS_PREVIOUS_EFFECTIVE_START_DATE', l_PrevTimeLevelId, 'BIS_PREVIOUS_EFFECTIVE_END_DATE', l_PrevTimeLevelId,

Line 7303: UPDATE BIS_USER_ATTRIBUTES SET

7299: COMMIT;
7300:
7301: ELSE
7302: --update bis_user_attributes for page_id -ansingh
7303: UPDATE BIS_USER_ATTRIBUTES SET
7304: session_value = DECODE(attribute_name, 'AS_OF_DATE', l_AsOfDate_Char, 'BIS_P_ASOF_DATE', l_PrevAsOfDate_Char,
7305: 'BIS_CUR_REPORT_START_DATE', l_CurrReportStartDate_Char, 'BIS_PREV_REPORT_START_DATE', l_PrevReportStartDate_Char,
7306: 'BIS_PREVIOUS_EFFECTIVE_START_DATE', l_PrevTimeLevelId, 'BIS_PREVIOUS_EFFECTIVE_END_DATE', l_PrevTimeLevelId,
7307: p_time_level || '_FROM', l_TimeLevelId, p_time_level || '_TO', l_TimeLevelId),