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.WMS_SAVE_QUERY_PVT dependencies on WMS_SAVED_QUERIES

Line 6: query_type wms_saved_queries.query_type%TYPE,

2: /* $Header: WMSVSQRS.pls 115.2 2003/01/15 19:17:36 piwong noship $ */
3:
4: TYPE save_query_record IS RECORD
5: (
6: query_type wms_saved_queries.query_type%TYPE,
7: query_name wms_saved_queries.query_name%TYPE,
8: field_name wms_saved_queries.field_name%TYPE,
9: field_type wms_saved_queries.field_type%TYPE,
10: field_value wms_saved_queries.field_value%TYPE,

Line 7: query_name wms_saved_queries.query_name%TYPE,

3:
4: TYPE save_query_record IS RECORD
5: (
6: query_type wms_saved_queries.query_type%TYPE,
7: query_name wms_saved_queries.query_name%TYPE,
8: field_name wms_saved_queries.field_name%TYPE,
9: field_type wms_saved_queries.field_type%TYPE,
10: field_value wms_saved_queries.field_value%TYPE,
11: return_status VARCHAR2(1));

Line 8: field_name wms_saved_queries.field_name%TYPE,

4: TYPE save_query_record IS RECORD
5: (
6: query_type wms_saved_queries.query_type%TYPE,
7: query_name wms_saved_queries.query_name%TYPE,
8: field_name wms_saved_queries.field_name%TYPE,
9: field_type wms_saved_queries.field_type%TYPE,
10: field_value wms_saved_queries.field_value%TYPE,
11: return_status VARCHAR2(1));
12:

Line 9: field_type wms_saved_queries.field_type%TYPE,

5: (
6: query_type wms_saved_queries.query_type%TYPE,
7: query_name wms_saved_queries.query_name%TYPE,
8: field_name wms_saved_queries.field_name%TYPE,
9: field_type wms_saved_queries.field_type%TYPE,
10: field_value wms_saved_queries.field_value%TYPE,
11: return_status VARCHAR2(1));
12:
13: TYPE save_query_table IS TABLE OF save_query_record

Line 10: field_value wms_saved_queries.field_value%TYPE,

6: query_type wms_saved_queries.query_type%TYPE,
7: query_name wms_saved_queries.query_name%TYPE,
8: field_name wms_saved_queries.field_name%TYPE,
9: field_type wms_saved_queries.field_type%TYPE,
10: field_value wms_saved_queries.field_value%TYPE,
11: return_status VARCHAR2(1));
12:
13: TYPE save_query_table IS TABLE OF save_query_record
14: INDEX BY BINARY_INTEGER;

Line 16: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,

12:
13: TYPE save_query_table IS TABLE OF save_query_record
14: INDEX BY BINARY_INTEGER;
15:
16: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
17: p_query_name wms_saved_queries.query_name%TYPE,
18: p_org_id wms_saved_queries.organization_id%TYPE,
19: p_user_id wms_saved_queries.user_id%TYPE,
20: p_login_id wms_saved_queries.last_update_login%TYPE,

Line 17: p_query_name wms_saved_queries.query_name%TYPE,

13: TYPE save_query_table IS TABLE OF save_query_record
14: INDEX BY BINARY_INTEGER;
15:
16: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
17: p_query_name wms_saved_queries.query_name%TYPE,
18: p_org_id wms_saved_queries.organization_id%TYPE,
19: p_user_id wms_saved_queries.user_id%TYPE,
20: p_login_id wms_saved_queries.last_update_login%TYPE,
21: p_table save_query_table,

Line 18: p_org_id wms_saved_queries.organization_id%TYPE,

14: INDEX BY BINARY_INTEGER;
15:
16: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
17: p_query_name wms_saved_queries.query_name%TYPE,
18: p_org_id wms_saved_queries.organization_id%TYPE,
19: p_user_id wms_saved_queries.user_id%TYPE,
20: p_login_id wms_saved_queries.last_update_login%TYPE,
21: p_table save_query_table,
22: x_return_status OUT NOCOPY varchar2);

Line 19: p_user_id wms_saved_queries.user_id%TYPE,

15:
16: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
17: p_query_name wms_saved_queries.query_name%TYPE,
18: p_org_id wms_saved_queries.organization_id%TYPE,
19: p_user_id wms_saved_queries.user_id%TYPE,
20: p_login_id wms_saved_queries.last_update_login%TYPE,
21: p_table save_query_table,
22: x_return_status OUT NOCOPY varchar2);
23:

Line 20: p_login_id wms_saved_queries.last_update_login%TYPE,

16: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
17: p_query_name wms_saved_queries.query_name%TYPE,
18: p_org_id wms_saved_queries.organization_id%TYPE,
19: p_user_id wms_saved_queries.user_id%TYPE,
20: p_login_id wms_saved_queries.last_update_login%TYPE,
21: p_table save_query_table,
22: x_return_status OUT NOCOPY varchar2);
23:
24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,

Line 24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,

20: p_login_id wms_saved_queries.last_update_login%TYPE,
21: p_table save_query_table,
22: x_return_status OUT NOCOPY varchar2);
23:
24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
25: p_query_name wms_saved_queries.query_name%TYPE,
26: p_org_id wms_saved_queries.organization_id%TYPE,
27: p_user_id wms_saved_queries.user_id%TYPE,
28: p_login_id wms_saved_queries.last_update_login%TYPE,

Line 25: p_query_name wms_saved_queries.query_name%TYPE,

21: p_table save_query_table,
22: x_return_status OUT NOCOPY varchar2);
23:
24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
25: p_query_name wms_saved_queries.query_name%TYPE,
26: p_org_id wms_saved_queries.organization_id%TYPE,
27: p_user_id wms_saved_queries.user_id%TYPE,
28: p_login_id wms_saved_queries.last_update_login%TYPE,
29: p_table save_query_table,

Line 26: p_org_id wms_saved_queries.organization_id%TYPE,

22: x_return_status OUT NOCOPY varchar2);
23:
24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
25: p_query_name wms_saved_queries.query_name%TYPE,
26: p_org_id wms_saved_queries.organization_id%TYPE,
27: p_user_id wms_saved_queries.user_id%TYPE,
28: p_login_id wms_saved_queries.last_update_login%TYPE,
29: p_table save_query_table,
30: x_return_status OUT NOCOPY varchar2);

Line 27: p_user_id wms_saved_queries.user_id%TYPE,

23:
24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
25: p_query_name wms_saved_queries.query_name%TYPE,
26: p_org_id wms_saved_queries.organization_id%TYPE,
27: p_user_id wms_saved_queries.user_id%TYPE,
28: p_login_id wms_saved_queries.last_update_login%TYPE,
29: p_table save_query_table,
30: x_return_status OUT NOCOPY varchar2);
31:

Line 28: p_login_id wms_saved_queries.last_update_login%TYPE,

24: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
25: p_query_name wms_saved_queries.query_name%TYPE,
26: p_org_id wms_saved_queries.organization_id%TYPE,
27: p_user_id wms_saved_queries.user_id%TYPE,
28: p_login_id wms_saved_queries.last_update_login%TYPE,
29: p_table save_query_table,
30: x_return_status OUT NOCOPY varchar2);
31:
32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,

Line 32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,

28: p_login_id wms_saved_queries.last_update_login%TYPE,
29: p_table save_query_table,
30: x_return_status OUT NOCOPY varchar2);
31:
32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
33: p_query_name wms_saved_queries.query_name%TYPE,
34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,

Line 33: p_query_name wms_saved_queries.query_name%TYPE,

29: p_table save_query_table,
30: x_return_status OUT NOCOPY varchar2);
31:
32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
33: p_query_name wms_saved_queries.query_name%TYPE,
34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,
37: p_org_id wms_saved_queries.organization_id%TYPE,

Line 34: p_field_name wms_saved_queries.field_name%TYPE,

30: x_return_status OUT NOCOPY varchar2);
31:
32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
33: p_query_name wms_saved_queries.query_name%TYPE,
34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,
37: p_org_id wms_saved_queries.organization_id%TYPE,
38: p_user_id wms_saved_queries.user_id%TYPE,

Line 35: p_field_value wms_saved_queries.field_value%TYPE,

31:
32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
33: p_query_name wms_saved_queries.query_name%TYPE,
34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,
37: p_org_id wms_saved_queries.organization_id%TYPE,
38: p_user_id wms_saved_queries.user_id%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2);

Line 36: p_field_type wms_saved_queries.field_type%TYPE,

32: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
33: p_query_name wms_saved_queries.query_name%TYPE,
34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,
37: p_org_id wms_saved_queries.organization_id%TYPE,
38: p_user_id wms_saved_queries.user_id%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2);
40:

