96: l_attr_table_name varchar2(30) := null;
97: l_grp_use_code varchar2(30) := null;
98: l_dimension_id number;
99:
100: l_resp_id number := FND_GLOBAL.RESP_ID;
101: l_resp_key varchar2(30);
102:
103: --
104: -- Cursor to determine the responsibility key corresponding
230: l_attr_table_name varchar2(30) := null;
231: l_grp_use_code varchar2(30) := null;
232: l_dimension_id number;
233:
234: l_resp_id number := FND_GLOBAL.RESP_ID;
235: l_resp_key varchar2(30);
236:
237: -- For Bug#3980015
238: l_dim_use_grp_flag varchar2(1) :='N';
504: -- Secured users cannot update/delete shared data.
505: IF p_personal_flag = 'N' THEN
506: RETURN 'Y';
507: ELSE
508: IF p_created_by <> Fnd_Global.User_Id THEN
509: RETURN 'Y';
510: END IF;
511: END IF;
512:
561: -- Personal users cannot update/delete shared data.
562: RETURN 'Y';
563: ELSE
564: -- Check if current user owns this personal data.
565: IF p_created_by <> Fnd_Global.User_Id THEN
566: -- Current user does not own it meaning it is read only.
567: RETURN 'Y';
568: ELSE
569: -- Current user owns it.
1059: -- Set Global fields.
1060: l_creation_date := SYSDATE ;
1061: l_last_update_date := l_creation_date ;
1062: --
1063: l_last_Updated_by := FND_GLOBAL.User_Id;
1064: l_created_by := l_last_Updated_by;
1065: IF l_last_Updated_by IS NULL THEN
1066: l_last_Updated_by := -1;
1067: l_created_by := FND_GLOBAL.User_Id;
1063: l_last_Updated_by := FND_GLOBAL.User_Id;
1064: l_created_by := l_last_Updated_by;
1065: IF l_last_Updated_by IS NULL THEN
1066: l_last_Updated_by := -1;
1067: l_created_by := FND_GLOBAL.User_Id;
1068: END IF ;
1069: --
1070: l_last_update_login := FND_GLOBAL.Login_Id ;
1071: IF l_last_update_login IS NULL THEN
1066: l_last_Updated_by := -1;
1067: l_created_by := FND_GLOBAL.User_Id;
1068: END IF ;
1069: --
1070: l_last_update_login := FND_GLOBAL.Login_Id ;
1071: IF l_last_update_login IS NULL THEN
1072: l_last_update_login := -1;
1073: END IF;
1074: --
5092: -- Set Global fields.
5093: --
5094: l_last_update_date := SYSDATE ;
5095: --
5096: l_last_Updated_by := FND_GLOBAL.User_Id;
5097: IF l_last_Updated_by IS NULL THEN
5098: l_last_Updated_by := -1;
5099: END IF ;
5100: --
5097: IF l_last_Updated_by IS NULL THEN
5098: l_last_Updated_by := -1;
5099: END IF ;
5100: --
5101: l_last_update_login := FND_GLOBAL.Login_Id ;
5102: IF l_last_update_login IS NULL THEN
5103: l_last_update_login := -1;
5104: END IF;
5105: --
9622: --
9623: l_creation_date := SYSDATE ;
9624: l_last_update_date := l_creation_date ;
9625: --
9626: l_last_updated_by := FND_GLOBAL.User_Id;
9627: l_created_by := l_last_Updated_by;
9628: IF l_last_Updated_by IS NULL THEN
9629: l_last_Updated_by := -1;
9630: l_created_by := -1;
9629: l_last_Updated_by := -1;
9630: l_created_by := -1;
9631: END IF ;
9632: --
9633: l_last_update_login := FND_GLOBAL.Login_Id ;
9634: IF l_last_update_login IS NULL THEN
9635: l_last_update_login := -1;
9636: END IF;
9637: --
9874: -- Set Global fields.
9875: --
9876: l_last_update_date := SYSDATE ;
9877: --
9878: l_last_updated_by := FND_GLOBAL.User_Id;
9879: IF l_last_Updated_by IS NULL THEN
9880: l_last_Updated_by := -1;
9881: END IF ;
9882: --
9879: IF l_last_Updated_by IS NULL THEN
9880: l_last_Updated_by := -1;
9881: END IF ;
9882: --
9883: l_last_update_login := FND_GLOBAL.Login_Id ;
9884: IF l_last_update_login IS NULL THEN
9885: l_last_update_login := -1;
9886: END IF;
9887: --
10805: decode(p_segment_28, '-999', null, p_segment_28),
10806: decode(p_segment_29, '-999', null, p_segment_29),
10807: decode(p_segment_30, '-999', null, p_segment_30),
10808: sysdate,
10809: fnd_global.user_id,
10810: fnd_global.user_id,
10811: sysdate,
10812: fnd_global.login_id,
10813: 1,
10806: decode(p_segment_29, '-999', null, p_segment_29),
10807: decode(p_segment_30, '-999', null, p_segment_30),
10808: sysdate,
10809: fnd_global.user_id,
10810: fnd_global.user_id,
10811: sysdate,
10812: fnd_global.login_id,
10813: 1,
10814: 'Y',
10808: sysdate,
10809: fnd_global.user_id,
10810: fnd_global.user_id,
10811: sysdate,
10812: fnd_global.login_id,
10813: 1,
10814: 'Y',
10815: 'N',
10816: 'N'
11074: decode(p_segment_28, '-999', null, p_segment_28),
11075: decode(p_segment_29, '-999', null, p_segment_29),
11076: decode(p_segment_30, '-999', null, p_segment_30),
11077: sysdate,
11078: fnd_global.user_id,
11079: fnd_global.user_id,
11080: sysdate,
11081: fnd_global.login_id,
11082: 1,
11075: decode(p_segment_29, '-999', null, p_segment_29),
11076: decode(p_segment_30, '-999', null, p_segment_30),
11077: sysdate,
11078: fnd_global.user_id,
11079: fnd_global.user_id,
11080: sysdate,
11081: fnd_global.login_id,
11082: 1,
11083: 'Y',
11077: sysdate,
11078: fnd_global.user_id,
11079: fnd_global.user_id,
11080: sysdate,
11081: fnd_global.login_id,
11082: 1,
11083: 'Y',
11084: 'N',
11085: 'N');