APPS.HZ_PARAM_TAB_PKG dependencies on HZ_PARAM_TAB

Line 1: package body hz_param_tab_pkg as

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

Line 27: insert into hz_param_tab (

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 (

Line 51: insert into hz_param_tab (

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 (

Line 75: insert into hz_param_tab (

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 (

Line 93: delete from hz_param_tab

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;