DBA Data[Home] [Help]

APPS.IBE_ORDER_SAVE_PVT dependencies on IBE_LEAD_IMPORT_PVT

Line 315: IBE_LEAD_IMPORT_PVT.parseInput (p_line_ids, 'CHAR', l_parseKey,l_parseNum, l_line_id_query);

311: Ibe_util.debug('p_line_ids set: '||p_line_ids);
312: end if;
313:
314: /** This API is called for parsing the where condition PlSQL Bind Variables Std. **/
315: IBE_LEAD_IMPORT_PVT.parseInput (p_line_ids, 'CHAR', l_parseKey,l_parseNum, l_line_id_query);
316:
317: l_tmp_query := 'SELECT csu.site_use_id '||
318: 'FROM hz_cust_site_uses_all csu '||
319: 'WHERE csu.status = ''A'' AND site_use_code = :siteusecode '||

Line 1363: IBE_LEAD_IMPORT_PVT.parseInput (p_lineids_set, 'CHAR', l_parseKey, l_parseNum, l_all_lineids_query);

1359: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1360: IBE_Util.Debug('Line Ids to be parsed: '|| p_lineids_set);
1361: END IF;
1362:
1363: IBE_LEAD_IMPORT_PVT.parseInput (p_lineids_set, 'CHAR', l_parseKey, l_parseNum, l_all_lineids_query);
1364:
1365: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1366: IBE_Util.Debug('After calling Lead_Import package');
1367: END IF;

Line 1834: IBE_LEAD_IMPORT_PVT.parseInput (p_tmp_error_lineIds, 'CHAR', l_parseKey, l_parseNum, l_tmp_error_lineIds);

1830: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1831: Ibe_util.debug('l_tmp_error_lineIds set: '||p_tmp_error_lineIds);
1832: end if;
1833:
1834: IBE_LEAD_IMPORT_PVT.parseInput (p_tmp_error_lineIds, 'CHAR', l_parseKey, l_parseNum, l_tmp_error_lineIds);
1835:
1836: -- this query returns the Ordernumber, partnumber necessary for the error message of the lines
1837: -- violating the qty. check
1838: -- Supppose if only one of the child w/in a MODEL is violating, then

Line 3043: IBE_LEAD_IMPORT_PVT.parseInput (p_dl_line_ids, 'CHAR', l_parseKey, l_parseNum, l_dl_line_id_qry);

3039: p_dl_line_ids := p_dl_line_ids || ','||l_order_line_tbl(lineIdx).LINE_ID;
3040: end if;
3041: end loop;
3042:
3043: IBE_LEAD_IMPORT_PVT.parseInput (p_dl_line_ids, 'CHAR', l_parseKey, l_parseNum, l_dl_line_id_qry);
3044:
3045: l_dl_tmp_qry := 'SELECT count(*) from oe_order_lines_all '||
3046: 'WHERE header_id= :dl_header_id '||
3047: 'AND line_id NOT IN('||l_dl_line_id_qry||')';