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_REQ_ACCT_DIST dependencies on AK_QUERY_PKG

Line 466: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

462: htp.p('');
463: htp.br;
464: END IF; /* IF v_error_text */
465:
466: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
467: P_PARENT_REGION_CODE => v_distribution_header_region,
468: P_RESPONSIBILITY_ID => v_responsibility_id,
469: P_USER_ID => v_web_user_id,
470: P_WHERE_CLAUSE => v_where_clause,

Line 491: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

487: IF p_show_more_lines IS NOT NULL THEN
488:
489: /* If show more lines is clicked then get only the structure, no data
490: from AK. Set P_RETURN_PARENTS => 'F' */
491: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
492: P_PARENT_REGION_CODE => v_distribution_lines_region,
493: P_RESPONSIBILITY_ID => v_responsibility_id,
494: P_USER_ID => v_web_user_id,
495: P_WHERE_CLAUSE => v_where_clause,

Line 503: for j IN 0..ak_query_pkg.g_items_table.LAST LOOP

499: print_lines_header;
500:
501: -- determine if amount is ahead of quantity or quantity is ahead of amount
502: v_display_first := NULL;
503: for j IN 0..ak_query_pkg.g_items_table.LAST LOOP
504: if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' and
505: v_display_first is NULL then
506: v_display_first := 'ICX_PERCENTAGE';
507: exit;

Line 504: if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' and

500:
501: -- determine if amount is ahead of quantity or quantity is ahead of amount
502: v_display_first := NULL;
503: for j IN 0..ak_query_pkg.g_items_table.LAST LOOP
504: if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' and
505: v_display_first is NULL then
506: v_display_first := 'ICX_PERCENTAGE';
507: exit;
508: elsif ak_query_pkg.g_items_table(j).attribute_code = 'ICX_AMOUNT' and

Line 508: elsif ak_query_pkg.g_items_table(j).attribute_code = 'ICX_AMOUNT' and

504: if ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' and
505: v_display_first is NULL then
506: v_display_first := 'ICX_PERCENTAGE';
507: exit;
508: elsif ak_query_pkg.g_items_table(j).attribute_code = 'ICX_AMOUNT' and
509: v_display_first is NULL then
510: v_display_first := 'ICX_AMOUNT';
511: exit;
512: end if;

Line 525: FOR i IN 0 .. ak_query_pkg.g_items_table.LAST LOOP

521: FOR r IN 1 .. v_display_lines LOOP
522:
523: htp.p('');
524:
525: FOR i IN 0 .. ak_query_pkg.g_items_table.LAST LOOP
526: -- FOR i IN 1 .. ak_query_pkg.g_items_table.LAST LOOP
527:
528: v_value := NULL;
529:

Line 526: -- FOR i IN 1 .. ak_query_pkg.g_items_table.LAST LOOP

522:
523: htp.p('');
524:
525: FOR i IN 0 .. ak_query_pkg.g_items_table.LAST LOOP
526: -- FOR i IN 1 .. ak_query_pkg.g_items_table.LAST LOOP
527:
528: v_value := NULL;
529:
530: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 530: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

526: -- FOR i IN 1 .. ak_query_pkg.g_items_table.LAST LOOP
527:
528: v_value := NULL;
529:
530: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
531: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
532: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
533:
534: -- The condition icx_distribution_id.count >= r is required to

Line 531: AND ak_query_pkg.g_items_table(i).secured_column = 'F'

527:
528: v_value := NULL;
529:
530: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
531: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
532: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
533:
534: -- The condition icx_distribution_id.count >= r is required to
535: -- prevent a memory out of bound value.

Line 532: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN

528: v_value := NULL;
529:
530: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
531: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
532: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
533:
534: -- The condition icx_distribution_id.count >= r is required to
535: -- prevent a memory out of bound value.
536: -- The hidden values are returned only for those displayed in the

Line 540: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_ID' AND (icx_distribution_id.COUNT >= r) THEN

536: -- The hidden values are returned only for those displayed in the
537: -- browser. So if one distribution id is displayed as hidden value
538: -- the count will be 1. If 5 distribution ids are displayed as hidden
539: -- distribution count will be 5.
540: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_ID' AND (icx_distribution_id.COUNT >= r) THEN
541:
542: v_value := icx_distribution_id(r);
543: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
544: l_pos := l_pos + 1;

Line 543: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

539: -- distribution count will be 5.
540: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_ID' AND (icx_distribution_id.COUNT >= r) THEN
541:
542: v_value := icx_distribution_id(r);
543: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
544: l_pos := l_pos + 1;
545:
546: END IF; /* ICX_DISTRIBUTION_ID */
547: END IF; /* item_style = 'HIDDEN' */

Line 549: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

545:
546: END IF; /* ICX_DISTRIBUTION_ID */
547: END IF; /* item_style = 'HIDDEN' */
548:
549: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
550: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
551: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
552:
553:

Line 550: AND ak_query_pkg.g_items_table(i).secured_column = 'F'

546: END IF; /* ICX_DISTRIBUTION_ID */
547: END IF; /* item_style = 'HIDDEN' */
548:
549: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
550: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
551: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
552:
553:
554: IF r <= v_total_lines_entered THEN

Line 551: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

547: END IF; /* item_style = 'HIDDEN' */
548:
549: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
550: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
551: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
552:
553:
554: IF r <= v_total_lines_entered THEN
555: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

Line 555: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

551: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
552:
553:
554: IF r <= v_total_lines_entered THEN
555: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
556: v_value := icx_charge_acct_seg1(r);
557: ----------------------------------------------------------------
558: -- Note:
559: -- Get the display only segment value to populate the

Line 568: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN

564: -- This is done repeatedly in this loop rather than in a different
565: -- loop to avoid performance degradation. (avoding another loop!)
566: ----------------------------------------------------------------
567: v_charge_account_seg1 := icx_charge_acct_seg1(1);
568: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
569: v_value := icx_charge_acct_seg2(r);
570: v_charge_account_seg2 := icx_charge_acct_seg2(1);
571: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
572: v_value := icx_charge_acct_seg3(r);

Line 571: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

567: v_charge_account_seg1 := icx_charge_acct_seg1(1);
568: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
569: v_value := icx_charge_acct_seg2(r);
570: v_charge_account_seg2 := icx_charge_acct_seg2(1);
571: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
572: v_value := icx_charge_acct_seg3(r);
573: v_charge_account_seg3 := icx_charge_acct_seg3(1);
574: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
575: v_value := icx_charge_acct_seg4(r);

Line 574: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

570: v_charge_account_seg2 := icx_charge_acct_seg2(1);
571: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
572: v_value := icx_charge_acct_seg3(r);
573: v_charge_account_seg3 := icx_charge_acct_seg3(1);
574: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
575: v_value := icx_charge_acct_seg4(r);
576: v_charge_account_seg4 := icx_charge_acct_seg4(1);
577: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
578: v_value := icx_charge_acct_seg5(r);

Line 577: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

573: v_charge_account_seg3 := icx_charge_acct_seg3(1);
574: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
575: v_value := icx_charge_acct_seg4(r);
576: v_charge_account_seg4 := icx_charge_acct_seg4(1);
577: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
578: v_value := icx_charge_acct_seg5(r);
579: v_charge_account_seg5 := icx_charge_acct_seg5(1);
580: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
581: v_value := icx_charge_acct_seg6(r);

Line 580: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

576: v_charge_account_seg4 := icx_charge_acct_seg4(1);
577: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
578: v_value := icx_charge_acct_seg5(r);
579: v_charge_account_seg5 := icx_charge_acct_seg5(1);
580: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
581: v_value := icx_charge_acct_seg6(r);
582: v_charge_account_seg6 := icx_charge_acct_seg6(1);
583: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
584: v_value := icx_charge_acct_seg7(r);

Line 583: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

579: v_charge_account_seg5 := icx_charge_acct_seg5(1);
580: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
581: v_value := icx_charge_acct_seg6(r);
582: v_charge_account_seg6 := icx_charge_acct_seg6(1);
583: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
584: v_value := icx_charge_acct_seg7(r);
585: v_charge_account_seg7 := icx_charge_acct_seg7(1);
586: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
587: v_value := icx_charge_acct_seg8(r);

Line 586: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

