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

Line 1: PACKAGE BODY "AHL_PRD_PRINT_PVT" AS

1: PACKAGE BODY "AHL_PRD_PRINT_PVT" AS
2: /* $Header: AHLVPPRB.pls 120.43.12020000.2 2012/12/07 11:40:50 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) :='AHL_PRD_PRINT_PVT';
5:

Line 4: G_PKG_NAME VARCHAR2(30) :='AHL_PRD_PRINT_PVT';

1: PACKAGE BODY "AHL_PRD_PRINT_PVT" AS
2: /* $Header: AHLVPPRB.pls 120.43.12020000.2 2012/12/07 11:40:50 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) :='AHL_PRD_PRINT_PVT';
5:
6: -- Constants to identify locator and item number elements
7: G_ITEM_NUMBER_CHAR NUMBER := 10;
8: G_LOCATOR_CHAR NUMBER := 15;

Line 124: decode(wo.scheduled_start_date, null, null, TO_CHAR(wo.scheduled_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_start_date,

120: wo.job_status_meaning,
121: wo.visit_number,
122: wo.organization_name,
123: wo.department_name,
124: decode(wo.scheduled_start_date, null, null, TO_CHAR(wo.scheduled_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_start_date,
125: decode(wo.scheduled_end_date, null, null, TO_CHAR(wo.scheduled_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_end_date,
126: decode(wo.actual_start_date, null, null, TO_CHAR(wo.actual_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )actual_start_date,
127: decode(wo.actual_end_date, null, null, TO_CHAR(wo.actual_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) actual_end_date,
128: wo.unit_name,

Line 125: decode(wo.scheduled_end_date, null, null, TO_CHAR(wo.scheduled_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_end_date,

121: wo.visit_number,
122: wo.organization_name,
123: wo.department_name,
124: decode(wo.scheduled_start_date, null, null, TO_CHAR(wo.scheduled_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_start_date,
125: decode(wo.scheduled_end_date, null, null, TO_CHAR(wo.scheduled_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_end_date,
126: decode(wo.actual_start_date, null, null, TO_CHAR(wo.actual_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )actual_start_date,
127: decode(wo.actual_end_date, null, null, TO_CHAR(wo.actual_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) actual_end_date,
128: wo.unit_name,
129: wo.wo_part_number,

Line 126: decode(wo.actual_start_date, null, null, TO_CHAR(wo.actual_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )actual_start_date,

122: wo.organization_name,
123: wo.department_name,
124: decode(wo.scheduled_start_date, null, null, TO_CHAR(wo.scheduled_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_start_date,
125: decode(wo.scheduled_end_date, null, null, TO_CHAR(wo.scheduled_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_end_date,
126: decode(wo.actual_start_date, null, null, TO_CHAR(wo.actual_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )actual_start_date,
127: decode(wo.actual_end_date, null, null, TO_CHAR(wo.actual_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) actual_end_date,
128: wo.unit_name,
129: wo.wo_part_number,
130: wo.serial_number,

Line 127: decode(wo.actual_end_date, null, null, TO_CHAR(wo.actual_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) actual_end_date,

123: wo.department_name,
124: decode(wo.scheduled_start_date, null, null, TO_CHAR(wo.scheduled_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_start_date,
125: decode(wo.scheduled_end_date, null, null, TO_CHAR(wo.scheduled_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.scheduled_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) scheduled_end_date,
126: decode(wo.actual_start_date, null, null, TO_CHAR(wo.actual_start_date,''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_start_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )actual_start_date,
127: decode(wo.actual_end_date, null, null, TO_CHAR(wo.actual_end_date, ''YYYY-MM-DD'')||''T''||TO_CHAR(wo.actual_end_date, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) actual_end_date,
128: wo.unit_name,
129: wo.wo_part_number,
130: wo.serial_number,
131: wo.mr_title,

Line 146: decode(ENTERED_DATE, null, null, TO_CHAR(ENTERED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ENTERED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ENTERED_DATE,

142:
143: --2. Gather turnover notes for the workorder.
144: l_to_notes VARCHAR2(3000) := '
145: SELECT
146: decode(ENTERED_DATE, null, null, TO_CHAR(ENTERED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ENTERED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ENTERED_DATE,
147: ENTERED_BY_NAME ,
148: notes
149: FROM
150: JTF_NOTES_VL

Line 167: decode(SCHEDULED_START_DATE, null, null, TO_CHAR(SCHEDULED_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULED_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )SCHEDULED_START_DATE,

163: --AHL_PRD_UTIL_PKG.Get_Op_TotalHours_Assigned(WIP_ENTITY_ID,operation_sequence_num) "Total_Hours",
164: --AHL_PRD_UTIL_PKG.Get_Op_transacted_hours(WIP_ENTITY_ID,operation_sequence_num) "Hours_Worked",
165:
166: l_op_details_2 VARCHAR2(1000) := '
167: decode(SCHEDULED_START_DATE, null, null, TO_CHAR(SCHEDULED_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULED_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )SCHEDULED_START_DATE,
168: decode(ACTUAL_START_DATE, null, null, TO_CHAR(ACTUAL_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_START_DATE,
169: decode(ACTUAL_END_DATE, null, null, TO_CHAR(ACTUAL_END_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_END_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_END_DATE
170: FROM
171: ahl_workorder_operations_v

Line 168: decode(ACTUAL_START_DATE, null, null, TO_CHAR(ACTUAL_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_START_DATE,

164: --AHL_PRD_UTIL_PKG.Get_Op_transacted_hours(WIP_ENTITY_ID,operation_sequence_num) "Hours_Worked",
165:
166: l_op_details_2 VARCHAR2(1000) := '
167: decode(SCHEDULED_START_DATE, null, null, TO_CHAR(SCHEDULED_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULED_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )SCHEDULED_START_DATE,
168: decode(ACTUAL_START_DATE, null, null, TO_CHAR(ACTUAL_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_START_DATE,
169: decode(ACTUAL_END_DATE, null, null, TO_CHAR(ACTUAL_END_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_END_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_END_DATE
170: FROM
171: ahl_workorder_operations_v
172: WHERE

Line 169: decode(ACTUAL_END_DATE, null, null, TO_CHAR(ACTUAL_END_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_END_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_END_DATE

165:
166: l_op_details_2 VARCHAR2(1000) := '
167: decode(SCHEDULED_START_DATE, null, null, TO_CHAR(SCHEDULED_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULED_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset )SCHEDULED_START_DATE,
168: decode(ACTUAL_START_DATE, null, null, TO_CHAR(ACTUAL_START_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_START_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_START_DATE,
169: decode(ACTUAL_END_DATE, null, null, TO_CHAR(ACTUAL_END_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(ACTUAL_END_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) ACTUAL_END_DATE
170: FROM
171: ahl_workorder_operations_v
172: WHERE
173: workorder_operation_id = ';

Line 183: decode(REQUESTED_DATE, null, null, TO_CHAR(REQUESTED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(REQUESTED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) required_date,

179: CONCATENATED_SEGMENTS,
180: OPERATION_SEQUENCE,
181: DESCRIPTION,
182: REQUESTED_QUANTITY required_quantity,
183: decode(REQUESTED_DATE, null, null, TO_CHAR(REQUESTED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(REQUESTED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) required_date,
184: SCHEDULE_QUANTITY,
185: decode(SCHEDULE_DATE, null, null, TO_CHAR(SCHEDULE_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULE_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) SCHEDULE_DATE,
186: ISSUED_QTY,
187: UOM

Line 185: decode(SCHEDULE_DATE, null, null, TO_CHAR(SCHEDULE_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULE_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) SCHEDULE_DATE,

181: DESCRIPTION,
182: REQUESTED_QUANTITY required_quantity,
183: decode(REQUESTED_DATE, null, null, TO_CHAR(REQUESTED_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(REQUESTED_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) required_date,
184: SCHEDULE_QUANTITY,
185: decode(SCHEDULE_DATE, null, null, TO_CHAR(SCHEDULE_DATE, ''YYYY-MM-DD'')||''T''||TO_CHAR(SCHEDULE_DATE, ''hh24:mi:ss'')||AHL_PRD_PRINT_PVT.get_tz_offset ) SCHEDULE_DATE,
186: ISSUED_QTY,
187: UOM
188: FROM
189: AHL_JOB_OPER_MATERIALS_V

Line 472: 'AHL_PRD_PRINT_PVT.get_tz_offset -> '||AHL_PRD_PRINT_PVT.get_tz_offset

468: fnd_log.string
469: (
470: fnd_log.level_statement,
471: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
472: 'AHL_PRD_PRINT_PVT.get_tz_offset -> '||AHL_PRD_PRINT_PVT.get_tz_offset
473: );
474: END IF;
475:
476: -- Initialize return status to success initially

Line 1056: 'At the end of AHL_PRD_PRINT_PVT'

1052: fnd_log.string
1053: (
1054: fnd_log.level_procedure,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
1056: 'At the end of AHL_PRD_PRINT_PVT'
1057: );
1058: END IF;
1059:
1060: EXCEPTION

Line 1924: g_pkg_name VARCHAR2(30) :='AHL_PRD_PRINT_PVT';

1920: --TYPE workorder_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1921: TYPE ue_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1922: l_ue_id_tbl ue_id_tbl_type;
1923: l_wo_id_tbl workorder_id_tbl_type;
1924: g_pkg_name VARCHAR2(30) :='AHL_PRD_PRINT_PVT';
1925: l_api_name CONSTANT VARCHAR2(30) := 'Generate_JCG_XML';
1926: l_index NUMBER ;
1927: l_mr_id NUMBER ;
1928: l_ue_id NUMBER ;

Line 3056: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_PRINT_PVT', 'GENERATE_JCG_XML', 'B', 'C' )) then

3052: END IF;
3053:
3054: -- Call pre customer hook api call
3055:
3056: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_PRINT_PVT', 'GENERATE_JCG_XML', 'B', 'C' )) then
3057: ahl_prd_print_CUHK.GENERATE_JCG_XML_pre(
3058: p_object_type => p_object_type,
3059: p_object_id => p_object_id,
3060: p_split_flag => p_split_flag,

Line 3849: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_PRINT_PVT', 'GENERATE_JCG_XML', 'A', 'C' )) then

3845: -- dbms_lob.freeTemporary( l_merged_lob );
3846:
3847: --post user hook api call
3848:
3849: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_PRINT_PVT', 'GENERATE_JCG_XML', 'A', 'C' )) then
3850: -- start to create file
3851: -- DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);
3852: -- call customer hook here
3853: -- end to create file

Line 4030: fnd_file.put_line(FND_FILE.LOG,'Entered AHL_PRD_PRINT_PVT.Generate_JCG_Request: cc id : ' || l_conc_request_id );

4026:
4027: BEGIN
4028: l_conc_request_id := fnd_global.conc_request_id;
4029: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
4030: fnd_file.put_line(FND_FILE.LOG,'Entered AHL_PRD_PRINT_PVT.Generate_JCG_Request: cc id : ' || l_conc_request_id );
4031: fnd_file.new_line(FND_FILE.LOG,1);
4032: -- initialize return status.
4033: retcode := 0;
4034: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4428: WF_CORE.CONTEXT('AHL_PRD_PRINT_PVT','HANDLE_ENIGMAJCG_RESP',

4424: END IF;
4425: RETURN 'SUCCESS';
4426: EXCEPTION
4427: WHEN OTHERS THEN
4428: WF_CORE.CONTEXT('AHL_PRD_PRINT_PVT','HANDLE_ENIGMAJCG_RESP',
4429: p_event.getEventName(), p_subscription_guid);
4430: WF_EVENT.setErrorInfo(p_event, 'ERROR');
4431: RETURN 'ERROR';
4432:

Line 4448: WF_CORE.CONTEXT('AHL_PRD_PRINT_PVT','HANDLE_ENIGMAJCG_RESP',

4444: END IF;
4445: RETURN 'SUCCESS';
4446: EXCEPTION
4447: WHEN OTHERS THEN
4448: WF_CORE.CONTEXT('AHL_PRD_PRINT_PVT','HANDLE_ENIGMAJCG_RESP',
4449: p_event.getEventName(), p_subscription_guid);
4450: WF_EVENT.setErrorInfo(p_event, 'ERROR');
4451: RETURN 'ERROR';
4452:

Line 7750: g_pkg_name VARCHAR2(30) :='AHL_PRD_PRINT_PVT';

7746: dummy VARCHAR2 (1000);
7747:
7748: --TYPE workorder_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7749: --l_wo_id_tbl workorder_id_tbl_type;
7750: g_pkg_name VARCHAR2(30) :='AHL_PRD_PRINT_PVT';
7751: l_api_name CONSTANT VARCHAR2(30) := 'Gen_JCG_Xml';
7752: l_index NUMBER ;
7753: l_mr_id NUMBER ;
7754: l_ue_id NUMBER ;

Line 9912: END AHL_PRD_PRINT_PVT;

9908: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
9909: CLOSE wo_details_csr;
9910: END LOOP;
9911: END Get_job_card_det;
9912: END AHL_PRD_PRINT_PVT;