666:
667:
668: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
669:
670: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Insert_Row)
671: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_AUDIT_PROCEDURES_PKG.Insert_Row');
672: AMW_AUDIT_PROCEDURES_PKG.Insert_Row(
673: x_rowid => l_row_id,
674: x_audit_procedure_rev_id => l_dummy_audit_procedure_rec.audit_procedure_rev_id,
667:
668: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
669:
670: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Insert_Row)
671: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_AUDIT_PROCEDURES_PKG.Insert_Row');
672: AMW_AUDIT_PROCEDURES_PKG.Insert_Row(
673: x_rowid => l_row_id,
674: x_audit_procedure_rev_id => l_dummy_audit_procedure_rec.audit_procedure_rev_id,
675: x_project_id => l_dummy_audit_procedure_rec.project_id,
668: AMW_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
669:
670: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Insert_Row)
671: AMW_UTILITY_PVT.debug_message( 'Private API: Calling AMW_AUDIT_PROCEDURES_PKG.Insert_Row');
672: AMW_AUDIT_PROCEDURES_PKG.Insert_Row(
673: x_rowid => l_row_id,
674: x_audit_procedure_rev_id => l_dummy_audit_procedure_rec.audit_procedure_rev_id,
675: x_project_id => l_dummy_audit_procedure_rec.project_id,
676: x_classification => l_dummy_audit_procedure_rec.classification,
912: l_dummy_audit_procedure_rec.classification := l_classification;
913: END IF;
914:
915:
916: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Update_Row)
917: AMW_AUDIT_PROCEDURES_PKG.Update_Row(
918: x_audit_procedure_rev_id => l_dummy_audit_procedure_rec.audit_procedure_rev_id,
919: x_project_id => l_dummy_audit_procedure_rec.project_id,
920: x_classification => l_dummy_audit_procedure_rec.classification,
913: END IF;
914:
915:
916: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Update_Row)
917: AMW_AUDIT_PROCEDURES_PKG.Update_Row(
918: x_audit_procedure_rev_id => l_dummy_audit_procedure_rec.audit_procedure_rev_id,
919: x_project_id => l_dummy_audit_procedure_rec.project_id,
920: x_classification => l_dummy_audit_procedure_rec.classification,
921: x_attribute10 => l_dummy_audit_procedure_rec.attribute10,
1067: x_return_status := G_RET_STS_SUCCESS;
1068:
1069: AMW_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1070:
1071: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Delete_Row)
1072: AMW_AUDIT_PROCEDURES_PKG.Delete_Row(
1073: x_audit_procedure_rev_id => p_audit_procedure_rev_id);
1074:
1075:
1068:
1069: AMW_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1070:
1071: -- Invoke table handler(AMW_AUDIT_PROCEDURES_PKG.Delete_Row)
1072: AMW_AUDIT_PROCEDURES_PKG.Delete_Row(
1073: x_audit_procedure_rev_id => p_audit_procedure_rev_id);
1074:
1075:
1076: -- Standard check for p_commit