eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_HEADER_PUB

Line 26: PROCEDURE VALIDATE_PC_HEADER (p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC);

22:
23: ------------------------
24: -- VALIDATE_PC_HEADER --
25: ------------------------
26: PROCEDURE VALIDATE_PC_HEADER (p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC);
27:
28: -------------------------------
29: -- VALIDATE_PC_HEADER_UPDATE --
30: -------------------------------

Line 37: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

Line 41: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

37: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
42: );
43:
44: -----------------
45: -- CREATE_LINK --

Line 53: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,

49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE,
52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2
57: );

Line 83: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,

79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

Line 87: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

83: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
88: );
89:
90: ------------------------
91: -- DELETE_PC_AND_TREE --

Line 104: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2
108: )

Line 268: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

Line 272: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

268: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
273: )
274: IS
275:
276: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PC_HEADER';

Line 493: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2
497: )

Line 747: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

743: p_api_version IN NUMBER,
744: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
745: p_commit IN VARCHAR2 := FND_API.G_FALSE,
746: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
747: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
748: x_return_status OUT NOCOPY VARCHAR2,
749: x_msg_count OUT NOCOPY NUMBER,
750: x_msg_data OUT NOCOPY VARCHAR2
751: )

Line 1316: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

1312: p_default IN VARCHAR2 := FND_API.G_FALSE,
1313: x_return_status OUT NOCOPY VARCHAR2,
1314: x_msg_count OUT NOCOPY NUMBER,
1315: x_msg_data OUT NOCOPY VARCHAR2,
1316: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
1317: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
1318: )
1319: AS
1320:

Line 1317: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

1313: x_return_status OUT NOCOPY VARCHAR2,
1314: x_msg_count OUT NOCOPY NUMBER,
1315: x_msg_data OUT NOCOPY VARCHAR2,
1316: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
1317: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
1318: )
1319: AS
1320:
1321: CURSOR get_pc_details(l_pc_header_id IN NUMBER, l_object_version_number IN NUMBER)

Line 1500: PROCEDURE VALIDATE_PC_HEADER (p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC)

1496:
1497: ------------------------
1498: -- VALIDATE_PC_HEADER --
1499: ------------------------
1500: PROCEDURE VALIDATE_PC_HEADER (p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC)
1501: IS
1502:
1503: -- veena : added nvl :to check for duplicate name for approval pending and complete pc
1504:

Line 1686: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,

1682: p_api_version IN NUMBER,
1683: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1684: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1685: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1686: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,
1687: x_return_status OUT NOCOPY VARCHAR2,
1688: x_msg_count OUT NOCOPY NUMBER,
1689: x_msg_data OUT NOCOPY VARCHAR2
1690: )

Line 2410: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,

2406: p_api_version IN NUMBER,
2407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2408: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2410: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,
2411: x_return_status OUT NOCOPY VARCHAR2,
2412: x_msg_count OUT NOCOPY NUMBER,
2413: x_msg_data OUT NOCOPY VARCHAR2,
2414: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

Line 2414: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

2410: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC ,
2411: x_return_status OUT NOCOPY VARCHAR2,
2412: x_msg_count OUT NOCOPY NUMBER,
2413: x_msg_data OUT NOCOPY VARCHAR2,
2414: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
2415: )
2416: IS
2417:
2418: -- To address the Bug # 9486654 The following cursor attach_nodes split in to two

Line 2722: l_pc_header_rec AHL_PC_HEADER_PUB.PC_HEADER_REC;

2718: l_node_units_data_rec attach_nodes_units%ROWTYPE;
2719: l_node_data_rec_det detach_nodes%ROWTYPE;
2720: l_asso_data_rec_det detach_associations%ROWTYPE;
2721:
2722: l_pc_header_rec AHL_PC_HEADER_PUB.PC_HEADER_REC;
2723: l_nodeId_tbl PC_NODE_ID_TBL;
2724:
2725: -- Senthil
2726: TYPE l_num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 3596: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

3592: p_api_version IN NUMBER,
3593: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3594: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3595: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3596: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
3597: x_return_status OUT NOCOPY VARCHAR2,
3598: x_msg_count OUT NOCOPY NUMBER,
3599: x_msg_data OUT NOCOPY VARCHAR2,
3600: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

Line 3600: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type

3596: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
3597: x_return_status OUT NOCOPY VARCHAR2,
3598: x_msg_count OUT NOCOPY NUMBER,
3599: x_msg_data OUT NOCOPY VARCHAR2,
3600: x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
3601: )
3602: IS
3603:
3604: CURSOR check_header_data (p_header_id IN NUMBER)