eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RESULTS_PUB dependencies on GMD_RESULTS

Line 1: PACKAGE GMD_RESULTS_PUB AUTHID CURRENT_USER AS

1: PACKAGE GMD_RESULTS_PUB AUTHID CURRENT_USER AS
2: /* $Header: GMDPRESS.pls 120.1.12020000.2 2012/07/17 10:07:02 mtou ship $*/
3: /*#
4: * This interface is used for processing QM Results.
5: * This package defines and implements the procedures and datatypes

Line 10: * @rep:displayname GMD Results Package

6: * required for processing QM results.
7: * @rep:scope public
8: * @rep:product GMD
9: * @rep:lifecycle active
10: * @rep:displayname GMD Results Package
11: * @rep:compatibility S
12: * @rep:category BUSINESS_ENTITY GMD_RESULTS_PUB
13: */
14: -- Define Results Rec Type

Line 12: * @rep:category BUSINESS_ENTITY GMD_RESULTS_PUB

8: * @rep:product GMD
9: * @rep:lifecycle active
10: * @rep:displayname GMD Results Package
11: * @rep:compatibility S
12: * @rep:category BUSINESS_ENTITY GMD_RESULTS_PUB
13: */
14: -- Define Results Rec Type
15: -- Bug 3559515 EVAL_IND and ACTION_CODE assigned proper data types.
16:

Line 18: ( UPDATE_INSTANCE_ID GMD_RESULTS.UPDATE_INSTANCE_ID%TYPE,

14: -- Define Results Rec Type
15: -- Bug 3559515 EVAL_IND and ACTION_CODE assigned proper data types.
16:
17: TYPE RESULTS_REC IS RECORD
18: ( UPDATE_INSTANCE_ID GMD_RESULTS.UPDATE_INSTANCE_ID%TYPE,
19: RESULT_ID GMD_RESULTS.RESULT_ID%TYPE,
20: SAMPLE_ID GMD_RESULTS.SAMPLE_ID%TYPE,
21: SAMPLE_NO GMD_SAMPLES.SAMPLE_NO%TYPE,
22: ORGANIZATION_ID GMD_SAMPLES.ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/

Line 19: RESULT_ID GMD_RESULTS.RESULT_ID%TYPE,

15: -- Bug 3559515 EVAL_IND and ACTION_CODE assigned proper data types.
16:
17: TYPE RESULTS_REC IS RECORD
18: ( UPDATE_INSTANCE_ID GMD_RESULTS.UPDATE_INSTANCE_ID%TYPE,
19: RESULT_ID GMD_RESULTS.RESULT_ID%TYPE,
20: SAMPLE_ID GMD_RESULTS.SAMPLE_ID%TYPE,
21: SAMPLE_NO GMD_SAMPLES.SAMPLE_NO%TYPE,
22: ORGANIZATION_ID GMD_SAMPLES.ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
23: LAB_ORGANIZATION_ID GMD_RESULTS.LAB_ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/

Line 20: SAMPLE_ID GMD_RESULTS.SAMPLE_ID%TYPE,

16:
17: TYPE RESULTS_REC IS RECORD
18: ( UPDATE_INSTANCE_ID GMD_RESULTS.UPDATE_INSTANCE_ID%TYPE,
19: RESULT_ID GMD_RESULTS.RESULT_ID%TYPE,
20: SAMPLE_ID GMD_RESULTS.SAMPLE_ID%TYPE,
21: SAMPLE_NO GMD_SAMPLES.SAMPLE_NO%TYPE,
22: ORGANIZATION_ID GMD_SAMPLES.ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
23: LAB_ORGANIZATION_ID GMD_RESULTS.LAB_ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
24: TEST_CODE GMD_QC_TESTS.TEST_CODE%TYPE,

Line 23: LAB_ORGANIZATION_ID GMD_RESULTS.LAB_ORGANIZATION_ID%TYPE, /NSRIVAST, INVCONV/

19: RESULT_ID GMD_RESULTS.RESULT_ID%TYPE,
20: SAMPLE_ID GMD_RESULTS.SAMPLE_ID%TYPE,
21: SAMPLE_NO GMD_SAMPLES.SAMPLE_NO%TYPE,
22: ORGANIZATION_ID GMD_SAMPLES.ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
23: LAB_ORGANIZATION_ID GMD_RESULTS.LAB_ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
24: TEST_CODE GMD_QC_TESTS.TEST_CODE%TYPE,
25: TEST_ID GMD_RESULTS.TEST_ID%TYPE,
26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,
27: RESULT_VALUE VARCHAR2(80),

Line 25: TEST_ID GMD_RESULTS.TEST_ID%TYPE,

21: SAMPLE_NO GMD_SAMPLES.SAMPLE_NO%TYPE,
22: ORGANIZATION_ID GMD_SAMPLES.ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
23: LAB_ORGANIZATION_ID GMD_RESULTS.LAB_ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
24: TEST_CODE GMD_QC_TESTS.TEST_CODE%TYPE,
25: TEST_ID GMD_RESULTS.TEST_ID%TYPE,
26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,
27: RESULT_VALUE VARCHAR2(80),
28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/

Line 26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,

22: ORGANIZATION_ID GMD_SAMPLES.ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
23: LAB_ORGANIZATION_ID GMD_RESULTS.LAB_ORGANIZATION_ID%TYPE, /*NSRIVAST, INVCONV*/
24: TEST_CODE GMD_QC_TESTS.TEST_CODE%TYPE,
25: TEST_ID GMD_RESULTS.TEST_ID%TYPE,
26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,
27: RESULT_VALUE VARCHAR2(80),
28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/

Line 28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,

24: TEST_CODE GMD_QC_TESTS.TEST_CODE%TYPE,
25: TEST_ID GMD_RESULTS.TEST_ID%TYPE,
26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,
27: RESULT_VALUE VARCHAR2(80),
28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,

Line 29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /NSRIVAST, INVCONV/

25: TEST_ID GMD_RESULTS.TEST_ID%TYPE,
26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,
27: RESULT_VALUE VARCHAR2(80),
28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,

Line 30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /NSRIVAST, INVCONV/

26: TEST_REPLICATE_CNT GMD_RESULTS.TEST_REPLICATE_CNT%TYPE,
27: RESULT_VALUE VARCHAR2(80),
28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,

Line 31: TESTER GMD_RESULTS.TESTER%TYPE,

27: RESULT_VALUE VARCHAR2(80),
28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,
35: SEQ GMD_RESULTS.SEQ%TYPE,

Line 32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,

28: RESULT_DATE GMD_RESULTS.RESULT_DATE%TYPE,
29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,
35: SEQ GMD_RESULTS.SEQ%TYPE,
36: IN_SPEC GMD_SPEC_RESULTS.IN_SPEC_IND%TYPE,

Line 33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,

29: TEST_KIT_INV_ITEM_ID GMD_RESULTS.TEST_KIT_INV_ITEM_ID%TYPE, /*NSRIVAST, INVCONV*/
30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,
35: SEQ GMD_RESULTS.SEQ%TYPE,
36: IN_SPEC GMD_SPEC_RESULTS.IN_SPEC_IND%TYPE,
37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,

Line 34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,

30: TEST_KIT_LOT_NUMBER GMD_RESULTS.TEST_KIT_LOT_NUMBER%TYPE, /*NSRIVAST, INVCONV*/
31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,
35: SEQ GMD_RESULTS.SEQ%TYPE,
36: IN_SPEC GMD_SPEC_RESULTS.IN_SPEC_IND%TYPE,
37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,
38: EVAL_IND GMD_SPEC_RESULTS.EVALUATION_IND%TYPE,

Line 35: SEQ GMD_RESULTS.SEQ%TYPE,

31: TESTER GMD_RESULTS.TESTER%TYPE,
32: TESTER_ID GMD_RESULTS.TESTER_ID%TYPE,
33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,
35: SEQ GMD_RESULTS.SEQ%TYPE,
36: IN_SPEC GMD_SPEC_RESULTS.IN_SPEC_IND%TYPE,
37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,
38: EVAL_IND GMD_SPEC_RESULTS.EVALUATION_IND%TYPE,
39: ACTION_CODE GMD_SPEC_RESULTS.ACTION_CODE%TYPE,

Line 37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,

33: TEST_PROVIDER_CODE GMD_RESULTS.TEST_PROVIDER_CODE%TYPE,
34: TEST_PROVIDER_ID GMD_RESULTS.TEST_PROVIDER_ID%TYPE,
35: SEQ GMD_RESULTS.SEQ%TYPE,
36: IN_SPEC GMD_SPEC_RESULTS.IN_SPEC_IND%TYPE,
37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,
38: EVAL_IND GMD_SPEC_RESULTS.EVALUATION_IND%TYPE,
39: ACTION_CODE GMD_SPEC_RESULTS.ACTION_CODE%TYPE,
40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,
41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,

Line 40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,

36: IN_SPEC GMD_SPEC_RESULTS.IN_SPEC_IND%TYPE,
37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,
38: EVAL_IND GMD_SPEC_RESULTS.EVALUATION_IND%TYPE,
39: ACTION_CODE GMD_SPEC_RESULTS.ACTION_CODE%TYPE,
40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,
41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,
42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,

Line 41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,

37: ASSAY_RETEST GMD_RESULTS.ASSAY_RETEST%TYPE,
38: EVAL_IND GMD_SPEC_RESULTS.EVALUATION_IND%TYPE,
39: ACTION_CODE GMD_SPEC_RESULTS.ACTION_CODE%TYPE,
40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,
41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,
42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,

Line 42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,

38: EVAL_IND GMD_SPEC_RESULTS.EVALUATION_IND%TYPE,
39: ACTION_CODE GMD_SPEC_RESULTS.ACTION_CODE%TYPE,
40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,
41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,
42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,

Line 43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,

39: ACTION_CODE GMD_SPEC_RESULTS.ACTION_CODE%TYPE,
40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,
41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,
42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,

Line 44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,

40: AD_HOC_PRINT_ON_COA_IND GMD_RESULTS.AD_HOC_PRINT_ON_COA_IND%TYPE,
41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,
42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/

Line 45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,

41: PLANNED_RESOURCE GMD_RESULTS.PLANNED_RESOURCE%TYPE,
42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/
49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,

Line 46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,

42: PLANNED_RESOURCE_INSTANCE GMD_RESULTS.PLANNED_RESOURCE_INSTANCE%TYPE,
43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/
49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,
50: CONSUMED_QTY GMD_RESULTS.CONSUMED_QTY%TYPE,

Line 47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,

43: ACTUAL_RESOURCE GMD_RESULTS.ACTUAL_RESOURCE%TYPE,
44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/
49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,
50: CONSUMED_QTY GMD_RESULTS.CONSUMED_QTY%TYPE,
51: attribute_category VARCHAR2(30), -- added dffs for Bug 13976016 - HOW TO UPDATE DFF IN QUALITY RESULT FORM, USING API

Line 48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /NSRIVAST, INVCONV/

44: ACTUAL_RESOURCE_INSTANCE GMD_RESULTS.ACTUAL_RESOURCE_INSTANCE%TYPE,
45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/
49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,
50: CONSUMED_QTY GMD_RESULTS.CONSUMED_QTY%TYPE,
51: attribute_category VARCHAR2(30), -- added dffs for Bug 13976016 - HOW TO UPDATE DFF IN QUALITY RESULT FORM, USING API
52: attribute1 VARCHAR2(240),

Line 49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,

45: PLANNED_RESULT_DATE GMD_RESULTS.PLANNED_RESULT_DATE%TYPE,
46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/
49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,
50: CONSUMED_QTY GMD_RESULTS.CONSUMED_QTY%TYPE,
51: attribute_category VARCHAR2(30), -- added dffs for Bug 13976016 - HOW TO UPDATE DFF IN QUALITY RESULT FORM, USING API
52: attribute1 VARCHAR2(240),
53: attribute2 VARCHAR2(240),

Line 50: CONSUMED_QTY GMD_RESULTS.CONSUMED_QTY%TYPE,

46: TEST_BY_DATE GMD_RESULTS.TEST_BY_DATE%TYPE,
47: TEST_QTY GMD_RESULTS.TEST_QTY%TYPE,
48: TEST_QTY_UOM GMD_RESULTS.TEST_QTY_UOM%TYPE, /*NSRIVAST, INVCONV*/
49: RESERVE_SAMPLE_ID GMD_RESULTS.RESERVE_SAMPLE_ID%TYPE,
50: CONSUMED_QTY GMD_RESULTS.CONSUMED_QTY%TYPE,
51: attribute_category VARCHAR2(30), -- added dffs for Bug 13976016 - HOW TO UPDATE DFF IN QUALITY RESULT FORM, USING API
52: attribute1 VARCHAR2(240),
53: attribute2 VARCHAR2(240),
54: attribute3 VARCHAR2(240),

Line 101: ( p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC,

97: * @rep:compatibility S
98: */
99:
100: PROCEDURE VALIDATE_INPUT
101: ( p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC,
102: x_return_status OUT NOCOPY VARCHAR2
103: );
104:
105: /*#

Line 118: ( p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC,

114: * @rep:compatibility S
115: */
116:
117: PROCEDURE GET_RESULT_INFO
118: ( p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC,
119: x_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE,
120: x_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE,
121: x_return_status OUT NOCOPY VARCHAR2
122: );

Line 133: * @param x_results_rec Record structure for GMD results

129: * @param p_commit Flag to check for commit
130: * @param p_validation_level For future use
131: * @param p_results_rec Record structure for Results
132: * @param p_user_name Login User Name
133: * @param x_results_rec Record structure for GMD results
134: * @param x_spec_results_rec Record structure for GMD specification results
135: * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
136: * @param x_msg_count Number of messages on message stack
137: * @param x_msg_data Actual message data on message stack

Line 151: , p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC

147: ( p_api_version IN NUMBER
148: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
149: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
150: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
151: , p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC
152: , p_user_name IN VARCHAR2
153: , x_results_rec OUT NOCOPY GMD_RESULTS%ROWTYPE
154: , x_spec_results_rec OUT NOCOPY GMD_SPEC_RESULTS%ROWTYPE
155: , x_return_status OUT NOCOPY VARCHAR2

Line 153: , x_results_rec OUT NOCOPY GMD_RESULTS%ROWTYPE

149: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
150: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
151: , p_results_rec IN GMD_RESULTS_PUB.RESULTS_REC
152: , p_user_name IN VARCHAR2
153: , x_results_rec OUT NOCOPY GMD_RESULTS%ROWTYPE
154: , x_spec_results_rec OUT NOCOPY GMD_SPEC_RESULTS%ROWTYPE
155: , x_return_status OUT NOCOPY VARCHAR2
156: , x_msg_count OUT NOCOPY NUMBER
157: , x_msg_data OUT NOCOPY VARCHAR2

Line 193: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab

189: , p_user_name IN VARCHAR2
190: , p_sample_rec IN GMD_SAMPLES%ROWTYPE
191: , p_test_id_tab IN GMD_API_PUB.number_tab
192: , p_event_spec_disp_id IN NUMBER
193: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
194: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
195: , x_return_status OUT NOCOPY VARCHAR2
196: , x_msg_count OUT NOCOPY NUMBER
197: , x_msg_data OUT NOCOPY VARCHAR2

Line 200: END GMD_RESULTS_PUB;

196: , x_msg_count OUT NOCOPY NUMBER
197: , x_msg_data OUT NOCOPY VARCHAR2
198: );
199:
200: END GMD_RESULTS_PUB;