DBA Data[Home] [Help]

APPS.POS_ASN dependencies on AK_QUERY_PKG

Line 102: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then

98: END po_num;
99:
100: FUNCTION item_reqd(l_index in number) RETURN VARCHAR2 IS
101: BEGIN
102: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then
103: return '';
104: else
105: return '';
106: end if;

Line 113: ak_query_pkg.g_items_table(l_index).horizontal_alignment;

109: FUNCTION item_halign(l_index in number) RETURN VARCHAR2 IS
110: BEGIN
111:
112: RETURN ' align=' ||
113: ak_query_pkg.g_items_table(l_index).horizontal_alignment;
114:
115: END item_halign;
116:
117: FUNCTION item_valign(l_index in number) RETURN VARCHAR2 IS

Line 121: ak_query_pkg.g_items_table(l_index).vertical_alignment;

117: FUNCTION item_valign(l_index in number) RETURN VARCHAR2 IS
118: BEGIN
119:
120: RETURN ' valign=' ||
121: ak_query_pkg.g_items_table(l_index).vertical_alignment;
122:
123: END item_valign;
124:
125: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS

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

124:
125: FUNCTION item_name(l_index in number) RETURN VARCHAR2 IS
126: BEGIN
127:
128: RETURN ak_query_pkg.g_items_table(l_index).attribute_label_long;
129:
130: END item_name;
131:
132: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS

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

131:
132: FUNCTION item_code(l_index in number) RETURN VARCHAR2 IS
133: BEGIN
134:
135: RETURN ak_query_pkg.g_items_table(l_index).attribute_code;
136:
137: END item_code;
138:
139: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS

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

138:
139: FUNCTION item_style(l_index in number) RETURN VARCHAR2 IS
140: BEGIN
141:
142: RETURN ak_query_pkg.g_items_table(l_index).item_style;
143:
144: END item_style;
145:
146: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS

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

145:
146: FUNCTION item_displayed(l_index in number) RETURN BOOLEAN IS
147: BEGIN
148:
149: RETURN (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y');
150:
151: END item_displayed;
152:
153: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS

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

152:
153: FUNCTION item_updateable(l_index in number) RETURN BOOLEAN IS
154: BEGIN
155:
156: RETURN (ak_query_pkg.g_items_table(l_index).update_flag = 'Y');
157:
158: END item_updateable;
159:
160: FUNCTION item_size (l_index in number) RETURN VARCHAR2 IS

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

159:
160: FUNCTION item_size (l_index in number) RETURN VARCHAR2 IS
161: BEGIN
162:
163: RETURN ' size=' || to_char(ak_query_pkg.g_items_table(l_index).display_value_length);
164:
165: END item_size;
166:
167: FUNCTION item_maxlength (l_index in number) RETURN VARCHAR2 IS

Line 170: RETURN ' maxlength=' || to_char(ak_query_pkg.g_items_table(l_index).attribute_value_length);

166:
167: FUNCTION item_maxlength (l_index in number) RETURN VARCHAR2 IS
168: BEGIN
169:
170: RETURN ' maxlength=' || to_char(ak_query_pkg.g_items_table(l_index).attribute_value_length);
171:
172: END item_maxlength;
173:
174: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS

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

173:
174: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS
175: BEGIN
176:
177: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
178: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)
179: THEN
180: return '

Line 178: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)

174: FUNCTION item_lov(l_index in number) RETURN VARCHAR2 IS
175: BEGIN
176:
177: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
178: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)
179: THEN
180: return ' 182: '>

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

189:
190: FUNCTION item_lov_multi(l_index in number, l_row in number, l_wip_row in number) RETURN VARCHAR2 IS
191: BEGIN
192:
193: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
194: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL)
195: THEN
196: return ' 197: item_code(l_index) || '''' || ',' || '''' || to_char(l_row-1) ||
198: '''' || ',' || '''' || l_script_name || '''' || ',' ||

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

708: htp.p('');
709: htp.p('');
710:
711:
712: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
713: p_parent_region_code => 'POS_ASN_HEADERS',
714: p_where_clause => l_where_clause,
715: p_responsibility_id => l_responsibility_id,
716: p_user_id => l_user_id,

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

716: p_user_id => l_user_id,
717: p_return_parents => 'T',
718: p_return_children => 'F');
719:
720: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
721: l_result_index := ak_query_pkg.g_results_table.FIRST;
722:
723: htp.p('');
724:

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

717: p_return_parents => 'T',
718: p_return_children => 'F');
719:
720: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
721: l_result_index := ak_query_pkg.g_results_table.FIRST;
722:
723: htp.p('

');
724:
725: htp.p('');

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

766: l_current_col := l_current_col -1;
767: END IF;
768: END IF;
769:
770: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
771:
772: if ((l_col mod 3) = 0) THEN
773: htp.p('

');
774: htp.p('');

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

792: BEGIN
793:
794: fnd_client_info.set_org_context(l_org_id);
795:
796: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
797: p_parent_region_code => 'POS_ASN_SHIPMENTS',
798: p_where_clause => l_where_clause,
799: p_responsibility_id => l_responsibility_id,
800: p_user_id => l_user_id,

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

800: p_user_id => l_user_id,
801: p_return_parents => 'T',
802: p_return_children => 'F');
803:
804: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
805:
806:
807: htp.p('

');
808: htp.p('');

Line 841: IF ak_query_pkg.g_results_table.count > 0 THEN

837:
838:
839: /* ----- print contents -----------*/
840:
841: IF ak_query_pkg.g_results_table.count > 0 THEN
842:
843: l_result_index := ak_query_pkg.g_results_table.FIRST;
844:
845: l_current_row := 0;

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

839: /* ----- print contents -----------*/
840:
841: IF ak_query_pkg.g_results_table.count > 0 THEN
842:
843: l_result_index := ak_query_pkg.g_results_table.FIRST;
844:
845: l_current_row := 0;
846: l_wip_row := 0;
847:

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

854: else
855: htp.p('

');
856: end if;
857:
858: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
859:
860: l_current_col := 0;
861:
862: WHILE (l_attribute_index IS NOT NULL) LOOP

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

914: END IF;
915: END IF;
916: END IF;
917:
918: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
919:
920: END LOOP;
921:
922: htp.p('

');

Line 924: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);

920: END LOOP;
921:
922: htp.p('');
923:
924: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);
925:
926: END LOOP;
927:
928: END IF;

Line 1650: IF ak_query_pkg.g_results_table.count > 0 THEN

1646: l_execute INTEGER;
1647: l_result VARCHAR2(2000);
1648: BEGIN
1649:
1650: IF ak_query_pkg.g_results_table.count > 0 THEN
1651:
1652: sql_statement := 'begin ' ||
1653: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
1654: to_char(p_col) || '; ' ||

Line 1653: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||

1649:
1650: IF ak_query_pkg.g_results_table.count > 0 THEN
1651:
1652: sql_statement := 'begin ' ||
1653: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
1654: to_char(p_col) || '; ' ||
1655: ' end;';
1656:
1657: l_cursor := dbms_sql.open_cursor;

');

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

826: multi_row_label(l_attribute_index);
827:
828: END IF;
829:
830: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
831:
832: END LOOP;
833:
834: htp.p('