APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_NUM_TBL_TYPE

Line 1432: l_str SYSTEM.PA_NUM_TBL_TYPE;

1428:
1429: -- SWM/IPM enhancement merger into R12.
1430: -- Bug 6046307
1431: l_strucutre_status PA_PROJ_ELEM_VER_STRUCTURE.STATUS_CODE%TYPE;
1432: l_str SYSTEM.PA_NUM_TBL_TYPE;
1433: l_rvn SYSTEM.PA_NUM_TBL_TYPE;
1434: i BINARY_INTEGER := 0;
1435:
1436:

Line 1433: l_rvn SYSTEM.PA_NUM_TBL_TYPE;

1429: -- SWM/IPM enhancement merger into R12.
1430: -- Bug 6046307
1431: l_strucutre_status PA_PROJ_ELEM_VER_STRUCTURE.STATUS_CODE%TYPE;
1432: l_str SYSTEM.PA_NUM_TBL_TYPE;
1433: l_rvn SYSTEM.PA_NUM_TBL_TYPE;
1434: i BINARY_INTEGER := 0;
1435:
1436:
1437: BEGIN

Line 1500: l_str := SYSTEM.PA_NUM_TBL_TYPE(1);

1496: -- This should be treated as a bug and should be taken care of.
1497:
1498: IF l_strucutre_status = 'STRUCTURE_PUBLISHED' THEN
1499: i := i+1;
1500: l_str := SYSTEM.PA_NUM_TBL_TYPE(1);
1501: l_rvn := SYSTEM.PA_NUM_TBL_TYPE(1);
1502:
1503: l_str(1) := p_structure_version_id;
1504: l_rvn(1) := p_record_version_number;

Line 1501: l_rvn := SYSTEM.PA_NUM_TBL_TYPE(1);

1497:
1498: IF l_strucutre_status = 'STRUCTURE_PUBLISHED' THEN
1499: i := i+1;
1500: l_str := SYSTEM.PA_NUM_TBL_TYPE(1);
1501: l_rvn := SYSTEM.PA_NUM_TBL_TYPE(1);
1502:
1503: l_str(1) := p_structure_version_id;
1504: l_rvn(1) := p_record_version_number;
1505:

Line 3866: -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

3862: -- Return Value : N/A
3863: -- Parameters
3864: -- p_api_version IN NUMBER := 1.0
3865: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3866: -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3867: -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3868: -- ,x_return_status OUT NOCOPY VARCHAR2
3869: -- ,x_msg_count OUT NOCOPY NUMBER
3870: -- ,x_msg_data OUT NOCOPY VARCHAR2

Line 3867: -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

3863: -- Parameters
3864: -- p_api_version IN NUMBER := 1.0
3865: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3866: -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3867: -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3868: -- ,x_return_status OUT NOCOPY VARCHAR2
3869: -- ,x_msg_count OUT NOCOPY NUMBER
3870: -- ,x_msg_data OUT NOCOPY VARCHAR2
3871: --

Line 4007: ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

4003: (
4004: p_api_version IN NUMBER := 1.0
4005: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4006: ,p_project_id IN NUMBER
4007: ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
4008: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
4009: ,x_return_status OUT NOCOPY VARCHAR2
4010: ,x_msg_count OUT NOCOPY NUMBER
4011: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4008: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

4004: p_api_version IN NUMBER := 1.0
4005: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4006: ,p_project_id IN NUMBER
4007: ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
4008: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
4009: ,x_return_status OUT NOCOPY VARCHAR2
4010: ,x_msg_count OUT NOCOPY NUMBER
4011: ,x_msg_data OUT NOCOPY VARCHAR2
4012: ) IS