eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_USER_SEC_ATTR_PVT dependencies on AK_QUERY_PKG

Line 450: ak_query_pkg.exec_query(

446: if l_customer_contact_id is not null
447: then
448: for s in cust_sec_attr loop
449:
450: ak_query_pkg.exec_query(
451: P_PARENT_REGION_APPL_ID => s.REGION_APPLICATION_ID,
452: P_PARENT_REGION_CODE => s.REGION_CODE,
453: P_WHERE_CLAUSE => 'CONTACT_ID = '||l_customer_contact_id,
454: P_RETURN_PARENTS => 'T',

Line 465: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

461: from AK_ATTRIBUTES
462: where ATTRIBUTE_CODE = s.ATTRIBUTE_CODE
463: and ATTRIBUTE_APPLICATION_ID = s.ATTRIBUTE_APPLICATION_ID;
464:
465: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
466: if l_data_type = 'NUMBER'
467: then
468: l_varchar2_value := '';
469: l_date_value := '';

Line 470: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);

466: if l_data_type = 'NUMBER'
467: then
468: l_varchar2_value := '';
469: l_date_value := '';
470: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);
471: elsif l_data_type = 'DATE'
472: then
473: l_varchar2_value := '';
474: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));

Line 474: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));

470: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);
471: elsif l_data_type = 'DATE'
472: then
473: l_varchar2_value := '';
474: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));
475: l_number_value := '';
476: else
477: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;
478: l_date_value := '';

Line 477: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;

473: l_varchar2_value := '';
474: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));
475: l_number_value := '';
476: else
477: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;
478: l_date_value := '';
479: l_number_value := '';
480: end if;
481:

Line 510: ak_query_pkg.exec_query(

506: if l_internal_contact_id is not null
507: then
508: for s in int_sec_attr loop
509:
510: ak_query_pkg.exec_query(
511: P_PARENT_REGION_APPL_ID => s.REGION_APPLICATION_ID,
512: P_PARENT_REGION_CODE => s.REGION_CODE,
513: P_WHERE_CLAUSE => 'CONTACT_ID = '||l_internal_contact_id,
514: P_RETURN_PARENTS => 'T',

Line 525: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

521: from AK_ATTRIBUTES
522: where ATTRIBUTE_CODE = s.ATTRIBUTE_CODE
523: and ATTRIBUTE_APPLICATION_ID = s.ATTRIBUTE_APPLICATION_ID;
524:
525: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
526: if l_data_type = 'NUMBER'
527: then
528: l_varchar2_value := '';
529: l_date_value := '';

Line 530: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);

526: if l_data_type = 'NUMBER'
527: then
528: l_varchar2_value := '';
529: l_date_value := '';
530: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);
531: elsif l_data_type = 'DATE'
532: then
533: l_varchar2_value := '';
534: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));

Line 534: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));

530: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);
531: elsif l_data_type = 'DATE'
532: then
533: l_varchar2_value := '';
534: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));
535: l_number_value := '';
536: else
537: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;
538: l_date_value := '';

Line 537: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;

533: l_varchar2_value := '';
534: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));
535: l_number_value := '';
536: else
537: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;
538: l_date_value := '';
539: l_number_value := '';
540: end if;
541:

Line 570: ak_query_pkg.exec_query(

566: if l_vendor_contact_id is not null
567: then
568: for s in supp_sec_attr loop
569:
570: ak_query_pkg.exec_query(
571: P_PARENT_REGION_APPL_ID => s.REGION_APPLICATION_ID,
572: P_PARENT_REGION_CODE => s.REGION_CODE,
573: P_WHERE_CLAUSE => 'CONTACT_ID = '||l_vendor_contact_id,
574: P_RETURN_PARENTS => 'T',

Line 585: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop

581: from AK_ATTRIBUTES
582: where ATTRIBUTE_CODE = s.ATTRIBUTE_CODE
583: and ATTRIBUTE_APPLICATION_ID = s.ATTRIBUTE_APPLICATION_ID;
584:
585: for r in ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST loop
586: if l_data_type = 'NUMBER'
587: then
588: l_varchar2_value := '';
589: l_date_value := '';

Line 590: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);

586: if l_data_type = 'NUMBER'
587: then
588: l_varchar2_value := '';
589: l_date_value := '';
590: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);
591: elsif l_data_type = 'DATE'
592: then
593: l_varchar2_value := '';
594: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));

Line 594: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));

590: l_number_value := to_number(ak_query_pkg.g_results_table(r).value1);
591: elsif l_data_type = 'DATE'
592: then
593: l_varchar2_value := '';
594: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));
595: l_number_value := '';
596: else
597: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;
598: l_date_value := '';

Line 597: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;

593: l_varchar2_value := '';
594: l_date_value := to_date(ak_query_pkg.g_results_table(r).value1,icx_sec.getID(icx_sec.PV_DATE_FORMAT));
595: l_number_value := '';
596: else
597: l_varchar2_value := ak_query_pkg.g_results_table(r).value1;
598: l_date_value := '';
599: l_number_value := '';
600: end if;
601: