30: l_proc_flag varchar2(1);
31: BEGIN
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: -- accept input
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_acct_period_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctId',inputs);
38: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ProcFlag',inputs);
65: end if;
66:
67: sqltxt :=sqltxt||' ORDER BY mp.organization_code, oap.acct_period_id';
68:
69: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Period Information for Pending Txn in MMTT');
70:
71: statusStr := 'SUCCESS';
72: isFatal := 'FALSE';
73:
116: if l_proc_flag is not null then
117: sqltxt :=sqltxt||'AND process_flag= ' ||l_proc_flag;
118: end if;
119:
120: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Error Txn in MMTT');
121:
122: statusStr := 'SUCCESS';
123: isFatal := 'FALSE';
124:
123: isFatal := 'FALSE';
124:
125: /**
126: else
127: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input parameters');
128: statusStr := 'FAILURE';
129: errStr := 'org_id null';
130: fixInfo := 'Org or OrdID input is required ';
131: isFatal := 'SUCCESS';