APPS.MSC_ALLOCATION_PLAN dependencies on MSC_GET_NAME

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

455:
456: if p_char1 = '-2' then -- null column
457: p_text := g_other_text;
458: elsif p_sequence = GY_CUSTOMER then
459: p_text := msc_get_name.customer(p_char1);
460: elsif p_sequence = GY_CUSTOMER_SITE then
461: p_text := msc_get_name.customer_site(p_char1);
462: elsif p_sequence in (8,9) then -- an org
463: p_text := msc_get_name.org_code(p_char1,arg_instance_id);

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

457: p_text := g_other_text;
458: elsif p_sequence = GY_CUSTOMER then
459: p_text := msc_get_name.customer(p_char1);
460: elsif p_sequence = GY_CUSTOMER_SITE then
461: p_text := msc_get_name.customer_site(p_char1);
462: elsif p_sequence in (8,9) then -- an org
463: p_text := msc_get_name.org_code(p_char1,arg_instance_id);
464: if p_sequence = 8 then -- forecast without customer
465: p_text := p_text ||' - '||g_other_text;

Line 463: p_text := msc_get_name.org_code(p_char1,arg_instance_id);

459: p_text := msc_get_name.customer(p_char1);
460: elsif p_sequence = GY_CUSTOMER_SITE then
461: p_text := msc_get_name.customer_site(p_char1);
462: elsif p_sequence in (8,9) then -- an org
463: p_text := msc_get_name.org_code(p_char1,arg_instance_id);
464: if p_sequence = 8 then -- forecast without customer
465: p_text := p_text ||' - '||g_other_text;
466: end if;
467: elsif p_sequence = 1 then -- total

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

880: if p_org_id <> -1 then
881: sql_stmt := sql_stmt ||
882: ' and msi.sr_instance_id = :p_inst_id '||
883: ' and msi.organization_id = :p_org_list ';
884: p_org_code := msc_get_name.org_code(p_org_id, p_inst_id);
885: else -- item across all orgs
886: sql_stmt := sql_stmt ||
887: ' and -1 = :p_inst_id '||
888: ' and -1 = :p_org_list ';