APPS.BIS_RG_SCHEDULES_PVT dependencies on BIS_USER_ATTRIBUTES

Line 485: UPDATE BIS_USER_ATTRIBUTES

481: ,p_context_values
482: );
483: x_Schedule_id := l_schedule_id;
484: BEGIN
485: UPDATE BIS_USER_ATTRIBUTES
486: SET schedule_id = l_schedule_id
487: WHERE session_id=p_Session_id AND
488: function_name = p_function_name AND
489: user_id = p_user_id AND

Line 495: insert into bis_user_attributes (USER_ID,

491:
492: /* -- aleung, 10/19/01, no need to do this, should retrieve data according to schedule id
493: -- aleung, 5/12/01, need to duplicate records(but schedule id is null)
494: -- for drilldown from table porlet to work
495: insert into bis_user_attributes (USER_ID,
496: FUNCTION_NAME,
497: SESSION_ID,
498: SESSION_VALUE,
499: SESSION_DESCRIPTION,

Line 515: from bis_user_attributes

511: DEFAULT_DESCRIPTION,
512: ATTRIBUTE_NAME,
513: DIMENSION,
514: PERIOD_DATE
515: from bis_user_attributes
516: where schedule_id = l_schedule_id;
517: */
518:
519: END;

Line 598: insert into bis_user_attributes (USER_ID,

594: commit;
595:
596: x_Schedule_id := l_schedule_id;
597: BEGIN
598: insert into bis_user_attributes (USER_ID,
599: FUNCTION_NAME,
600: SESSION_ID,
601: SESSION_VALUE,
602: SESSION_DESCRIPTION,

Line 620: from bis_user_attributes

616: ATTRIBUTE_NAME,
617: DIMENSION,
618: PERIOD_DATE,
619: l_schedule_id
620: from bis_user_attributes
621: WHERE session_id=p_Session_id AND
622: function_name = p_function_name AND
623: user_id = p_user_id AND
624: schedule_id is null;

Line 716: DELETE FROM bis_user_attributes

712: )
713: IS
714: BEGIN
715:
716: DELETE FROM bis_user_attributes
717: WHERE schedule_id = p_schedule_id
718: AND function_name = p_function_name;
719:
720: UPDATE BIS_USER_ATTRIBUTES

Line 720: UPDATE BIS_USER_ATTRIBUTES

716: DELETE FROM bis_user_attributes
717: WHERE schedule_id = p_schedule_id
718: AND function_name = p_function_name;
719:
720: UPDATE BIS_USER_ATTRIBUTES
721: SET schedule_id = p_schedule_id
722: WHERE session_id=p_Session_id AND
723: function_name = p_function_name AND
724: user_id = p_user_id AND

Line 799: FROM bis_user_attributes

795: )
796: IS
797: CURSOR c_attrs IS
798: SELECT attribute_name, session_value
799: FROM bis_user_attributes
800: WHERE user_id=p_user_id AND
801: function_name = p_function_name AND
802: schedule_id IS NOT NULL;
803: l_scheduled varchar2(1);

Line 1703: from bis_user_attributes

1699:
1700:
1701: cursor cParameterValues (cpFunctionName varchar2, cpSessionId varchar2, cpUserId varchar2) is
1702: select session_value
1703: from bis_user_attributes
1704: where session_id = cpSessionId
1705: and user_id = cpUserId
1706: and function_name = cpFunctionName
1707: and schedule_id is null

Line 1983: -- Step 2 - Delete from BIS_USER_ATTRIBUTES

1979: into vRequestId
1980: from bis_scheduler
1981: where schedule_id = pScheduleId;
1982:
1983: -- Step 2 - Delete from BIS_USER_ATTRIBUTES
1984:
1985: delete bis_user_attributes
1986: where schedule_id = pScheduleId;
1987:

Line 1985: delete bis_user_attributes

1981: where schedule_id = pScheduleId;
1982:
1983: -- Step 2 - Delete from BIS_USER_ATTRIBUTES
1984:
1985: delete bis_user_attributes
1986: where schedule_id = pScheduleId;
1987:
1988: -- Step 3 - Delete from bis_schedule_preferences
1989:

Line 2128: -- Step 3 - Delete from BIS_USER_ATTRIBUTES

2124:
2125: delete fnd_lobs
2126: where file_id = vFileId;
2127:
2128: -- Step 3 - Delete from BIS_USER_ATTRIBUTES
2129:
2130: delete bis_user_attributes
2131: where schedule_id = pScheduleId;
2132:

Line 2130: delete bis_user_attributes

2126: where file_id = vFileId;
2127:
2128: -- Step 3 - Delete from BIS_USER_ATTRIBUTES
2129:
2130: delete bis_user_attributes
2131: where schedule_id = pScheduleId;
2132:
2133: -- Step 4 - Delete Role
2134:

Line 2641: from bis_user_attributes

2637: IS
2638: BEGIN
2639: delete fnd_lobs where file_id in
2640: (select session_value
2641: from bis_user_attributes
2642: where user_id = p_user_id
2643: and schedule_id = p_schedule_id
2644: and function_name = p_function_name
2645: and attribute_name in