eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_GTA_CONSOLIDATE_PROC dependencies on XMLTYPE

Line 76: l_report_XML XMLType;

72: (p_consolidation_paras IN AR_GTA_TRX_UTIL.consolparas_rec_type
73: )
74: IS
75: l_procedure_name VARCHAR2(30):='Generate_XML_output';
76: l_report_XML XMLType;
77: l_parameter XMLType;
78: l_success XMLType;
79: l_warning XMLType;
80: l_failed XMLType;

Line 77: l_parameter XMLType;

73: )
74: IS
75: l_procedure_name VARCHAR2(30):='Generate_XML_output';
76: l_report_XML XMLType;
77: l_parameter XMLType;
78: l_success XMLType;
79: l_warning XMLType;
80: l_failed XMLType;
81: --Yao Zhang add for bug 14462789

Line 78: l_success XMLType;

74: IS
75: l_procedure_name VARCHAR2(30):='Generate_XML_output';
76: l_report_XML XMLType;
77: l_parameter XMLType;
78: l_success XMLType;
79: l_warning XMLType;
80: l_failed XMLType;
81: --Yao Zhang add for bug 14462789
82: l_consol_seq VARCHAR2(30);

Line 79: l_warning XMLType;

75: l_procedure_name VARCHAR2(30):='Generate_XML_output';
76: l_report_XML XMLType;
77: l_parameter XMLType;
78: l_success XMLType;
79: l_warning XMLType;
80: l_failed XMLType;
81: --Yao Zhang add for bug 14462789
82: l_consol_seq VARCHAR2(30);
83: l_success_invs XMLType;

Line 80: l_failed XMLType;

76: l_report_XML XMLType;
77: l_parameter XMLType;
78: l_success XMLType;
79: l_warning XMLType;
80: l_failed XMLType;
81: --Yao Zhang add for bug 14462789
82: l_consol_seq VARCHAR2(30);
83: l_success_invs XMLType;
84: l_warning_invs XMLType;

Line 83: l_success_invs XMLType;

79: l_warning XMLType;
80: l_failed XMLType;
81: --Yao Zhang add for bug 14462789
82: l_consol_seq VARCHAR2(30);
83: l_success_invs XMLType;
84: l_warning_invs XMLType;
85: l_failed_invs XMLType;
86: l_success_all XMLType;
87: l_warning_all XMLType;

Line 84: l_warning_invs XMLType;

80: l_failed XMLType;
81: --Yao Zhang add for bug 14462789
82: l_consol_seq VARCHAR2(30);
83: l_success_invs XMLType;
84: l_warning_invs XMLType;
85: l_failed_invs XMLType;
86: l_success_all XMLType;
87: l_warning_all XMLType;
88: l_failed_all XMLType;

Line 85: l_failed_invs XMLType;

81: --Yao Zhang add for bug 14462789
82: l_consol_seq VARCHAR2(30);
83: l_success_invs XMLType;
84: l_warning_invs XMLType;
85: l_failed_invs XMLType;
86: l_success_all XMLType;
87: l_warning_all XMLType;
88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;

Line 86: l_success_all XMLType;

82: l_consol_seq VARCHAR2(30);
83: l_success_invs XMLType;
84: l_warning_invs XMLType;
85: l_failed_invs XMLType;
86: l_success_all XMLType;
87: l_warning_all XMLType;
88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;
90: l_Reportfailed XMLType;

Line 87: l_warning_all XMLType;

83: l_success_invs XMLType;
84: l_warning_invs XMLType;
85: l_failed_invs XMLType;
86: l_success_all XMLType;
87: l_warning_all XMLType;
88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;
90: l_Reportfailed XMLType;
91: l_failedwithparameters XMLType;

Line 88: l_failed_all XMLType;

84: l_warning_invs XMLType;
85: l_failed_invs XMLType;
86: l_success_all XMLType;
87: l_warning_all XMLType;
88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;
90: l_Reportfailed XMLType;
91: l_failedwithparameters XMLType;
92: l_summary XMLType;

Line 90: l_Reportfailed XMLType;

86: l_success_all XMLType;
87: l_warning_all XMLType;
88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;
90: l_Reportfailed XMLType;
91: l_failedwithparameters XMLType;
92: l_summary XMLType;
93: l_sameprisamedis VARCHAR2(1);
94: l_samepridiffdis VARCHAR2(1);

Line 91: l_failedwithparameters XMLType;

87: l_warning_all XMLType;
88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;
90: l_Reportfailed XMLType;
91: l_failedwithparameters XMLType;
92: l_summary XMLType;
93: l_sameprisamedis VARCHAR2(1);
94: l_samepridiffdis VARCHAR2(1);
95: l_diffpri VARCHAR2(1);

Line 92: l_summary XMLType;

88: l_failed_all XMLType;
89: -- Yao zhang add end for bug 14462789 ;
90: l_Reportfailed XMLType;
91: l_failedwithparameters XMLType;
92: l_summary XMLType;
93: l_sameprisamedis VARCHAR2(1);
94: l_samepridiffdis VARCHAR2(1);
95: l_diffpri VARCHAR2(1);
96: l_saleslistflag VARCHAR2(1);

Line 179: -- generate the xmltype for success inv

175: INTO l_summary
176: FROM dual;
177:
178:
179: -- generate the xmltype for success inv
180: --Yao Zhang add for bug 14462789
181: OPEN c_consol_seq('S');
182: LOOP
183: FETCH c_consol_seq

Line 230: -- generate the xmltype for warning inv

226: FROM dual;
227:
228: END LOOP;
229: CLOSE c_consol_seq;
230: -- generate the xmltype for warning inv
231: --Yao Zhang add for bug 14462789
232: OPEN c_consol_seq('W');
233: LOOP
234: FETCH c_consol_seq

Line 281: -- generate the xmltype for error inv

277: FROM dual;
278: END LOOP;
279: CLOSE c_consol_seq;
280: --ORDER BY jgct.seq;
281: -- generate the xmltype for error inv
282: --Yao Zhang add for bug 14462789
283: OPEN c_consol_seq('E');
284: LOOP
285: FETCH c_consol_seq