17: -- Local copy of fnd globals to prevent pragma violations of api functions
18: -- to be used within 'select', 'where' and 'order by' clauses of dynamic
19: -- SQL build by wms rules engine
20: --
21: g_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
22: g_miss_char CONSTANT VARCHAR2(1) := fnd_api.g_miss_char;
23: g_miss_date CONSTANT DATE := fnd_api.g_miss_date;
24:
25:
18: -- to be used within 'select', 'where' and 'order by' clauses of dynamic
19: -- SQL build by wms rules engine
20: --
21: g_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
22: g_miss_char CONSTANT VARCHAR2(1) := fnd_api.g_miss_char;
23: g_miss_date CONSTANT DATE := fnd_api.g_miss_date;
24:
25:
26: -- Following global variables are use to cache the locator_id and and the qty_onhand to improve
19: -- SQL build by wms rules engine
20: --
21: g_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
22: g_miss_char CONSTANT VARCHAR2(1) := fnd_api.g_miss_char;
23: g_miss_date CONSTANT DATE := fnd_api.g_miss_date;
24:
25:
26: -- Following global variables are use to cache the locator_id and and the qty_onhand to improve
27: -- the performance of the getItemonhand function() used in the rules defination query