582: v_charge_account_seg6 := icx_charge_acct_seg6(1);
583: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
584: v_value := icx_charge_acct_seg7(r);
585: v_charge_account_seg7 := icx_charge_acct_seg7(1);
586: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
587: v_value := icx_charge_acct_seg8(r);
588: v_charge_account_seg8 := icx_charge_acct_seg8(1);
589: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
590: v_value := icx_charge_acct_seg9(r);

Line 589: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

585: v_charge_account_seg7 := icx_charge_acct_seg7(1);
586: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
587: v_value := icx_charge_acct_seg8(r);
588: v_charge_account_seg8 := icx_charge_acct_seg8(1);
589: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
590: v_value := icx_charge_acct_seg9(r);
591: v_charge_account_seg9 := icx_charge_acct_seg9(1);
592: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
593: v_value := icx_charge_acct_seg10(r);

Line 592: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

588: v_charge_account_seg8 := icx_charge_acct_seg8(1);
589: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
590: v_value := icx_charge_acct_seg9(r);
591: v_charge_account_seg9 := icx_charge_acct_seg9(1);
592: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
593: v_value := icx_charge_acct_seg10(r);
594: v_charge_account_seg10 := icx_charge_acct_seg10(1);
595: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
596: v_value := icx_charge_acct_seg11(r);

Line 595: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

591: v_charge_account_seg9 := icx_charge_acct_seg9(1);
592: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
593: v_value := icx_charge_acct_seg10(r);
594: v_charge_account_seg10 := icx_charge_acct_seg10(1);
595: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
596: v_value := icx_charge_acct_seg11(r);
597: v_charge_account_seg11 := icx_charge_acct_seg11(1);
598: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
599: v_value := icx_charge_acct_seg12(r);

Line 598: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

594: v_charge_account_seg10 := icx_charge_acct_seg10(1);
595: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
596: v_value := icx_charge_acct_seg11(r);
597: v_charge_account_seg11 := icx_charge_acct_seg11(1);
598: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
599: v_value := icx_charge_acct_seg12(r);
600: v_charge_account_seg12 := icx_charge_acct_seg12(1);
601: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
602: v_value := icx_charge_acct_seg13(r);

Line 601: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

597: v_charge_account_seg11 := icx_charge_acct_seg11(1);
598: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
599: v_value := icx_charge_acct_seg12(r);
600: v_charge_account_seg12 := icx_charge_acct_seg12(1);
601: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
602: v_value := icx_charge_acct_seg13(r);
603: v_charge_account_seg13 := icx_charge_acct_seg13(1);
604: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
605: v_value := icx_charge_acct_seg14(r);

Line 604: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

600: v_charge_account_seg12 := icx_charge_acct_seg12(1);
601: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
602: v_value := icx_charge_acct_seg13(r);
603: v_charge_account_seg13 := icx_charge_acct_seg13(1);
604: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
605: v_value := icx_charge_acct_seg14(r);
606: v_charge_account_seg14 := icx_charge_acct_seg14(1);
607: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
608: v_value := icx_charge_acct_seg15(r);

Line 607: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

603: v_charge_account_seg13 := icx_charge_acct_seg13(1);
604: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
605: v_value := icx_charge_acct_seg14(r);
606: v_charge_account_seg14 := icx_charge_acct_seg14(1);
607: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
608: v_value := icx_charge_acct_seg15(r);
609: v_charge_account_seg15 := icx_charge_acct_seg15(1);
610: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
611: v_value := icx_charge_acct_seg16(r);

Line 610: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

606: v_charge_account_seg14 := icx_charge_acct_seg14(1);
607: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
608: v_value := icx_charge_acct_seg15(r);
609: v_charge_account_seg15 := icx_charge_acct_seg15(1);
610: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
611: v_value := icx_charge_acct_seg16(r);
612: v_charge_account_seg16 := icx_charge_acct_seg16(1);
613: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
614: v_value := icx_charge_acct_seg17(r);

Line 613: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

609: v_charge_account_seg15 := icx_charge_acct_seg15(1);
610: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
611: v_value := icx_charge_acct_seg16(r);
612: v_charge_account_seg16 := icx_charge_acct_seg16(1);
613: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
614: v_value := icx_charge_acct_seg17(r);
615: v_charge_account_seg17 := icx_charge_acct_seg17(1);
616: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
617: v_value := icx_charge_acct_seg18(r);

Line 616: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

612: v_charge_account_seg16 := icx_charge_acct_seg16(1);
613: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
614: v_value := icx_charge_acct_seg17(r);
615: v_charge_account_seg17 := icx_charge_acct_seg17(1);
616: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
617: v_value := icx_charge_acct_seg18(r);
618: v_charge_account_seg18 := icx_charge_acct_seg18(1);
619: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
620: v_value := icx_charge_acct_seg19(r);

Line 619: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

615: v_charge_account_seg17 := icx_charge_acct_seg17(1);
616: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
617: v_value := icx_charge_acct_seg18(r);
618: v_charge_account_seg18 := icx_charge_acct_seg18(1);
619: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
620: v_value := icx_charge_acct_seg19(r);
621: v_charge_account_seg19 := icx_charge_acct_seg19(1);
622: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
623: v_value := icx_charge_acct_seg20(r);

Line 622: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

618: v_charge_account_seg18 := icx_charge_acct_seg18(1);
619: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
620: v_value := icx_charge_acct_seg19(r);
621: v_charge_account_seg19 := icx_charge_acct_seg19(1);
622: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
623: v_value := icx_charge_acct_seg20(r);
624: v_charge_account_seg20 := icx_charge_acct_seg20(1);
625: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
626: v_value := icx_charge_acct_seg21(r);

Line 625: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

621: v_charge_account_seg19 := icx_charge_acct_seg19(1);
622: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
623: v_value := icx_charge_acct_seg20(r);
624: v_charge_account_seg20 := icx_charge_acct_seg20(1);
625: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
626: v_value := icx_charge_acct_seg21(r);
627: v_charge_account_seg21 := icx_charge_acct_seg21(1);
628: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
629: v_value := icx_charge_acct_seg22(r);

Line 628: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

624: v_charge_account_seg20 := icx_charge_acct_seg20(1);
625: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
626: v_value := icx_charge_acct_seg21(r);
627: v_charge_account_seg21 := icx_charge_acct_seg21(1);
628: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
629: v_value := icx_charge_acct_seg22(r);
630: v_charge_account_seg22 := icx_charge_acct_seg22(1);
631: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
632: v_value := icx_charge_acct_seg23(r);

Line 631: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

627: v_charge_account_seg21 := icx_charge_acct_seg21(1);
628: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
629: v_value := icx_charge_acct_seg22(r);
630: v_charge_account_seg22 := icx_charge_acct_seg22(1);
631: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
632: v_value := icx_charge_acct_seg23(r);
633: v_charge_account_seg23 := icx_charge_acct_seg23(1);
634: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
635: v_value := icx_charge_acct_seg24(r);

Line 634: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

630: v_charge_account_seg22 := icx_charge_acct_seg22(1);
631: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
632: v_value := icx_charge_acct_seg23(r);
633: v_charge_account_seg23 := icx_charge_acct_seg23(1);
634: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
635: v_value := icx_charge_acct_seg24(r);
636: v_charge_account_seg24 := icx_charge_acct_seg24(1);
637: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
638: v_value := icx_charge_acct_seg25(r);

Line 637: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

633: v_charge_account_seg23 := icx_charge_acct_seg23(1);
634: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
635: v_value := icx_charge_acct_seg24(r);
636: v_charge_account_seg24 := icx_charge_acct_seg24(1);
637: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
638: v_value := icx_charge_acct_seg25(r);
639: v_charge_account_seg25 := icx_charge_acct_seg25(1);
640: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
641: v_value := icx_charge_acct_seg26(r);

Line 640: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

636: v_charge_account_seg24 := icx_charge_acct_seg24(1);
637: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
638: v_value := icx_charge_acct_seg25(r);
639: v_charge_account_seg25 := icx_charge_acct_seg25(1);
640: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
641: v_value := icx_charge_acct_seg26(r);
642: v_charge_account_seg26 := icx_charge_acct_seg26(1);
643: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
644: v_value := icx_charge_acct_seg27(r);

Line 643: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

