499:
500: end loop;
501:
502: if (l_view_by = 'ORGANIZATION+JTF_ORG_SALES_GROUP') then
503: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_SALES_GROUP');
504: elsif (l_view_by = 'ISC_AGREEMENT_TYPE+ISC_AGREEMENT_TYPE') then
505: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_AGREEMENT_TYPE');
506: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
507: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUST_CLASS');
501:
502: if (l_view_by = 'ORGANIZATION+JTF_ORG_SALES_GROUP') then
503: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_SALES_GROUP');
504: elsif (l_view_by = 'ISC_AGREEMENT_TYPE+ISC_AGREEMENT_TYPE') then
505: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_AGREEMENT_TYPE');
506: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
507: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUST_CLASS');
508: elsif (l_view_by = 'CUSTOMER+FII_CUSTOMERS') then
509: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUSTOMER');
503: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_SALES_GROUP');
504: elsif (l_view_by = 'ISC_AGREEMENT_TYPE+ISC_AGREEMENT_TYPE') then
505: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_AGREEMENT_TYPE');
506: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
507: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUST_CLASS');
508: elsif (l_view_by = 'CUSTOMER+FII_CUSTOMERS') then
509: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUSTOMER');
510: end if;
511:
505: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_AGREEMENT_TYPE');
506: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
507: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUST_CLASS');
508: elsif (l_view_by = 'CUSTOMER+FII_CUSTOMERS') then
509: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE1_CUSTOMER');
510: end if;
511:
512: return l_title;
513:
528:
529: end loop;
530:
531: if (l_view_by = 'ORGANIZATION+JTF_ORG_SALES_GROUP') then
532: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_SALES_GROUP');
533: elsif (l_view_by = 'ISC_AGREEMENT_TYPE+ISC_AGREEMENT_TYPE') then
534: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_AGREEMENT_TYPE');
535: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
536: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUST_CLASS');
530:
531: if (l_view_by = 'ORGANIZATION+JTF_ORG_SALES_GROUP') then
532: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_SALES_GROUP');
533: elsif (l_view_by = 'ISC_AGREEMENT_TYPE+ISC_AGREEMENT_TYPE') then
534: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_AGREEMENT_TYPE');
535: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
536: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUST_CLASS');
537: elsif (l_view_by = 'CUSTOMER+FII_CUSTOMERS') then
538: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUSTOMER');
532: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_SALES_GROUP');
533: elsif (l_view_by = 'ISC_AGREEMENT_TYPE+ISC_AGREEMENT_TYPE') then
534: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_AGREEMENT_TYPE');
535: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
536: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUST_CLASS');
537: elsif (l_view_by = 'CUSTOMER+FII_CUSTOMERS') then
538: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUSTOMER');
539: end if;
540:
534: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_AGREEMENT_TYPE');
535: elsif (l_view_by = 'FII_TRADING_PARTNER_MKT_CLASS+FII_TRADING_PARTNER_MKT_CLASS') then
536: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUST_CLASS');
537: elsif (l_view_by = 'CUSTOMER+FII_CUSTOMERS') then
538: l_title := fnd_message.get_string('ISC','ISC_DBI_TITLE2_CUSTOMER');
539: end if;
540:
541: return l_title;
542: