DBA Data[Home] [Help]

APPS.POS_ASN_SEARCH_PKG dependencies on AK_QUERY_PKG

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

576: into l_num_shipments
577: from pos_asn_shop_cart_details
578: where session_id = l_session_id;
579:
580: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
581: p_parent_region_code=>'POS_ASN_RESULT_R',
582: p_where_clause=>l_where_clause,
583: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
584: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),

Line 588: l_num_results := ak_query_pkg.g_results_table.count;

584: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
585: p_return_parents=>'T',
586: p_return_children=>'F');
587:
588: l_num_results := ak_query_pkg.g_results_table.count;
589:
590: htp.p('');
591: htp.p('');
1027: htp.p('');
1031: htp.p('');
1031: htp.p('');

Line 1046: ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||

1042: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1043: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
1044:
1045: htp.p(' 1047: '>');
1048: END IF;
1049:
1050: htp.p('');

Line 1100: htp.p('');
1102: END IF;
1103:
1104: END IF;

Line 1101: ' - '||ak_query_pkg.g_items_table(l_index).item_style||' -->');

1097:
1098: ELSE
1099:
1100: htp.p('');
1102: END IF;
1103:
1104: END IF;
1105:

Line 1106: l_index := ak_query_pkg.g_items_table.NEXT(l_index);

1102: END IF;
1103:
1104: END IF;
1105:
1106: l_index := ak_query_pkg.g_items_table.NEXT(l_index);
1107:
1108: END LOOP;
1109:
1110: END ShowBasic;

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

1119: l_fix VARCHAR2(100);
1120:
1121: BEGIN
1122:
1123: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1124: p_parent_region_code=>'POS_ASN_ADV_SEARCH_R',
1125: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1126: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1127: p_return_parents=>'F',

Line 1131: l_index := ak_query_pkg.g_items_table.FIRST;

1127: p_return_parents=>'F',
1128: p_return_children=>'F');
1129:
1130: l_count := 0;
1131: l_index := ak_query_pkg.g_items_table.FIRST;
1132:
1133: WHILE (l_index IS NOT NULL) LOOP
1134:
1135: l_count := l_count + 1;

Line 1137: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND

1133: WHILE (l_index IS NOT NULL) LOOP
1134:
1135: l_count := l_count + 1;
1136:
1137: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
1138: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
1139:
1140: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
1141:

Line 1138: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN

1134:
1135: l_count := l_count + 1;
1136:
1137: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
1138: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
1139:
1140: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
1141:
1142: htp.p(' 1143: ak_query_pkg.g_items_table(l_index).attribute_code||
1144: '" TYPE="hidden" VALUE="' ||

Line 1143: ak_query_pkg.g_items_table(l_index).attribute_code||

1139:
1140: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
1141:
1142: htp.p('');
1147:

Line 1145: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

1141:
1142: htp.p('');
1147:
1148: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
1149:

Line 1148: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN

1144: '" TYPE="hidden" VALUE="' ||
1145: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1146: p_start_index=>l_count) || '">');
1147:
1148: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
1149:
1150: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then
1151:
1152: l_star := '';

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

1146: p_start_index=>l_count) || '">');
1147:
1148: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
1149:
1150: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then
1151:
1152: l_star := '';
1153:
1154: else