639: v_charge_account_seg25 := icx_charge_acct_seg25(1);
640: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
641: v_value := icx_charge_acct_seg26(r);
642: v_charge_account_seg26 := icx_charge_acct_seg26(1);
643: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
644: v_value := icx_charge_acct_seg27(r);
645: v_charge_account_seg27 := icx_charge_acct_seg27(1);
646: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
647: v_value := icx_charge_acct_seg28(r);

Line 646: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

642: v_charge_account_seg26 := icx_charge_acct_seg26(1);
643: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
644: v_value := icx_charge_acct_seg27(r);
645: v_charge_account_seg27 := icx_charge_acct_seg27(1);
646: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
647: v_value := icx_charge_acct_seg28(r);
648: v_charge_account_seg28 := icx_charge_acct_seg28(1);
649: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
650: v_value := icx_charge_acct_seg29(r);

Line 649: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

645: v_charge_account_seg27 := icx_charge_acct_seg27(1);
646: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
647: v_value := icx_charge_acct_seg28(r);
648: v_charge_account_seg28 := icx_charge_acct_seg28(1);
649: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
650: v_value := icx_charge_acct_seg29(r);
651: v_charge_account_seg29 := icx_charge_acct_seg29(1);
652: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
653: v_value := icx_charge_acct_seg30(r);

Line 652: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

648: v_charge_account_seg28 := icx_charge_acct_seg28(1);
649: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
650: v_value := icx_charge_acct_seg29(r);
651: v_charge_account_seg29 := icx_charge_acct_seg29(1);
652: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
653: v_value := icx_charge_acct_seg30(r);
654: v_charge_account_seg30 := icx_charge_acct_seg30(1);
655: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_NUM' THEN
656: v_value := icx_charge_account_num(r);

Line 655: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_NUM' THEN

651: v_charge_account_seg29 := icx_charge_acct_seg29(1);
652: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
653: v_value := icx_charge_acct_seg30(r);
654: v_charge_account_seg30 := icx_charge_acct_seg30(1);
655: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_NUM' THEN
656: v_value := icx_charge_account_num(r);
657: v_charge_account_num := icx_charge_account_num(1);
658: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
659: v_value := icx_percentage(r);

Line 658: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN

654: v_charge_account_seg30 := icx_charge_acct_seg30(1);
655: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_NUM' THEN
656: v_value := icx_charge_account_num(r);
657: v_charge_account_num := icx_charge_account_num(1);
658: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
659: v_value := icx_percentage(r);
660: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN
661: v_value := icx_amount(r);
662: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_NUM' THEN

Line 660: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN

656: v_value := icx_charge_account_num(r);
657: v_charge_account_num := icx_charge_account_num(1);
658: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
659: v_value := icx_percentage(r);
660: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN
661: v_value := icx_amount(r);
662: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_NUM' THEN
663: v_value := icx_distribution_num(r);
664: END IF; /* ak_query_pkg. ... ICX_ ... */

Line 662: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_NUM' THEN

658: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
659: v_value := icx_percentage(r);
660: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN
661: v_value := icx_amount(r);
662: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_NUM' THEN
663: v_value := icx_distribution_num(r);
664: END IF; /* ak_query_pkg. ... ICX_ ... */
665: ELSE
666: v_value := NULL;

Line 664: END IF; /* ak_query_pkg. ... ICX_ ... */

660: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN
661: v_value := icx_amount(r);
662: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DISTRIBUTION_NUM' THEN
663: v_value := icx_distribution_num(r);
664: END IF; /* ak_query_pkg. ... ICX_ ... */
665: ELSE
666: v_value := NULL;
667: END IF; /* i < v_total_lines_entered */
668:

Line 669: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN

665: ELSE
666: v_value := NULL;
667: END IF; /* i < v_total_lines_entered */
668:
669: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
670: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
671: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN
672: htp.tableData(cvalue => '', crowspan => 1);

Line 670: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN

666: v_value := NULL;
667: END IF; /* i < v_total_lines_entered */
668:
669: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
670: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
671: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN
672: htp.tableData(cvalue => '', crowspan => 1);
674: ELSE

Line 671: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN

667: END IF; /* i < v_total_lines_entered */
668:
669: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
670: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
671: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN
672: htp.tableData(cvalue => '', crowspan => 1);
674: ELSE
675: htp.tableData(cvalue => '', crowspan => 1);
674: ELSE
675: htp.tableData(cvalue => '', crowspan => 1);

Line 675: htp.tableData(cvalue => '', crowspan => 1);
674: ELSE
675: htp.tableData(cvalue => '', crowspan => 1);
677: END IF;
678:
679: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN

Line 679: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN

675: htp.tableData(cvalue => '', crowspan => 1);
677: END IF;
678:
679: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN
680: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN
681: htp.tableData(cvalue => '', crowspan => 1);
683: ELSE

Line 680: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN

676: ||'" onChange=''if(!checkNumber(this)) { this.focus(); this.value="";} else {roundDecimals(this, 5); set_amount(' || to_char(l_pos) || ',this.value,' || v_extended_price || ',1);}''>', crowspan => 1);
677: END IF;
678:
679: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' THEN
680: IF v_display_first = ak_query_pkg.g_items_table(i).attribute_code THEN
681: htp.tableData(cvalue => '', crowspan => 1);
683: ELSE
684: htp.tableData(cvalue => '', crowspan => 1);
683: ELSE
684: htp.tableData(cvalue => '', crowspan => 1);

Line 684: htp.tableData(cvalue => '', crowspan => 1);
683: ELSE
684: htp.tableData(cvalue => '', crowspan => 1);
686: END IF;
687: ELSE
688: htp.tableData(cvalue => '', crowspan => 1);
686: END IF;
687: ELSE
688: htp.tableData(cvalue => '', crowspan => 1);
690: END IF;
691:
692: l_pos := l_pos + 1;

Line 696: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

692: l_pos := l_pos + 1;
693: ELSE
694: -- Print for display only; pass that as a hidden value
695:
696: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
697: v_value := v_charge_account_seg1;
698: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
699: v_value := v_charge_account_seg2;
700: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

Line 698: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN

694: -- Print for display only; pass that as a hidden value
695:
696: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
697: v_value := v_charge_account_seg1;
698: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
699: v_value := v_charge_account_seg2;
700: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
701: v_value := v_charge_account_seg3;
702: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

Line 700: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

696: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
697: v_value := v_charge_account_seg1;
698: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
699: v_value := v_charge_account_seg2;
700: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
701: v_value := v_charge_account_seg3;
702: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
703: v_value := v_charge_account_seg4;
704: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

Line 702: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

698: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
699: v_value := v_charge_account_seg2;
700: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
701: v_value := v_charge_account_seg3;
702: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
703: v_value := v_charge_account_seg4;
704: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
705: v_value := v_charge_account_seg5;
706: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

Line 704: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

700: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
701: v_value := v_charge_account_seg3;
702: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
703: v_value := v_charge_account_seg4;
704: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
705: v_value := v_charge_account_seg5;
706: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
707: v_value := v_charge_account_seg6;
708: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

Line 706: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

702: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
703: v_value := v_charge_account_seg4;
704: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
705: v_value := v_charge_account_seg5;
706: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
707: v_value := v_charge_account_seg6;
708: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
709: v_value := v_charge_account_seg7;
710: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

Line 708: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

704: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
705: v_value := v_charge_account_seg5;
706: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
707: v_value := v_charge_account_seg6;
708: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
709: v_value := v_charge_account_seg7;
710: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
711: v_value := v_charge_account_seg8;
712: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

Line 710: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

706: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
707: v_value := v_charge_account_seg6;
708: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
709: v_value := v_charge_account_seg7;
710: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
711: v_value := v_charge_account_seg8;
712: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
713: v_value := v_charge_account_seg9;
714: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

Line 712: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

708: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
709: v_value := v_charge_account_seg7;
710: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
711: v_value := v_charge_account_seg8;
712: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
713: v_value := v_charge_account_seg9;
714: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
715: v_value := v_charge_account_seg10;
716: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

Line 714: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

710: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
711: v_value := v_charge_account_seg8;
712: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
713: v_value := v_charge_account_seg9;
714: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
715: v_value := v_charge_account_seg10;
716: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
717: v_value := v_charge_account_seg11;
718: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

Line 716: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

712: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
713: v_value := v_charge_account_seg9;
714: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
715: v_value := v_charge_account_seg10;
716: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
717: v_value := v_charge_account_seg11;
718: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
719: v_value := v_charge_account_seg12;
720: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

