APPS.PO_PALT_ASSIGNMENT_WF dependencies on PO_CLM_ASSIGNMENTS

Line 30: l_est_comp_days PO_CLM_ASSIGNMENTS.estimated_completion_days%TYPE;

26: l_curr_org_id NUMBER;
27:
28: l_view_assign_url VARCHAR2(240);
29:
30: l_est_comp_days PO_CLM_ASSIGNMENTS.estimated_completion_days%TYPE;
31: l_start_date PO_CLM_ASSIGNMENTS.assignment_start_date%TYPE;
32: l_ms_temp_id PO_CLM_ASSIGNMENTS.milestone_template_id%TYPE;
33: l_assignment_number PO_CLM_ASSIGNMENTS.assignment_number%TYPE;
34:

Line 31: l_start_date PO_CLM_ASSIGNMENTS.assignment_start_date%TYPE;

27:
28: l_view_assign_url VARCHAR2(240);
29:
30: l_est_comp_days PO_CLM_ASSIGNMENTS.estimated_completion_days%TYPE;
31: l_start_date PO_CLM_ASSIGNMENTS.assignment_start_date%TYPE;
32: l_ms_temp_id PO_CLM_ASSIGNMENTS.milestone_template_id%TYPE;
33: l_assignment_number PO_CLM_ASSIGNMENTS.assignment_number%TYPE;
34:
35: BEGIN

Line 32: l_ms_temp_id PO_CLM_ASSIGNMENTS.milestone_template_id%TYPE;

28: l_view_assign_url VARCHAR2(240);
29:
30: l_est_comp_days PO_CLM_ASSIGNMENTS.estimated_completion_days%TYPE;
31: l_start_date PO_CLM_ASSIGNMENTS.assignment_start_date%TYPE;
32: l_ms_temp_id PO_CLM_ASSIGNMENTS.milestone_template_id%TYPE;
33: l_assignment_number PO_CLM_ASSIGNMENTS.assignment_number%TYPE;
34:
35: BEGIN
36: SELECT PO_PALT_WF_ITEMKEY_S.NEXTVAL INTO l_seq_for_item_key FROM sys.dual;

Line 33: l_assignment_number PO_CLM_ASSIGNMENTS.assignment_number%TYPE;

29:
30: l_est_comp_days PO_CLM_ASSIGNMENTS.estimated_completion_days%TYPE;
31: l_start_date PO_CLM_ASSIGNMENTS.assignment_start_date%TYPE;
32: l_ms_temp_id PO_CLM_ASSIGNMENTS.milestone_template_id%TYPE;
33: l_assignment_number PO_CLM_ASSIGNMENTS.assignment_number%TYPE;
34:
35: BEGIN
36: SELECT PO_PALT_WF_ITEMKEY_S.NEXTVAL INTO l_seq_for_item_key FROM sys.dual;
37: l_itemkey := To_Char(pAssignmentId) || '-' || l_seq_for_item_key;

Line 43: FROM po_clm_assignments

39: wf_engine.CreateProcess( ItemType => l_itemtype, ItemKey => l_itemkey, process => l_workflow_process );
40:
41: SELECT assignment_number, buyer_id, estimated_completion_days, assignment_start_date ,milestone_template_id
42: INTO l_assignment_number, l_buyer_id, l_est_comp_days, l_start_date, l_ms_temp_id
43: FROM po_clm_assignments
44: WHERE assignment_id = pAssignmentId;
45:
46: PO_REQAPPROVAL_INIT1.get_user_name(l_buyer_id, l_username, l_user_display_name);
47: