70: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
71: , p14_a7 out nocopy JTF_NUMBER_TABLE
72: , p12_a0 NUMBER := 0-1962.0724
73: , p12_a1 NUMBER := 0-1962.0724
74: , p12_a2 VARCHAR2 := fnd_api.g_miss_char
75: );
76: procedure get_channelspercategory(p_api_version NUMBER
77: , p_init_msg_list VARCHAR2
78: , p_validation_level NUMBER
115: , p12_a1 out nocopy JTF_NUMBER_TABLE
116: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
117: , p9_a0 NUMBER := 0-1962.0724
118: , p9_a1 NUMBER := 0-1962.0724
119: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
121: , p10_a1 VARCHAR2 := fnd_api.g_miss_char
122: );
123: procedure get_catparentshierarchy(p_api_version NUMBER
116: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
117: , p9_a0 NUMBER := 0-1962.0724
118: , p9_a1 NUMBER := 0-1962.0724
119: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
121: , p10_a1 VARCHAR2 := fnd_api.g_miss_char
122: );
123: procedure get_catparentshierarchy(p_api_version NUMBER
124: , p_init_msg_list VARCHAR2
117: , p9_a0 NUMBER := 0-1962.0724
118: , p9_a1 NUMBER := 0-1962.0724
119: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
120: , p10_a0 VARCHAR2 := fnd_api.g_miss_char
121: , p10_a1 VARCHAR2 := fnd_api.g_miss_char
122: );
123: procedure get_catparentshierarchy(p_api_version NUMBER
124: , p_init_msg_list VARCHAR2
125: , p_validation_level NUMBER