APPS.INV_DIAG_ORG dependencies on JTF_DIAGNOSTIC_COREAPI

Line 21: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

17: reportClob OUT NOCOPY CLOB) IS
18:
19: reportStr LONG;
20: counter NUMBER;
21: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
22: c_userid VARCHAR2(50);
23: statusStr VARCHAR2(50);
24: errStr VARCHAR2(4000);
25: fixInfo VARCHAR2(4000);

Line 37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

33: BEGIN
34:
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40:
41: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;

Line 38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');

34:
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40:
41: INV_DIAG_GRP.g_inv_diag_item_tbl.delete;
42: INV_DIAG_GRP.g_inv_diag_item_tbl(1).org_id := l_org_id;

Line 84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Organization Parameters');

80: ' FROM mtl_parameters '||
81: ' WHERE organization_id ='||l_org_id||' )'||
82: ' ORDER BY mp.organization_code';
83:
84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Organization Parameters');
85: statusStr := 'SUCCESS';
86: isFatal := 'FALSE';
87:
88: sqltxt := 'SELECT ORGANIZATION_CODE, organization_name, operating_unit, gl.name "Set of Books" '||

Line 92: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Organization Information');

88: sqltxt := 'SELECT ORGANIZATION_CODE, organization_name, operating_unit, gl.name "Set of Books" '||
89: 'FROM org_organization_definitions org, gl_sets_of_books gl '||
90: 'WHERE organization_id = '||l_org_id||
91: 'and org.SET_OF_BOOKS_ID=gl.set_of_books_id';
92: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Organization Information');
93: statusStr := 'SUCCESS';
94: isFatal := 'FALSE';
95:
96: sqltxt := 'select mg.concatenated_segments "Alias", gl.concatenated_segments "Account" '||

Line 103: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Account Aliases');

99: ', to_char(mg.end_date_active , ''DD-Mon-RRRR'') "Effective To" '||
100: 'from mtl_generic_dispositions_kfv mg, gl_code_combinations_kfv gl '||
101: 'where mg.distribution_account = gl.code_combination_id '||
102: 'and mg.organization_id= '||l_org_id;
103: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Account Aliases');
104: statusStr := 'SUCCESS';
105: isFatal := 'FALSE';
106:
107:

Line 111: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Inventory Accounting Periods');

107:
108: sqltxt := 'select period_name "Period", period_start_date "From", schedule_close_date "To", period_close_date "Close Date", decode(open_flag, ''Y'', ''Open'', ''Closed'') "Status" '||
109: 'from org_acct_periods where organization_id = '||l_org_id||
110: 'order by acct_period_id desc ';
111: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Inventory Accounting Periods');
112: statusStr := 'SUCCESS';
113: isFatal := 'FALSE';
114:
115: sqltxt := 'select alias_name "Alias", gl.code_combination_id "Account Id" '||

Line 125: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Operations Account');

121: 'where id_flex_code =''GL#'' and application_id=101 and ID_FLEX_NUM=''101'' '||
122: 'and gl.chart_of_accounts_id = ff.id_flex_num '||
123: 'and gl.concatenated_segments=ff.concatenated_segments' ;
124:
125: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Operations Account');
126: statusStr := 'SUCCESS';
127: isFatal := 'FALSE';
128:
129: else

Line 131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Org Id or Org Code input is requred!');

127: isFatal := 'FALSE';
128:
129: else
130:
131: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Org Id or Org Code input is requred!');
132: statusStr := 'FAILURE';
133: errStr := 'This test failed as: no input';
134: fixInfo := 'Put informative fix info. here';
135: isFatal := 'SUCCESS';