PACKAGE: APPS.OKL_AM_QA_DATA_INTEGRITY_PVT

Source

1 PACKAGE okl_am_qa_data_integrity_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRAMQS.pls 115.3 2002/08/19 20:01:30 rdraguil noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- GLOBAL DATASTRUCTURES
6   ---------------------------------------------------------------------------
7 
8   SUBTYPE rgr_rec_type IS okl_rgrp_rules_process_pub.rgr_rec_type;
9 
10   ---------------------------------------------------------------------------
11   -- GLOBAL VARIABLES
12   ---------------------------------------------------------------------------
13 
14   -- Validation for missing fields
15   G_MISS_NUM		CONSTANT NUMBER		:= OKL_API.G_MISS_NUM;
16   G_MISS_CHAR		CONSTANT VARCHAR2(1)	:= OKL_API.G_MISS_CHAR;
17   G_MISS_DATE		CONSTANT DATE		:= OKL_API.G_MISS_DATE;
18 
19   ---------------------------------------------------------------------------
20   -- GLOBAL MESSAGE CONSTANTS FOR ERROR HANDLING
21   ---------------------------------------------------------------------------
22 
23   G_APP_NAME		CONSTANT VARCHAR2(3)	:=  OKL_API.G_APP_NAME;
24   G_API_VERSION		CONSTANT NUMBER		:= 1;
25   G_PKG_NAME		CONSTANT VARCHAR2(200)	:=
26 					'OKL_AM_QA_DATA_INTEGRITY_PVT';
27 
28   G_SQLCODE_TOKEN	CONSTANT VARCHAR2(200)	:= 'SQLCODE';
29   G_SQLERRM_TOKEN	CONSTANT VARCHAR2(200)	:= 'SQLERRM';
30   G_UNEXPECTED_ERROR	CONSTANT VARCHAR2(200)	:=
31 					 'OKL_CONTRACTS_UNEXPECTED_ERROR';
32 
33   G_OKC_APP_NAME	CONSTANT VARCHAR2(3)	:= OKC_API.G_APP_NAME;
34   G_INVALID_VALUE	CONSTANT VARCHAR2(200)	:= OKC_API.G_INVALID_VALUE;
35   G_REQUIRED_VALUE	CONSTANT VARCHAR2(200)	:= OKC_API.G_REQUIRED_VALUE;
36   G_COL_NAME_TOKEN	CONSTANT VARCHAR2(200)	:= OKC_API.G_COL_NAME_TOKEN;
37 
38   ---------------------------------------------------------------------------
39   -- Procedures and Functions
40   ---------------------------------------------------------------------------
41 
42   -- Mandatory checks for values of contract rules used by AM
43   PROCEDURE check_rule_constraints (
44 	x_return_status	OUT NOCOPY VARCHAR2,
45 	p_chr_id	IN  NUMBER);
46 
47   -- Optional checks for values of contract rules used by AM
48   PROCEDURE check_warning_constraints (
49 	x_return_status	OUT NOCOPY VARCHAR2,
50 	p_chr_id	IN  NUMBER);
51 
52   -- Check correct format of Formula-Amount rules used by AM
53   PROCEDURE check_am_rule_format (
54 	x_return_status	OUT NOCOPY VARCHAR2,
55 	p_chr_id	IN  NUMBER,
56 	p_rgr_rec	IN  rgr_rec_type);
57 
58 END okl_am_qa_data_integrity_pvt;