1 PACKAGE PO_REQIMP_VAL_PVT AS
2 /* $Header: POXVRIVS.pls 120.1 2005/10/03 15:28:18 vinokris noship $ */
3
4 -- Constants used for the p_interface_table_code parameter
5 -- in val_pjm_proj_references
6 G_PO_REQUISITIONS_INTERFACE CONSTANT VARCHAR2(1) := 'R';
7 G_PO_REQ_DIST_INTERFACE CONSTANT VARCHAR2(1) := 'D';
8
9 /**
10 * Private Procedure: val_pjm_proj_references
11 * Requires: none
12 * Modifies: PO_INTERFACE_ERRORS, concurrent program log
13 * Parameters:
14 * p_interface_table_code - the interface table to be validated;
15 * if G_PO_REQUISITIONS_INTERFACE, use PO_REQUISITIONS_INTERFACE
16 * if G_PO_REQ_DIST_INTERFACE, use PO_REQ_DIST_INTERFACE
17 * Effects: For all records with the given request ID in the specified
18 * interface table, calls the PJM validation API to validate
19 * project and task information. Writes any validation errors to
20 * PO_INTERFACE_ERRORS and any validation warnings to the concurrent
21 * program log.
22 * Returns:
23 * x_return_status -
24 * FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs
25 * FND_API.G_RET_STS_SUCCESS otherwise
26 */
27 PROCEDURE val_pjm_proj_references (
28 p_api_version IN NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2,
30 p_interface_table_code IN VARCHAR2,
31 p_request_id IN NUMBER,
32 p_user_id IN NUMBER,
33 p_login_id IN NUMBER,
34 p_prog_application_id IN NUMBER,
35 p_program_id IN NUMBER
36 );
37
38 END PO_REQIMP_VAL_PVT;