DBA Data[Home] [Help]

APPS.CUG_VALIDATE_ADDRESS_TYPE dependencies on CUG_VALIDATE_ADDRESS_TYPE

Line 1: Package Body CUG_VALIDATE_ADDRESS_TYPE AS

1: Package Body CUG_VALIDATE_ADDRESS_TYPE AS
2: --
3: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
4: -- directory of SQL Navigator
5: --

Line 15: G_PKG_NAME CONSTANT VARCHAR2(25):= 'CUG_VALIDATE_ADDRESS_TYPE';

11: -- aneemuch 11-Feb-04 To fix bug 2657648 changed hz_location_pub to hz_location_v2_pub
12: --
13: --
14: -- Enter procedure, function bodies as shown below
15: G_PKG_NAME CONSTANT VARCHAR2(25):= 'CUG_VALIDATE_ADDRESS_TYPE';
16:
17: PROCEDURE Validate_Incident_Address_Type (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

Line 22: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL,

18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
20: p_commit IN VARCHAR2 default fnd_api.g_false,
21: p_incident_type_id IN NUMBER,
22: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_return_status OUT NOCOPY VARCHAR2,
26: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL)

Line 41: l_incident_address_rec CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL;

37: l_msg_data VARCHAR2(2000);
38: l_location_id NUMBER;
39: l_incident_id NUMBER;
40:
41: l_incident_address_rec CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL;
42: l_incident_address_index BINARY_INTEGER;
43:
44: CURSOR l_ValidateAddressFlag_csr IS
45: SELECT validate_address_flag

Line 170: END; -- Package Body CUG_VALIDATE_ADDRESS_TYPE

166: -- raise FND_API.G_EXC_ERROR;
167:
168: END Validate_Incident_Address_Type;
169: -- Enter further code below as specified in the Package spec.
170: END; -- Package Body CUG_VALIDATE_ADDRESS_TYPE