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 2358: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

2354: OPEN sel_struct_type;
2355: LOOP
2356: FETCH sel_struct_type into l_rowid;
2357: EXIT WHEN sel_struct_type%NOTFOUND;
2358: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
2359: END LOOP;
2360: CLOSE sel_struct_type;
2361:
2362: --Lock record

Line 8646: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

8642: IF sel_struct_type%FOUND THEN
8643: IF (p_debug_mode = 'Y') THEN
8644: pa_debug.debug('Deleting type structure type');
8645: END IF;
8646: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
8647: END IF;
8648: CLOSE sel_struct_type;
8649:
8650: --create_structure

Line 9988: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

9984:
9985: --Delete structure type
9986: OPEN sel_wp_struct_type(l_structure_id);
9987: FETCH sel_wp_struct_type into l_rowid;
9988: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
9989: CLOSE sel_wp_struct_type;
9990:
9991: --Update structure status to published if project;
9992: -- working if template

Line 10209: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

10205: OPEN sel_struc_type_id;
10206: FETCH sel_struc_type_id INTO l_struc_type_id;
10207: CLOSE sel_struc_type_id;
10208:
10209: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
10210: X_ROWID => l_rowid
10211: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
10212: ,X_PROJ_ELEMENT_ID => l_structure_id
10213: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 10680: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

10676:
10677: --Delete structure type
10678: OPEN sel_wp_struct_type(l_structure_id);
10679: FETCH sel_wp_struct_type into l_rowid;
10680: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
10681: CLOSE sel_wp_struct_type;
10682:
10683: --Update structure status to published if project;
10684: -- working if template

Line 14580: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

14576: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
14577: CLOSE sel_fin_struc_type_id;
14578:
14579: l_proj_structure_type_id := NULL;
14580: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
14581: X_ROWID => l_rowid
14582: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
14583: ,X_PROJ_ELEMENT_ID => l_structure_id
14584: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 14997: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

14993: FETCH sel_struc_type_id INTO l_struc_type_id;
14994: CLOSE sel_struc_type_id;
14995:
14996: l_proj_structure_type_id := NULL;
14997: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
14998: X_ROWID => l_rowid
14999: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15000: ,X_PROJ_ELEMENT_ID => l_structure_id
15001: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 15565: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

15561: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
15562: CLOSE sel_fin_struc_type_id;
15563:
15564: l_proj_structure_type_id := NULL;
15565: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
15566: X_ROWID => l_rowid
15567: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15568: ,X_PROJ_ELEMENT_ID => l_structure_id
15569: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 16996: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

16992: OPEN sel_struc_type_id;
16993: FETCH sel_struc_type_id INTO l_struc_type_id;
16994: CLOSE sel_struc_type_id;
16995:
16996: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
16997: X_ROWID => l_rowid
16998: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
16999: ,X_PROJ_ELEMENT_ID => l_structure_id
17000: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 17388: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

17384: OPEN sel_struc_type_id;
17385: FETCH sel_struc_type_id INTO l_struc_type_id;
17386: CLOSE sel_struc_type_id;
17387:
17388: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
17389: X_ROWID => l_rowid
17390: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
17391: ,X_PROJ_ELEMENT_ID => l_structure_id
17392: ,X_STRUCTURE_TYPE_ID => l_struc_type_id