Line 718: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

714: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
715: v_value := v_charge_account_seg10;
716: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
717: v_value := v_charge_account_seg11;
718: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
719: v_value := v_charge_account_seg12;
720: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
721: v_value := v_charge_account_seg13;
722: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

Line 720: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

716: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
717: v_value := v_charge_account_seg11;
718: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
719: v_value := v_charge_account_seg12;
720: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
721: v_value := v_charge_account_seg13;
722: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
723: v_value := v_charge_account_seg14;
724: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

Line 722: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

718: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
719: v_value := v_charge_account_seg12;
720: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
721: v_value := v_charge_account_seg13;
722: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
723: v_value := v_charge_account_seg14;
724: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
725: v_value := v_charge_account_seg15;
726: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

Line 724: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

720: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
721: v_value := v_charge_account_seg13;
722: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
723: v_value := v_charge_account_seg14;
724: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
725: v_value := v_charge_account_seg15;
726: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
727: v_value := v_charge_account_seg16;
728: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

Line 726: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

722: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
723: v_value := v_charge_account_seg14;
724: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
725: v_value := v_charge_account_seg15;
726: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
727: v_value := v_charge_account_seg16;
728: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
729: v_value := v_charge_account_seg17;
730: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

Line 728: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

724: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
725: v_value := v_charge_account_seg15;
726: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
727: v_value := v_charge_account_seg16;
728: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
729: v_value := v_charge_account_seg17;
730: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
731: v_value := v_charge_account_seg18;
732: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

Line 730: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

726: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
727: v_value := v_charge_account_seg16;
728: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
729: v_value := v_charge_account_seg17;
730: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
731: v_value := v_charge_account_seg18;
732: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
733: v_value := v_charge_account_seg19;
734: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

Line 732: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

728: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
729: v_value := v_charge_account_seg17;
730: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
731: v_value := v_charge_account_seg18;
732: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
733: v_value := v_charge_account_seg19;
734: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
735: v_value := v_charge_account_seg20;
736: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

Line 734: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

730: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
731: v_value := v_charge_account_seg18;
732: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
733: v_value := v_charge_account_seg19;
734: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
735: v_value := v_charge_account_seg20;
736: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
737: v_value := v_charge_account_seg21;
738: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

Line 736: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

732: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
733: v_value := v_charge_account_seg19;
734: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
735: v_value := v_charge_account_seg20;
736: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
737: v_value := v_charge_account_seg21;
738: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
739: v_value := v_charge_account_seg22;
740: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

Line 738: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

734: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
735: v_value := v_charge_account_seg20;
736: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
737: v_value := v_charge_account_seg21;
738: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
739: v_value := v_charge_account_seg22;
740: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
741: v_value := v_charge_account_seg23;
742: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

Line 740: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

736: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
737: v_value := v_charge_account_seg21;
738: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
739: v_value := v_charge_account_seg22;
740: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
741: v_value := v_charge_account_seg23;
742: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
743: v_value := v_charge_account_seg24;
744: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

Line 742: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

738: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
739: v_value := v_charge_account_seg22;
740: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
741: v_value := v_charge_account_seg23;
742: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
743: v_value := v_charge_account_seg24;
744: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
745: v_value := v_charge_account_seg25;
746: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

Line 744: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

740: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
741: v_value := v_charge_account_seg23;
742: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
743: v_value := v_charge_account_seg24;
744: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
745: v_value := v_charge_account_seg25;
746: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
747: v_value := v_charge_account_seg26;
748: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

Line 746: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

742: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
743: v_value := v_charge_account_seg24;
744: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
745: v_value := v_charge_account_seg25;
746: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
747: v_value := v_charge_account_seg26;
748: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
749: v_value := v_charge_account_seg27;
750: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

Line 748: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

744: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
745: v_value := v_charge_account_seg25;
746: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
747: v_value := v_charge_account_seg26;
748: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
749: v_value := v_charge_account_seg27;
750: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
751: v_value := v_charge_account_seg28;
752: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

Line 750: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

746: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
747: v_value := v_charge_account_seg26;
748: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
749: v_value := v_charge_account_seg27;
750: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
751: v_value := v_charge_account_seg28;
752: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
753: v_value := v_charge_account_seg29;
754: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

Line 752: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

748: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
749: v_value := v_charge_account_seg27;
750: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
751: v_value := v_charge_account_seg28;
752: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
753: v_value := v_charge_account_seg29;
754: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
755: v_value := v_charge_account_seg30;
756: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCOUNT_NUM' THEN

Line 754: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

750: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
751: v_value := v_charge_account_seg28;
752: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
753: v_value := v_charge_account_seg29;
754: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
755: v_value := v_charge_account_seg30;
756: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCOUNT_NUM' THEN
757: v_value := v_charge_account_num;
758: END IF; /* ak.. attribute_code = 'ICX_...' /

Line 756: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCOUNT_NUM' THEN

752: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
753: v_value := v_charge_account_seg29;
754: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
755: v_value := v_charge_account_seg30;
756: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCOUNT_NUM' THEN
757: v_value := v_charge_account_num;
758: END IF; / ak.. attribute_code = 'ICX_...' /
759:
760: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

Line 760: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

756: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCOUNT_NUM' THEN
757: v_value := v_charge_account_num;
758: END IF; / ak.. attribute_code = 'ICX_...' /
759:
760: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
761: l_pos := l_pos + 1;
762:
763: IF v_value IS NULL THEN
764: htp.tableData(cvalue => ' ', crowspan => 1);

Line 781: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

777: END LOOP; / FOR 1 .. v_display_lines /
778:
779: ELSE
780: / get the data from AK /
781: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
782: P_PARENT_REGION_CODE => v_distribution_lines_region,
783: P_RESPONSIBILITY_ID => v_responsibility_id,
784: P_USER_ID => v_web_user_id,
785: P_WHERE_CLAUSE => v_where_clause,

Line 795: v_rows_returned := ak_query_pkg.g_results_table.count;

791: -- icx_on_utilities2.printPLSQLtables;
792:
793: print_lines_header;
794:
795: v_rows_returned := ak_query_pkg.g_results_table.count;
796:
797: IF (v_rows_returned >= v_fixed_line_count) THEN
798: v_display_lines := v_rows_returned + v_fixed_line_count;
799: ELSE

Line 801: END IF; / if ak_query_pkg.g_result_table.count ... */

797: IF (v_rows_returned >= v_fixed_line_count) THEN
798: v_display_lines := v_rows_returned + v_fixed_line_count;
799: ELSE
800: v_display_lines := v_fixed_line_count;
**801: END IF; /* if ak_query_pkg.g_result_table.count ... */
802:
803: -- determine if amount is ahead of quantity or quantity is ahead of amount
804: v_display_first := NULL;
805:

Line 806: FOR j IN 0..ak_query_pkg.g_items_table.LAST LOOP

802:
803: -- determine if amount is ahead of quantity or quantity is ahead of amount
804: v_display_first := NULL;
805:
806: FOR j IN 0..ak_query_pkg.g_items_table.LAST LOOP
807: IF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' AND
808: v_display_first is NULL THEN
809: v_display_first := 'ICX_PERCENTAGE';
810: EXIT;

Line 807: IF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' AND

803: -- determine if amount is ahead of quantity or quantity is ahead of amount
804: v_display_first := NULL;
805:
806: FOR j IN 0..ak_query_pkg.g_items_table.LAST LOOP
807: IF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' AND
808: v_display_first is NULL THEN
809: v_display_first := 'ICX_PERCENTAGE';
810: EXIT;
811: ELSIF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_AMOUNT' AND

Line 811: ELSIF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_AMOUNT' AND

807: IF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_PERCENTAGE' AND
808: v_display_first is NULL THEN
809: v_display_first := 'ICX_PERCENTAGE';
810: EXIT;
811: ELSIF ak_query_pkg.g_items_table(j).attribute_code = 'ICX_AMOUNT' AND
812: v_display_first is NULL THEN
813: v_display_first := 'ICX_AMOUNT';
814: EXIT;
815: END IF;

Line 819: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP

815: END IF;
816: END LOOP;
817:
818: IF v_rows_returned > 0 THEN
819: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
820:
821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
822:
823: htp.p('');

Line 821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

