DBA Data[Home] [Help]

APPS.POS_ASN_DETAILS_S dependencies on AK_QUERY_PKG

Line 36: RETURN ak_query_pkg.g_items_table(l_index).horizontal_alignment;

32: * Generic utility to return the horizontal alignment of the attribute
33: */
34: FUNCTION item_halign(l_index in number) RETURN VARCHAR2 IS
35: BEGIN
36: RETURN ak_query_pkg.g_items_table(l_index).horizontal_alignment;
37: END;
38:
39:
40: /* item_valign

Line 46: RETURN ak_query_pkg.g_items_table(l_index).vertical_alignment;

42: * Generic utility to return the vertical alignment of the attribute
43: */
44: FUNCTION item_valign(l_index in number) RETURN VARCHAR2 IS
45: BEGIN
46: RETURN ak_query_pkg.g_items_table(l_index).vertical_alignment;
47: END;
48:
49:
50: /* item_name

Line 56: RETURN ak_query_pkg.g_items_table(l_index).attribute_label_long;

52: * Generic utility to retrieve the attribute label
53: */
54: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS
55: BEGIN
56: RETURN ak_query_pkg.g_items_table(l_index).attribute_label_long;
57: END;
58:
59:
60: /* item_code

Line 66: RETURN ak_query_pkg.g_items_table(l_index).attribute_code;

62: * Generic utility to retrieve the attribute code
63: */
64: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS
65: BEGIN
66: RETURN ak_query_pkg.g_items_table(l_index).attribute_code;
67: END;
68:
69:
70: /* item_style

Line 75: RETURN ak_query_pkg.g_items_table(l_index).item_style;

71: * ----------
72: */
73: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS
74: BEGIN
75: RETURN ak_query_pkg.g_items_table(l_index).item_style;
76: END;
77:
78:
79: /* item_displayed

Line 84: RETURN (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y');

80: * --------------
81: */
82: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS
83: BEGIN
84: RETURN (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y');
85: END;
86:
87:
88: /* item_updateable

Line 93: RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');

89: * ---------------
90: */
91: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
92: BEGIN
93: RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');
94: END;
95:
96:
97: /* item_sequence

Line 102: RETURN ak_query_pkg.g_items_table(l_index).display_sequence;

98: * -------------
99: */
100: FUNCTION item_sequence(l_index in number) RETURN NUMBER IS
101: BEGIN
102: RETURN ak_query_pkg.g_items_table(l_index).display_sequence;
103: END;
104:
105:
106: /* item_maxlength

Line 113: to_char(ak_query_pkg.g_items_table(l_index).attribute_value_length);

109: FUNCTION item_maxlength (l_index in number) RETURN VARCHAR2 IS
110: BEGIN
111:
112: RETURN ' maxlength=' ||
113: to_char(ak_query_pkg.g_items_table(l_index).attribute_value_length);
114:
115: END item_maxlength;
116:
117:

Line 124: RETURN ' size=' || to_char(ak_query_pkg.g_items_table(l_index).display_value_length);

120: */
121: FUNCTION item_size (l_index in number) RETURN VARCHAR2 IS
122: BEGIN
123:
124: RETURN ' size=' || to_char(ak_query_pkg.g_items_table(l_index).display_value_length);
125:
126: END item_size;
127:
128:

Line 135: IF ((ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL) AND

131: */
132: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS
133: BEGIN
134:
135: IF ((ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL) AND
136: (ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL))
137: THEN
138:
139: return ' 140: item_code(l_index) || ''')"' ||

Line 478: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,

474: ' AND ASN_LINE_ID = ' || p_asn_line_id ||
475: ' AND ASN_LINE_SPLIT_ID = ' || p_asn_line_split_id;
476:
477:
478: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
479: p_parent_region_code => p_region,
480: p_where_clause => l_where_clause,
481: p_responsibility_id => l_responsibility_id,
482: p_user_id => l_user_id,

Line 486: l_attribute_index := ak_query_pkg.g_items_table.FIRST;

482: p_user_id => l_user_id,
483: p_return_parents => 'T',
484: p_return_children => 'F');
485:
486: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
487: l_result_index := ak_query_pkg.g_results_table.FIRST;
488:
489: l_current_col := 0;
490: l_paint_col := 0;

