APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_PROJECT_CLASSES

Line 2814: p_flexfield_name => 'PA_PROJECT_CLASSES_DESC_FLEX',

2810: IF p_calling_module = 'ADD_CLASS_CATEGORIES' THEN /*Added ADD_CLASS_CATEGORIES condition to validate only in the add classifications flow. */
2811: l_application_id := FND_GLOBAL.resp_appl_id;
2812: PA_PROJECT_UTILS.validate_dff(
2813: p_application_id => l_application_id,
2814: p_flexfield_name => 'PA_PROJECT_CLASSES_DESC_FLEX',
2815: p_attribute_category => l_attribute_category,
2816: p_calling_module => p_calling_module,
2817: p_attribute1 => l_attribute1,
2818: p_attribute2 => l_attribute2,

Line 2848: --dbms_output.put_line('Pa_project_classes_pkg.insert_row Project Data ');

2844: RAISE FND_API.G_EXC_ERROR;
2845: End if;
2846: End if;
2847:
2848: --dbms_output.put_line('Pa_project_classes_pkg.insert_row Project Data ');
2849: if (p_debug_mode = 'Y') then
2850: pa_debug.debug('Create classification PVT: Calling Table handler to insert new classification record ');
2851: end if;
2852: pa_project_classes_pkg.insert_row

Line 2852: pa_project_classes_pkg.insert_row

2848: --dbms_output.put_line('Pa_project_classes_pkg.insert_row Project Data ');
2849: if (p_debug_mode = 'Y') then
2850: pa_debug.debug('Create classification PVT: Calling Table handler to insert new classification record ');
2851: end if;
2852: pa_project_classes_pkg.insert_row
2853: ( l_row_id
2854: ,p_object_id
2855: ,p_object_type
2856: ,p_class_category

Line 3023: FROM PA_PROJECT_CLASSES ppc, PA_CLASS_CATEGORIES cat, PA_CLASS_CODES code

3019: -- Bug 2904327
3020: CURSOR l_get_classification
3021: IS
3022: SELECT cat.class_category_id, code.class_code_id
3023: FROM PA_PROJECT_CLASSES ppc, PA_CLASS_CATEGORIES cat, PA_CLASS_CODES code
3024: WHERE ppc.rowid = p_rowid
3025: AND ppc.class_category = cat.class_category
3026: AND ppc.class_category = code.class_category
3027: AND ppc.class_code = code.class_code;

Line 3052: FROM pa_project_classes

3048:
3049: if p_validate_only <> FND_API.G_TRUE then
3050: BEGIN
3051: SELECT 'x' INTO l_dummy
3052: FROM pa_project_classes
3053: WHERE rowid = p_rowid
3054: AND record_version_number = p_record_version_number
3055: FOR UPDATE OF record_version_number NOWAIT;
3056: EXCEPTION

Line 3083: FROM pa_project_classes

3079: END;
3080: else
3081: BEGIN
3082: SELECT 'x' INTO l_dummy
3083: FROM pa_project_classes
3084: WHERE rowid = p_rowid
3085: AND record_version_number = p_record_version_number;
3086: EXCEPTION
3087: when NO_DATA_FOUND then

Line 3245: pa_project_classes_pkg.update_row

3241: CLOSE l_get_classification;
3242: -- anlee end of changes
3243:
3244: if p_validate_only <> FND_API.G_TRUE then
3245: pa_project_classes_pkg.update_row
3246: ( X_rowid => p_rowid
3247: ,X_object_id => p_object_id
3248: ,X_object_type => p_object_type
3249: ,X_class_category => p_class_category

Line 3394: FROM pa_project_classes

3390:
3391: CURSOR C(c_object_id NUMBER, c_object_type VARCHAR2, c_class_category VARCHAR2, c_class_code VARCHAR2)
3392: IS
3393: SELECT rowid
3394: FROM pa_project_classes
3395: WHERE object_id = c_object_id
3396: AND object_type = c_object_type
3397: AND class_category = c_class_category
3398: AND class_code = c_class_code;

Line 3403: FROM PA_PROJECT_CLASSES

3399:
3400: CURSOR C2(c_rowid VARCHAR2)
3401: IS
3402: SELECT class_category
3403: FROM PA_PROJECT_CLASSES
3404: WHERE rowid = c_rowid;
3405:
3406: BEGIN
3407:

Line 3798: FROM pa_project_classes

3794: end if;
3795: if p_validate_only <> FND_API.G_TRUE then
3796: BEGIN
3797: SELECT rowid INTO l_row_id
3798: FROM pa_project_classes
3799: WHERE object_id = p_object_id
3800: AND object_type = p_object_type
3801: AND class_category = p_class_category
3802: and class_code = p_class_code

Line 3834: FROM pa_project_classes

3830: END;
3831: ELSE
3832: BEGIN
3833: SELECT rowid INTO l_row_id
3834: FROM pa_project_classes
3835: WHERE object_id = p_object_id
3836: AND object_type = p_object_type
3837: AND class_category = p_class_category
3838: and class_code = p_class_code

Line 3904: pa_project_classes_pkg.delete_row

3900: THEN
3901: if (p_debug_mode = 'Y') then
3902: pa_debug.debug('Delete classification PVT: Calling table handler to delete classfications record');
3903: end if;
3904: pa_project_classes_pkg.delete_row
3905: ( l_row_id);
3906:
3907: -- anlee
3908: -- Ext Attribute changes