APPS.GMD_SPEC_PUB dependencies on GMD_SPEC_PUB

Line 1: PACKAGE BODY GMD_SPEC_PUB AS

1: PACKAGE BODY GMD_SPEC_PUB AS
2: /* $Header: GMDPSPCB.pls 120.1 2006/05/31 13:43:08 ragsriva noship $
3: +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 9: | Package Name : GMD_Spec_PUB |

5: | TVP, Reading, England |
6: | All rights reserved |
7: +=========================================================================+
8: | File Name : GMDPSPCB.pls |
9: | Package Name : GMD_Spec_PUB |
10: | Type : PUBLIC |
11: | |
12: | Contents CREATE_SPEC |
13: | DELETE_SPEC |

Line 28: API Name : GMD_Spec_PUB

24: | HVerddin B2711643: Added call to set user_context |
25: | |
26: | |
27: +=========================================================================+
28: API Name : GMD_Spec_PUB
29: Type : Public
30: Function : This package contains public procedures used to process
31: specifications.
32: Pre-reqs : N/A

Line 47: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_SPEC_PUB';

43:
44:
45: /* Global variables */
46:
47: G_PKG_NAME CONSTANT VARCHAR2(30):='GMD_SPEC_PUB';
48:
49: /*
50: +=========================================================================+
51: | Name : CREATE_SPEC |

Line 81: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl

77: , p_init_msg_list IN VARCHAR2
78: , p_commit IN VARCHAR2
79: , p_validation_level IN VARCHAR2
80: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
81: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
82: , p_user_name IN VARCHAR2
83: , x_spec OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE
84: , x_spec_tests_tbl OUT NOCOPY GMD_SPEC_PUB.spec_tests_tbl
85: , x_return_status OUT NOCOPY VARCHAR2

Line 84: , x_spec_tests_tbl OUT NOCOPY GMD_SPEC_PUB.spec_tests_tbl

80: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
81: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
82: , p_user_name IN VARCHAR2
83: , x_spec OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE
84: , x_spec_tests_tbl OUT NOCOPY GMD_SPEC_PUB.spec_tests_tbl
85: , x_return_status OUT NOCOPY VARCHAR2
86: , x_msg_count OUT NOCOPY NUMBER
87: , x_msg_data OUT NOCOPY VARCHAR2
88: )

Line 99: l_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl;

95: l_spec GMD_SPECIFICATIONS%ROWTYPE;
96: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
97: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
98: l_spec_tests_out GMD_SPEC_TESTS%ROWTYPE;
99: l_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl;
100: l_spec_id NUMBER;
101: l_rowid ROWID;
102: l_user_id NUMBER(15);
103: pp_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl ;

Line 103: pp_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl ;

99: l_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl;
100: l_spec_id NUMBER;
101: l_rowid ROWID;
102: l_user_id NUMBER(15);
103: pp_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl ;
104:
105: CURSOR Cur_get_dtl_base (p_basespec_id NUMBER) IS
106: SELECT *
107: FROM gmd_spec_tests

Line 585: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl

581: ( p_api_version IN NUMBER
582: , p_init_msg_list IN VARCHAR2
583: , p_commit IN VARCHAR2
584: , p_validation_level IN VARCHAR2
585: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
586: , x_deleted_rows OUT NOCOPY NUMBER
587: , x_return_status OUT NOCOPY VARCHAR2
588: , x_msg_count OUT NOCOPY NUMBER
589: , x_msg_data OUT NOCOPY VARCHAR2

Line 778: END GMD_SPEC_PUB;

774: );
775:
776: END DELETE_SPEC_TESTS;
777:
778: END GMD_SPEC_PUB;