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 4: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,

1: PACKAGE BODY wms_save_query_pvt AS
2: /* $Header: WMSVSQRB.pls 115.3 2003/01/15 19:18:18 piwong noship $ */
3:
4: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
5: p_query_name wms_saved_queries.query_name%TYPE,
6: p_org_id wms_saved_queries.organization_id%TYPE,
7: p_user_id wms_saved_queries.user_id%TYPE,
8: p_login_id wms_saved_queries.last_update_login%TYPE,

Line 5: p_query_name wms_saved_queries.query_name%TYPE,

1: PACKAGE BODY wms_save_query_pvt AS
2: /* $Header: WMSVSQRB.pls 115.3 2003/01/15 19:18:18 piwong noship $ */
3:
4: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
5: p_query_name wms_saved_queries.query_name%TYPE,
6: p_org_id wms_saved_queries.organization_id%TYPE,
7: p_user_id wms_saved_queries.user_id%TYPE,
8: p_login_id wms_saved_queries.last_update_login%TYPE,
9: p_table save_query_table,

Line 6: p_org_id wms_saved_queries.organization_id%TYPE,

2: /* $Header: WMSVSQRB.pls 115.3 2003/01/15 19:18:18 piwong noship $ */
3:
4: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
5: p_query_name wms_saved_queries.query_name%TYPE,
6: p_org_id wms_saved_queries.organization_id%TYPE,
7: p_user_id wms_saved_queries.user_id%TYPE,
8: p_login_id wms_saved_queries.last_update_login%TYPE,
9: p_table save_query_table,
10: x_return_status OUT NOCOPY varchar2)

Line 7: p_user_id wms_saved_queries.user_id%TYPE,

3:
4: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
5: p_query_name wms_saved_queries.query_name%TYPE,
6: p_org_id wms_saved_queries.organization_id%TYPE,
7: p_user_id wms_saved_queries.user_id%TYPE,
8: p_login_id wms_saved_queries.last_update_login%TYPE,
9: p_table save_query_table,
10: x_return_status OUT NOCOPY varchar2)
11: IS

Line 8: p_login_id wms_saved_queries.last_update_login%TYPE,

4: PROCEDURE insert_query_row(p_query_type wms_saved_queries.query_type%TYPE,
5: p_query_name wms_saved_queries.query_name%TYPE,
6: p_org_id wms_saved_queries.organization_id%TYPE,
7: p_user_id wms_saved_queries.user_id%TYPE,
8: p_login_id wms_saved_queries.last_update_login%TYPE,
9: p_table save_query_table,
10: x_return_status OUT NOCOPY varchar2)
11: IS
12: l_user_id NUMBER(15);

Line 20: INSERT INTO wms_saved_queries

16: x_return_status := 'S';
17: l_sysdate := SYSDATE;
18:
19: FOR i IN p_table.first..p_table.last LOOP
20: INSERT INTO wms_saved_queries
21: (query_type,
22: query_name,
23: field_name,
24: field_type,

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

51: WHEN OTHERS THEN
52: x_return_status := 'U';
53: END insert_query_row;
54:
55: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
56: p_query_name wms_saved_queries.query_name%TYPE,
57: p_org_id wms_saved_queries.organization_id%TYPE,
58: p_user_id wms_saved_queries.user_id%TYPE,
59: p_login_id wms_saved_queries.last_update_login%TYPE,

Line 56: p_query_name wms_saved_queries.query_name%TYPE,

52: x_return_status := 'U';
53: END insert_query_row;
54:
55: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
56: p_query_name wms_saved_queries.query_name%TYPE,
57: p_org_id wms_saved_queries.organization_id%TYPE,
58: p_user_id wms_saved_queries.user_id%TYPE,
59: p_login_id wms_saved_queries.last_update_login%TYPE,
60: p_table save_query_table,

Line 57: p_org_id wms_saved_queries.organization_id%TYPE,

53: END insert_query_row;
54:
55: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
56: p_query_name wms_saved_queries.query_name%TYPE,
57: p_org_id wms_saved_queries.organization_id%TYPE,
58: p_user_id wms_saved_queries.user_id%TYPE,
59: p_login_id wms_saved_queries.last_update_login%TYPE,
60: p_table save_query_table,
61: x_return_status OUT NOCOPY varchar2) IS

Line 58: p_user_id wms_saved_queries.user_id%TYPE,

54:
55: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
56: p_query_name wms_saved_queries.query_name%TYPE,
57: p_org_id wms_saved_queries.organization_id%TYPE,
58: p_user_id wms_saved_queries.user_id%TYPE,
59: p_login_id wms_saved_queries.last_update_login%TYPE,
60: p_table save_query_table,
61: x_return_status OUT NOCOPY varchar2) IS
62: BEGIN

Line 59: p_login_id wms_saved_queries.last_update_login%TYPE,

55: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
56: p_query_name wms_saved_queries.query_name%TYPE,
57: p_org_id wms_saved_queries.organization_id%TYPE,
58: p_user_id wms_saved_queries.user_id%TYPE,
59: p_login_id wms_saved_queries.last_update_login%TYPE,
60: p_table save_query_table,
61: x_return_status OUT NOCOPY varchar2) IS
62: BEGIN
63: x_return_status := 'S';

Line 66: UPDATE wms_saved_queries

62: BEGIN
63: x_return_status := 'S';
64:
65: FOR i IN p_table.first..p_table.last LOOP
66: UPDATE wms_saved_queries
67: SET field_value = p_table(i).field_value,
68: field_type = p_table(i).field_type
69: WHERE query_type = p_query_type
70: and query_name = p_query_name

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

78: WHEN OTHERS THEN
79: x_return_status := 'U';
80: END;
81:
82: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
83: p_query_name wms_saved_queries.query_name%TYPE,
84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,

Line 83: p_query_name wms_saved_queries.query_name%TYPE,

79: x_return_status := 'U';
80: END;
81:
82: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
83: p_query_name wms_saved_queries.query_name%TYPE,
84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,
87: p_org_id wms_saved_queries.organization_id%TYPE,

Line 84: p_field_name wms_saved_queries.field_name%TYPE,

80: END;
81:
82: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
83: p_query_name wms_saved_queries.query_name%TYPE,
84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,
87: p_org_id wms_saved_queries.organization_id%TYPE,
88: p_user_id wms_saved_queries.user_id%TYPE,

Line 85: p_field_value wms_saved_queries.field_value%TYPE,

81:
82: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
83: p_query_name wms_saved_queries.query_name%TYPE,
84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,
87: p_org_id wms_saved_queries.organization_id%TYPE,
88: p_user_id wms_saved_queries.user_id%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2)

Line 86: p_field_type wms_saved_queries.field_type%TYPE,

82: PROCEDURE update_query_row(p_query_type wms_saved_queries.query_type%TYPE,
83: p_query_name wms_saved_queries.query_name%TYPE,
84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,
87: p_org_id wms_saved_queries.organization_id%TYPE,
88: p_user_id wms_saved_queries.user_id%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2)
90: IS

Line 87: p_org_id wms_saved_queries.organization_id%TYPE,

83: p_query_name wms_saved_queries.query_name%TYPE,
84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,
87: p_org_id wms_saved_queries.organization_id%TYPE,
88: p_user_id wms_saved_queries.user_id%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2)
90: IS
91: BEGIN

Line 88: p_user_id wms_saved_queries.user_id%TYPE,

84: p_field_name wms_saved_queries.field_name%TYPE,
85: p_field_value wms_saved_queries.field_value%TYPE,
86: p_field_type wms_saved_queries.field_type%TYPE,
87: p_org_id wms_saved_queries.organization_id%TYPE,
88: p_user_id wms_saved_queries.user_id%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2)
90: IS
91: BEGIN
92: x_return_status := 'S';

Line 94: UPDATE WMS_SAVED_QUERIES

90: IS
91: BEGIN
92: x_return_status := 'S';
93:
94: UPDATE WMS_SAVED_QUERIES
95: SET field_value = p_field_value, field_type = p_field_type
96: WHERE query_type = p_query_type
97: and query_name = p_query_name
98: and field_name = p_field_name

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

105: x_return_status := 'U';
106:
107: END update_query_row;
108:
109: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
110: p_query_name wms_saved_queries.query_name%TYPE,
111: p_field_name wms_saved_queries.field_name%TYPE,
112: p_org_id wms_saved_queries.organization_id%TYPE,
113: p_user_id wms_saved_queries.user_id%TYPE,

