34:
35: l_api_name CONSTANT VARCHAR2(50) := 'create_item_sec_assoc';
36:
37:
38: l_section_id_tbl JTF_NUMBER_TABLE ;
39: l_start_date_tbl JTF_DATE_TABLE;
40: l_end_date_tbl JTF_DATE_TABLE;
41:
42: l_sort_order_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE() ;
38: l_section_id_tbl JTF_NUMBER_TABLE ;
39: l_start_date_tbl JTF_DATE_TABLE;
40: l_end_date_tbl JTF_DATE_TABLE;
41:
42: l_sort_order_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE() ;
43: l_association_reason_code_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
44: x_section_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
45:
46:
40: l_end_date_tbl JTF_DATE_TABLE;
41:
42: l_sort_order_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE() ;
43: l_association_reason_code_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
44: x_section_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
45:
46:
47:
48: l_api_version NUMBER := p_api_version;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96:
97: l_section_id_tbl := JTF_NUMBER_TABLE(1);
98: l_section_id_tbl(1) := p_section_rec.section_id;
99:
100: AMS_UTILITY_PVT.debug_message(l_api_name || ' the l_section_id_tbl(1):' ||l_section_id_tbl(1));
101: l_start_date_tbl := JTF_DATE_TABLE();
214:
215: IS
216: l_api_name CONSTANT VARCHAR2(50) := 'Delete_item_sec_assoc';
217:
218: l_inv_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
219: l_org_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
220: l_section_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
221:
222: l_api_version NUMBER := p_api_version;
215: IS
216: l_api_name CONSTANT VARCHAR2(50) := 'Delete_item_sec_assoc';
217:
218: l_inv_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
219: l_org_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
220: l_section_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
221:
222: l_api_version NUMBER := p_api_version;
223: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
216: l_api_name CONSTANT VARCHAR2(50) := 'Delete_item_sec_assoc';
217:
218: l_inv_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
219: l_org_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
220: l_section_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);
221:
222: l_api_version NUMBER := p_api_version;
223: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
224: l_commit VARCHAR2(1) := p_commit;