Line 487: l_result_index := ak_query_pkg.g_results_table.FIRST;

483: p_return_parents => 'T',
484: p_return_children => 'F');
485:
486: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
487: l_result_index := ak_query_pkg.g_results_table.FIRST;
488:
489: l_current_col := 0;
490: l_paint_col := 0;
491:

Line 541: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);

537: END IF;
538:
539: END IF;
540:
541: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
542:
543: if ((l_paint_col mod 2) = 0) THEN
544: htp.p('');
545: htp.p('');

Line 634: return ak_query_pkg.g_results_table(p_index).value1;

630:
631: BEGIN
632:
633: if p_col = 1 then
634: return ak_query_pkg.g_results_table(p_index).value1;
635: elsif p_col = 2 then
636: return ak_query_pkg.g_results_table(p_index).value2;
637: elsif p_col = 3 then
638: return ak_query_pkg.g_results_table(p_index).value3;

Line 636: return ak_query_pkg.g_results_table(p_index).value2;

632:
633: if p_col = 1 then
634: return ak_query_pkg.g_results_table(p_index).value1;
635: elsif p_col = 2 then
636: return ak_query_pkg.g_results_table(p_index).value2;
637: elsif p_col = 3 then
638: return ak_query_pkg.g_results_table(p_index).value3;
639: elsif p_col = 4 then
640: return ak_query_pkg.g_results_table(p_index).value4;

Line 638: return ak_query_pkg.g_results_table(p_index).value3;

634: return ak_query_pkg.g_results_table(p_index).value1;
635: elsif p_col = 2 then
636: return ak_query_pkg.g_results_table(p_index).value2;
637: elsif p_col = 3 then
638: return ak_query_pkg.g_results_table(p_index).value3;
639: elsif p_col = 4 then
640: return ak_query_pkg.g_results_table(p_index).value4;
641: elsif p_col = 5 then
642: return ak_query_pkg.g_results_table(p_index).value5;

Line 640: return ak_query_pkg.g_results_table(p_index).value4;

636: return ak_query_pkg.g_results_table(p_index).value2;
637: elsif p_col = 3 then
638: return ak_query_pkg.g_results_table(p_index).value3;
639: elsif p_col = 4 then
640: return ak_query_pkg.g_results_table(p_index).value4;
641: elsif p_col = 5 then
642: return ak_query_pkg.g_results_table(p_index).value5;
643: elsif p_col = 6 then
644: return ak_query_pkg.g_results_table(p_index).value6;

Line 642: return ak_query_pkg.g_results_table(p_index).value5;

638: return ak_query_pkg.g_results_table(p_index).value3;
639: elsif p_col = 4 then
640: return ak_query_pkg.g_results_table(p_index).value4;
641: elsif p_col = 5 then
642: return ak_query_pkg.g_results_table(p_index).value5;
643: elsif p_col = 6 then
644: return ak_query_pkg.g_results_table(p_index).value6;
645: elsif p_col = 7 then
646: return ak_query_pkg.g_results_table(p_index).value7;

Line 644: return ak_query_pkg.g_results_table(p_index).value6;

640: return ak_query_pkg.g_results_table(p_index).value4;
641: elsif p_col = 5 then
642: return ak_query_pkg.g_results_table(p_index).value5;
643: elsif p_col = 6 then
644: return ak_query_pkg.g_results_table(p_index).value6;
645: elsif p_col = 7 then
646: return ak_query_pkg.g_results_table(p_index).value7;
647: elsif p_col = 8 then
648: return ak_query_pkg.g_results_table(p_index).value8;

Line 646: return ak_query_pkg.g_results_table(p_index).value7;

642: return ak_query_pkg.g_results_table(p_index).value5;
643: elsif p_col = 6 then
644: return ak_query_pkg.g_results_table(p_index).value6;
645: elsif p_col = 7 then
646: return ak_query_pkg.g_results_table(p_index).value7;
647: elsif p_col = 8 then
648: return ak_query_pkg.g_results_table(p_index).value8;
649: elsif p_col = 9 then
650: return ak_query_pkg.g_results_table(p_index).value9;

Line 648: return ak_query_pkg.g_results_table(p_index).value8;

644: return ak_query_pkg.g_results_table(p_index).value6;
645: elsif p_col = 7 then
646: return ak_query_pkg.g_results_table(p_index).value7;
647: elsif p_col = 8 then
648: return ak_query_pkg.g_results_table(p_index).value8;
649: elsif p_col = 9 then
650: return ak_query_pkg.g_results_table(p_index).value9;
651: elsif p_col = 10 then
652: return ak_query_pkg.g_results_table(p_index).value10;

Line 650: return ak_query_pkg.g_results_table(p_index).value9;

646: return ak_query_pkg.g_results_table(p_index).value7;
647: elsif p_col = 8 then
648: return ak_query_pkg.g_results_table(p_index).value8;
649: elsif p_col = 9 then
650: return ak_query_pkg.g_results_table(p_index).value9;
651: elsif p_col = 10 then
652: return ak_query_pkg.g_results_table(p_index).value10;
653: elsif p_col = 11 then
654: return ak_query_pkg.g_results_table(p_index).value11;

Line 652: return ak_query_pkg.g_results_table(p_index).value10;

648: return ak_query_pkg.g_results_table(p_index).value8;
649: elsif p_col = 9 then
650: return ak_query_pkg.g_results_table(p_index).value9;
651: elsif p_col = 10 then
652: return ak_query_pkg.g_results_table(p_index).value10;
653: elsif p_col = 11 then
654: return ak_query_pkg.g_results_table(p_index).value11;
655: elsif p_col = 12 then
656: return ak_query_pkg.g_results_table(p_index).value12;

Line 654: return ak_query_pkg.g_results_table(p_index).value11;

650: return ak_query_pkg.g_results_table(p_index).value9;
651: elsif p_col = 10 then
652: return ak_query_pkg.g_results_table(p_index).value10;
653: elsif p_col = 11 then
654: return ak_query_pkg.g_results_table(p_index).value11;
655: elsif p_col = 12 then
656: return ak_query_pkg.g_results_table(p_index).value12;
657: elsif p_col = 13 then
658: return ak_query_pkg.g_results_table(p_index).value13;

Line 656: return ak_query_pkg.g_results_table(p_index).value12;

652: return ak_query_pkg.g_results_table(p_index).value10;
653: elsif p_col = 11 then
654: return ak_query_pkg.g_results_table(p_index).value11;
655: elsif p_col = 12 then
656: return ak_query_pkg.g_results_table(p_index).value12;
657: elsif p_col = 13 then
658: return ak_query_pkg.g_results_table(p_index).value13;
659: elsif p_col = 14 then
660: return ak_query_pkg.g_results_table(p_index).value14;

Line 658: return ak_query_pkg.g_results_table(p_index).value13;

654: return ak_query_pkg.g_results_table(p_index).value11;
655: elsif p_col = 12 then
656: return ak_query_pkg.g_results_table(p_index).value12;
657: elsif p_col = 13 then
658: return ak_query_pkg.g_results_table(p_index).value13;
659: elsif p_col = 14 then
660: return ak_query_pkg.g_results_table(p_index).value14;
661: elsif p_col = 15 then
662: return ak_query_pkg.g_results_table(p_index).value15;

Line 660: return ak_query_pkg.g_results_table(p_index).value14;

656: return ak_query_pkg.g_results_table(p_index).value12;
657: elsif p_col = 13 then
658: return ak_query_pkg.g_results_table(p_index).value13;
659: elsif p_col = 14 then
660: return ak_query_pkg.g_results_table(p_index).value14;
661: elsif p_col = 15 then
662: return ak_query_pkg.g_results_table(p_index).value15;
663: elsif p_col = 16 then
664: return ak_query_pkg.g_results_table(p_index).value16;

Line 662: return ak_query_pkg.g_results_table(p_index).value15;