817:
818: IF v_rows_returned > 0 THEN
819: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
820:
821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
822:
823: htp.p('');
824:
825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP

Line 825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP

821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
822:
823: htp.p('');
824:
825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
826:
827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN

Line 827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

823: htp.p('');
824:
825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
826:
827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
830:
831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

Line 828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'

824:
825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
826:
827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
830:
831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
832: l_pos := l_pos + 1;

Line 829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN

825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
826:
827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
830:
831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
832: l_pos := l_pos + 1;
833: END IF;

Line 831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

827: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
828: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
829: AND ak_query_pkg.g_items_table(i).item_style = 'HIDDEN' THEN
830:
831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
832: l_pos := l_pos + 1;
833: END IF;
834:
835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

831: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
832: l_pos := l_pos + 1;
833: END IF;
834:
835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
836: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
837: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
838:
839: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE'

Line 836: AND ak_query_pkg.g_items_table(i).secured_column = 'F'

832: l_pos := l_pos + 1;
833: END IF;
834:
835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
836: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
837: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
838:
839: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE'
840: THEN

Line 837: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

833: END IF;
834:
835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
836: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
837: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
838:
839: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE'
840: THEN
841: v_percentage_value := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 839: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE'

835: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
836: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
837: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
838:
839: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE'**
840: THEN
841: v_percentage_value := l_values(ak_query_pkg.g_items_table(i).value_id);
842: END IF; /* ICX_PERCENTAGE /
843:

Line 841: v_percentage_value := l_values(ak_query_pkg.g_items_table(i).value_id);

837: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
838:
839: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE'
840: THEN
841: v_percentage_value := l_values(ak_query_pkg.g_items_table(i).value_id);
842: END IF; / ICX_PERCENTAGE /
843:
844: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT'
845: THEN

Line 844: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT'

840: THEN
841: v_percentage_value := l_values(ak_query_pkg.g_items_table(i).value_id);
842: END IF; / ICX_PERCENTAGE /
843:
844: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT'
845: THEN
846: / aahmad 1/28/98: Changed from ROUND to TO_CHAR. Bug no. 585194 /
847: / v_value := ROUND(v_extended_price * (v_percentage_value/100), 2); /
848: v_value := TO_CHAR(v_extended_price (v_percentage_value/100), 'FM99999999999999999999999999999999999990D00');

Line 850: v_value := l_values(ak_query_pkg.g_items_table(i).value_id);

846: /* aahmad 1/28/98: Changed from ROUND to TO_CHAR. Bug no. 585194 /
847: / v_value := ROUND(v_extended_price * (v_percentage_value/100), 2); /
848: v_value := TO_CHAR(v_extended_price (v_percentage_value/100), 'FM99999999999999999999999999999999999990D00');
849: ELSE
850: v_value := l_values(ak_query_pkg.g_items_table(i).value_id);
851: END IF;
852:
853: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
854: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then

Line 853: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN

849: ELSE
850: v_value := l_values(ak_query_pkg.g_items_table(i).value_id);
851: END IF;
852:
853: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
854: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then
855: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
856: htp.tableData(cvalue => '', crowspan => 1);

Line 854: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then

850: v_value := l_values(ak_query_pkg.g_items_table(i).value_id);
851: END IF;
852:
853: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
854: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then
855: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
856: htp.tableData(cvalue => '', crowspan => 1);
858: else

Line 855: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then

851: END IF;
852:
853: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
854: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then
855: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
856: htp.tableData(cvalue => '', crowspan => 1);
858: else
859: htp.tableData(cvalue => '', crowspan => 1);
858: else
859: htp.tableData(cvalue => '', crowspan => 1);

Line 859: htp.tableData(cvalue => '', crowspan => 1);
858: else
859: htp.tableData(cvalue => '', crowspan => 1);
861: end if;
862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then

Line 862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then

858: else
859: htp.tableData(cvalue => '', crowspan => 1);
861: end if;
862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
864: htp.tableData(cvalue => '', crowspan => 1);
866: else

Line 863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then

859: htp.tableData(cvalue => '', crowspan => 1);
861: end if;
862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
864: htp.tableData(cvalue => '', crowspan => 1);
866: else
867: htp.tableData(cvalue => '', crowspan => 1);
861: end if;
862: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
863: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
864: htp.tableData(cvalue => '', crowspan => 1);
866: else
867: htp.tableData(cvalue => '', crowspan => 1);

Line 867: htp.tableData(cvalue => '', crowspan => 1);
866: else
867: htp.tableData(cvalue => '', crowspan => 1);
869: end if;
870: else
871: htp.tableData(cvalue => '', crowspan => 1);
869: end if;
870: else
871: htp.tableData(cvalue => '', crowspan => 1);
873: end if;
874:
875: l_pos := l_pos + 1;

Line 878: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));

874:
875: l_pos := l_pos + 1;
876:
877: ELSE
878: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
879: l_pos := l_pos + 1;
880: -- Print as display only pass that data as hidden
881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);
882:

Line 881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);

877: ELSE
878: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'));
879: l_pos := l_pos + 1;
880: -- Print as display only pass that data as hidden
881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);
882:
883: -- capture the value to be used as hidden fields later for
884: -- blank lines
885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

Line 885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

881: htp.tableData(cvalue => replace(l_values(ak_query_pkg.g_items_table(i).value_id),'"','"'), crowspan => 1);
882:
883: -- capture the value to be used as hidden fields later for
884: -- blank lines
885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);
887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

Line 886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);

882:
883: -- capture the value to be used as hidden fields later for
884: -- blank lines
885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);
887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN

883: -- capture the value to be used as hidden fields later for
884: -- blank lines
885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);
887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

Line 888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);

884: -- blank lines
885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);
887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

885: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);
887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

Line 890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);

886: v_charge_account_seg1 := l_values(ak_query_pkg.g_items_table(i).value_id);
887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

887: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

Line 892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);

888: v_charge_account_seg2 := l_values(ak_query_pkg.g_items_table(i).value_id);
889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

889: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

Line 894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);

890: v_charge_account_seg3 := l_values(ak_query_pkg.g_items_table(i).value_id);
891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

891: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

Line 896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);

892: v_charge_account_seg4 := l_values(ak_query_pkg.g_items_table(i).value_id);
893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

893: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

Line 898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);

894: v_charge_account_seg5 := l_values(ak_query_pkg.g_items_table(i).value_id);
895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

895: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

Line 900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);

896: v_charge_account_seg6 := l_values(ak_query_pkg.g_items_table(i).value_id);
897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

897: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

Line 902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);

898: v_charge_account_seg7 := l_values(ak_query_pkg.g_items_table(i).value_id);
899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

899: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

Line 904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);

900: v_charge_account_seg8 := l_values(ak_query_pkg.g_items_table(i).value_id);
901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

901: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

Line 906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);

902: v_charge_account_seg9 := l_values(ak_query_pkg.g_items_table(i).value_id);
903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

903: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

Line 908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);

904: v_charge_account_seg10 := l_values(ak_query_pkg.g_items_table(i).value_id);
905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

905: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

Line 910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);

906: v_charge_account_seg11 := l_values(ak_query_pkg.g_items_table(i).value_id);
907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

907: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

Line 912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);

908: v_charge_account_seg12 := l_values(ak_query_pkg.g_items_table(i).value_id);
909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

909: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

Line 914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);

910: v_charge_account_seg13 := l_values(ak_query_pkg.g_items_table(i).value_id);
911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

911: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

Line 916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);

912: v_charge_account_seg14 := l_values(ak_query_pkg.g_items_table(i).value_id);
913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

913: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

Line 918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);

914: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

915: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

Line 920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);

916: v_charge_account_seg16 := l_values(ak_query_pkg.g_items_table(i).value_id);
917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

917: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

Line 922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);

918: v_charge_account_seg17 := l_values(ak_query_pkg.g_items_table(i).value_id);
919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

919: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

Line 924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);

920: v_charge_account_seg18 := l_values(ak_query_pkg.g_items_table(i).value_id);
921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

921: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

Line 926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);

922: v_charge_account_seg19 := l_values(ak_query_pkg.g_items_table(i).value_id);
923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

923: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

Line 928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);

924: v_charge_account_seg20 := l_values(ak_query_pkg.g_items_table(i).value_id);
925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

925: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

Line 930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);

926: v_charge_account_seg21 := l_values(ak_query_pkg.g_items_table(i).value_id);
927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

927: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

Line 932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);

928: v_charge_account_seg22 := l_values(ak_query_pkg.g_items_table(i).value_id);
929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

929: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

Line 934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);

930: v_charge_account_seg23 := l_values(ak_query_pkg.g_items_table(i).value_id);
931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

931: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

Line 936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);

932: v_charge_account_seg24 := l_values(ak_query_pkg.g_items_table(i).value_id);
933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

933: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

Line 938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);

934: v_charge_account_seg25 := l_values(ak_query_pkg.g_items_table(i).value_id);
935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

935: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);
943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

Line 940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);

936: v_charge_account_seg26 := l_values(ak_query_pkg.g_items_table(i).value_id);
937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);
943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
944: v_charge_account_seg30 := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

937: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);
943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
944: v_charge_account_seg30 := l_values(ak_query_pkg.g_items_table(i).value_id);
945:

Line 942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);

938: v_charge_account_seg27 := l_values(ak_query_pkg.g_items_table(i).value_id);
939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);
943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
944: v_charge_account_seg30 := l_values(ak_query_pkg.g_items_table(i).value_id);
945:
946: END IF; /* ak.. attribute_code = 'ICX_...' /

Line 943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

939: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);
943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
944: v_charge_account_seg30 := l_values(ak_query_pkg.g_items_table(i).value_id);
945:
946: END IF; / ak.. attribute_code = 'ICX_...' /
947:

Line 944: v_charge_account_seg30 := l_values(ak_query_pkg.g_items_table(i).value_id);

940: v_charge_account_seg28 := l_values(ak_query_pkg.g_items_table(i).value_id);
941: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
942: v_charge_account_seg29 := l_values(ak_query_pkg.g_items_table(i).value_id);
943: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
944: v_charge_account_seg30 := l_values(ak_query_pkg.g_items_table(i).value_id);
945:
946: END IF; / ak.. attribute_code = 'ICX_...' /
947:
948: END IF; / update_flag = 'Y' /

Line 965: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP

961: FOR r IN v_rows_returned + 1 .. v_display_lines LOOP
962:
963: htp.p('');
964:
965: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
966:
967: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
968: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
969: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

Line 967: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

963: htp.p('');
964:
965: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
966:
967: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
968: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
969: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
970:
971: v_value := NULL;

Line 968: AND ak_query_pkg.g_items_table(i).secured_column = 'F'

964:
965: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
966:
967: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
968: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
969: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
970:
971: v_value := NULL;
972:

Line 969: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

965: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP
966:
967: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
968: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
969: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
970:
971: v_value := NULL;
972:
973: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN

Line 973: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN

969: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
970:
971: v_value := NULL;
972:
973: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
974: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then
975:
976: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
977:

Line 974: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then

970:
971: v_value := NULL;
972:
973: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
974: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then
975:
976: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
977:
978:

Line 976: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then

972:
973: IF ak_query_pkg.g_items_table(i).update_flag = 'Y' THEN
974: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' then
975:
976: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
977:
978:
979: htp.tableData(cvalue => '', crowspan => 1);

Line 979: htp.tableData(cvalue => '', crowspan => 1);
981:
982: else
983:

Line 984: htp.tableData(cvalue => '', crowspan => 1);
981:
982: else
983:
984: htp.tableData(cvalue => '', crowspan => 1);
986:
987:
988: end if;

Line 990: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then

986:
987:
988: end if;
989:
990: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_AMOUNT' then
991:
992: if v_display_first = ak_query_pkg.g_items_table(i).attribute_code then
993:
994: htp.tableData(cvalue => '', crowspan => 1);
996:

Line 994: htp.tableData(cvalue => '', crowspan => 1);
996:
997:
998: else

Line 1002: htp.tableData(cvalue => '', crowspan => 1);
1004:
1005:
1006: end if;

Line 1009: -- htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);

1006: end if;
1007:
1008: else
1009: -- htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);

Line 1011: -- htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1015: end if;

Line 1012: -- ' SIZE=' || ak_query_pkg.g_items_table(i).display_value_length || ' VALUE = "'|| v_value ||'">', crowspan => 1);

1008: else
1009: -- htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1015: end if;
1016:

Line 1013: htp.tableData(cvalue => '', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1015: end if;
1016:
1017: l_pos := l_pos + 1;

Line 1014: || ' SIZE=' || ak_query_pkg.g_items_table(i).display_value_length ||'>', crowspan => 1);

1010: -- ' MAXLENGTH=' || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE = "">', crowspan => 1);
1011: -- htp.tableData(cvalue => '', crowspan => 1);
1013: htp.tableData(cvalue => '', crowspan => 1);
1015: end if;
1016:
1017: l_pos := l_pos + 1;
1018: ELSE

Line 1021: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN

1017: l_pos := l_pos + 1;
1018: ELSE
1019: -- Print for display only; pass that as a hidden value
1020:
1021: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
1022: v_value := v_charge_account_seg1;
1023: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
1024: v_value := v_charge_account_seg2;
1025: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

Line 1023: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN

1019: -- Print for display only; pass that as a hidden value
1020:
1021: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
1022: v_value := v_charge_account_seg1;
1023: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
1024: v_value := v_charge_account_seg2;
1025: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
1026: v_value := v_charge_account_seg3;
1027: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

Line 1025: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN

1021: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG1' THEN
1022: v_value := v_charge_account_seg1;
1023: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
1024: v_value := v_charge_account_seg2;
1025: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
1026: v_value := v_charge_account_seg3;
1027: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
1028: v_value := v_charge_account_seg4;
1029: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

Line 1027: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN

1023: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG2' THEN
1024: v_value := v_charge_account_seg2;
1025: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
1026: v_value := v_charge_account_seg3;
1027: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
1028: v_value := v_charge_account_seg4;
1029: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
1030: v_value := v_charge_account_seg5;
1031: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

Line 1029: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN

1025: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG3' THEN
1026: v_value := v_charge_account_seg3;
1027: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
1028: v_value := v_charge_account_seg4;
1029: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
1030: v_value := v_charge_account_seg5;
1031: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
1032: v_value := v_charge_account_seg6;
1033: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

Line 1031: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN

1027: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG4' THEN
1028: v_value := v_charge_account_seg4;
1029: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
1030: v_value := v_charge_account_seg5;
1031: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
1032: v_value := v_charge_account_seg6;
1033: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
1034: v_value := v_charge_account_seg7;
1035: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

Line 1033: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN

1029: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG5' THEN
1030: v_value := v_charge_account_seg5;
1031: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
1032: v_value := v_charge_account_seg6;
1033: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
1034: v_value := v_charge_account_seg7;
1035: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
1036: v_value := v_charge_account_seg8;
1037: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

Line 1035: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN

1031: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG6' THEN
1032: v_value := v_charge_account_seg6;
1033: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
1034: v_value := v_charge_account_seg7;
1035: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
1036: v_value := v_charge_account_seg8;
1037: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
1038: v_value := v_charge_account_seg9;
1039: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

Line 1037: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN

1033: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG7' THEN
1034: v_value := v_charge_account_seg7;
1035: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
1036: v_value := v_charge_account_seg8;
1037: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
1038: v_value := v_charge_account_seg9;
1039: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
1040: v_value := v_charge_account_seg10;
1041: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

Line 1039: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN

1035: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG8' THEN
1036: v_value := v_charge_account_seg8;
1037: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
1038: v_value := v_charge_account_seg9;
1039: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
1040: v_value := v_charge_account_seg10;
1041: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
1042: v_value := v_charge_account_seg11;
1043: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

Line 1041: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN

1037: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG9' THEN
1038: v_value := v_charge_account_seg9;
1039: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
1040: v_value := v_charge_account_seg10;
1041: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
1042: v_value := v_charge_account_seg11;
1043: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
1044: v_value := v_charge_account_seg12;
1045: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

Line 1043: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN

1039: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG10' THEN
1040: v_value := v_charge_account_seg10;
1041: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
1042: v_value := v_charge_account_seg11;
1043: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
1044: v_value := v_charge_account_seg12;
1045: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
1046: v_value := v_charge_account_seg13;
1047: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

Line 1045: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN

1041: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG11' THEN
1042: v_value := v_charge_account_seg11;
1043: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
1044: v_value := v_charge_account_seg12;
1045: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
1046: v_value := v_charge_account_seg13;
1047: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
1048: v_value := v_charge_account_seg14;
1049: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

Line 1047: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN

1043: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG12' THEN
1044: v_value := v_charge_account_seg12;
1045: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
1046: v_value := v_charge_account_seg13;
1047: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
1048: v_value := v_charge_account_seg14;
1049: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
1050: v_value := v_charge_account_seg15;
1051: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

Line 1049: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN

1045: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG13' THEN
1046: v_value := v_charge_account_seg13;
1047: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
1048: v_value := v_charge_account_seg14;
1049: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
1050: v_value := v_charge_account_seg15;
1051: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
1052: v_value := v_charge_account_seg16;
1053: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

Line 1051: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN

1047: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG14' THEN
1048: v_value := v_charge_account_seg14;
1049: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
1050: v_value := v_charge_account_seg15;
1051: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
1052: v_value := v_charge_account_seg16;
1053: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
1054: v_value := v_charge_account_seg17;
1055: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

Line 1053: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN

1049: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG15' THEN
1050: v_value := v_charge_account_seg15;
1051: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
1052: v_value := v_charge_account_seg16;
1053: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
1054: v_value := v_charge_account_seg17;
1055: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
1056: v_value := v_charge_account_seg18;
1057: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

Line 1055: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN

1051: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG16' THEN
1052: v_value := v_charge_account_seg16;
1053: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
1054: v_value := v_charge_account_seg17;
1055: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
1056: v_value := v_charge_account_seg18;
1057: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
1058: v_value := v_charge_account_seg19;
1059: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

Line 1057: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN

1053: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG17' THEN
1054: v_value := v_charge_account_seg17;
1055: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
1056: v_value := v_charge_account_seg18;
1057: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
1058: v_value := v_charge_account_seg19;
1059: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
1060: v_value := v_charge_account_seg20;
1061: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

Line 1059: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN

1055: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG18' THEN
1056: v_value := v_charge_account_seg18;
1057: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
1058: v_value := v_charge_account_seg19;
1059: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
1060: v_value := v_charge_account_seg20;
1061: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
1062: v_value := v_charge_account_seg21;
1063: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

Line 1061: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN

1057: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG19' THEN
1058: v_value := v_charge_account_seg19;
1059: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
1060: v_value := v_charge_account_seg20;
1061: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
1062: v_value := v_charge_account_seg21;
1063: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
1064: v_value := v_charge_account_seg22;
1065: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

Line 1063: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN

1059: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG20' THEN
1060: v_value := v_charge_account_seg20;
1061: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
1062: v_value := v_charge_account_seg21;
1063: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
1064: v_value := v_charge_account_seg22;
1065: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
1066: v_value := v_charge_account_seg23;
1067: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

Line 1065: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN

1061: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG21' THEN
1062: v_value := v_charge_account_seg21;
1063: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
1064: v_value := v_charge_account_seg22;
1065: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
1066: v_value := v_charge_account_seg23;
1067: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
1068: v_value := v_charge_account_seg24;
1069: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

Line 1067: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN

1063: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG22' THEN
1064: v_value := v_charge_account_seg22;
1065: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
1066: v_value := v_charge_account_seg23;
1067: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
1068: v_value := v_charge_account_seg24;
1069: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
1070: v_value := v_charge_account_seg25;
1071: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

Line 1069: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN

1065: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG23' THEN
1066: v_value := v_charge_account_seg23;
1067: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
1068: v_value := v_charge_account_seg24;
1069: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
1070: v_value := v_charge_account_seg25;
1071: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
1072: v_value := v_charge_account_seg26;
1073: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

Line 1071: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN

1067: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG24' THEN
1068: v_value := v_charge_account_seg24;
1069: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
1070: v_value := v_charge_account_seg25;
1071: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
1072: v_value := v_charge_account_seg26;
1073: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
1074: v_value := v_charge_account_seg27;
1075: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

Line 1073: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN

1069: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG25' THEN
1070: v_value := v_charge_account_seg25;
1071: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
1072: v_value := v_charge_account_seg26;
1073: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
1074: v_value := v_charge_account_seg27;
1075: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
1076: v_value := v_charge_account_seg28;
1077: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

Line 1075: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN

1071: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG26' THEN
1072: v_value := v_charge_account_seg26;
1073: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
1074: v_value := v_charge_account_seg27;
1075: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
1076: v_value := v_charge_account_seg28;
1077: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
1078: v_value := v_charge_account_seg29;
1079: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

Line 1077: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN

1073: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG27' THEN
1074: v_value := v_charge_account_seg27;
1075: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
1076: v_value := v_charge_account_seg28;
1077: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
1078: v_value := v_charge_account_seg29;
1079: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
1080: v_value := v_charge_account_seg30;
1081: END IF; / ak.. attribute_code = 'ICX_...' /

Line 1079: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN

1075: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG28' THEN
1076: v_value := v_charge_account_seg28;
1077: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG29' THEN
1078: v_value := v_charge_account_seg29;
1079: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
1080: v_value := v_charge_account_seg30;
1081: END IF; / ak.. attribute_code = 'ICX_...' /
1082:
1083: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

Line 1083: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);

1079: ELSIF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_CHARGE_ACCT_SEG30' THEN
1080: v_value := v_charge_account_seg30;
1081: END IF; / ak.. attribute_code = 'ICX_...' /
1082:
1083: htp.formHidden(cname => ak_query_pkg.g_items_table(i).attribute_code , cvalue => v_value);
1084: l_pos := l_pos + 1;
1085:
1086: IF v_value IS NULL THEN
1087: htp.tableData(cvalue => ' ', crowspan => 1);

Line 1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);

1151: v_money_fmt_mask := fnd_currency.safe_get_format_mask(v_currency, 30);
1152:
1153: htp.tableOpen('BORDER=0');
1154:
1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);
1156:
1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1158:
1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

1153: htp.tableOpen('BORDER=0');
1154:
1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);
1156:
1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1158:
1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1160: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

Line 1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);
1156:
1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1158:
1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1160: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
1162:
1163: htp.tableRowOpen;

Line 1160: AND ak_query_pkg.g_items_table(i).secured_column = 'F'

1156:
1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1158:
1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1160: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
1162:
1163: htp.tableRowOpen;
1164:

Line 1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN

1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1158:
1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
1160: AND ak_query_pkg.g_items_table(i).secured_column = 'F'
1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
1162:
1163: htp.tableRowOpen;
1164:
1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');

Line 1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');

1161: AND ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' THEN
1162:
1163: htp.tableRowOpen;
1164:
1165: htp.tableData(cvalue => ak_query_pkg.g_items_table(i).attribute_label_long, calign => 'RIGHT', cattributes=>'VALIGN=CENTER');
1166:
1167: / Leave a blank space between the prompt and the value /
1168: htp.tableData(cvalue => ' ');
1169:

Line 1172: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN

1168: htp.tableData(cvalue => ' ');
1169:
1170: htp.p('');
1171: htp.p('');
1172: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1173: htp.p('');
1174: END IF;
1175:
1176: / Format ext. price before displaying /

Line 1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN

1173: htp.p('');
1174: END IF;
1175:
1176: / Format ext. price before displaying /
1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN
1178: v_ext_amount := y_table(ak_query_pkg.g_items_table(i).value_id);
1179: htp.p(TO_CHAR(v_ext_amount, v_money_fmt_mask));
1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));

Line 1178: v_ext_amount := y_table(ak_query_pkg.g_items_table(i).value_id);

1174: END IF;
1175:
1176: / Format ext. price before displaying /
1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN
1178: v_ext_amount := y_table(ak_query_pkg.g_items_table(i).value_id);
1179: htp.p(TO_CHAR(v_ext_amount, v_money_fmt_mask));
1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; / ICX_EXT_PRICE /

Line 1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));

1177: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE' THEN
1178: v_ext_amount := y_table(ak_query_pkg.g_items_table(i).value_id);
1179: htp.p(TO_CHAR(v_ext_amount, v_money_fmt_mask));
1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; / ICX_EXT_PRICE /
1183:
1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');

Line 1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),

1180: ELSE
1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; / ICX_EXT_PRICE /
1183:
1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
1186:
1187: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
1188: THEN

Line 1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');

1181: htp.p(y_table(ak_query_pkg.g_items_table(i).value_id));
1182: END IF; / ICX_EXT_PRICE /
1183:
1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
1186:
1187: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
1188: THEN
1189: v_extended_price := y_table(ak_query_pkg.g_items_table(i).value_id);

Line 1187: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'

1183:
1184: -- htp.tableData(cvalue => icx_on_utilities.formatText(y_table(ak_query_pkg.g_items_table(i).value_id),ak_query_pkg.g_items_table(i).bold,ak_query_pkg.g_items_table(i).italic),
1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
1186:
1187: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
1188: THEN
1189: v_extended_price := y_table(ak_query_pkg.g_items_table(i).value_id);
1190: END IF; / ICX_EXT_PRICE /
1191:

Line 1189: v_extended_price := y_table(ak_query_pkg.g_items_table(i).value_id);

1185: -- calign => ak_query_pkg.g_items_table(i).horizontal_alignment, cattributes => 'VALIGN="'||ak_query_pkg.g_items_table(i).vertical_alignment||'"');
1186:
1187: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_EXT_PRICE'
1188: THEN
1189: v_extended_price := y_table(ak_query_pkg.g_items_table(i).value_id);
1190: END IF; / ICX_EXT_PRICE /
1191:
1192: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1193: htp.p('');

Line 1192: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN

1188: THEN
1189: v_extended_price := y_table(ak_query_pkg.g_items_table(i).value_id);
1190: END IF; / ICX_EXT_PRICE /
1191:
1192: IF ak_query_pkg.g_items_table(i).italic = 'Y' THEN
1193: htp.p('');
1194: END IF;
1195: htp.p('');
1196: htp.p('');

Line 1233: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

1229: htp.p('');
1230:
1231: v_table_attribute := ' COLSPAN=1';
1232:
1233: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND
1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND
1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:

Line 1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND

1230:
1231: v_table_attribute := ' COLSPAN=1';
1232:
1233: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND
1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND
1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:
1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );

Line 1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND

1231: v_table_attribute := ' COLSPAN=1';
1232:
1233: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND
1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND
1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:
1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
1239:

Line 1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN

1232:
1233: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND
1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND
1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:
1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
1239:
1240: END IF; / if ak_query_pkg ... <> HIDDEN /

Line 1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );

1234: IF (ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' AND
1235: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' AND
1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:
1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
1239:
1240: END IF; / if ak_query_pkg ... <> HIDDEN /
1241:
1242: END LOOP; / FOR in ak_query_pkg ... /

Line 1240: END IF; / if ak_query_pkg ... <> HIDDEN */

1236: ak_query_pkg.g_items_table(i).secured_column <> 'T') THEN
1237:
1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
1239:
**1240: END IF; /* if ak_query_pkg ... <> HIDDEN */**
1241:
1242: END LOOP; /* FOR in ak_query_pkg ... /
1243:
1244: -- Leave a thin blank line border between the header and the table rows

Line 1242: END LOOP; / FOR in ak_query_pkg ... /

1238: htp.p( '' || ak_query_pkg.g_items_table(i).attribute_label_long || '' );
1239:
1240: END IF; / if ak_query_pkg ... <> HIDDEN */
1241:
**1242: END LOOP; /* FOR in ak_query_pkg ... */
1243:
1244: -- Leave a thin blank line border between the header and the table rows
1245: htp.p('');
1246:

Line 2066: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,

2062: FOR prec IN get_distributions LOOP
2063:
2064: v_where_clause := 'CART_ID =' || v_cart_id || 'AND CART_LINE_ID =' || v_cart_line_id || 'AND DISTRIBUTION_ID =' || prec.distribution_id;
2065:
2066: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
2067: P_PARENT_REGION_CODE => v_distribution_lines_region,
2068: P_RESPONSIBILITY_ID => v_responsibility_id,
2069: P_USER_ID => v_web_user_id,
2070: P_WHERE_CLAUSE => v_where_clause,

Line 2074: IF ak_query_pkg.g_results_table.COUNT > 0 THEN

2070: P_WHERE_CLAUSE => v_where_clause,
2071: P_RETURN_PARENTS => 'T',
2072: P_RETURN_CHILDREN => 'F');
2073:
2074: IF ak_query_pkg.g_results_table.COUNT > 0 THEN
2075: l := 1;
2076: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
2077:
2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

Line 2076: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP

2072: P_RETURN_CHILDREN => 'F');
2073:
2074: IF ak_query_pkg.g_results_table.COUNT > 0 THEN
2075: l := 1;
2076: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
2077:
2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
2079:
2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

Line 2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

2074: IF ak_query_pkg.g_results_table.COUNT > 0 THEN
2075: l := 1;
2076: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
2077:
2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
2079:
2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
2081:
2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP

2076: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
2077:
2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
2079:
2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
2081:
2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
2083: AND (substr(ltrim(rtrim(ak_query_pkg.g_items_table(i).attribute_code)), 1, 19) = 'ICX_CHARGE_ACCT_SEG') THEN
2084:

Line 2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
2079:
2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
2081:
2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
2083: AND (substr(ltrim(rtrim(ak_query_pkg.g_items_table(i).attribute_code)), 1, 19) = 'ICX_CHARGE_ACCT_SEG') THEN
2084:
2085: -- Build the segment values in segment array
2086: v_segment_value(l) := l_values(ak_query_pkg.g_items_table(i).value_id);

Line 2083: AND (substr(ltrim(rtrim(ak_query_pkg.g_items_table(i).attribute_code)), 1, 19) = 'ICX_CHARGE_ACCT_SEG') THEN

2079:
2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
2081:
2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
2083: AND (substr(ltrim(rtrim(ak_query_pkg.g_items_table(i).attribute_code)), 1, 19) = 'ICX_CHARGE_ACCT_SEG') THEN
2084:
2085: -- Build the segment values in segment array
2086: v_segment_value(l) := l_values(ak_query_pkg.g_items_table(i).value_id);
2087: l := l + 1;

Line 2086: v_segment_value(l) := l_values(ak_query_pkg.g_items_table(i).value_id);

2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
2083: AND (substr(ltrim(rtrim(ak_query_pkg.g_items_table(i).attribute_code)), 1, 19) = 'ICX_CHARGE_ACCT_SEG') THEN
2084:
2085: -- Build the segment values in segment array
2086: v_segment_value(l) := l_values(ak_query_pkg.g_items_table(i).value_id);**
2087: l := l + 1;
2088: END IF; /* IF ak_query_pkg /
2089:
2090: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN

Line 2088: END IF; / IF ak_query_pkg */

2084:
2085: -- Build the segment values in segment array
2086: v_segment_value(l) := l_values(ak_query_pkg.g_items_table(i).value_id);
2087: l := l + 1;
**2088: END IF; /* IF ak_query_pkg */**
2089:
2090: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
2091: v_allocation_value := l_values(ak_query_pkg.g_items_table(i).value_id);
2092: END IF; /* IF ak_query_pkg /

Line 2090: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN

2086: v_segment_value(l) := l_values(ak_query_pkg.g_items_table(i).value_id);
2087: l := l + 1;
2088: END IF; / IF ak_query_pkg /
2089:
2090: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
2091: v_allocation_value := l_values(ak_query_pkg.g_items_table(i).value_id);
2092: END IF; / IF ak_query_pkg /
2093:
2094: END LOOP; / FOR i in items table /

Line 2091: v_allocation_value := l_values(ak_query_pkg.g_items_table(i).value_id);

2087: l := l + 1;
2088: END IF; / IF ak_query_pkg /
2089:
2090: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
2091: v_allocation_value := l_values(ak_query_pkg.g_items_table(i).value_id);
2092: END IF; / IF ak_query_pkg /
2093:
2094: END LOOP; / FOR i in items table /
2095:

Line 2092: END IF; / IF ak_query_pkg /

2088: END IF; / IF ak_query_pkg */
2089:
2090: IF ak_query_pkg.g_items_table(i).attribute_code = 'ICX_PERCENTAGE' THEN
2091: v_allocation_value := l_values(ak_query_pkg.g_items_table(i).value_id);
**2092: END IF; /* IF ak_query_pkg */**
2093:
2094: END LOOP; /* FOR i in items table /
2095:
2096: END LOOP; / FOR r in results table */