[Home] [Help]
PACKAGE: APPS.GME_VALIDATE_FLEX_FLD_PVT
Source
1 PACKAGE gme_validate_flex_fld_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVVFFS.pls 120.3 2006/03/09 05:33:53 svgonugu noship $ */
3 pkg_application_short_name VARCHAR2 (10) DEFAULT '*';
4 pkg_application_id NUMBER;
5 pkg_flex_field_name VARCHAR2 (200) DEFAULT '*';
6 pkg_flex_enabled VARCHAR2 (1);
7 pkg_context_column_name VARCHAR2 (200);
8 pkg_context_required VARCHAR2 (1);
9
10 /*BUG#3406639 -- Added following 5 Procedures for the Flex field Validations.*/
11 PROCEDURE validate_flex_batch_header (
12 p_batch_header IN gme_batch_header%ROWTYPE
13 ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE
14 ,x_return_status OUT NOCOPY VARCHAR2);
15
16 PROCEDURE validate_flex_batch_step (
17 p_batch_step IN gme_batch_steps%ROWTYPE
18 ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE
19 ,x_return_status OUT NOCOPY VARCHAR2);
20
21 PROCEDURE validate_flex_step_activities (
22 p_step_activities IN gme_batch_step_activities%ROWTYPE
23 ,x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE
24 ,x_return_status OUT NOCOPY VARCHAR2);
25
26 PROCEDURE validate_flex_step_resources (
27 p_step_resources IN gme_batch_step_resources%ROWTYPE
28 ,x_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31 /* start , Punit Kumar */
32 PROCEDURE validate_rsrc_txn_flex (
33 p_resource_txn_rec IN gme_resource_txns%ROWTYPE
34 ,x_resource_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
35 ,x_return_status OUT NOCOPY VARCHAR2);
36
37 /*end */
38
39 --Bug#5078853 rewritten the following procedure
40 PROCEDURE validate_flex_material_details (
41 p_material_detail_rec IN gme_material_details%ROWTYPE
42 ,x_material_detail_rec IN OUT NOCOPY gme_material_details%ROWTYPE
43 ,x_return_status OUT NOCOPY VARCHAR2);
44
45 /* Nsinha added p_validate_flexfields in param as part of GME_Process_Parameter_APIs_TD */
46 PROCEDURE validate_flex_process_param (
47 p_process_param_rec IN gme_process_parameters%ROWTYPE
48 ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
49 ,x_process_param_rec IN OUT NOCOPY gme_process_parameters%ROWTYPE
50 ,x_return_status OUT NOCOPY VARCHAR2);
51
52 --siva Bug#4395561 Start
53 PROCEDURE create_flex_batch_header (
54 p_batch_header IN gme_batch_header%ROWTYPE,
55 x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE,
56 x_return_status OUT NOCOPY VARCHAR2
57 );
58 PROCEDURE create_flex_material_details (
59 p_material_detail IN gme_material_details%ROWTYPE,
60 x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE,
61 x_return_status OUT NOCOPY VARCHAR2
62 );
63 PROCEDURE create_flex_batch_step (
64 p_batch_step IN gme_batch_steps%ROWTYPE,
65 x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68 PROCEDURE create_flex_step_activities (
69 p_step_activities IN gme_batch_step_activities%ROWTYPE,
70 x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,
71 x_return_status OUT NOCOPY VARCHAR2
72 );
73 PROCEDURE create_flex_step_resources (
74 p_step_resources IN gme_batch_step_resources%ROWTYPE,
75 x_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE,
76 x_return_status OUT NOCOPY VARCHAR2
77 );
78 PROCEDURE create_flex_process_param (
79 p_process_param_rec IN gme_process_parameters%ROWTYPE,
80 x_process_param_rec IN OUT NOCOPY gme_process_parameters%ROWTYPE,
81 x_return_status OUT NOCOPY VARCHAR2
82 );
83 PROCEDURE create_flex_resource_txns (
84 p_resource_txns IN gme_resource_txns%ROWTYPE,
85 x_resource_txns IN OUT NOCOPY gme_resource_txns%ROWTYPE,
86 x_return_status OUT NOCOPY VARCHAR2
87 );
88 --siva Bug#4395561 End
89 CURSOR cur_get_appl_id
90 IS
91 SELECT application_id
92 FROM fnd_application
93 WHERE application_short_name = 'GME';
94 END gme_validate_flex_fld_pvt;