APPS.AMS_TCOP_SCHEDULER_PKG dependencies on AMS_TCOP_REQUESTS

Line 40: AMS_TCOP_REQUESTS_S.nextval

36:
37: cursor c_get_seq
38: is
39: select
40: AMS_TCOP_REQUESTS_S.nextval
41: from dual;
42:
43: l_request_id number;
44: BEGIN

Line 52: INSERT INTO AMS_TCOP_REQUESTS

48: fetch c_get_seq into l_request_id;
49: close c_get_seq;
50:
51: -- Insert the request with the request_status= 'NEW'
52: INSERT INTO AMS_TCOP_REQUESTS
53: (
54: REQUEST_ID,
55: SCHEDULE_ID,
56: REQUEST_DATE,

Line 97: FROM AMS_TCOP_REQUESTS

93: IS
94: CURSOR C_GET_REQ_STATUS (p_schedule_id NUMBER)
95: IS
96: SELECT STATUS
97: FROM AMS_TCOP_REQUESTS
98: WHERE SCHEDULE_ID = p_schedule_id;
99:
100: l_status VARCHAR2(30);
101:

Line 126: FROM AMS_TCOP_REQUESTS TCOP,WF_ITEMS WF

122: IS
123: SELECT TCOP.WF_ITEM_TYPE WF_ITEM_TYPE,
124: TCOP.WF_ITEM_ID WF_ITEM_ID,
125: TCOP.SCHEDULE_ID SCHEDULE_ID
126: FROM AMS_TCOP_REQUESTS TCOP,WF_ITEMS WF
127: WHERE TCOP.STATUS='NEW'
128: and TCOP.WF_ITEM_ID=WF.ITEM_KEY
129: ORDER BY TCOP.REQUEST_DATE; --first come,first serve
130:

Line 163: UPDATE AMS_TCOP_REQUESTS

159: )
160: IS
161: BEGIN
162:
163: UPDATE AMS_TCOP_REQUESTS
164: SET STATUS = p_status
165: WHERE schedule_id=p_schedule_id;
166:
167: END UPDATE_STATUS;