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_UMP_SMRINSTANCE_PVT dependencies on AHL_UMP_SMRINSTANCE_PVT

Line 1: PACKAGE BODY AHL_UMP_SMRINSTANCE_PVT AS

1: PACKAGE BODY AHL_UMP_SMRINSTANCE_PVT AS
2: /* $Header: AHLVSMRB.pls 120.15.12020000.2 2012/12/07 14:40:58 sareepar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SMRINSTANCE_PVT';
5:

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

1: PACKAGE BODY AHL_UMP_SMRINSTANCE_PVT AS
2: /* $Header: AHLVSMRB.pls 120.15.12020000.2 2012/12/07 14:40:58 sareepar ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_SMRINSTANCE_PVT';
5:
6: -- FND Logging Constants
7: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 17: P_SEARCH_MR_INSTANCE_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_MRINSTANCE_REC_TYPE);

13: -- Declare Local Procedures --
14: -------------------------------
15: PROCEDURE populate_instances(
16: p_module_type IN VARCHAR2,
17: P_SEARCH_MR_INSTANCE_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_MRINSTANCE_REC_TYPE);
18:
19: PROCEDURE populate_unit_instances(
20: P_MODULE_TYPE IN VARCHAR2,
21: p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type);

Line 21: p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type);

17: P_SEARCH_MR_INSTANCE_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_MRINSTANCE_REC_TYPE);
18:
19: PROCEDURE populate_unit_instances(
20: P_MODULE_TYPE IN VARCHAR2,
21: p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type);
22:
23:
24: PROCEDURE populate_dependent_instances(
25: p_module_type IN VARCHAR2);

Line 91: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,

87: p_default IN VARCHAR2 := FND_API.G_TRUE,
88: p_module_type IN VARCHAR2 := NULL,
89: p_start_row IN NUMBER,
90: p_rows_per_page IN NUMBER,
91: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,
92: x_results_mr_instance_tbl OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.Results_MRInstance_Tbl_Type,
93: x_results_count OUT NOCOPY NUMBER,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,

Line 92: x_results_mr_instance_tbl OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.Results_MRInstance_Tbl_Type,

88: p_module_type IN VARCHAR2 := NULL,
89: p_start_row IN NUMBER,
90: p_rows_per_page IN NUMBER,
91: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,
92: x_results_mr_instance_tbl OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.Results_MRInstance_Tbl_Type,
93: x_results_count OUT NOCOPY NUMBER,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 332: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances.begin',

328: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
329: fnd_log.string
330: (
331: G_DEBUG_PROC,
332: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances.begin',
333: 'At the start of PLSQL procedure'
334: );
335: END IF;
336: -- Standard start of API savepoint

Line 361: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

357: -- Logging input
358: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
359: fnd_log.string
360: (
361: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
362: 'p_search_mr_instance_rec.unit_name :' || p_search_mr_instance_rec.unit_name
363: );
364: fnd_log.string
365: (

Line 366: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

362: 'p_search_mr_instance_rec.unit_name :' || p_search_mr_instance_rec.unit_name
363: );
364: fnd_log.string
365: (
366: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
367: 'p_search_mr_instance_rec.part_number :' || p_search_mr_instance_rec.part_number
368: );
369: fnd_log.string
370: (

Line 371: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

367: 'p_search_mr_instance_rec.part_number :' || p_search_mr_instance_rec.part_number
368: );
369: fnd_log.string
370: (
371: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
372: 'p_search_mr_instance_rec.serial_number :' || p_search_mr_instance_rec.serial_number
373: );
374: fnd_log.string
375: (

Line 376: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

372: 'p_search_mr_instance_rec.serial_number :' || p_search_mr_instance_rec.serial_number
373: );
374: fnd_log.string
375: (
376: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
377: 'p_search_mr_instance_rec.sort_by :' || p_search_mr_instance_rec.sort_by
378: );
379: fnd_log.string
380: (

Line 381: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

377: 'p_search_mr_instance_rec.sort_by :' || p_search_mr_instance_rec.sort_by
378: );
379: fnd_log.string
380: (
381: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
382: 'p_search_mr_instance_rec.mr_status :' || p_search_mr_instance_rec.mr_status
383: );
384: fnd_log.string
385: (

Line 386: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

382: 'p_search_mr_instance_rec.mr_status :' || p_search_mr_instance_rec.mr_status
383: );
384: fnd_log.string
385: (
386: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
387: 'p_search_mr_instance_rec.program_type :' || p_search_mr_instance_rec.program_type
388: );
389: fnd_log.string
390: (

Line 391: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

387: 'p_search_mr_instance_rec.program_type :' || p_search_mr_instance_rec.program_type
388: );
389: fnd_log.string
390: (
391: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
392: 'p_search_mr_instance_rec.due_from :' || p_search_mr_instance_rec.due_from
393: );
394: fnd_log.string
395: (

Line 396: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

392: 'p_search_mr_instance_rec.due_from :' || p_search_mr_instance_rec.due_from
393: );
394: fnd_log.string
395: (
396: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
397: 'p_search_mr_instance_rec.due_to :' || p_search_mr_instance_rec.due_to
398: );
399: fnd_log.string
400: (

Line 401: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

397: 'p_search_mr_instance_rec.due_to :' || p_search_mr_instance_rec.due_to
398: );
399: fnd_log.string
400: (
401: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
402: 'p_search_mr_instance_rec.show_tolerance :' || p_search_mr_instance_rec.show_tolerance
403: );
404: fnd_log.string
405: (

Line 406: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

402: 'p_search_mr_instance_rec.show_tolerance :' || p_search_mr_instance_rec.show_tolerance
403: );
404: fnd_log.string
405: (
406: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
407: 'p_search_mr_instance_rec.components_flag :' || p_search_mr_instance_rec.components_flag
408: );
409: fnd_log.string
410: (

Line 411: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

407: 'p_search_mr_instance_rec.components_flag :' || p_search_mr_instance_rec.components_flag
408: );
409: fnd_log.string
410: (
411: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
412: 'p_search_mr_instance_rec.repetitive_flag :' || p_search_mr_instance_rec.repetitive_flag
413: );
414: fnd_log.string
415: (

Line 416: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

412: 'p_search_mr_instance_rec.repetitive_flag :' || p_search_mr_instance_rec.repetitive_flag
413: );
414: fnd_log.string
415: (
416: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
417: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
418: );
419: fnd_log.string
420: (

Line 421: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

417: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
418: );
419: fnd_log.string
420: (
421: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
422: 'p_search_mr_instance_rec.contract_modifier :' || p_search_mr_instance_rec.contract_modifier
423: );
424: fnd_log.string
425: (

Line 426: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

422: 'p_search_mr_instance_rec.contract_modifier :' || p_search_mr_instance_rec.contract_modifier
423: );
424: fnd_log.string
425: (
426: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
427: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
428: );
429: fnd_log.string
430: (

Line 431: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

427: 'p_search_mr_instance_rec.contract_number :' || p_search_mr_instance_rec.contract_number
428: );
429: fnd_log.string
430: (
431: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
432: 'p_search_mr_instance_rec.service_line_id :' || p_search_mr_instance_rec.service_line_id
433: );
434: fnd_log.string
435: (

Line 436: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

432: 'p_search_mr_instance_rec.service_line_id :' || p_search_mr_instance_rec.service_line_id
433: );
434: fnd_log.string
435: (
436: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
437: 'p_search_mr_instance_rec.service_line_num :' || p_search_mr_instance_rec.service_line_num
438: );
439: fnd_log.string
440: (

Line 441: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

437: 'p_search_mr_instance_rec.service_line_num :' || p_search_mr_instance_rec.service_line_num
438: );
439: fnd_log.string
440: (
441: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
442: 'p_search_mr_instance_rec.program_id :' || p_search_mr_instance_rec.program_id
443: );
444: fnd_log.string
445: (

Line 446: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

442: 'p_search_mr_instance_rec.program_id :' || p_search_mr_instance_rec.program_id
443: );
444: fnd_log.string
445: (
446: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
447: 'p_search_mr_instance_rec.program_title :' || p_search_mr_instance_rec.program_title
448: );
449: fnd_log.string
450: (

Line 451: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

447: 'p_search_mr_instance_rec.program_title :' || p_search_mr_instance_rec.program_title
448: );
449: fnd_log.string
450: (
451: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
452: 'p_search_mr_instance_rec.show_groupmr :' || p_search_mr_instance_rec.show_groupmr
453: );
454: fnd_log.string
455: (

Line 456: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

452: 'p_search_mr_instance_rec.show_groupmr :' || p_search_mr_instance_rec.show_groupmr
453: );
454: fnd_log.string
455: (
456: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
457: 'p_search_mr_instance_rec.object_type :' || p_search_mr_instance_rec.object_type
458: );
459:
460: fnd_log.string

Line 462: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

458: );
459:
460: fnd_log.string
461: (
462: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
463: 'p_search_mr_instance_rec.search_for_type :' || p_search_mr_instance_rec.search_for_type
464: );
465:
466: fnd_log.string

Line 468: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

464: );
465:
466: fnd_log.string
467: (
468: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
469: 'p_search_mr_instance_rec.INCIDENT_TYPE_ID :' || p_search_mr_instance_rec.INCIDENT_TYPE_ID
470: );
471:
472: fnd_log.string

Line 474: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

470: );
471:
472: fnd_log.string
473: (
474: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
475: 'p_search_mr_instance_rec.SERVICE_REQ_NUM :' || p_search_mr_instance_rec.SERVICE_REQ_NUM
476: );
477:
478: --apattark added for VWPE

Line 481: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

477:
478: --apattark added for VWPE
479: fnd_log.string
480: (
481: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
482: 'p_search_mr_instance_rec.item_grp_name :' || p_search_mr_instance_rec.ITEM_GRP_NAME
483: );
484: fnd_log.string
485: (

Line 486: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

482: 'p_search_mr_instance_rec.item_grp_name :' || p_search_mr_instance_rec.ITEM_GRP_NAME
483: );
484: fnd_log.string
485: (
486: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
487: 'p_search_mr_instance_rec.on_wing :' || p_search_mr_instance_rec.ON_WING
488: );
489:
490: -- Sthilak CAM changes

Line 493: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

489:
490: -- Sthilak CAM changes
491: fnd_log.string
492: (
493: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
494: 'p_search_mr_instance_rec.service_category :' || p_search_mr_instance_rec.SERVICE_CATEGORY
495: );
496:
497: fnd_log.string

Line 499: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

495: );
496:
497: fnd_log.string
498: (
499: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
500: 'p_search_mr_instance_rec.mr_implement_status :' || p_search_mr_instance_rec.MR_IMPLEMENT_STATUS
501: );
502:
503: END IF;

Line 513: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

509: l_due_to := TRUNC(p_search_mr_instance_rec.due_to) + 1;
510: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
511: fnd_log.string
512: (
513: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
514: 'l_due_to :' || to_char(l_due_to,'DD-MON-YYYY HH24:MI:SS')
515: );
516: END IF;
517: END IF;

Line 1025: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

1021: -- Logging the sql string .
1022: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1023: fnd_log.string
1024: (
1025: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1026: 'Prepared SQL string IS '
1027: );
1028: l_sql_segment_count := CEIL(LENGTH(l_sql_string)/4000);
1029: FOR i in 1..l_sql_segment_count LOOP

Line 1033: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

1029: FOR i in 1..l_sql_segment_count LOOP
1030: IF(i < l_sql_segment_count - 1) THEN
1031: fnd_log.string
1032: (
1033: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1034: SUBSTR(l_sql_string,(i-1)*4000,4000)
1035: );
1036: ELSE
1037: fnd_log.string

Line 1039: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

1035: );
1036: ELSE
1037: fnd_log.string
1038: (
1039: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1040: SUBSTR(l_sql_string,(i-1)*4000, LENGTH(l_sql_string) - (l_sql_segment_count -1 ) * 4000)
1041: );
1042: END IF;
1043: END LOOP;

Line 1201: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

1197: x_results_mr_instance_tbl(l_counter).version_number := l_version_number || '+';
1198: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1199: fnd_log.string
1200: (
1201: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1202: 'entered +' || l_end_date || l_status_code || sysdate
1203: );
1204: END IF;
1205: ELSE

Line 1210: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

1206: x_results_mr_instance_tbl(l_counter).version_number := l_version_number;
1207: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1208: fnd_log.string
1209: (
1210: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1211: 'entered normal' || l_end_date || l_status_code || sysdate
1212: );
1213: END IF;
1214: END IF;

Line 1354: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',

1350: -- Logging input
1351: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1352: fnd_log.string
1353: (
1354: G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances',
1355: 'number of records returned :' || x_results_count
1356: );
1357: END IF;
1358:

Line 1363: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances.end',

1359: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1360: fnd_log.string
1361: (
1362: G_DEBUG_PROC,
1363: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Search_MR_Instances.end',
1364: 'At the end of PLSQL procedure'
1365: );
1366: END IF;
1367:

Line 1400: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type) IS

1396:
1397:
1398: PROCEDURE populate_instances(
1399: p_module_type IN VARCHAR2,
1400: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type) IS
1401:
1402:
1403: CURSOR only_units_csr(p_unit_name in VARCHAR2) IS
1404: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu

Line 1520: p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type) IS

1516: END populate_instances;
1517:
1518: PROCEDURE populate_unit_instances(
1519: p_module_type IN VARCHAR2,
1520: p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type) IS
1521:
1522:
1523: CURSOR only_units_csr(p_unit_name in VARCHAR2) IS
1524: Select ahlu.csi_item_instance_id from ahl_unit_config_headers ahlu

Line 1792: -- p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type Required

1788: -- x_msg_count OUT NUMBER Required
1789: -- x_msg_data OUT VARCHAR2 Required
1790: --
1791: -- Build_Ump_Search_query Parameters :
1792: -- p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type Required
1793: -- The search criteria based on which the query needs to be built.
1794: -- x_ump_search_query OUT VARCHAR2 Required
1795: -- The query built based upon the search criterion passed.
1796: -- x_ump_bind_params OUT AHL_UMP_SMRINSTANCE_PVT.Ump_Bind_Param_Type Required

Line 1796: -- x_ump_bind_params OUT AHL_UMP_SMRINSTANCE_PVT.Ump_Bind_Param_Type Required

1792: -- p_search_ump_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_Ump_Rec_Type Required
1793: -- The search criteria based on which the query needs to be built.
1794: -- x_ump_search_query OUT VARCHAR2 Required
1795: -- The query built based upon the search criterion passed.
1796: -- x_ump_bind_params OUT AHL_UMP_SMRINSTANCE_PVT.Ump_Bind_Param_Type Required
1797: -- Bind parameters for the UMP search query
1798: -- Version :
1799: -- Initial Version 1.0
1800: --

Line 1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,

1808: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,
1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
1813: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,
1814: X_UMP_BIND_PARAMS OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_BIND_PARAM_TBL_TYPE,
1815: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1816: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1813: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,

1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,
1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
1813: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,
1814: X_UMP_BIND_PARAMS OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_BIND_PARAM_TBL_TYPE,
1815: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1816: X_MSG_COUNT OUT NOCOPY NUMBER,
1817: X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS

Line 1814: X_UMP_BIND_PARAMS OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_BIND_PARAM_TBL_TYPE,

1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,
1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
1813: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,
1814: X_UMP_BIND_PARAMS OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_BIND_PARAM_TBL_TYPE,
1815: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1816: X_MSG_COUNT OUT NOCOPY NUMBER,
1817: X_MSG_DATA OUT NOCOPY VARCHAR2 ) IS
1818:

Line 1839: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.start',

1835: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1836: FND_LOG.STRING
1837: (
1838: G_DEBUG_PROC,
1839: 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.start',
1840: 'At the start of PLSQL procedure'
1841: );
1842: END IF;
1843: -- Standard call to check for call compatibility

Line 1910: AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) DUE_COUNTER_VALUE, ''View all UOMs'' view_all_uoms, B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,

1906: (select meaning from fnd_lookup_values where lookup_code = mrb.PROGRAM_TYPE_CODE and lookup_type = ''AHL_FMP_MR_PROGRAM_TYPE'' and language = userenv(''LANG'')) prog_type ,
1907: B.MR_HEADER_ID,MRB.TITLE,MTL.CONCATENATED_SEGMENTS concatenated_segments,csib.serial_number,
1908: (select c.name from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id and i.counter_id = c.counter_id) name ,
1909: (select c.uom_code from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id AND I.COUNTER_ID = C.COUNTER_ID) uom_code,
1910: AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) DUE_COUNTER_VALUE, ''View all UOMs'' view_all_uoms, B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,
1911: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
1912: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
1913: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id
1914: and task.status_code <> ''DELETED'' and rownum < 2) visit_name,

Line 2217: csib.serial_number,null name ,null uom_code,AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) due_counter_value,''View all UOMs'' view_all_uoms,

2213: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' ''N'' select_flag, ''Show'' details,ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id) unit_name,
2214: (select meaning from fnd_lookup_values where lookup_type = ''AHL_FMP_MR_PROGRAM_TYPE'' and lookup_code = ''NON-ROUTINE''
2215: AND LANGUAGE = USERENV(''LANG'')) prog_type,
2216: null mr_header_id,(CITT.NAME || ''-'' || CSB.INCIDENT_NUMBER) TITLE,MTL.CONCATENATED_SEGMENTS concatenated_segments,
2217: csib.serial_number,null name ,null uom_code,AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) due_counter_value,''View all UOMs'' view_all_uoms,
2218: B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,
2219: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2220: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
2221: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

Line 2481: FND_LOG.STRING ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.end', 'At the end of PLSQL procedure' );

2477: P_DATA => X_MSG_DATA,
2478: P_ENCODED => FND_API.G_FALSE );
2479:
2480: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
2481: FND_LOG.STRING ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.end', 'At the end of PLSQL procedure' );
2482: END IF;
2483:
2484: EXCEPTION
2485: WHEN FND_API.G_EXC_ERROR THEN

Line 2580: END AHL_UMP_SMRINSTANCE_PVT;

2576: END LOOP;
2577: RETURN l_uom_remain;
2578: END;
2579:
2580: END AHL_UMP_SMRINSTANCE_PVT;