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 3846: -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

3842: -- Return Value : N/A
3843: -- Parameters
3844: -- p_api_version IN NUMBER := 1.0
3845: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3846: -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3847: -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3848: -- ,x_return_status OUT NOCOPY VARCHAR2
3849: -- ,x_msg_count OUT NOCOPY NUMBER
3850: -- ,x_msg_data OUT NOCOPY VARCHAR2

Line 3847: -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

3843: -- Parameters
3844: -- p_api_version IN NUMBER := 1.0
3845: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3846: -- ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3847: -- ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3848: -- ,x_return_status OUT NOCOPY VARCHAR2
3849: -- ,x_msg_count OUT NOCOPY NUMBER
3850: -- ,x_msg_data OUT NOCOPY VARCHAR2
3851: --

Line 3987: ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

3983: (
3984: p_api_version IN NUMBER := 1.0
3985: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3986: ,p_project_id IN NUMBER
3987: ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3988: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3989: ,x_return_status OUT NOCOPY VARCHAR2
3990: ,x_msg_count OUT NOCOPY NUMBER
3991: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3988: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

3984: p_api_version IN NUMBER := 1.0
3985: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3986: ,p_project_id IN NUMBER
3987: ,p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3988: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
3989: ,x_return_status OUT NOCOPY VARCHAR2
3990: ,x_msg_count OUT NOCOPY NUMBER
3991: ,x_msg_data OUT NOCOPY VARCHAR2
3992: ) IS