APPS.PSP_WF_ADJ_PKG dependencies on PSP_ADJUSTMENT_CONTROL_TABLE

Line 73: PSP_ADJUSTMENT_CONTROL_TABLE with the */

69: END get_approver_status;
70:
71: /**************************************************************************/
72: /*Procedure UPDATE_ADJUSTMENT_CONTROL_TABLE updated the table
73: PSP_ADJUSTMENT_CONTROL_TABLE with the */
74: /*approver's UserID. */
75: /**************************************************************************/
76: PROCEDURE update_adj_ctrl_table(p_batch_name IN VARCHAR2,
77: p_approver_userID IN NUMBER,

Line 82: UPDATE psp_adjustment_control_table

78: p_comments IN VARCHAR2,
79: return_code OUT NOCOPY NUMBER) IS
80: BEGIN
81:
82: UPDATE psp_adjustment_control_table
83: SET approver_id = p_approver_userID,
84: approval_date = SYSDATE, -- Added to fix bug 1661405. approval_date is a new column added to table
85: comments = p_comments
86: WHERE adjustment_batch_name = p_batch_name;

Line 467: ** user ID is recorded in table PSP_ADJUSTMENT_CONTROL_TABLE.

463:
464: /************************************************************************
465: ** Procedure RECORD_APPROVER is called by workflow activity "Record Approver".
466: ** When the distribution adjustment batch is approved, the approver's
467: ** user ID is recorded in table PSP_ADJUSTMENT_CONTROL_TABLE.
468: ************************************************************************/
469: PROCEDURE record_approver(itemtype IN VARCHAR2,
470: itemkey IN VARCHAR2,
471: actid IN NUMBER,