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_
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 ,
29: param_name ,
30: param_char ,
31: param_indicator ) values (
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 ,
53: param_name ,
54: param_num ,
55: param_indicator ) values (
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 ,
77: param_name ,
78: param_date ,
79: param_indicator ) values (
89: procedure delete_row (
90: x_item_key in varchar2
91: ) is
92: begin
93: delete from hz_param_tab
94: where item_key = x_item_key;
95: end;
96: end;