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_QC_TESTS_PUB dependencies on GMD_QC_TESTS_PUB

Line 1: PACKAGE BODY gmd_qc_tests_pub AS

1: PACKAGE BODY gmd_qc_tests_pub AS
2: /* $Header: GMDPTSTB.pls 115.13 2004/05/05 09:51:17 rboddu noship $
3: *****************************************************************
4: * *
5: * Package GMD_QC_TESTS_PUB *

Line 5: * Package GMD_QC_TESTS_PUB *

1: PACKAGE BODY gmd_qc_tests_pub AS
2: /* $Header: GMDPTSTB.pls 115.13 2004/05/05 09:51:17 rboddu noship $
3: *****************************************************************
4: * *
5: * Package GMD_QC_TESTS_PUB *
6: * *
7: * Contents CREATE_TESTS *
8: * DELETE_TEST_HEADERS *
9: * DELETE_TEST_VALUES *

Line 25: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_QC_TESTS_PUB';

21: */
22:
23: /* Global variables */
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_QC_TESTS_PUB';
26:
27: G_PROCESS_TESTS BOOLEAN := FALSE;
28: G_PROCESS_VALUES BOOLEAN := FALSE;
29: G_PROCESS_CUSTOMERS BOOLEAN := FALSE;

Line 35: p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl,

31: /* Private Routines */
32:
33: PROCEDURE VALIDATE_INPUT_PARAMS
34: (
35: p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl,
36: p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
37:
38: )
39: IS

Line 36: p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl

32:
33: PROCEDURE VALIDATE_INPUT_PARAMS
34: (
35: p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl,
36: p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
37:
38: )
39: IS
40:

Line 67: , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl

63: , p_init_msg_list IN VARCHAR2
64: , p_commit IN VARCHAR2
65: , p_validation_level IN NUMBER
66: , p_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE
67: , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
68: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
69: , p_user_name IN VARCHAR2
70: , x_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE
71: , x_qc_test_values_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_test_values_tbl

Line 68: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl

64: , p_commit IN VARCHAR2
65: , p_validation_level IN NUMBER
66: , p_qc_tests_rec IN GMD_QC_TESTS%ROWTYPE
67: , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
68: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
69: , p_user_name IN VARCHAR2
70: , x_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE
71: , x_qc_test_values_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_test_values_tbl
72: , x_qc_cust_tests_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_cust_tests_tbl

Line 71: , x_qc_test_values_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_test_values_tbl

67: , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
68: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
69: , p_user_name IN VARCHAR2
70: , x_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE
71: , x_qc_test_values_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_test_values_tbl
72: , x_qc_cust_tests_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_cust_tests_tbl
73: , x_return_status OUT NOCOPY VARCHAR2
74: , x_msg_count OUT NOCOPY NUMBER
75: , x_msg_data OUT NOCOPY VARCHAR2

Line 72: , x_qc_cust_tests_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_cust_tests_tbl

68: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
69: , p_user_name IN VARCHAR2
70: , x_qc_tests_rec OUT NOCOPY GMD_QC_TESTS%ROWTYPE
71: , x_qc_test_values_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_test_values_tbl
72: , x_qc_cust_tests_tbl OUT NOCOPY GMD_QC_TESTS_PUB.qc_cust_tests_tbl
73: , x_return_status OUT NOCOPY VARCHAR2
74: , x_msg_count OUT NOCOPY NUMBER
75: , x_msg_data OUT NOCOPY VARCHAR2
76: )

Line 88: l_qc_test_values_tbl GMD_QC_TESTS_PUB.qc_test_values_tbl;

84: l_qc_tests_rec_in GMD_QC_TESTS%ROWTYPE;
85: l_qc_cust_tests_rec GMD_CUSTOMER_TESTS%ROWTYPE;
86: l_qc_test_values_rec_in GMD_QC_TEST_VALUES%ROWTYPE;
87: l_qc_test_values_rec GMD_QC_TEST_VALUES%ROWTYPE;
88: l_qc_test_values_tbl GMD_QC_TESTS_PUB.qc_test_values_tbl;
89: l_qc_cust_tests_tbl GMD_QC_TESTS_PUB.qc_cust_tests_tbl;
90: l_rowid ROWID;
91: l_user_id NUMBER(15);
92:

Line 89: l_qc_cust_tests_tbl GMD_QC_TESTS_PUB.qc_cust_tests_tbl;

85: l_qc_cust_tests_rec GMD_CUSTOMER_TESTS%ROWTYPE;
86: l_qc_test_values_rec_in GMD_QC_TEST_VALUES%ROWTYPE;
87: l_qc_test_values_rec GMD_QC_TEST_VALUES%ROWTYPE;
88: l_qc_test_values_tbl GMD_QC_TESTS_PUB.qc_test_values_tbl;
89: l_qc_cust_tests_tbl GMD_QC_TESTS_PUB.qc_cust_tests_tbl;
90: l_rowid ROWID;
91: l_user_id NUMBER(15);
92:
93: BEGIN

Line 634: , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl

630: ( p_api_version IN NUMBER
631: , p_init_msg_list IN VARCHAR2
632: , p_commit IN VARCHAR2
633: , p_validation_level IN NUMBER
634: , p_qc_test_values_tbl IN GMD_QC_TESTS_PUB.qc_test_values_tbl
635: , x_deleted_rows OUT NOCOPY NUMBER
636: , x_return_status OUT NOCOPY VARCHAR2
637: , x_msg_count OUT NOCOPY NUMBER
638: , x_msg_data OUT NOCOPY VARCHAR2

Line 649: l_qc_test_values_tbl GMD_QC_TESTS_PUB.qc_test_values_tbl;

645: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
646: l_qc_tests_rec GMD_QC_TESTS%ROWTYPE;
647: l_qc_tests_rec_in GMD_QC_TESTS%ROWTYPE;
648: l_qc_test_values_rec GMD_QC_TEST_VALUES%ROWTYPE;
649: l_qc_test_values_tbl GMD_QC_TESTS_PUB.qc_test_values_tbl;
650: l_deleted_rows NUMBER(10);
651: l_test_id NUMBER(10);
652:
653: BEGIN

Line 849: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl

845: ( p_api_version IN NUMBER
846: , p_init_msg_list IN VARCHAR2
847: , p_commit IN VARCHAR2
848: , p_validation_level IN NUMBER
849: , p_qc_cust_tests_tbl IN GMD_QC_TESTS_PUB.qc_cust_tests_tbl
850: , x_deleted_rows OUT NOCOPY NUMBER
851: , x_return_status OUT NOCOPY VARCHAR2
852: , x_msg_count OUT NOCOPY NUMBER
853: , x_msg_data OUT NOCOPY VARCHAR2

Line 1037: END gmd_qc_tests_pub;

1033: );
1034:
1035: END delete_customer_tests;
1036:
1037: END gmd_qc_tests_pub;