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.19.12010000.2 2008/12/17 00:48:16 sikumar 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.19.12010000.2 2008/12/17 00:48:16 sikumar 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 237: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.PRD_workoperation_rec,

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

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

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

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

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

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

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

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

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

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

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

Line 735: p_x_prd_workoper_rec IN OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_workoperation_rec,

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

Line 972: p_prd_workoper_rec IN AHL_PRD_OPERATIONS_PVT.PRD_workoperation_rec

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

Line 1627: END AHL_PRD_OPERATIONS_PVT;

1623: END IF;
1624: RETURN l_date;
1625: END get_date_and_time;
1626:
1627: END AHL_PRD_OPERATIONS_PVT;
1628: