DBA Data[Home] [Help]

APPS.PO_PALT_ASSIGNMENT_WF dependencies on PO_WF_UTIL_PKG

Line 48: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,

44: WHERE assignment_id = pAssignmentId;
45:
46: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_username, l_user_display_name);
47:
48: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
49: aname => 'ASSIGNMENT_ID' , avalue => pAssignmentId );
50:
51: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
52: aname => 'ASSIGNMENT_NUMBER' , avalue => l_assignment_number);

Line 51: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

47:
48: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
49: aname => 'ASSIGNMENT_ID' , avalue => pAssignmentId );
50:
51: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
52: aname => 'ASSIGNMENT_NUMBER' , avalue => l_assignment_number);
53:
54: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
55: aname => 'ASSIGNED_TO_ID' , avalue => l_buyer_id );

Line 54: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,

50:
51: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
52: aname => 'ASSIGNMENT_NUMBER' , avalue => l_assignment_number);
53:
54: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
55: aname => 'ASSIGNED_TO_ID' , avalue => l_buyer_id );
56:
57: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
58: aname => 'ASSIGNED_TO_USER_NAME' , avalue => l_username );

Line 57: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

53:
54: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
55: aname => 'ASSIGNED_TO_ID' , avalue => l_buyer_id );
56:
57: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
58: aname => 'ASSIGNED_TO_USER_NAME' , avalue => l_username );
59:
60: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
61: aname => 'ASSIGNED_TO_DISP_NAME' , avalue => l_user_display_name );

Line 60: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

56:
57: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
58: aname => 'ASSIGNED_TO_USER_NAME' , avalue => l_username );
59:
60: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
61: aname => 'ASSIGNED_TO_DISP_NAME' , avalue => l_user_display_name );
62: -- set the view assignment page url
63: l_view_assign_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_CLM_VIEW_WLOAD_ASSIGNMENTS' || '&' || 'AssignmentNumber=' ||
64: l_assignment_number || '&' || 'retainAM=Y' || '&' || 'addBreadCrumb=Y' ;

Line 65: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

61: aname => 'ASSIGNED_TO_DISP_NAME' , avalue => l_user_display_name );
62: -- set the view assignment page url
63: l_view_assign_url := 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_CLM_VIEW_WLOAD_ASSIGNMENTS' || '&' || 'AssignmentNumber=' ||
64: l_assignment_number || '&' || 'retainAM=Y' || '&' || 'addBreadCrumb=Y' ;
65: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
66: aname => 'VIEW_ASSIGNMENT_URL' , avalue => l_view_assign_url );
67:
68: -- Setting Previous Buyer Info
69: IF(pPrevBuyerID <> -1) THEN

Line 72: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,

68: -- Setting Previous Buyer Info
69: IF(pPrevBuyerID <> -1) THEN
70: l_prev_buyer_id := pPrevBuyerID;
71: PO_REQAPPROVAL_INIT1.get_user_name(l_prev_buyer_id, l_prev_username, l_prev_user_display_name);
72: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
73: aname => 'REASSIGNED_FROM_ID' , avalue => l_prev_buyer_id );
74:
75: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
76: aname => 'REASSIGNED_FROM_USER_NAME' , avalue => l_prev_username );

Line 75: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

71: PO_REQAPPROVAL_INIT1.get_user_name(l_prev_buyer_id, l_prev_username, l_prev_user_display_name);
72: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
73: aname => 'REASSIGNED_FROM_ID' , avalue => l_prev_buyer_id );
74:
75: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
76: aname => 'REASSIGNED_FROM_USER_NAME' , avalue => l_prev_username );
77:
78: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
79: aname => 'REASSIGNED_FROM_DISP_NAME' , avalue => l_prev_user_display_name );

Line 78: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

74:
75: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
76: aname => 'REASSIGNED_FROM_USER_NAME' , avalue => l_prev_username );
77:
78: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
79: aname => 'REASSIGNED_FROM_DISP_NAME' , avalue => l_prev_user_display_name );
80: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
81: aname => 'ACTION_NAME' , avalue => 'reassigned' );
82: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

Line 80: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

76: aname => 'REASSIGNED_FROM_USER_NAME' , avalue => l_prev_username );
77:
78: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
79: aname => 'REASSIGNED_FROM_DISP_NAME' , avalue => l_prev_user_display_name );
80: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
81: aname => 'ACTION_NAME' , avalue => 'reassigned' );
82: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
83: aname => 'REASON' , avalue => pReason );
84: ELSE

Line 82: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

78: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
79: aname => 'REASSIGNED_FROM_DISP_NAME' , avalue => l_prev_user_display_name );
80: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
81: aname => 'ACTION_NAME' , avalue => 'reassigned' );
82: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
83: aname => 'REASON' , avalue => pReason );
84: ELSE
85: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
86: aname => 'ACTION_NAME' , avalue => 'assigned' );

Line 85: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

81: aname => 'ACTION_NAME' , avalue => 'reassigned' );
82: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
83: aname => 'REASON' , avalue => pReason );
84: ELSE
85: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
86: aname => 'ACTION_NAME' , avalue => 'assigned' );
87: END IF;
88:
89: SELECT employee_id INTO l_employee_id

Line 96: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,

92:
93: IF l_employee_id IS NOT NULL AND l_employee_id <> -1 THEN
94: PO_REQAPPROVAL_INIT1.get_user_name(l_employee_id, l_from_username, l_from_user_disp_name);
95:
96: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
97: aname => 'ASSIGNED_FROM_ID' , avalue => l_employee_id );
98:
99: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
100: aname => 'ASSIGNED_FROM_USER_NAME' , avalue => l_from_username );

Line 99: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

95:
96: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
97: aname => 'ASSIGNED_FROM_ID' , avalue => l_employee_id );
98:
99: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
100: aname => 'ASSIGNED_FROM_USER_NAME' , avalue => l_from_username );
101:
102: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
103: aname => 'ASSIGNED_FROM_DISP_NAME' , avalue => l_from_user_disp_name );

Line 102: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

98:
99: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
100: aname => 'ASSIGNED_FROM_USER_NAME' , avalue => l_from_username );
101:
102: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
103: aname => 'ASSIGNED_FROM_DISP_NAME' , avalue => l_from_user_disp_name );
104:
105: END IF;
106:

Line 119: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,

115: GL_SETS_OF_BOOKS GSB
116: WHERE FSP.set_of_books_id = GSB.set_of_books_id
117: AND FSP.org_id=l_curr_org_id;
118:
119: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
120: aname => 'FUNCTIONAL_CURRENCY' , avalue => l_func_curr );
121:
122: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
123: aname => 'ESTIMATED_COMPLETION_DAYS' , avalue => l_est_comp_days );

Line 122: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,

118:
119: PO_WF_UTIL_PKG.SetItemAttrText( itemtype => l_itemtype , itemkey => l_itemkey ,
120: aname => 'FUNCTIONAL_CURRENCY' , avalue => l_func_curr );
121:
122: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
123: aname => 'ESTIMATED_COMPLETION_DAYS' , avalue => l_est_comp_days );
124:
125: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
126: aname => 'MILESTONE_TEMPLATE_ID' , avalue => l_ms_temp_id );

Line 125: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,

121:
122: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
123: aname => 'ESTIMATED_COMPLETION_DAYS' , avalue => l_est_comp_days );
124:
125: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
126: aname => 'MILESTONE_TEMPLATE_ID' , avalue => l_ms_temp_id );
127:
128: PO_WF_UTIL_PKG.SetItemAttrDate( itemtype => l_itemtype , itemkey => l_itemkey ,
129: aname => 'ASSIGNMENT_START_DATE' , avalue => l_start_date );

Line 128: PO_WF_UTIL_PKG.SetItemAttrDate( itemtype => l_itemtype , itemkey => l_itemkey ,

124:
125: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => l_itemtype , itemkey => l_itemkey ,
126: aname => 'MILESTONE_TEMPLATE_ID' , avalue => l_ms_temp_id );
127:
128: PO_WF_UTIL_PKG.SetItemAttrDate( itemtype => l_itemtype , itemkey => l_itemkey ,
129: aname => 'ASSIGNMENT_START_DATE' , avalue => l_start_date );
130:
131: wf_engine.StartProcess( ItemType => l_itemtype, ItemKey => l_itemkey);
132: