DBA Data[Home] [Help]

APPS.HZ_PARAM_TAB_PKG dependencies on FND_API

Line 5: -- In TCA API V1 FND_API.G_MISS_ represent a Null Value => Test of Null value is based on FND_API.G_MISS_ before insertions

1: package body hz_param_tab_pkg as
2: /*$Header: ARHPRMTB.pls 120.1 2005/06/16 21:14:42 jhuang noship $ */
3:
4: ---------------------------------------------------------------------------------------------------------------------------------------
5: -- In TCA API V1 FND_API.G_MISS_ represent a Null Value => Test of Null value is based on FND_API.G_MISS_ before insertions
6: -- In TCA API V2 NULL represent a Null Value => Test of Null value is based on NULL before insertions
7: -- if value = G_MISS_ then insert NULL end if;
8: ---------------------------------------------------------------------------------------------------------------------------------------
9: -- This is the V1 version

Line 24: IF l_param_value = FND_API.G_MISS_CHAR THEN

20: l_param_value varchar2(4000) := x_param_value;
21: begin
22: l_param_value := trim(x_param_value);
23: IF l_param_value IS NOT NULL THEN
24: IF l_param_value = FND_API.G_MISS_CHAR THEN
25: l_param_value := NULL;
26: END IF;
27: insert into hz_param_tab (
28: item_key ,

Line 48: IF l_param_value = FND_API.G_MISS_NUM THEN

44: ) is
45: l_param_value number := x_param_value;
46: BEGIN
47: IF l_param_value IS NOT NULL THEN
48: IF l_param_value = FND_API.G_MISS_NUM THEN
49: l_param_value := NULL;
50: END IF;
51: insert into hz_param_tab (
52: item_key ,

Line 72: IF l_param_value = FND_API.G_MISS_DATE THEN

68: ) is
69: l_param_value date := x_param_value;
70: begin
71: IF l_param_value IS NOT NULL THEN
72: IF l_param_value = FND_API.G_MISS_DATE THEN
73: l_param_value := NULL;
74: END IF;
75: insert into hz_param_tab (
76: item_key ,