APPS.MSC_ALLOCATION_PLAN dependencies on MSC_GET_NAME

Line 469: p_text := msc_get_name.customer(p_char1);

465:
466: if p_char1 = '-2' then -- null column
467: p_text := g_other_text;
468: elsif p_sequence = GY_CUSTOMER then
469: p_text := msc_get_name.customer(p_char1);
470: elsif p_sequence = GY_CUSTOMER_SITE then
471: p_text := msc_get_name.customer_site(p_char1);
472: elsif p_sequence in (8,9) then -- an org
473: p_text := msc_get_name.org_code(p_char1,p_sub_inst_id);

Line 471: p_text := msc_get_name.customer_site(p_char1);

467: p_text := g_other_text;
468: elsif p_sequence = GY_CUSTOMER then
469: p_text := msc_get_name.customer(p_char1);
470: elsif p_sequence = GY_CUSTOMER_SITE then
471: p_text := msc_get_name.customer_site(p_char1);
472: elsif p_sequence in (8,9) then -- an org
473: p_text := msc_get_name.org_code(p_char1,p_sub_inst_id);
474: if p_sequence = 8 then -- forecast without customer
475: p_text := p_text ||' - '||g_other_text;

Line 473: p_text := msc_get_name.org_code(p_char1,p_sub_inst_id);

469: p_text := msc_get_name.customer(p_char1);
470: elsif p_sequence = GY_CUSTOMER_SITE then
471: p_text := msc_get_name.customer_site(p_char1);
472: elsif p_sequence in (8,9) then -- an org
473: p_text := msc_get_name.org_code(p_char1,p_sub_inst_id);
474: if p_sequence = 8 then -- forecast without customer
475: p_text := p_text ||' - '||g_other_text;
476: end if;
477: elsif p_sequence = 1 then -- total

Line 899: p_org_code := msc_get_name.org_code(p_org_id, p_inst_id);

895: if p_org_id <> -1 then
896: sql_stmt := sql_stmt ||
897: ' and msi.sr_instance_id = :p_inst_id '||
898: ' and msi.organization_id = :p_org_list ';
899: p_org_code := msc_get_name.org_code(p_org_id, p_inst_id);
900: else -- item across all orgs
901: sql_stmt := sql_stmt ||
902: ' and -1 = :p_inst_id '||
903: ' and -1 = :p_org_list ';