DBA Data[Home] [Help]

APPS.CN_API dependencies on FND_API

Line 310: p_show_message IN VARCHAR2 := FND_API.G_TRUE);

306: p_org_id IN NUMBER,
307: x_salesrep_id OUT NOCOPY cn_salesreps.salesrep_id%TYPE,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_loading_status OUT NOCOPY VARCHAR2,
310: p_show_message IN VARCHAR2 := FND_API.G_TRUE);
311:
312:
313: -- --------------------------------------------------------------------------+
314: -- Function : date_range_overlap

Line 356: --| p_end_date_nullable = FND_API.G_TRUE

352: --| Desc : Check if start date exist, if start_date > end_date
353: --| If so, add error message onto FND message stack and update error
354: --| x_loading_status
355: --| Input : p_end_date_nullable : end_date is nullable only if
356: --| p_end_date_nullable = FND_API.G_TRUE
357: --| ---------------------------------------------------------------------+
358: FUNCTION invalid_date_range
359: ( p_start_date IN DATE ,
360: p_end_date IN DATE ,

Line 361: p_end_date_nullable IN VARCHAR2 := FND_API.G_TRUE,

357: --| ---------------------------------------------------------------------+
358: FUNCTION invalid_date_range
359: ( p_start_date IN DATE ,
360: p_end_date IN DATE ,
361: p_end_date_nullable IN VARCHAR2 := FND_API.G_TRUE,
362: p_loading_status IN VARCHAR2 := NULL ,
363: x_loading_status OUT NOCOPY VARCHAR2,
364: p_show_message IN VARCHAR2 := fnd_api.G_TRUE )
365: RETURN VARCHAR2 ;

Line 364: p_show_message IN VARCHAR2 := fnd_api.G_TRUE )

360: p_end_date IN DATE ,
361: p_end_date_nullable IN VARCHAR2 := FND_API.G_TRUE,
362: p_loading_status IN VARCHAR2 := NULL ,
363: x_loading_status OUT NOCOPY VARCHAR2,
364: p_show_message IN VARCHAR2 := fnd_api.G_TRUE )
365: RETURN VARCHAR2 ;
366:
367:
368: --| ---------------------------------------------------------------------+

Line 688: --| Desc : function to return FND_API.g_miss_char

684:
685:
686: --| ---------------------------------------------------------------------+
687: --| Function Name : g_miss_char
688: --| Desc : function to return FND_API.g_miss_char
689: --| ---------------------------------------------------------------------+
690: FUNCTION g_miss_char RETURN VARCHAR2;
691:
692: --| ---------------------------------------------------------------------+

Line 694: --| Desc : function to return FND_API.g_miss_date

690: FUNCTION g_miss_char RETURN VARCHAR2;
691:
692: --| ---------------------------------------------------------------------+
693: --| Function Name : g_miss_date
694: --| Desc : function to return FND_API.g_miss_date
695: --| ---------------------------------------------------------------------+
696: FUNCTION g_miss_date RETURN DATE;
697:
698: --| ---------------------------------------------------------------------+

Line 700: --| Desc : function to return FND_API.g_miss_num

696: FUNCTION g_miss_date RETURN DATE;
697:
698: --| ---------------------------------------------------------------------+
699: --| Function Name : g_miss_num
700: --| Desc : function to return FND_API.g_miss_num
701: --| ---------------------------------------------------------------------+
702: FUNCTION g_miss_num RETURN NUMBER;
703:
704: --| ---------------------------------------------------------------------+

Line 712: --| Desc : function to return FND_API.g_false

708: FUNCTION g_miss_id RETURN NUMBER;
709:
710: --| ---------------------------------------------------------------------+
711: --| Function Name : g_false
712: --| Desc : function to return FND_API.g_false
713: --| ---------------------------------------------------------------------+
714: FUNCTION g_false RETURN VARCHAR2;
715:
716: --| ---------------------------------------------------------------------+

Line 718: --| Desc : function to return FND_API.g_true

714: FUNCTION g_false RETURN VARCHAR2;
715:
716: --| ---------------------------------------------------------------------+
717: --| Function Name : g_true
718: --| Desc : function to return FND_API.g_true
719: --| ---------------------------------------------------------------------+
720: FUNCTION g_true RETURN VARCHAR2;
721:
722: --| ---------------------------------------------------------------------+

Line 724: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE

720: FUNCTION g_true RETURN VARCHAR2;
721:
722: --| ---------------------------------------------------------------------+
723: --| Function Name : g_valid_level_none
724: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE
725: --| ---------------------------------------------------------------------+
726: FUNCTION g_valid_level_none RETURN NUMBER;
727:
728: --| ---------------------------------------------------------------------+

Line 730: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL

726: FUNCTION g_valid_level_none RETURN NUMBER;
727:
728: --| ---------------------------------------------------------------------+
729: --| Function Name : g_valid_level_full
730: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL
731: --| ---------------------------------------------------------------------+
732: FUNCTION g_valid_level_full RETURN NUMBER;
733:
734: --| ---------------------------------------------------------------------+