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.GMP_DESPATCH_LOAD_RPT_PKG dependencies on GMP_DESPATCH_LOAD_RPT_PKG

Line 1: PACKAGE BODY GMP_DESPATCH_LOAD_RPT_PKG as

1: PACKAGE BODY GMP_DESPATCH_LOAD_RPT_PKG as
2: /* $Header: GMPRDESB.pls 120.13 2012/03/29 08:35:53 maychen ship $ */
3:
4: G_ret_code BOOLEAN;
5: G_forg VARCHAR2(240);

Line 64: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);

60: f_org := V_forg;
61: t_org := V_torg;
62:
63: --copying the parameter values into the global variables
64: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);
65: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
66: G_fres := V_fres;
67: G_tores := V_tores;
68: --Bug # 12909142 start

Line 65: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);

61: t_org := V_torg;
62:
63: --copying the parameter values into the global variables
64: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);
65: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
66: G_fres := V_fres;
67: G_tores := V_tores;
68: --Bug # 12909142 start
69: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );--V_fres_instance;

Line 69: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );--V_fres_instance;

65: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
66: G_fres := V_fres;
67: G_tores := V_tores;
68: --Bug # 12909142 start
69: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );--V_fres_instance;
70: G_tores_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_tores_instance, V_tores);--V_tores_instance;
71: --Bug # 12909142 End
72: G_start_date := to_date(V_start_date,'yyyy/mm/dd hh24:mi:ss');
73: G_to_date := to_date(V_to_date,'yyyy/mm/dd hh24:mi:ss');

Line 70: G_tores_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_tores_instance, V_tores);--V_tores_instance;

66: G_fres := V_fres;
67: G_tores := V_tores;
68: --Bug # 12909142 start
69: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );--V_fres_instance;
70: G_tores_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_tores_instance, V_tores);--V_tores_instance;
71: --Bug # 12909142 End
72: G_start_date := to_date(V_start_date,'yyyy/mm/dd hh24:mi:ss');
73: G_to_date := to_date(V_to_date,'yyyy/mm/dd hh24:mi:ss');
74: G_template := V_template;

Line 78: LOG_MESSAGE( 'Calling GMP_DESPATCH_LOAD_RPT_PKG.print_res_desp with values ');

74: G_template := V_template;
75: G_template_locale := V_template_locale;
76:
77:
78: LOG_MESSAGE( 'Calling GMP_DESPATCH_LOAD_RPT_PKG.print_res_desp with values ');
79: LOG_MESSAGE( ' G_forg = '||G_forg);
80: LOG_MESSAGE( ' G_torg = '||G_torg);
81: LOG_MESSAGE( ' G_fres = '||G_fres);
82: LOG_MESSAGE( ' G_tores = '||G_tores);

Line 145: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);

141:
142: log_message('Inside the procedure print_res_load');
143:
144: --copying the parameter values into the global variables
145: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);
146: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
147: G_inst := gmp_despatch_load_rpt_pkg.get_inst_code(V_inst_id);
148: G_plan := gmp_despatch_load_rpt_pkg.get_plan_code(V_plan_id);
149:

Line 146: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);

142: log_message('Inside the procedure print_res_load');
143:
144: --copying the parameter values into the global variables
145: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);
146: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
147: G_inst := gmp_despatch_load_rpt_pkg.get_inst_code(V_inst_id);
148: G_plan := gmp_despatch_load_rpt_pkg.get_plan_code(V_plan_id);
149:
150: IF V_fres IS NOT NULL THEN

Line 147: G_inst := gmp_despatch_load_rpt_pkg.get_inst_code(V_inst_id);

143:
144: --copying the parameter values into the global variables
145: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);
146: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
147: G_inst := gmp_despatch_load_rpt_pkg.get_inst_code(V_inst_id);
148: G_plan := gmp_despatch_load_rpt_pkg.get_plan_code(V_plan_id);
149:
150: IF V_fres IS NOT NULL THEN
151: G_fres := gmp_despatch_load_rpt_pkg.get_resource_desc(V_fres);

Line 148: G_plan := gmp_despatch_load_rpt_pkg.get_plan_code(V_plan_id);

144: --copying the parameter values into the global variables
145: G_forg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_forg);
146: G_torg := gmp_despatch_load_rpt_pkg.get_orgn_code(V_torg);
147: G_inst := gmp_despatch_load_rpt_pkg.get_inst_code(V_inst_id);
148: G_plan := gmp_despatch_load_rpt_pkg.get_plan_code(V_plan_id);
149:
150: IF V_fres IS NOT NULL THEN
151: G_fres := gmp_despatch_load_rpt_pkg.get_resource_desc(V_fres);
152: f_res := to_number(V_fres);

Line 151: G_fres := gmp_despatch_load_rpt_pkg.get_resource_desc(V_fres);

147: G_inst := gmp_despatch_load_rpt_pkg.get_inst_code(V_inst_id);
148: G_plan := gmp_despatch_load_rpt_pkg.get_plan_code(V_plan_id);
149:
150: IF V_fres IS NOT NULL THEN
151: G_fres := gmp_despatch_load_rpt_pkg.get_resource_desc(V_fres);
152: f_res := to_number(V_fres);
153: ELSE
154: G_fres := NULL;
155: f_res := NULL;

Line 159: G_tores := gmp_despatch_load_rpt_pkg.get_resource_desc(V_tores);

155: f_res := NULL;
156: END IF;
157:
158: IF V_tores IS NOT NULL THEN
159: G_tores := gmp_despatch_load_rpt_pkg.get_resource_desc(V_tores);
160: t_res := to_number(V_tores);
161: ELSE
162: G_tores := NULL;
163: t_res := NULL;

Line 168: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );

164: END IF;
165: --Bug # 12909142 start
166: --G_fres_instance := V_fres_instance;
167: --G_tores_instance := V_tores_instance;
168: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );
169: G_tores_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_tores_instance, V_tores);
170: --Bug # 12909142 End
171: G_start_date := to_date(V_start_date,'yyyy/mm/dd hh24:mi:ss');
172: G_to_date := to_date(V_to_date,'yyyy/mm/dd hh24:mi:ss');

Line 169: G_tores_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_tores_instance, V_tores);

165: --Bug # 12909142 start
166: --G_fres_instance := V_fres_instance;
167: --G_tores_instance := V_tores_instance;
168: G_fres_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_fres_instance, V_fres );
169: G_tores_instance := gmp_despatch_load_rpt_pkg.get_resource_inst(V_tores_instance, V_tores);
170: --Bug # 12909142 End
171: G_start_date := to_date(V_start_date,'yyyy/mm/dd hh24:mi:ss');
172: G_to_date := to_date(V_to_date,'yyyy/mm/dd hh24:mi:ss');
173: G_template := V_template;

Line 176: LOG_MESSAGE( 'Calling GMP_DESPATCH_LOAD_RPT_PKG.print_res_load with values ');

172: G_to_date := to_date(V_to_date,'yyyy/mm/dd hh24:mi:ss');
173: G_template := V_template;
174: G_template_locale := V_template_locale;
175:
176: LOG_MESSAGE( 'Calling GMP_DESPATCH_LOAD_RPT_PKG.print_res_load with values ');
177: LOG_MESSAGE( ' v_inst_id = '||to_char(v_inst_id));
178: LOG_MESSAGE( ' G_plan = '||G_plan);
179: IF V_plan_id IS NULL THEN
180: LOG_MESSAGE( ' No Plan Name, Please choose the plan name. Plan_id = '||to_char(plan_id));

Line 247: ' gmp_despatch_load_rpt_pkg.get_orgn_code(mp.organization_id) organzation_code, ' ||

243: ''''||G_start_date||''''||' fdate, ' ||
244: ''''||G_to_date||''''||' tdate, ' ||
245: ' CURSOR( ' ||
246: ' SELECT ' ||
247: ' gmp_despatch_load_rpt_pkg.get_orgn_code(mp.organization_id) organzation_code, ' ||
248: ' crd.resources resource_desc, ' ||
249: ' crd.usage_uom uom, '||
250: ' gi.instance_number instance_number, ' ||
251: ' CURSOR( ' ||

Line 413: ' gmp_despatch_load_rpt_pkg.get_orgn_code(dr.organization_id) organization_code, '||

409: ''''||G_start_date||''''||' fdate, ' ||
410: ''''||G_to_date||''''||' tdate, ' ||
411: ' CURSOR( ' ||
412: ' SELECT ' ||
413: ' gmp_despatch_load_rpt_pkg.get_orgn_code(dr.organization_id) organization_code, '||
414: ' substr(dr.resource_description,1,40) resource_desc,'||
415: ' dr.unit_of_measure UOM, '||
416: ' mri.serial_number Instance_number,'||
417: ' CURSOR( ' ||

Line 920: END GMP_DESPATCH_LOAD_RPT_PKG;

916: WHEN OTHERS THEN
917: log_message ('Exception in procedure rd_xml_transfer '||SQLERRM);
918: END rd_xml_transfer;
919:
920: END GMP_DESPATCH_LOAD_RPT_PKG;