APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJ_STRUCTURE_TYPES_PKG

Line 501: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

497:
498: --Insert into pa_proj_structure_types
499: BEGIN
500: l_proj_structure_type_id := NULL;
501: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
502: X_ROWID => l_rowid
503: , X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
504: , X_PROJ_ELEMENT_ID => l_proj_element_id
505: , X_STRUCTURE_TYPE_ID => l_structure_type_id

Line 2377: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

2373: OPEN sel_struct_type;
2374: LOOP
2375: FETCH sel_struct_type into l_rowid;
2376: EXIT WHEN sel_struct_type%NOTFOUND;
2377: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
2378: END LOOP;
2379: CLOSE sel_struct_type;
2380:
2381: --Lock record

Line 9018: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

9014: IF sel_struct_type%FOUND THEN
9015: IF (p_debug_mode = 'Y') THEN
9016: pa_debug.debug('Deleting type structure type');
9017: END IF;
9018: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
9019: END IF;
9020: CLOSE sel_struct_type;
9021:
9022: --create_structure

Line 10360: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

10356:
10357: --Delete structure type
10358: OPEN sel_wp_struct_type(l_structure_id);
10359: FETCH sel_wp_struct_type into l_rowid;
10360: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
10361: CLOSE sel_wp_struct_type;
10362:
10363: --Update structure status to published if project;
10364: -- working if template

Line 10581: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

10577: OPEN sel_struc_type_id;
10578: FETCH sel_struc_type_id INTO l_struc_type_id;
10579: CLOSE sel_struc_type_id;
10580:
10581: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
10582: X_ROWID => l_rowid
10583: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
10584: ,X_PROJ_ELEMENT_ID => l_structure_id
10585: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 11052: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

11048:
11049: --Delete structure type
11050: OPEN sel_wp_struct_type(l_structure_id);
11051: FETCH sel_wp_struct_type into l_rowid;
11052: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
11053: CLOSE sel_wp_struct_type;
11054:
11055: --Update structure status to published if project;
11056: -- working if template

Line 14956: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

14952: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
14953: CLOSE sel_fin_struc_type_id;
14954:
14955: l_proj_structure_type_id := NULL;
14956: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
14957: X_ROWID => l_rowid
14958: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
14959: ,X_PROJ_ELEMENT_ID => l_structure_id
14960: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 15373: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

15369: FETCH sel_struc_type_id INTO l_struc_type_id;
15370: CLOSE sel_struc_type_id;
15371:
15372: l_proj_structure_type_id := NULL;
15373: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
15374: X_ROWID => l_rowid
15375: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15376: ,X_PROJ_ELEMENT_ID => l_structure_id
15377: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 15941: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

15937: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
15938: CLOSE sel_fin_struc_type_id;
15939:
15940: l_proj_structure_type_id := NULL;
15941: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
15942: X_ROWID => l_rowid
15943: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15944: ,X_PROJ_ELEMENT_ID => l_structure_id
15945: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 17372: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

17368: OPEN sel_struc_type_id;
17369: FETCH sel_struc_type_id INTO l_struc_type_id;
17370: CLOSE sel_struc_type_id;
17371:
17372: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
17373: X_ROWID => l_rowid
17374: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
17375: ,X_PROJ_ELEMENT_ID => l_structure_id
17376: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 17764: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

17760: OPEN sel_struc_type_id;
17761: FETCH sel_struc_type_id INTO l_struc_type_id;
17762: CLOSE sel_struc_type_id;
17763:
17764: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
17765: X_ROWID => l_rowid
17766: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
17767: ,X_PROJ_ELEMENT_ID => l_structure_id
17768: ,X_STRUCTURE_TYPE_ID => l_struc_type_id