[Home] [Help]
PACKAGE: APPS.JG_GLOBE_FLEX_VAL_SHARED
Source
1 PACKAGE jg_globe_flex_val_shared AUTHID CURRENT_USER AS
2 /* $Header: jggdfvss.pls 115.3 2002/05/17 11:33:52 pkm ship $ */
3
4 --
5 -- Record type is introduced to handle global_attributes
6 --
7
8 TYPE GdfRec IS RECORD
9 (global_attribute_category VARCHAR2(30) DEFAULT NULL,
10 global_attribute1 VARCHAR2(150) DEFAULT NULL,
11 global_attribute2 VARCHAR2(150) DEFAULT NULL,
12 global_attribute3 VARCHAR2(150) DEFAULT NULL,
13 global_attribute4 VARCHAR2(150) DEFAULT NULL,
14 global_attribute5 VARCHAR2(150) DEFAULT NULL,
15 global_attribute6 VARCHAR2(150) DEFAULT NULL,
16 global_attribute7 VARCHAR2(150) DEFAULT NULL,
17 global_attribute8 VARCHAR2(150) DEFAULT NULL,
18 global_attribute9 VARCHAR2(150) DEFAULT NULL,
19 global_attribute10 VARCHAR2(150) DEFAULT NULL,
20 global_attribute11 VARCHAR2(150) DEFAULT NULL,
21 global_attribute12 VARCHAR2(150) DEFAULT NULL,
22 global_attribute13 VARCHAR2(150) DEFAULT NULL,
23 global_attribute14 VARCHAR2(150) DEFAULT NULL,
24 global_attribute15 VARCHAR2(150) DEFAULT NULL,
25 global_attribute16 VARCHAR2(150) DEFAULT NULL,
26 global_attribute17 VARCHAR2(150) DEFAULT NULL,
27 global_attribute18 VARCHAR2(150) DEFAULT NULL,
28 global_attribute19 VARCHAR2(150) DEFAULT NULL,
29 global_attribute20 VARCHAR2(150) DEFAULT NULL
30 );
31
32
33 TYPE GenRec IS RECORD
34 (core_prod_arg1 VARCHAR2(150) DEFAULT NULL,
35 core_prod_arg2 VARCHAR2(150) DEFAULT NULL,
36 core_prod_arg3 VARCHAR2(150) DEFAULT NULL,
37 core_prod_arg4 VARCHAR2(150) DEFAULT NULL,
38 core_prod_arg5 VARCHAR2(150) DEFAULT NULL,
39 core_prod_arg6 VARCHAR2(150) DEFAULT NULL,
40 core_prod_arg7 VARCHAR2(150) DEFAULT NULL,
41 core_prod_arg8 VARCHAR2(150) DEFAULT NULL,
42 core_prod_arg9 VARCHAR2(150) DEFAULT NULL,
43 core_prod_arg10 VARCHAR2(150) DEFAULT NULL,
44 core_prod_arg11 VARCHAR2(150) DEFAULT NULL,
45 core_prod_arg12 VARCHAR2(150) DEFAULT NULL,
46 core_prod_arg13 VARCHAR2(150) DEFAULT NULL,
47 core_prod_arg14 VARCHAR2(150) DEFAULT NULL,
48 core_prod_arg15 VARCHAR2(150) DEFAULT NULL,
49 core_prod_arg16 VARCHAR2(150) DEFAULT NULL,
50 core_prod_arg17 VARCHAR2(150) DEFAULT NULL,
51 core_prod_arg18 VARCHAR2(150) DEFAULT NULL,
52 core_prod_arg19 VARCHAR2(150) DEFAULT NULL,
53 core_prod_arg20 VARCHAR2(150) DEFAULT NULL,
54 core_prod_arg21 VARCHAR2(150) DEFAULT NULL,
55 core_prod_arg22 VARCHAR2(150) DEFAULT NULL,
56 core_prod_arg23 VARCHAR2(150) DEFAULT NULL,
57 core_prod_arg24 VARCHAR2(150) DEFAULT NULL,
58 core_prod_arg25 VARCHAR2(150) DEFAULT NULL,
59 core_prod_arg26 VARCHAR2(150) DEFAULT NULL,
60 core_prod_arg27 VARCHAR2(150) DEFAULT NULL,
61 core_prod_arg28 VARCHAR2(150) DEFAULT NULL,
62 core_prod_arg29 VARCHAR2(150) DEFAULT NULL,
63 core_prod_arg30 VARCHAR2(150) DEFAULT NULL
64 );
65
66 PROCEDURE insert_rejections(
67 p_parent_table IN VARCHAR2,
68 p_parent_id IN NUMBER,
69 p_reject_code IN VARCHAR2,
70 p_last_updated_by IN NUMBER,
71 p_last_update_login IN NUMBER,
72 p_calling_sequence IN VARCHAR2);
73
74 PROCEDURE update_ra_customers_interface(
75 p_code IN VARCHAR2,
76 p_row_id IN VARCHAR2,
77 p_current_status IN VARCHAR2);
78
79 PROCEDURE update_interface_status(
80 p_rowid IN VARCHAR2,
81 p_table_name IN VARCHAR2,
82 p_code IN VARCHAR2,
83 p_current_status IN VARCHAR2);
84
85 FUNCTION check_format(
86 p_value IN VARCHAR2,
87 p_format_type IN VARCHAR2,
88 p_maximum_size IN NUMBER,
89 p_precision IN NUMBER,
90 p_alphanumeric IN VARCHAR2,
91 p_uppercase_only IN VARCHAR2,
92 p_right_justify IN VARCHAR2,
93 p_min_value IN VARCHAR2,
94 p_max_value IN VARCHAR2) RETURN BOOLEAN;
95
96 END jg_globe_flex_val_shared;