DBA Data[Home] [Help]

APPS.PO_PALT_ASSIGNMENTS dependencies on PO_TBL_VARCHAR30

Line 278: PROCEDURE removeLinesFromAssignments(pAssignmentNums IN PO_TBL_VARCHAR30

274: WHEN No_Data_Found THEN
275: x_associated_line_ids :=NULL;
276: END getAssociatedReqLines;
277:
278: PROCEDURE removeLinesFromAssignments(pAssignmentNums IN PO_TBL_VARCHAR30
279: ,pLineIds IN PO_TBL_VARCHAR30
280: ,xReturnStatus OUT NOCOPY VARCHAR2
281: ,xErrAssigmentNums OUT NOCOPY PO_TBL_VARCHAR30)
282: IS

Line 279: ,pLineIds IN PO_TBL_VARCHAR30

275: x_associated_line_ids :=NULL;
276: END getAssociatedReqLines;
277:
278: PROCEDURE removeLinesFromAssignments(pAssignmentNums IN PO_TBL_VARCHAR30
279: ,pLineIds IN PO_TBL_VARCHAR30
280: ,xReturnStatus OUT NOCOPY VARCHAR2
281: ,xErrAssigmentNums OUT NOCOPY PO_TBL_VARCHAR30)
282: IS
283: l_cnt NUMBER;

Line 281: ,xErrAssigmentNums OUT NOCOPY PO_TBL_VARCHAR30)

277:
278: PROCEDURE removeLinesFromAssignments(pAssignmentNums IN PO_TBL_VARCHAR30
279: ,pLineIds IN PO_TBL_VARCHAR30
280: ,xReturnStatus OUT NOCOPY VARCHAR2
281: ,xErrAssigmentNums OUT NOCOPY PO_TBL_VARCHAR30)
282: IS
283: l_cnt NUMBER;
284: err_ids_cnt NUMBER:=0;
285: l_req_line_ids_str VARCHAR2(1000):='';

Line 341: xErrAssigmentNums := PO_TBL_VARCHAR30();

337: ELSE
338: --For this assignment, few/all milestones are completed.
339: --So we cannot unassign the lines
340: IF xErrAssigmentNums IS NULL THEN
341: xErrAssigmentNums := PO_TBL_VARCHAR30();
342: xReturnStatus := 'U';
343: END IF;
344: err_ids_cnt := err_ids_cnt+1;
345: xErrAssigmentNums.extend(1);