DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_HISTORY_PKG dependencies on DUAL

Line 26: CURSOR C2 IS SELECT fa_distribution_history_s.nextval FROM sys.dual;

22: X_Calling_Fn VARCHAR2
23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
24: CURSOR C IS SELECT rowid FROM fa_distribution_history
25: WHERE distribution_id = X_Distribution_Id;
26: CURSOR C2 IS SELECT fa_distribution_history_s.nextval FROM sys.dual;
27: BEGIN
28: if (X_Distribution_Id is NULL) then
29: OPEN C2;
30: FETCH C2 INTO X_Distribution_Id;