APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_LEAD_LINES_ALL

Line 245: From AS_LEAD_LINES_ALL

241: ,attribute14
242: ,attribute15
243: ,product_category_id
244: ,product_cat_set_id
245: From AS_LEAD_LINES_ALL
246: Where lead_id = x_Lead_Id;
247:
248: l_api_name CONSTANT VARCHAR2(30) := 'Get_Potential_Opportunity';
249: l_api_version_number CONSTANT NUMBER := 2.0;

Line 1199: -- 103000 FFANG as_lead_lines_all.status_code has been obsolete

1195: */
1196: l_line_tbl(l_cnt).lead_line_id := NULL;
1197: -- end ffang 101200
1198: l_line_tbl(l_cnt).lead_id := p_opportunity_id;
1199: -- 103000 FFANG as_lead_lines_all.status_code has been obsolete
1200: -- l_line_tbl(l_cnt).status_code := 'PRELIMINARY';
1201: -- end 103000 FFANG
1202: /* Commented by gbatra for product hierarchy uptake
1203: l_line_tbl(l_cnt).interest_type_id

Line 1226: -- 103000 FFANG as_lead_lines_all.channel_code has been obsolete

1222: -- l_line_tbl(l_cnt).sales_stage_id -- obsolete
1223: -- l_line_tbl(l_cnt).ship_date -- not exist in sales lead lines
1224: -- l_line_tbl(l_cnt).win_probability -- obsolete
1225: -- l_line_tbl(l_cnt).decision_date -- obsolete
1226: -- 103000 FFANG as_lead_lines_all.channel_code has been obsolete
1227: -- l_line_tbl(l_cnt).channel_code := l_header_rec.channel_code;
1228: -- end 103000 FFANG
1229: -- l_line_tbl(l_cnt).quoted_line_flag -- not exist in sales lead lines
1230: -- l_line_tbl(l_cnt).original_lead_line_id -- not exist in sl lines

Line 2943: -- 103000 FFANG as_lead_lines_all.status_code has been obsolete

2939: l_line_tbl(l_cnt).creation_Date := SYSDATE;
2940: l_line_tbl(l_cnt).created_by := FND_GLOBAL.USER_ID;
2941: l_line_tbl(l_cnt).last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
2942: l_line_tbl(l_cnt).lead_id := l_lead_id;
2943: -- 103000 FFANG as_lead_lines_all.status_code has been obsolete
2944: -- l_line_tbl(l_cnt).status_code := 'NEW_OPPORTUNITY';
2945: -- end 103000 FFANG
2946: l_line_tbl(l_cnt).interest_type_id
2947: := C_Sales_Lead_lines_Rec.interest_type_id;

Line 2965: -- 103000 FFANG as_lead_lines_all.channel_code has been obsolete

2961: -- l_line_tbl(l_cnt).sales_stage_id -- obsolete
2962: -- l_line_tbl(l_cnt).ship_date -- not exist in sales lead lines
2963: -- l_line_tbl(l_cnt).win_probability -- obsolete
2964: -- l_line_tbl(l_cnt).decision_date -- obsolete
2965: -- 103000 FFANG as_lead_lines_all.channel_code has been obsolete
2966: -- l_line_tbl(l_cnt).channel_code := l_header_rec.channel_code;
2967: -- end 103000 FFANG
2968: -- l_line_tbl(l_cnt).quoted_line_flag -- not exist in sales lead lines
2969: -- l_line_tbl(l_cnt).original_lead_line_id -- not exist in sl lines