Line 110: p_query_name wms_saved_queries.query_name%TYPE,

106:
107: END update_query_row;
108:
109: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
110: p_query_name wms_saved_queries.query_name%TYPE,
111: p_field_name wms_saved_queries.field_name%TYPE,
112: p_org_id wms_saved_queries.organization_id%TYPE,
113: p_user_id wms_saved_queries.user_id%TYPE,
114: x_return_status OUT NOCOPY VARCHAR2)

Line 111: p_field_name wms_saved_queries.field_name%TYPE,

107: END update_query_row;
108:
109: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
110: p_query_name wms_saved_queries.query_name%TYPE,
111: p_field_name wms_saved_queries.field_name%TYPE,
112: p_org_id wms_saved_queries.organization_id%TYPE,
113: p_user_id wms_saved_queries.user_id%TYPE,
114: x_return_status OUT NOCOPY VARCHAR2)
115: IS

Line 112: p_org_id wms_saved_queries.organization_id%TYPE,

108:
109: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
110: p_query_name wms_saved_queries.query_name%TYPE,
111: p_field_name wms_saved_queries.field_name%TYPE,
112: p_org_id wms_saved_queries.organization_id%TYPE,
113: p_user_id wms_saved_queries.user_id%TYPE,
114: x_return_status OUT NOCOPY VARCHAR2)
115: IS
116: BEGIN

Line 113: p_user_id wms_saved_queries.user_id%TYPE,

109: PROCEDURE delete_query_row(p_query_type wms_saved_queries.query_type%TYPE,
110: p_query_name wms_saved_queries.query_name%TYPE,
111: p_field_name wms_saved_queries.field_name%TYPE,
112: p_org_id wms_saved_queries.organization_id%TYPE,
113: p_user_id wms_saved_queries.user_id%TYPE,
114: x_return_status OUT NOCOPY VARCHAR2)
115: IS
116: BEGIN
117: x_return_status := 'S';

Line 120: FROM WMS_SAVED_QUERIES

116: BEGIN
117: x_return_status := 'S';
118:
119: DELETE
120: FROM WMS_SAVED_QUERIES
121: WHERE query_type = p_query_type
122: and query_name = p_query_name
123: and field_name = p_field_name
124: AND organization_id = p_org_id

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

130: x_return_status := 'U';
131:
132: END delete_query_row;
133:
134: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
135: p_query_name wms_saved_queries.query_name%TYPE,
136: p_org_id wms_saved_queries.organization_id%TYPE,
137: p_user_id wms_saved_queries.user_id%TYPE,
138: x_return_status OUT NOCOPY VARCHAR2)

Line 135: p_query_name wms_saved_queries.query_name%TYPE,

131:
132: END delete_query_row;
133:
134: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
135: p_query_name wms_saved_queries.query_name%TYPE,
136: p_org_id wms_saved_queries.organization_id%TYPE,
137: p_user_id wms_saved_queries.user_id%TYPE,
138: x_return_status OUT NOCOPY VARCHAR2)
139: IS

Line 136: p_org_id wms_saved_queries.organization_id%TYPE,

132: END delete_query_row;
133:
134: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
135: p_query_name wms_saved_queries.query_name%TYPE,
136: p_org_id wms_saved_queries.organization_id%TYPE,
137: p_user_id wms_saved_queries.user_id%TYPE,
138: x_return_status OUT NOCOPY VARCHAR2)
139: IS
140: BEGIN

Line 137: p_user_id wms_saved_queries.user_id%TYPE,

133:
134: PROCEDURE delete_query(p_query_type wms_saved_queries.query_type%TYPE,
135: p_query_name wms_saved_queries.query_name%TYPE,
136: p_org_id wms_saved_queries.organization_id%TYPE,
137: p_user_id wms_saved_queries.user_id%TYPE,
138: x_return_status OUT NOCOPY VARCHAR2)
139: IS
140: BEGIN
141: x_return_status := 'S';

Line 144: FROM WMS_SAVED_QUERIES

140: BEGIN
141: x_return_status := 'S';
142:
143: DELETE
144: FROM WMS_SAVED_QUERIES
145: WHERE query_type = p_query_type
146: and query_name = p_query_name
147: AND organization_id = p_org_id
148: AND user_id = p_user_id;