Line 1160: if ak_query_pkg.g_items_table(l_index).attribute_code in ('POS_VENDOR_SITE_NAME',

1156: l_star := '';
1157:
1158: end if;
1159:
1160: if ak_query_pkg.g_items_table(l_index).attribute_code in ('POS_VENDOR_SITE_NAME',
1161: 'POS_SHIP_TO_LOCATION') then
1162:
1163: l_fix := ' onfocus="javascript:checkBlur(this)" ';
1164:

Line 1174: ak_query_pkg.g_items_table(l_index).attribute_label_long||

1170:
1171: htp.p('

');
1172: htp.p('');
1176: htp.p('');
1176: htp.p('');

Line 1191: ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||

1187: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1188: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
1189:
1190: htp.p(' 1192: '>');
1193: END IF;
1194:
1195: IF ak_query_pkg.g_items_table(l_index).attribute_code = 'POS_DATE_START' THEN

Line 1195: IF ak_query_pkg.g_items_table(l_index).attribute_code = 'POS_DATE_START' THEN

1191: ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||
1192: '>');
1193: END IF;
1194:
1195: IF ak_query_pkg.g_items_table(l_index).attribute_code = 'POS_DATE_START' THEN
1196:
1197: l_index := ak_query_pkg.g_items_table.NEXT(l_index);
1198:
1199: l_count := l_count + 1;

Line 1197: l_index := ak_query_pkg.g_items_table.NEXT(l_index);

1193: END IF;
1194:
1195: IF ak_query_pkg.g_items_table(l_index).attribute_code = 'POS_DATE_START' THEN
1196:
1197: l_index := ak_query_pkg.g_items_table.NEXT(l_index);
1198:
1199: l_count := l_count + 1;
1200:
1201: htp.p('' || ak_query_pkg.g_items_table(l_index).attribute_label_long ||

Line 1201: htp.p('' || ak_query_pkg.g_items_table(l_index).attribute_label_long ||

1197: l_index := ak_query_pkg.g_items_table.NEXT(l_index);
1198:
1199: l_count := l_count + 1;
1200:
1201: htp.p('' || ak_query_pkg.g_items_table(l_index).attribute_label_long ||
1202: '` ');
1203:
1204: htp.p(' 1205: ' VALUE="'||

Line 1204: htp.p('

1200:
1201: htp.p('' || ak_query_pkg.g_items_table(l_index).attribute_label_long ||
1202: '` ');
1203:
1204: htp.p(' 1205: ' VALUE="'||
1206: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1207: p_start_index=>l_count) ||
1208: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||

Line 1206: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

1202: '` ');
1203:
1204: htp.p(' 1205: ' VALUE="'||
1206: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1207: p_start_index=>l_count) ||
1208: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1209: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1210: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||

Line 1208: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||

1204: htp.p(' 1205: ' VALUE="'||
1206: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1207: p_start_index=>l_count) ||
1208: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1209: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1210: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1211: l_fix ||'>');
1212:

Line 1209: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||

1205: ' VALUE="'||
1206: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1207: p_start_index=>l_count) ||
1208: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1209: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1210: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1211: l_fix ||'>');
1212:
1213: END IF;

Line 1210: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||

1206: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1207: p_start_index=>l_count) ||
1208: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1209: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1210: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1211: l_fix ||'>');
1212:
1213: END IF;
1214:

Line 1225: htp.p('');
1227:
1228: END IF;
1229:

Line 1226: ' - '||ak_query_pkg.g_items_table(l_index).item_style||' -->');

1222:
1223: ELSE
1224:
1225: htp.p('');
1227:
1228: END IF;
1229:
1230: END IF;

Line 1232: l_index := ak_query_pkg.g_items_table.NEXT(l_index);

1228: END IF;
1229:
1230: END IF;
1231:
1232: l_index := ak_query_pkg.g_items_table.NEXT(l_index);
1233:
1234: END LOOP;
1235:
1236: END ShowAdvanced;

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

1301: into l_empty_cart
1302: from POS_ASN_SHOP_CART_DETAILS
1303: where session_id = l_session_id;
1304:
1305: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1306: p_parent_region_code=>'POS_ASN_RESULT_R',
1307: p_where_clause=>l_where_clause,
1308: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1309: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),

Line 1313: l_total_rows := ak_query_pkg.g_results_table.count;

1309: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1310: p_return_parents=>'T',
1311: p_return_children=>'F');
1312:
1313: l_total_rows := ak_query_pkg.g_results_table.count;
1314:
1315: l_msg := p_msg;
1316:
1317: if l_msg is null and l_total_rows = 0 then

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

1335: IF l_total_rows > 0 THEN
1336:
1337: PrintResultHeadings;
1338:
1339: l_result_index := ak_query_pkg.g_results_table.FIRST;
1340:
1341: l_current_row := 0;
1342:
1343: WHILE (l_result_index IS NOT NULL) LOOP

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

1372: END IF;
1373:
1374: EXIT WHEN l_current_row >= p_start_row + l_pagesize - 1;
1375:
1376: l_result_index := ak_query_pkg.g_results_table.NEXT(l_result_index);
1377:
1378: END LOOP;
1379:
1380: END IF;

Line 1437: l_attribute_index NUMBER := ak_query_pkg.g_items_table.FIRST;

1433: END ShowResult;
1434:
1435: PROCEDURE PrintResultHeadings IS
1436:
1437: l_attribute_index NUMBER := ak_query_pkg.g_items_table.FIRST;
1438:
1439: BEGIN
1440:
1441: htp.p('

');

Line 1445: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND

1441: htp.p('

');
1442:
1443: WHILE (l_attribute_index IS NOT NULL) LOOP
1444:
1445: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1446: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1447:
1448: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1449:

Line 1446: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN

1442:
1443: WHILE (l_attribute_index IS NOT NULL) LOOP
1444:
1445: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1446: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1447:
1448: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1449:
1450: htp.p('

');

Line 1450: htp.p('
');
1453:
1454: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN

Line 1452: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '');

1448: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1449:
1450: htp.p('

');
1453:
1454: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1455:
1456: htp.p('');
1453:
1454: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1455:
1456: htp.p('');

Line 1456: htp.p('
');
1453:
1454: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1455:
1456: htp.p('');
1459:
1460: END IF;

Line 1458: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '');

1454: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1455:
1456: htp.p('

');
1459:
1460: END IF;
1461:
1462: END IF;

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

1460: END IF;
1461:
1462: END IF;
1463:
1464: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
1465:
1466: END LOOP;
1467:
1468: htp.p('

');

Line 1475: l_attribute_index NUMBER := ak_query_pkg.g_items_table.FIRST;

1471:
1472: PROCEDURE PrintAvailableShipment(p_result_index NUMBER,
1473: p_current_row NUMBER) IS
1474:
1475: l_attribute_index NUMBER := ak_query_pkg.g_items_table.FIRST;
1476: l_current_col NUMBER := 0;
1477:
1478: BEGIN
1479:

Line 1482: if (ak_query_pkg.g_items_table(l_attribute_index).node_query_flag = 'Y') then

1478: BEGIN
1479:
1480: WHILE (l_attribute_index IS NOT NULL) LOOP
1481:
1482: if (ak_query_pkg.g_items_table(l_attribute_index).node_query_flag = 'Y') then
1483:
1484: l_current_col := l_current_col + 1;
1485:
1486: end if;

Line 1488: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND

1484: l_current_col := l_current_col + 1;
1485:
1486: end if;
1487:
1488: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1489: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1490:
1491: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1492:

Line 1489: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN

1485:
1486: end if;
1487:
1488: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1489: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1490:
1491: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1492:
1493: htp.p('

');

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

1613: l_execute NUMBER;
1614: l_result VARCHAR2(2000);
1615: BEGIN
1616:
1617: IF ak_query_pkg.g_results_table.count > 0 THEN
1618:
1619: sql_statement := 'begin ' ||
1620: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
1621: to_char(p_col) || '; ' ||

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

1616:
1617: IF ak_query_pkg.g_results_table.count > 0 THEN
1618:
1619: sql_statement := 'begin ' ||
1620: ':l_result := ak_query_pkg.g_results_table(:p_index).value' ||
1621: to_char(p_col) || '; ' ||
1622: ' end;';
1623:
1624: l_cursor := dbms_sql.open_cursor;

');
592:

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

971: l_fix VARCHAR2(100);
972:
973: BEGIN
974:
975: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
976: p_parent_region_code=>'POS_ASN_SEARCH_R',
977: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
978: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
979: p_return_parents=>'F',

Line 983: l_index := ak_query_pkg.g_items_table.FIRST;

979: p_return_parents=>'F',
980: p_return_children=>'F');
981:
982: l_count := 0;
983: l_index := ak_query_pkg.g_items_table.FIRST;
984: l_row := 0;
985:
986: WHILE (l_index IS NOT NULL) LOOP
987:

Line 990: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND

986: WHILE (l_index IS NOT NULL) LOOP
987:
988: l_count := l_count + 1;
989:
990: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
991: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
992:
993: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
994:

Line 991: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN

987:
988: l_count := l_count + 1;
989:
990: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
991: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
992:
993: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
994:
995: htp.p(' 996: ak_query_pkg.g_items_table(l_index).attribute_code||
997: '" TYPE="hidden" VALUE="' ||

Line 996: ak_query_pkg.g_items_table(l_index).attribute_code||

992:
993: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
994:
995: htp.p('');
1000:

Line 998: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

994:
995: htp.p('');
1000:
1001: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
1002:

Line 1001: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN

997: '" TYPE="hidden" VALUE="' ||
998: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
999: p_start_index=>l_count) || '">');
1000:
1001: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
1002:
1003: l_row := l_row + 1;
1004:
1005: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then

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

1001: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
1002:
1003: l_row := l_row + 1;
1004:
1005: if ak_query_pkg.g_items_table(l_index).required_flag = 'Y' then
1006:
1007: l_star := '';
1008:
1009: else

Line 1015: if ak_query_pkg.g_items_table(l_index).attribute_code in ('POS_VENDOR_SITE_NAME',

1011: l_star := '';
1012:
1013: end if;
1014:
1015: if ak_query_pkg.g_items_table(l_index).attribute_code in ('POS_VENDOR_SITE_NAME',
1016: 'POS_SHIP_TO_LOCATION') then
1017:
1018: l_fix := ' onfocus="javascript:checkBlur(this)" ';
1019:

Line 1029: ak_query_pkg.g_items_table(l_index).attribute_label_long||

1025:
1026: htp.p('

'|| l_star ||
1028: ''||
1029: ak_query_pkg.g_items_table(l_index).attribute_label_long||
1030: '` 		'||
1032: '');
1033: htp.p('

Line 1033: htp.p('

1029: ak_query_pkg.g_items_table(l_index).attribute_label_long||
1030: '` 

'||
1032: '');
1033: htp.p(' 1034: ' VALUE="'||
1035: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1036: p_start_index=>l_count) ||
1037: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||

Line 1035: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

1031: htp.p('

'||
1032: '');
1033: htp.p(' 1034: ' VALUE="'||
1035: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1036: p_start_index=>l_count) ||
1037: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1038: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||

Line 1037: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||

1033: htp.p(' 1034: ' VALUE="'||
1035: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1036: p_start_index=>l_count) ||
1037: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1038: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1040: l_fix ||'>');
1041:

Line 1038: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||

1034: ' VALUE="'||
1035: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1036: p_start_index=>l_count) ||
1037: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1038: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1040: l_fix ||'>');
1041:
1042: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND

Line 1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||

1035: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1036: p_start_index=>l_count) ||
1037: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1038: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1040: l_fix ||'>');
1041:
1042: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1043: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN

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

1038: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1040: l_fix ||'>');
1041:
1042: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1043: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
1044:
1045: htp.p('

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

1039: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1040: l_fix ||'>');
1041:
1042: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1043: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
1044:
1045: htp.p(' 1047: '>
'|| l_star ||
1173: ''||
1174: ak_query_pkg.g_items_table(l_index).attribute_label_long||
1175: '` 		'||
1177: '');
1178: htp.p('

Line 1178: htp.p('

1174: ak_query_pkg.g_items_table(l_index).attribute_label_long||
1175: '` 

'||
1177: '');
1178: htp.p(' 1179: ' VALUE="'||
1180: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1181: p_start_index=>l_count) ||
1182: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||

Line 1180: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

1176: htp.p('

'||
1177: '');
1178: htp.p(' 1179: ' VALUE="'||
1180: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1181: p_start_index=>l_count) ||
1182: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1183: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||

Line 1182: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||

1178: htp.p(' 1179: ' VALUE="'||
1180: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1181: p_start_index=>l_count) ||
1182: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1183: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1185: l_fix ||'>');
1186:

Line 1183: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||

1179: ' VALUE="'||
1180: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1181: p_start_index=>l_count) ||
1182: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1183: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1185: l_fix ||'>');
1186:
1187: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND

Line 1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||

1180: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
1181: p_start_index=>l_count) ||
1182: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length ||
1183: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1185: l_fix ||'>');
1186:
1187: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1188: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN

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

1183: ' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length ||
1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1185: l_fix ||'>');
1186:
1187: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1188: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
1189:
1190: htp.p('

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

1184: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')" ' ||
1185: l_fix ||'>');
1186:
1187: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
1188: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
1189:
1190: htp.p(' 1192: '>

1444:
1445: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1446: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1447:
1448: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1449:
1450: htp.p('

' ||
1452: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '		 1447:
1448: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1449:
1450: htp.p('		' ||
1452: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '		' ||
1452: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '

1450: htp.p('

' ||
1452: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '		 ' ||
1458: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '		 ' ||
1458: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '		' ||
1458: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long || '
');

Line 1491: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN

1487:
1488: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1489: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1490:
1491: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1492:
1493: htp.p('

');
1494:
1495: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN

Line 1493: htp.p('
');

1489: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1490:
1491: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1492:
1493: htp.p('

');
1494:
1495: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN
1496:
1497: null;

Line 1495: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN

1491: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1492:
1493: htp.p('

');
1494:
1495: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN
1496:
1497: null;
1498:
1499: htp.p('

1495: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN
1496:
1497: null;
1498:
1499: htp.p('');
1501:
1502: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1503:

Line 1502: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN

1498:
1499: htp.p('');
1501:
1502: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1503:
1504: if ak_query_pkg.g_items_table(l_attribute_index).attribute_code = 'POS_ITEM_DESCRIPTION' then
1505:
1506: htp.p('

' ||

Line 1504: if ak_query_pkg.g_items_table(l_attribute_index).attribute_code = 'POS_ITEM_DESCRIPTION' then

1500: '" TYPE="HIDDEN" VALUE="' || get_result_value(p_result_index, l_current_col) || '">');
1501:
1502: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1503:
1504: if ak_query_pkg.g_items_table(l_attribute_index).attribute_code = 'POS_ITEM_DESCRIPTION' then
1505:
1506: htp.p('

' ||
1507: nvl(get_result_value(p_result_index, l_current_col), '` ') || '');
1508:

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

1516: END IF;
1517:
1518: END IF;
1519:
1520: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
1521:
1522: END LOOP;
1523:
1524: END PrintAvailableShipment;

Line 1529: l_attribute_index NUMBER := ak_query_pkg.g_items_table.FIRST;

1525:
1526: PROCEDURE PrintSelectedShipment(p_result_index NUMBER,
1527: p_current_row NUMBER) IS
1528:
1529: l_attribute_index NUMBER := ak_query_pkg.g_items_table.FIRST;
1530: l_current_col NUMBER := 0;
1531:
1532: BEGIN
1533:

Line 1536: if (ak_query_pkg.g_items_table(l_attribute_index).node_query_flag = 'Y') then

1532: BEGIN
1533:
1534: WHILE (l_attribute_index IS NOT NULL) LOOP
1535:
1536: if (ak_query_pkg.g_items_table(l_attribute_index).node_query_flag = 'Y') then
1537:
1538: l_current_col := l_current_col + 1;
1539:
1540: end if;

Line 1542: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND

1538: l_current_col := l_current_col + 1;
1539:
1540: end if;
1541:
1542: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1543: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1544:
1545: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1546:

Line 1543: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN

1539:
1540: end if;
1541:
1542: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1543: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1544:
1545: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1546:
1547: htp.p('

');

Line 1545: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN

1541:
1542: IF (ak_query_pkg.g_items_table(l_attribute_index).node_display_flag = 'Y') AND
1543: (ak_query_pkg.g_items_table(l_attribute_index).secured_column = 'F') THEN
1544:
1545: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1546:
1547: htp.p('

');
1548:
1549: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN

Line 1549: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN

1545: IF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'CHECKBOX') THEN
1546:
1547: htp.p('

');
1548:
1549: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'HIDDEN') THEN
1550:
1551: htp.p('');
1553:

Line 1551: htp.p(' 1552: '" TYPE="HIDDEN" VALUE="' || get_result_value(p_result_index, l_current_col) || '">');
1553:
1554: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1555:

Line 1554: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN

1550:
1551: htp.p('');
1553:
1554: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1555:
1556: if ak_query_pkg.g_items_table(l_attribute_index).attribute_code = 'POS_ITEM_DESCRIPTION' then
1557:
1558: htp.p('

' ||

Line 1556: if ak_query_pkg.g_items_table(l_attribute_index).attribute_code = 'POS_ITEM_DESCRIPTION' then

1552: '" TYPE="HIDDEN" VALUE="' || get_result_value(p_result_index, l_current_col) || '">');
1553:
1554: ELSIF (ak_query_pkg.g_items_table(l_attribute_index).item_style = 'TEXT') THEN
1555:
1556: if ak_query_pkg.g_items_table(l_attribute_index).attribute_code = 'POS_ITEM_DESCRIPTION' then
1557:
1558: htp.p('

' ||
1559: nvl(get_result_value(p_result_index, l_current_col), '` ') || '');
1560:

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

1568: END IF;
1569:
1570: END IF;
1571:
1572: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
1573:
1574: END LOOP;
1575:
1576: htp.p('