DBA Data[Home] [Help]

APPS.ASO_ATP_INT dependencies on ASO_LINE_NUM_INT

Line 559: l_out_qte_line_number_tbl aso_line_num_int.Out_Line_Number_Tbl_Type;

555: l_check_atp_for_whole_quote varchar2(1) := fnd_api.g_false;
556: l_ship_to_party_site_id number;
557: l_ship_to_cust_account_id number;
558: lx_cust_acct_site_use_id number;
559: l_out_qte_line_number_tbl aso_line_num_int.Out_Line_Number_Tbl_Type;
560: l_in_qte_line_number_tbl aso_line_num_int.In_Line_Number_Tbl_Type;
561:
562: l_search_tbl Number_Search_Tbl_Type;
563: l_qte_line_id_from_bali number;

Line 560: l_in_qte_line_number_tbl aso_line_num_int.In_Line_Number_Tbl_Type;

556: l_ship_to_party_site_id number;
557: l_ship_to_cust_account_id number;
558: lx_cust_acct_site_use_id number;
559: l_out_qte_line_number_tbl aso_line_num_int.Out_Line_Number_Tbl_Type;
560: l_in_qte_line_number_tbl aso_line_num_int.In_Line_Number_Tbl_Type;
561:
562: l_search_tbl Number_Search_Tbl_Type;
563: l_qte_line_id_from_bali number;
564: l_no_of_lines number;

Line 1060: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.reset_line_num procedure', 1, 'Y');

1056:
1057: if l_qte_line_tbl.count > 0 then
1058:
1059: if aso_debug_pub.g_debug_flag = 'Y' then
1060: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.reset_line_num procedure', 1, 'Y');
1061: end if;
1062:
1063: aso_line_num_int.reset_line_num;
1064: l_in_qte_line_number_tbl(1).quote_line_id := l_qte_line_tbl(1).quote_line_id;

Line 1063: aso_line_num_int.reset_line_num;

1059: if aso_debug_pub.g_debug_flag = 'Y' then
1060: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.reset_line_num procedure', 1, 'Y');
1061: end if;
1062:
1063: aso_line_num_int.reset_line_num;
1064: l_in_qte_line_number_tbl(1).quote_line_id := l_qte_line_tbl(1).quote_line_id;
1065:
1066: if aso_debug_pub.g_debug_flag = 'Y' then
1067: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');

Line 1067: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');

1063: aso_line_num_int.reset_line_num;
1064: l_in_qte_line_number_tbl(1).quote_line_id := l_qte_line_tbl(1).quote_line_id;
1065:
1066: if aso_debug_pub.g_debug_flag = 'Y' then
1067: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1068: end if;
1069:
1070: aso_line_num_int.aso_ui_line_number( p_in_Line_number_tbl => l_in_qte_line_number_tbl,
1071: x_out_line_number_tbl => l_out_qte_line_number_tbl);

Line 1070: aso_line_num_int.aso_ui_line_number( p_in_Line_number_tbl => l_in_qte_line_number_tbl,

1066: if aso_debug_pub.g_debug_flag = 'Y' then
1067: aso_debug_pub.add('do_check_atp: Before call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1068: end if;
1069:
1070: aso_line_num_int.aso_ui_line_number( p_in_Line_number_tbl => l_in_qte_line_number_tbl,
1071: x_out_line_number_tbl => l_out_qte_line_number_tbl);
1072:
1073:
1074: if aso_debug_pub.g_debug_flag = 'Y' then

Line 1075: aso_debug_pub.add('do_check_atp: After call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');

1071: x_out_line_number_tbl => l_out_qte_line_number_tbl);
1072:
1073:
1074: if aso_debug_pub.g_debug_flag = 'Y' then
1075: aso_debug_pub.add('do_check_atp: After call to aso_line_num_int.aso_ui_line_number procedure', 1, 'Y');
1076: end if;
1077:
1078: end if;
1079:

Line 1179: l_atp_rec.line_number(i) := aso_line_num_int.get_ui_line_number(l_db_qte_line_rec.quote_line_id);

1175: l_atp_rec.quantity_uom(i) := l_db_qte_line_rec.uom_code;
1176: l_atp_rec.demand_source_header_id(i) := l_db_qte_line_rec.quote_header_id;
1177: l_atp_rec.included_item_flag(i) := 2;
1178: --l_atp_rec.cascade_model_info_to_comp(i) := 2;
1179: l_atp_rec.line_number(i) := aso_line_num_int.get_ui_line_number(l_db_qte_line_rec.quote_line_id);
1180:
1181: open c_description(l_db_qte_line_rec.inventory_item_id, l_db_qte_line_rec.organization_id);
1182: fetch c_description into l_atp_rec.inventory_item_name(i);
1183: close c_description;