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

Line 1: PACKAGE BODY GMD_CoA_Data_OM AS

1: PACKAGE BODY GMD_CoA_Data_OM AS
2: /* $Header: GMDCOA3B.pls 115.13 2004/02/18 16:52:36 magupta noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_COA_DATA_OM';
5: v_stage NUMBER; /* Variable for debugging. */

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_COA_DATA_OM';

1: PACKAGE BODY GMD_CoA_Data_OM AS
2: /* $Header: GMDCOA3B.pls 115.13 2004/02/18 16:52:36 magupta noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_COA_DATA_OM';
5: v_stage NUMBER; /* Variable for debugging. */
6: p_msg VARCHAR2(4000);
7: l_debug_enabled VARCHAR2(1):='Y';
8: l_utl_file_dir VARCHAR2(1000);

Line 561: trace('Populate Details Going to GMD_COA_DATA_OM.Look_For_CoC_Specs');

557: /* But tbl_hdr was passed to Populate_Details as IN. */
558: /* Look_For_Coc_Specs should not change hdr table with sales- */
559: /* order-no-results scenario, so send a temporary,writable copy. */
560: l_tmp_hdr_tbl := tbl_hdr;
561: trace('Populate Details Going to GMD_COA_DATA_OM.Look_For_CoC_Specs');
562: GMD_COA_DATA_OM.Look_For_CoC_Specs
563: (l_dummy_param_rec,
564: tbl_ndx,
565: l_tmp_hdr_tbl,

Line 562: GMD_COA_DATA_OM.Look_For_CoC_Specs

558: /* Look_For_Coc_Specs should not change hdr table with sales- */
559: /* order-no-results scenario, so send a temporary,writable copy. */
560: l_tmp_hdr_tbl := tbl_hdr;
561: trace('Populate Details Going to GMD_COA_DATA_OM.Look_For_CoC_Specs');
562: GMD_COA_DATA_OM.Look_For_CoC_Specs
563: (l_dummy_param_rec,
564: tbl_ndx,
565: l_tmp_hdr_tbl,
566: tbl_dtl);

Line 567: trace('Populate Details coming back from GMD_COA_DATA_OM.Look_For_CoC_Specs');

563: (l_dummy_param_rec,
564: tbl_ndx,
565: l_tmp_hdr_tbl,
566: tbl_dtl);
567: trace('Populate Details coming back from GMD_COA_DATA_OM.Look_For_CoC_Specs');
568: IF tbl_dtl.FIRST is not NULL THEN
569: v_report_title := 'COC';
570: END IF;
571: /* end if there are any rows in tbl_dtl */

Line 1199: trace('Populate_CoA_Data :- Going to GMD_COA_DATA_OM.Populate_Details');

1195:
1196:
1197:
1198: IF v_report_title <> 'BLK' THEN
1199: trace('Populate_CoA_Data :- Going to GMD_COA_DATA_OM.Populate_Details');
1200: GMD_COA_DATA_OM.Populate_Details (tbl_hdr, tbl_dtl);
1201: trace('Populate_CoA_Data :- Came Back from GMD_COA_DATA_OM.Populate_Details');
1202:
1203: END IF;

Line 1200: GMD_COA_DATA_OM.Populate_Details (tbl_hdr, tbl_dtl);

1196:
1197:
1198: IF v_report_title <> 'BLK' THEN
1199: trace('Populate_CoA_Data :- Going to GMD_COA_DATA_OM.Populate_Details');
1200: GMD_COA_DATA_OM.Populate_Details (tbl_hdr, tbl_dtl);
1201: trace('Populate_CoA_Data :- Came Back from GMD_COA_DATA_OM.Populate_Details');
1202:
1203: END IF;
1204:

Line 1201: trace('Populate_CoA_Data :- Came Back from GMD_COA_DATA_OM.Populate_Details');

1197:
1198: IF v_report_title <> 'BLK' THEN
1199: trace('Populate_CoA_Data :- Going to GMD_COA_DATA_OM.Populate_Details');
1200: GMD_COA_DATA_OM.Populate_Details (tbl_hdr, tbl_dtl);
1201: trace('Populate_CoA_Data :- Came Back from GMD_COA_DATA_OM.Populate_Details');
1202:
1203: END IF;
1204:
1205: IF tbl_dtl.EXISTS(1) THEN

Line 1206: GMD_COA_DATA_OM.Populate_Text (tbl_dtl, tbl_spec_text, tbl_rslt_text);

1202:
1203: END IF;
1204:
1205: IF tbl_dtl.EXISTS(1) THEN
1206: GMD_COA_DATA_OM.Populate_Text (tbl_dtl, tbl_spec_text, tbl_rslt_text);
1207: ELSE
1208: tbl_hdr := empty_header;
1209: /* if there is nothing in details, empty headers */
1210: /* this is not an error. Report will be empty */

Line 1557: param_rec gmd_coa_data_om.t_coa_parameters;

1553: where l.lookup_type = 'GMD_COA_REPORT_TITLE'
1554: and l.lookup_code = 'BLK';
1555:
1556:
1557: param_rec gmd_coa_data_om.t_coa_parameters;
1558: header_table gmd_coa_data_om.t_coa_header_tbl;
1559: detail_table gmd_coa_data_om.t_coa_detail_tbl;
1560: spec_text_table gmd_coa_data_om.t_coa_text_tbl;
1561: rslt_text_table gmd_coa_data_om.t_coa_text_tbl;

Line 1558: header_table gmd_coa_data_om.t_coa_header_tbl;

1554: and l.lookup_code = 'BLK';
1555:
1556:
1557: param_rec gmd_coa_data_om.t_coa_parameters;
1558: header_table gmd_coa_data_om.t_coa_header_tbl;
1559: detail_table gmd_coa_data_om.t_coa_detail_tbl;
1560: spec_text_table gmd_coa_data_om.t_coa_text_tbl;
1561: rslt_text_table gmd_coa_data_om.t_coa_text_tbl;
1562:

Line 1559: detail_table gmd_coa_data_om.t_coa_detail_tbl;

1555:
1556:
1557: param_rec gmd_coa_data_om.t_coa_parameters;
1558: header_table gmd_coa_data_om.t_coa_header_tbl;
1559: detail_table gmd_coa_data_om.t_coa_detail_tbl;
1560: spec_text_table gmd_coa_data_om.t_coa_text_tbl;
1561: rslt_text_table gmd_coa_data_om.t_coa_text_tbl;
1562:
1563: X_status BOOLEAN;

Line 1560: spec_text_table gmd_coa_data_om.t_coa_text_tbl;

1556:
1557: param_rec gmd_coa_data_om.t_coa_parameters;
1558: header_table gmd_coa_data_om.t_coa_header_tbl;
1559: detail_table gmd_coa_data_om.t_coa_detail_tbl;
1560: spec_text_table gmd_coa_data_om.t_coa_text_tbl;
1561: rslt_text_table gmd_coa_data_om.t_coa_text_tbl;
1562:
1563: X_status BOOLEAN;
1564: X_conc_id NUMBER;

Line 1561: rslt_text_table gmd_coa_data_om.t_coa_text_tbl;

1557: param_rec gmd_coa_data_om.t_coa_parameters;
1558: header_table gmd_coa_data_om.t_coa_header_tbl;
1559: detail_table gmd_coa_data_om.t_coa_detail_tbl;
1560: spec_text_table gmd_coa_data_om.t_coa_text_tbl;
1561: rslt_text_table gmd_coa_data_om.t_coa_text_tbl;
1562:
1563: X_status BOOLEAN;
1564: X_conc_id NUMBER;
1565: X_which_report VARCHAR2(80);

Line 1597: Trace('run_coa_coc : Going to gmd_coa_data_om.populate_coa_data, Shipment No '|| param_rec.shipment_no);

1593:
1594: p_init_msg_list := 'T';
1595: p_commit := 'T';
1596: p_validation_level := 0;
1597: Trace('run_coa_coc : Going to gmd_coa_data_om.populate_coa_data, Shipment No '|| param_rec.shipment_no);
1598: gmd_coa_data_om.populate_coa_data (
1599: p_api_version_populate,
1600: p_init_msg_list,
1601: p_commit,

Line 1598: gmd_coa_data_om.populate_coa_data (

1594: p_init_msg_list := 'T';
1595: p_commit := 'T';
1596: p_validation_level := 0;
1597: Trace('run_coa_coc : Going to gmd_coa_data_om.populate_coa_data, Shipment No '|| param_rec.shipment_no);
1598: gmd_coa_data_om.populate_coa_data (
1599: p_api_version_populate,
1600: p_init_msg_list,
1601: p_commit,
1602: p_validation_level,

Line 1608: Trace('run_coa_coc : Coming from gmd_coa_data_om.populate_coa_data, x_return_status'||x_return_status);

1604: x_return_status, x_msg_count, x_msg_data,
1605: header_table, detail_table,
1606: spec_text_table, rslt_text_table);
1607:
1608: Trace('run_coa_coc : Coming from gmd_coa_data_om.populate_coa_data, x_return_status'||x_return_status);
1609: IF x_return_status = 'S' THEN -- #1
1610:
1611: -- check if plsql tables have any data.
1612: -- If so, do dump to db tables and call concurrent manager for report.

Line 1616: Trace('run_coa_coc : calling gmd_coa_data_om.dump_to_db_tables ');

1612: -- If so, do dump to db tables and call concurrent manager for report.
1613: -- else give user 'blank report' message.
1614:
1615: p_init_msg_list := 'F';
1616: Trace('run_coa_coc : calling gmd_coa_data_om.dump_to_db_tables ');
1617: gmd_coa_data_om.dump_to_db_tables (
1618: p_api_version_dump,
1619: p_init_msg_list,
1620: p_commit,

Line 1617: gmd_coa_data_om.dump_to_db_tables (

1613: -- else give user 'blank report' message.
1614:
1615: p_init_msg_list := 'F';
1616: Trace('run_coa_coc : calling gmd_coa_data_om.dump_to_db_tables ');
1617: gmd_coa_data_om.dump_to_db_tables (
1618: p_api_version_dump,
1619: p_init_msg_list,
1620: p_commit,
1621: p_validation_level,

Line 1625: Trace('run_coa_coc : returning from gmd_coa_data_om.dump_to_db_tables, x_return_status'||x_return_status);

1621: p_validation_level,
1622: header_table, detail_table,
1623: spec_text_table, rslt_text_table,
1624: x_return_status, x_msg_count, x_msg_data);
1625: Trace('run_coa_coc : returning from gmd_coa_data_om.dump_to_db_tables, x_return_status'||x_return_status);
1626:
1627:
1628: IF x_return_status = 'S' THEN -- #2
1629: OPEN get_report_title;

Line 1693: END GMD_CoA_Data_OM;

1689: END run_coa_coc;
1690:
1691:
1692:
1693: END GMD_CoA_Data_OM;