APPS.PO_PALT_ASSIGNMENTS dependencies on PO_CLM_ASSIGNMENTS

Line 33: FROM PO_CLM_ASSIGNMENTS

29: l_Assignment_Number := po_palt_assignments_hook.AssignmentNumberCustHook(l_Requisition_Details);
30: IF (l_Assignment_Number is not NULL) THEN
31: SELECT count(*)
32: INTO l_Assignment_count
33: FROM PO_CLM_ASSIGNMENTS
34: WHERE ASSIGNMENT_NUMBER = l_Assignment_Number;
35:
36: IF (l_Assignment_count > 0) THEN
37: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;

Line 75: FROM PO_CLM_ASSIGNMENTS

71: and ACTION_END_DATE is NULL;
72:
73: SELECT ASSIGNMENT_NUMBER
74: INTO l_Assignment_Number
75: FROM PO_CLM_ASSIGNMENTS
76: WHERE ASSIGNMENT_ID = pAssignmentId;
77:
78: SELECT EMPLOYEE_ID
79: INTO l_Action_Taken_By

Line 171: UPDATE PO_CLM_ASSIGNMENTS

167:
168: IF (pOldStatus <> pNewStatus) THEN
169: IF (pNewStatus = 2 or pNewStatus = 3) THEN /*Suspend or Cancel*/
170:
171: UPDATE PO_CLM_ASSIGNMENTS
172: SET ASSIGNMENT_STATUS = pNewStatus ,
173: last_updated_by = fnd_global.user_id,
174: last_update_date = SYSDATE ,
175: last_update_login = fnd_global.login_id

Line 193: UPDATE PO_CLM_ASSIGNMENTS

189: END IF;
190:
191: ELSIF (pNewStatus = 5) THEN
192:
193: UPDATE PO_CLM_ASSIGNMENTS
194: SET ASSIGNMENT_STATUS = pNewStatus ,
195: last_updated_by = fnd_global.user_id,
196: last_update_date = SYSDATE ,
197: last_update_login = fnd_global.login_id,

Line 211: UPDATE PO_CLM_ASSIGNMENTS

207: AND ACTUAL_COMPLETION_DATE IS NULL;
208:
209: ELSIF (pNewStatus = 6) THEN
210:
211: UPDATE PO_CLM_ASSIGNMENTS
212: SET ASSIGNMENT_STATUS = 1 ,
213: last_updated_by = fnd_global.user_id,
214: last_update_date = SYSDATE ,
215: last_update_login = fnd_global.login_id

Line 309: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS dtls, PO_CLM_ASSIGNMENTS ca

305:
306: FOR i IN 1..pAssignmentNums.Count LOOP
307:
308: SELECT Count(*) INTO l_cnt
309: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS dtls, PO_CLM_ASSIGNMENTS ca
310: WHERE ca.ASSIGNMENT_NUMBER = pAssignmentNums(i)
311: AND ca.ASSIGNMENT_ID = dtls.ASSIGNMENT_ID
312: AND dtls.ACTUAL_COMPLETION_DATE IS NOT NULL;
313:

Line 464: FROM PO_CLM_ASSIGNMENTS

460: BEGIN
461:
462: SELECT ASSIGNMENT_NUMBER
463: INTO l_Assignment_Number
464: FROM PO_CLM_ASSIGNMENTS
465: WHERE ASSIGNMENT_ID = pAssignmentId;
466:
467: UPDATE PO_REQUISITION_LINES_ALL
468: SET SUGGESTED_BUYER_ID = pnewBuyerId,

Line 512: INSERT INTO po_clm_assignments (assignment_id,

508: -- If assignment number from hook is null, then create new assignment
509: IF l_assignment_number IS NULL THEN
510: l_assignment_number := PO_CLM_ASSIGNMENT_SEQUENCE.NEXTVAL;
511:
512: INSERT INTO po_clm_assignments (assignment_id,
513: assignment_number,
514: created_by,
515: creation_date,
516: last_updated_by,