658: return ak_query_pkg.g_results_table(p_index).value13;
659: elsif p_col = 14 then
660: return ak_query_pkg.g_results_table(p_index).value14;
661: elsif p_col = 15 then
662: return ak_query_pkg.g_results_table(p_index).value15;
663: elsif p_col = 16 then
664: return ak_query_pkg.g_results_table(p_index).value16;
665: elsif p_col = 17 then
666: return ak_query_pkg.g_results_table(p_index).value17;

Line 664: return ak_query_pkg.g_results_table(p_index).value16;

660: return ak_query_pkg.g_results_table(p_index).value14;
661: elsif p_col = 15 then
662: return ak_query_pkg.g_results_table(p_index).value15;
663: elsif p_col = 16 then
664: return ak_query_pkg.g_results_table(p_index).value16;
665: elsif p_col = 17 then
666: return ak_query_pkg.g_results_table(p_index).value17;
667: elsif p_col = 18 then
668: return ak_query_pkg.g_results_table(p_index).value18;

Line 666: return ak_query_pkg.g_results_table(p_index).value17;

662: return ak_query_pkg.g_results_table(p_index).value15;
663: elsif p_col = 16 then
664: return ak_query_pkg.g_results_table(p_index).value16;
665: elsif p_col = 17 then
666: return ak_query_pkg.g_results_table(p_index).value17;
667: elsif p_col = 18 then
668: return ak_query_pkg.g_results_table(p_index).value18;
669: elsif p_col = 19 then
670: return ak_query_pkg.g_results_table(p_index).value19;

Line 668: return ak_query_pkg.g_results_table(p_index).value18;

664: return ak_query_pkg.g_results_table(p_index).value16;
665: elsif p_col = 17 then
666: return ak_query_pkg.g_results_table(p_index).value17;
667: elsif p_col = 18 then
668: return ak_query_pkg.g_results_table(p_index).value18;
669: elsif p_col = 19 then
670: return ak_query_pkg.g_results_table(p_index).value19;
671: elsif p_col = 20 then
672: return ak_query_pkg.g_results_table(p_index).value20;

Line 670: return ak_query_pkg.g_results_table(p_index).value19;

666: return ak_query_pkg.g_results_table(p_index).value17;
667: elsif p_col = 18 then
668: return ak_query_pkg.g_results_table(p_index).value18;
669: elsif p_col = 19 then
670: return ak_query_pkg.g_results_table(p_index).value19;
671: elsif p_col = 20 then
672: return ak_query_pkg.g_results_table(p_index).value20;
673: elsif p_col = 21 then
674: return ak_query_pkg.g_results_table(p_index).value21;

Line 672: return ak_query_pkg.g_results_table(p_index).value20;

668: return ak_query_pkg.g_results_table(p_index).value18;
669: elsif p_col = 19 then
670: return ak_query_pkg.g_results_table(p_index).value19;
671: elsif p_col = 20 then
672: return ak_query_pkg.g_results_table(p_index).value20;
673: elsif p_col = 21 then
674: return ak_query_pkg.g_results_table(p_index).value21;
675: elsif p_col = 22 then
676: return ak_query_pkg.g_results_table(p_index).value22;

Line 674: return ak_query_pkg.g_results_table(p_index).value21;

670: return ak_query_pkg.g_results_table(p_index).value19;
671: elsif p_col = 20 then
672: return ak_query_pkg.g_results_table(p_index).value20;
673: elsif p_col = 21 then
674: return ak_query_pkg.g_results_table(p_index).value21;
675: elsif p_col = 22 then
676: return ak_query_pkg.g_results_table(p_index).value22;
677: elsif p_col = 23 then
678: return ak_query_pkg.g_results_table(p_index).value23;

Line 676: return ak_query_pkg.g_results_table(p_index).value22;

672: return ak_query_pkg.g_results_table(p_index).value20;
673: elsif p_col = 21 then
674: return ak_query_pkg.g_results_table(p_index).value21;
675: elsif p_col = 22 then
676: return ak_query_pkg.g_results_table(p_index).value22;
677: elsif p_col = 23 then
678: return ak_query_pkg.g_results_table(p_index).value23;
679: elsif p_col = 24 then
680: return ak_query_pkg.g_results_table(p_index).value24;

Line 678: return ak_query_pkg.g_results_table(p_index).value23;

674: return ak_query_pkg.g_results_table(p_index).value21;
675: elsif p_col = 22 then
676: return ak_query_pkg.g_results_table(p_index).value22;
677: elsif p_col = 23 then
678: return ak_query_pkg.g_results_table(p_index).value23;
679: elsif p_col = 24 then
680: return ak_query_pkg.g_results_table(p_index).value24;
681: elsif p_col = 25 then
682: return ak_query_pkg.g_results_table(p_index).value25;

Line 680: return ak_query_pkg.g_results_table(p_index).value24;

676: return ak_query_pkg.g_results_table(p_index).value22;
677: elsif p_col = 23 then
678: return ak_query_pkg.g_results_table(p_index).value23;
679: elsif p_col = 24 then
680: return ak_query_pkg.g_results_table(p_index).value24;
681: elsif p_col = 25 then
682: return ak_query_pkg.g_results_table(p_index).value25;
683: elsif p_col = 26 then
684: return ak_query_pkg.g_results_table(p_index).value26;

Line 682: return ak_query_pkg.g_results_table(p_index).value25;

678: return ak_query_pkg.g_results_table(p_index).value23;
679: elsif p_col = 24 then
680: return ak_query_pkg.g_results_table(p_index).value24;
681: elsif p_col = 25 then
682: return ak_query_pkg.g_results_table(p_index).value25;
683: elsif p_col = 26 then
684: return ak_query_pkg.g_results_table(p_index).value26;
685: elsif p_col = 27 then
686: return ak_query_pkg.g_results_table(p_index).value27;

Line 684: return ak_query_pkg.g_results_table(p_index).value26;

680: return ak_query_pkg.g_results_table(p_index).value24;
681: elsif p_col = 25 then
682: return ak_query_pkg.g_results_table(p_index).value25;
683: elsif p_col = 26 then
684: return ak_query_pkg.g_results_table(p_index).value26;
685: elsif p_col = 27 then
686: return ak_query_pkg.g_results_table(p_index).value27;
687: elsif p_col = 28 then
688: return ak_query_pkg.g_results_table(p_index).value28;

Line 686: return ak_query_pkg.g_results_table(p_index).value27;

682: return ak_query_pkg.g_results_table(p_index).value25;
683: elsif p_col = 26 then
684: return ak_query_pkg.g_results_table(p_index).value26;
685: elsif p_col = 27 then
686: return ak_query_pkg.g_results_table(p_index).value27;
687: elsif p_col = 28 then
688: return ak_query_pkg.g_results_table(p_index).value28;
689: elsif p_col = 29 then
690: return ak_query_pkg.g_results_table(p_index).value29;

Line 688: return ak_query_pkg.g_results_table(p_index).value28;

684: return ak_query_pkg.g_results_table(p_index).value26;
685: elsif p_col = 27 then
686: return ak_query_pkg.g_results_table(p_index).value27;
687: elsif p_col = 28 then
688: return ak_query_pkg.g_results_table(p_index).value28;
689: elsif p_col = 29 then
690: return ak_query_pkg.g_results_table(p_index).value29;
691: elsif p_col = 30 then
692: return ak_query_pkg.g_results_table(p_index).value30;

Line 690: return ak_query_pkg.g_results_table(p_index).value29;

686: return ak_query_pkg.g_results_table(p_index).value27;
687: elsif p_col = 28 then
688: return ak_query_pkg.g_results_table(p_index).value28;
689: elsif p_col = 29 then
690: return ak_query_pkg.g_results_table(p_index).value29;
691: elsif p_col = 30 then
692: return ak_query_pkg.g_results_table(p_index).value30;
693: end if;
694:

Line 692: return ak_query_pkg.g_results_table(p_index).value30;

688: return ak_query_pkg.g_results_table(p_index).value28;
689: elsif p_col = 29 then
690: return ak_query_pkg.g_results_table(p_index).value29;
691: elsif p_col = 30 then
692: return ak_query_pkg.g_results_table(p_index).value30;
693: end if;
694:
695: END get_result_value;
696: