DBA Data[Home] [Help]

APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_PRD_OPERATIONS_PVT

Line 1: PACKAGE BODY AHL_PRD_OPERATIONS_PVT AS

1: PACKAGE BODY AHL_PRD_OPERATIONS_PVT AS
2: /* $Header: AHLVPROB.pls 120.22.12020000.2 2012/12/07 13:24:17 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_OPERATIONS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

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

1: PACKAGE BODY AHL_PRD_OPERATIONS_PVT AS
2: /* $Header: AHLVPROB.pls 120.22.12020000.2 2012/12/07 13:24:17 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_OPERATIONS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: FUNCTION get_date_and_time(p_date IN DATE,
8: p_date_hh24 IN VARCHAR2,

Line 14: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_workoperation_rec

10: p_date_ss IN VARCHAR2) RETURN DATE;
11:
12: PROCEDURE default_attributes
13: (
14: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_workoperation_rec
15: )
16: AS
17:
18: CURSOR get_workorder_rec(c_workorder_id NUMBER)

Line 239: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.PRD_workoperation_rec,

235: END default_attributes;
236:
237: PROCEDURE default_missing_attributes
238: (
239: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.PRD_workoperation_rec,
240: p_module_type IN VARCHAR2
241: )
242: AS
243: cursor get_operation_rec(c_operation_id NUMBER)

Line 661: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',

657: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
658: fnd_log.string
659: (
660: fnd_log.level_statement,
661: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',
662: 'p_operation_id : ' || p_operation_id
663: );
664: fnd_log.string
665: (

Line 667: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',

663: );
664: fnd_log.string
665: (
666: fnd_log.level_statement,
667: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',
668: 'p_wo_op_id : ' || p_wo_op_id
669: );
670: fnd_log.string
671: (

Line 673: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',

669: );
670: fnd_log.string
671: (
672: fnd_log.level_statement,
673: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',
674: 'p_operation_code : ' || p_operation_code
675: );
676: fnd_log.string
677: (

Line 679: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',

675: );
676: fnd_log.string
677: (
678: fnd_log.level_statement,
679: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',
680: 'p_dml_operation : ' || p_dml_operation
681: );
682: END IF;
683:

Line 727: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',

723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
724: fnd_log.string
725: (
726: fnd_log.level_statement,
727: 'ahl.plsql.AHL_PRD_OPERATIONS_PVT.is_valid_operation_update',
728: 'Operation id returned -> l_operation_id : ' || l_operation_id
729: );
730: END IF;
731:

Line 737: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_workoperation_rec,

733:
734: END is_valid_operation_update;
735: PROCEDURE convert_values_to_ids
736: (
737: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_workoperation_rec,
738: p_module_type IN VARCHAR2
739: )
740: As
741:

Line 974: p_prd_workoper_rec IN AHL_PRD_OPERATIONS_PVT.PRD_workoperation_rec

970: END convert_values_to_ids;
971:
972: PROCEDURE validate_operation
973: (
974: p_prd_workoper_rec IN AHL_PRD_OPERATIONS_PVT.PRD_workoperation_rec
975: )
976: AS
977: CURSOR validate_unique_operation(c_workorder_id NUMBER,c_operation_seq_num NUMBER)
978: IS

Line 1653: END AHL_PRD_OPERATIONS_PVT;

1649: END IF;
1650: RETURN l_date;
1651: END get_date_and_time;
1652:
1653: END AHL_PRD_OPERATIONS_PVT;
1654: