DBA Data[Home] [Help]

APPS.PAY_ELEMENT_SETS_PKG dependencies on DUAL

Line 19: 05-Mar-97 J.Alloun 40.7 Changed all occurances of system.dual

15:
16: History
17: 24-Mar-94 J.S.Hobbs 40.0 Date created.
18: 22-Apr-94 J.S.Hobbs 40.1 Added rtrim to Lock_Row.
19: 05-Mar-97 J.Alloun 40.7 Changed all occurances of system.dual
20: to sys.dual for next release requirements.
21: 22-Sep-05 Shisriva 115.3 Changes for MLS enabling and dual maintenance.
22: 26-Sep-05 Shisriva 115.4 Added dbdrv commands.
23: 26-Sep-05 Shisriva 115.5 Removed gscc violation for in out parameters.

Line 20: to sys.dual for next release requirements.

16: History
17: 24-Mar-94 J.S.Hobbs 40.0 Date created.
18: 22-Apr-94 J.S.Hobbs 40.1 Added rtrim to Lock_Row.
19: 05-Mar-97 J.Alloun 40.7 Changed all occurances of system.dual
20: to sys.dual for next release requirements.
21: 22-Sep-05 Shisriva 115.3 Changes for MLS enabling and dual maintenance.
22: 26-Sep-05 Shisriva 115.4 Added dbdrv commands.
23: 26-Sep-05 Shisriva 115.5 Removed gscc violation for in out parameters.
24: Added NOCOPY for two parameters.

Line 21: 22-Sep-05 Shisriva 115.3 Changes for MLS enabling and dual maintenance.

17: 24-Mar-94 J.S.Hobbs 40.0 Date created.
18: 22-Apr-94 J.S.Hobbs 40.1 Added rtrim to Lock_Row.
19: 05-Mar-97 J.Alloun 40.7 Changed all occurances of system.dual
20: to sys.dual for next release requirements.
21: 22-Sep-05 Shisriva 115.3 Changes for MLS enabling and dual maintenance.
22: 26-Sep-05 Shisriva 115.4 Added dbdrv commands.
23: 26-Sep-05 Shisriva 115.5 Removed gscc violation for in out parameters.
24: Added NOCOPY for two parameters.
25: 30-Sep-05 tvankayl 115.6 Added delete validation for element

Line 359: CURSOR C2 IS SELECT pay_element_sets_s.nextval FROM sys.dual;

355: --
356: CURSOR C IS SELECT rowid FROM pay_element_sets
357: WHERE element_set_id = X_Element_Set_Id;
358: --
359: CURSOR C2 IS SELECT pay_element_sets_s.nextval FROM sys.dual;
360: --
361: BEGIN
362: --
363: check_unique_set

Line 532: ---For sustaining dual maintenance----------

528: comments = X_Comments
529: WHERE rowid = X_rowid;
530:
531: --For MLS-----------------------------------------------------------------------
532: ---For sustaining dual maintenance----------
533: if(PAY_ADHOC_UTILS_PKG.chk_post_r11i = 'Y') then
534: --MLS validation for uniqueness-----------------
535:
536: validate_translation (X_Element_Set_Id,