Line 37: p_org_id wms_saved_queries.organization_id%TYPE,

33: p_query_name wms_saved_queries.query_name%TYPE,
34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,
37: p_org_id wms_saved_queries.organization_id%TYPE,
38: p_user_id wms_saved_queries.user_id%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,

Line 38: p_user_id wms_saved_queries.user_id%TYPE,

34: p_field_name wms_saved_queries.field_name%TYPE,
35: p_field_value wms_saved_queries.field_value%TYPE,
36: p_field_type wms_saved_queries.field_type%TYPE,
37: p_org_id wms_saved_queries.organization_id%TYPE,
38: p_user_id wms_saved_queries.user_id%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
42: p_query_name wms_saved_queries.query_name%TYPE,

Line 41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,

37: p_org_id wms_saved_queries.organization_id%TYPE,
38: p_user_id wms_saved_queries.user_id%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
42: p_query_name wms_saved_queries.query_name%TYPE,
43: p_field_name wms_saved_queries.field_name%TYPE,
44: p_org_id wms_saved_queries.organization_id%TYPE,
45: p_user_id wms_saved_queries.user_id%TYPE,

Line 42: p_query_name wms_saved_queries.query_name%TYPE,

38: p_user_id wms_saved_queries.user_id%TYPE,
39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
42: p_query_name wms_saved_queries.query_name%TYPE,
43: p_field_name wms_saved_queries.field_name%TYPE,
44: p_org_id wms_saved_queries.organization_id%TYPE,
45: p_user_id wms_saved_queries.user_id%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2);

Line 43: p_field_name wms_saved_queries.field_name%TYPE,

39: x_return_status OUT NOCOPY VARCHAR2);
40:
41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
42: p_query_name wms_saved_queries.query_name%TYPE,
43: p_field_name wms_saved_queries.field_name%TYPE,
44: p_org_id wms_saved_queries.organization_id%TYPE,
45: p_user_id wms_saved_queries.user_id%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2);
47:

Line 44: p_org_id wms_saved_queries.organization_id%TYPE,

40:
41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
42: p_query_name wms_saved_queries.query_name%TYPE,
43: p_field_name wms_saved_queries.field_name%TYPE,
44: p_org_id wms_saved_queries.organization_id%TYPE,
45: p_user_id wms_saved_queries.user_id%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,

Line 45: p_user_id wms_saved_queries.user_id%TYPE,

41: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
42: p_query_name wms_saved_queries.query_name%TYPE,
43: p_field_name wms_saved_queries.field_name%TYPE,
44: p_org_id wms_saved_queries.organization_id%TYPE,
45: p_user_id wms_saved_queries.user_id%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
49: p_query_name wms_saved_queries.query_name%TYPE,

Line 48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,

44: p_org_id wms_saved_queries.organization_id%TYPE,
45: p_user_id wms_saved_queries.user_id%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
49: p_query_name wms_saved_queries.query_name%TYPE,
50: p_org_id wms_saved_queries.organization_id%TYPE,
51: p_user_id wms_saved_queries.user_id%TYPE,
52: x_return_status OUT NOCOPY VARCHAR2);

Line 49: p_query_name wms_saved_queries.query_name%TYPE,

45: p_user_id wms_saved_queries.user_id%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
49: p_query_name wms_saved_queries.query_name%TYPE,
50: p_org_id wms_saved_queries.organization_id%TYPE,
51: p_user_id wms_saved_queries.user_id%TYPE,
52: x_return_status OUT NOCOPY VARCHAR2);
53:

Line 50: p_org_id wms_saved_queries.organization_id%TYPE,

46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
49: p_query_name wms_saved_queries.query_name%TYPE,
50: p_org_id wms_saved_queries.organization_id%TYPE,
51: p_user_id wms_saved_queries.user_id%TYPE,
52: x_return_status OUT NOCOPY VARCHAR2);
53:
54: END wms_save_query_pvt;

Line 51: p_user_id wms_saved_queries.user_id%TYPE,

47:
48: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
49: p_query_name wms_saved_queries.query_name%TYPE,
50: p_org_id wms_saved_queries.organization_id%TYPE,
51: p_user_id wms_saved_queries.user_id%TYPE,
52: x_return_status OUT NOCOPY VARCHAR2);
53:
54: END wms_save_query_pvt;
55: