[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT br.default_basis_type
, ca.activity_id
, DECODE ( bd.location_id,
NULL, DECODE(br.AUTOCHARGE_TYPE,
NULL, 2,
3, 2,
br.AUTOCHARGE_TYPE),
NVL(br.AUTOCHARGE_TYPE, 2)
) default_autocharge
, NVL(br.standard_rate_flag, 1) standard_rate_flag
FROM BOM_RESOURCES br
, BOM_DEPARTMENTS bd
, BOM_OPERATION_SEQUENCES bos
, CST_ACTIVITIES_VAL_V ca
WHERE bd.department_id = bos.department_id
AND ca.activity_id (+) = br.default_activity_id
AND NVL(ca.organization_id, p_org_id) = p_org_id
AND br.resource_id = p_resource_id
AND bos.operation_sequence_id = p_operation_sequence_id ;
SELECT nvl(br.batchable,2) batchable
FROM BOM_RESOURCES br
WHERE br.resource_id = p_resource_id;
SELECT bdr.available_24_hours_flag
FROM BOM_OPERATION_SEQUENCES bos
, BOM_DEPARTMENT_RESOURCES bdr
WHERE bdr.department_id = bos.department_id
AND bdr.resource_id = p_resource_id
AND bos.operation_sequence_id = p_op_seq_id ;
* Procedure : Populate_Null_Columns used by Rtg BO(Update or Delete)
* Parameters IN : Operation Resource exposed column record
* Operation Resource unexposed column record
* Old Operation Resource exposed column record
* Old Operation Resource unexposed column record
* Parameters OUT: Op Resource exposed column record after
* populating null columns
* Op Resource unexposed column record after
* populating null columns
* Purpose : Convert Routing Op Resource to ECO Op Resource and
* Call Populate_Null_Columns for ECO BO.
* The procedure will populate the NULL columns from the
* record that is queried from the database.
********************************************************************/
PROCEDURE Populate_Null_Columns
( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
, p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
, p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
, p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
, x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
, x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
)
IS
l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
* used by ECO BO(Update, Delete or Create with ACD_Type:2 Change)
* Parameters IN : Revised Op Resource exposed column record
* Revised Op Resource unexposed column record
* Old Revised Op Resource exposed column record
* Old Revised Op Resource unexposed column record
* Parameters OUT: Revised Op Resource exposed column record
* after populating null columns
* Revised Op Resource unexposed column record
* after populating null columns
* Purpose : Complete record will compare the database record with
* the user given record and will complete the user
* record with values from the database record, for all
* columns that the user has left NULL.
********************************************************************/
PROCEDURE Populate_Null_Columns
( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
, p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
, p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
, p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
, x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
, x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
)
IS
l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;