DBA Data[Home] [Help]

APPS.AMS_ITEM_SECTION_PVT dependencies on JTF_NUMBER_TABLE

Line 38: l_section_id_tbl JTF_NUMBER_TABLE ;

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() ;

Line 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:

Line 44: x_section_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_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:
47:
48: l_api_version NUMBER := p_api_version;

Line 97: l_section_id_tbl := JTF_NUMBER_TABLE(1);

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();

Line 218: l_inv_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);

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;

Line 219: l_org_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);

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;

Line 220: l_section_id_tbl JTF_NUMBER_TABLE :=JTF_NUMBER_TABLE(1);

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;