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_
7: -- if value = G_MISS_
8: ---------------------------------------------------------------------------------------------------------------------------------------
9: -- This is the V1 version
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 ,
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 ,
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 ,