22: --
23: ---------------------------------------------------------------------
24: PROCEDURE add_tpl_ctg(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
27: p_commit IN VARCHAR2 := FND_API.g_false,
28: x_return_status OUT VARCHAR2,
29: x_msg_count OUT NUMBER,
30: x_msg_data OUT VARCHAR2,
23: ---------------------------------------------------------------------
24: PROCEDURE add_tpl_ctg(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
27: p_commit IN VARCHAR2 := FND_API.g_false,
28: x_return_status OUT VARCHAR2,
29: x_msg_count OUT NUMBER,
30: x_msg_data OUT VARCHAR2,
31: p_template_id IN NUMBER,
40: -- for all display contexts
41: --------------------------------------------------------------------
42: PROCEDURE delete_tpl_ctg_relation(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,
48: x_msg_data OUT VARCHAR2,
41: --------------------------------------------------------------------
42: PROCEDURE delete_tpl_ctg_relation(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,
48: x_msg_data OUT VARCHAR2,
49: p_tpl_ctg_id_tbl IN tpl_ctg_id_tbl_type
58: -- 4. Creates a category to templates relationship (JTF_DSP_TPL_CTG)
59: ---------------------------------------------------------------------
60: PROCEDURE add_ctg_tpl(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
63: p_commit IN VARCHAR2 := FND_API.g_false,
64: x_return_status OUT VARCHAR2,
65: x_msg_count OUT NUMBER,
66: x_msg_data OUT VARCHAR2,
59: ---------------------------------------------------------------------
60: PROCEDURE add_ctg_tpl(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
63: p_commit IN VARCHAR2 := FND_API.g_false,
64: x_return_status OUT VARCHAR2,
65: x_msg_count OUT NUMBER,
66: x_msg_data OUT VARCHAR2,
67: p_category_id IN NUMBER,