APPS.ICX_POR_EXTRACTOR dependencies on ICX_POR_LOADER_VALUES

Line 16: UPDATE ICX_POR_LOADER_VALUES

12: 'Update last run dates');
13:
14: IF pType = 'VENDOR_NAME' then
15: xErrLoc := 120;
16: UPDATE ICX_POR_LOADER_VALUES
17: SET vendor_last_run_date = gLastRunDate;
18: ELSIF pType = 'CATEGORY' then
19: IF gLoaderValue.load_categories = 'Y' THEN
20: gLoaderValue.categories_last_run_date := gLastRunDate;

Line 23: UPDATE ICX_POR_LOADER_VALUES

19: IF gLoaderValue.load_categories = 'Y' THEN
20: gLoaderValue.categories_last_run_date := gLastRunDate;
21: END IF;
22: xErrLoc := 120;
23: UPDATE ICX_POR_LOADER_VALUES
24: SET categories_last_run_date =
25: gLoaderValue.categories_last_run_date;
26: ELSIF pType = 'TEMPLATE_HEADER' then
27: IF gLoaderValue.load_template_headers = 'Y' THEN

Line 31: UPDATE ICX_POR_LOADER_VALUES

27: IF gLoaderValue.load_template_headers = 'Y' THEN
28: gLoaderValue.template_headers_last_run_date := gLastRunDate;
29: END IF;
30: xErrLoc := 140;
31: UPDATE ICX_POR_LOADER_VALUES
32: SET template_headers_last_run_date =
33: gLoaderValue.template_headers_last_run_date;
34: ELSIF pType = 'TEMPLATE' THEN
35: xErrLoc := 160;

Line 39: UPDATE icx_por_loader_values

35: xErrLoc := 160;
36: IF (gLoaderValue.load_template_lines = 'Y') THEN
37: gLoaderValue.template_lines_last_run_date := gLastRunDate;
38: END IF;
39: UPDATE icx_por_loader_values
40: SET template_lines_last_run_date =
41: gLoaderValue.template_lines_last_run_date;
42: ELSIF pType = 'CONTRACT' THEN
43: xErrLoc := 160;

Line 47: UPDATE icx_por_loader_values

43: xErrLoc := 160;
44: IF (gLoaderValue.load_contracts = 'Y') THEN
45: gLoaderValue.contracts_last_run_date := gLastRunDate;
46: END IF;
47: UPDATE icx_por_loader_values
48: SET contracts_last_run_date =
49: gLoaderValue.contracts_last_run_date;
50: ELSIF pType = 'ITEM' THEN
51: xErrLoc := 160;

Line 58: UPDATE icx_por_loader_values

54: END IF;
55: IF (gLoaderValue.load_internal_item = 'Y') THEN
56: gLoaderValue.internal_item_last_run_date := gLastRunDate;
57: END IF;
58: UPDATE icx_por_loader_values
59: SET item_master_last_run_date =
60: gLoaderValue.item_master_last_run_date,
61: internal_item_last_run_date =
62: gLoaderValue.internal_item_last_run_date;

Line 133: -- get loader value from ICX_POR_LOADER_VALUES

129: end if;
130:
131: xErrLoc := 200;
132:
133: -- get loader value from ICX_POR_LOADER_VALUES
134: -- Bug # 3991430
135: -- New column is added in the ICX_POR_LOADER_VALUES table to extract one time item in all the installed languages
136:
137: select nvl(load_catalog_groups, 'N'),

Line 135: -- New column is added in the ICX_POR_LOADER_VALUES table to extract one time item in all the installed languages

131: xErrLoc := 200;
132:
133: -- get loader value from ICX_POR_LOADER_VALUES
134: -- Bug # 3991430
135: -- New column is added in the ICX_POR_LOADER_VALUES table to extract one time item in all the installed languages
136:
137: select nvl(load_catalog_groups, 'N'),
138: nvl(load_categories, 'N'),
139: nvl(load_template_headers, 'N'),

Line 171: from icx_por_loader_values

167: gLoaderValue.load_internal_item,
168: gLoaderValue.internal_item_last_run_date,
169: gLoaderValue.cleanup_flag,
170: gLoaderValue.load_onetimeitems_all_langs -- Bug # 3991430
171: from icx_por_loader_values
172: where rownum = 1;
173:
174: xErrLoc := 300;
175: -- get last run date before starting process