DBA Data[Home] [Help]

APPS.AMS_ITEM_SECTION_PVT dependencies on JTF_DATE_TABLE

Line 39: l_start_date_tbl JTF_DATE_TABLE;

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() ;
43: l_association_reason_code_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

Line 40: l_end_date_tbl JTF_DATE_TABLE;

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

Line 101: l_start_date_tbl := JTF_DATE_TABLE();

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();
102: l_start_date_tbl.extend();
103: l_start_date_tbl(1) := sysdate; --p_section_rec.start_date
104:
105: l_end_date_tbl := JTF_DATE_TABLE();

Line 105: l_end_date_tbl := JTF_DATE_TABLE();

101: l_start_date_tbl := JTF_DATE_TABLE();
102: l_start_date_tbl.extend();
103: l_start_date_tbl(1) := sysdate; --p_section_rec.start_date
104:
105: l_end_date_tbl := JTF_DATE_TABLE();
106: l_end_date_tbl.extend();
107: l_end_date_tbl(1) := p_section_rec.end_date;
108:
109: l_association_reason_code_tbl.extend();