APPS.INV_DIAG_ITEM dependencies on INV_DIAG_GRP

Line 58: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'

54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
55: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
56:
57: /* -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
58: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'
59: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');
60: statusStr := 'FAILURE';
61: errStr := 'This test requires Inventory Responsibility Role';
62: fixInfo := 'Please contact your sysadmin to get Inventory Responsibility';

Line 72: l_row_limit := INV_DIAG_GRP.g_max_row;

68:
69: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
71: l_count := 0 ;
72: l_row_limit := INV_DIAG_GRP.g_max_row;
73:
74: IF l_item_id IS NOT NULL AND l_org_id IS NOT NULL THEN
75: OPEN c_item_valid (l_item_id, l_org_id);
76: FETCH c_item_valid INTO l_count;

Line 92: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;

88: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
89: RETURN;
90: END IF;
91:
92: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;
93: INV_DIAG_GRP.g_inv_diag_item_tbl(1).inventory_item_id :=l_item_id;
94: INV_DIAG_GRP.g_inv_diag_item_tbl(1).org_id := l_org_id;
95:
96: -- Collect the item informatation in a local variable

Line 93: INV_DIAG_GRP.g_inv_diag_item_tbl(1).inventory_item_id :=l_item_id;

89: RETURN;
90: END IF;
91:
92: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;
93: INV_DIAG_GRP.g_inv_diag_item_tbl(1).inventory_item_id :=l_item_id;
94: INV_DIAG_GRP.g_inv_diag_item_tbl(1).org_id := l_org_id;
95:
96: -- Collect the item informatation in a local variable
97: OPEN c_item_info (l_item_id, l_org_id);

Line 94: INV_DIAG_GRP.g_inv_diag_item_tbl(1).org_id := l_org_id;

90: END IF;
91:
92: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;
93: INV_DIAG_GRP.g_inv_diag_item_tbl(1).inventory_item_id :=l_item_id;
94: INV_DIAG_GRP.g_inv_diag_item_tbl(1).org_id := l_org_id;
95:
96: -- Collect the item informatation in a local variable
97: OPEN c_item_info (l_item_id, l_org_id);
98: FETCH c_item_info INTO l_item;

Line 102: if INV_DIAG_GRP.g_grp_name is null then --standard alone test for item

98: FETCH c_item_info INTO l_item;
99: CLOSE c_item_info;
100:
101:
102: if INV_DIAG_GRP.g_grp_name is null then --standard alone test for item
103: --fnd_file.put_line(fnd_file.log,'@@@ item grp null');
104: sqltxt := 'SELECT language "Language" '||
105: ', description "Description" '||
106: ', long_description "Long Description" '||