DBA Data[Home] [Help]

APPS.FEM_FEMAPPR_ITEM_TYPE dependencies on FEM_WF_REQUEST_ID_SEQ

Line 155: select fem_wf_request_id_seq.NEXTVAL

151: l_wf_request_id number;
152:
153: BEGIN
154:
155: select fem_wf_request_id_seq.NEXTVAL
156: into l_wf_request_id
157: from dual;
158:
159: insert into fem_wf_requests (

Line 195: -- p_request_id - Workflow Request Id (FEM_WF_REQUEST_ID_SEQ)

191: -- PL/SQL API for Raising any FEM Business Events
192: --
193: -- IN
194: -- p_event_name - Business Event Name
195: -- p_request_id - Workflow Request Id (FEM_WF_REQUEST_ID_SEQ)
196: -- p_user_id - FND User ID
197: -- p_user_name - FND User Name
198: -- p_responsibility_id - FND Responsibility ID
199: -- p_application_id - FND Application ID

Line 255: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

251: -- Initializes the all the item attributes of an FEM Approvals Workflow.
252: --
253: -- IN
254: -- p_item_type - The workflow item type (FEMAPPR)
255: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
256: -- p_act_id - The function activity
257: -- p_func_mode - Run/Cancel/Timeout
258: --
259: -- OUT

Line 356: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

352: -- Checks to see if this approval request contains approval items.
353: --
354: -- IN
355: -- p_item_type - The workflow item type (FEMAPPR)
356: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
357: -- p_act_id - The function activity
358: -- p_func_mode - Run/Cancel/Timeout
359: --
360: -- OUT

Line 448: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

444: -- Initializes all the approval items.
445: --
446: -- IN
447: -- p_item_type - The workflow item type (FEMAPPR)
448: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
449: -- p_act_id - The function activity
450: -- p_func_mode - Run/Cancel/Timeout
451: --
452: -- OUT

Line 539: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

535: -- Gets the next approver for the approval request.
536: --
537: -- IN
538: -- p_item_type - The workflow item type (FEMAPPR)
539: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
540: -- p_act_id - The function activity
541: -- p_func_mode - Run/Cancel/Timeout
542: --
543: -- OUT

Line 705: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

701: -- approver.
702: --
703: -- IN
704: -- p_item_type - The workflow item type (FEMAPPR)
705: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
706: -- p_act_id - The function activity
707: -- p_func_mode - Run/Cancel/Timeout
708: --
709: -- OUT

Line 770: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

766: -- approver.
767: --
768: -- IN
769: -- p_item_type - The workflow item type (FEMAPPR)
770: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
771: -- p_act_id - The function activity
772: -- p_func_mode - Run/Cancel/Timeout
773: --
774: -- OUT

Line 835: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

831: -- current approver.
832: --
833: -- IN
834: -- p_item_type - The workflow item type (FEMAPPR)
835: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
836: -- p_act_id - The function activity
837: -- p_func_mode - Run/Cancel/Timeout
838: --
839: -- OUT

Line 899: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

895: -- Notification Handler for FEM_APPROVAL_REQ_NTF.
896: --
897: -- IN
898: -- p_item_type - The workflow item type (FEMAPPR)
899: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
900: -- p_act_id - The function activity
901: -- p_func_mode - Run/Cancel/Timeout
902: --
903: -- OUT

Line 1120: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1116: -- Sets the approval items to the submitted state.
1117: --
1118: -- IN
1119: -- p_item_type - The workflow item type (FEMAPPR)
1120: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1121: -- p_act_id - The function activity
1122: -- p_func_mode - Run/Cancel/Timeout
1123: --
1124: -- OUT

Line 1211: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1207: -- Sets the approval items to the approved state.
1208: --
1209: -- IN
1210: -- p_item_type - The workflow item type (FEMAPPR)
1211: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1212: -- p_act_id - The function activity
1213: -- p_func_mode - Run/Cancel/Timeout
1214: --
1215: -- OUT

Line 1310: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1306: -- Sets the approval items to the rejected state.
1307: --
1308: -- IN
1309: -- p_item_type - The workflow item type (FEMAPPR)
1310: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1311: -- p_act_id - The function activity
1312: -- p_func_mode - Run/Cancel/Timeout
1313: --
1314: -- OUT

Line 1401: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1397: -- Handles the case when SetApprovedState fails.
1398: --
1399: -- IN
1400: -- p_item_type - The workflow item type (FEMAPPR)
1401: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1402: -- p_act_id - The function activity
1403: -- p_func_mode - Run/Cancel/Timeout
1404: --
1405: -- OUT

Line 1467: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1463: -- Finalizes the approval request.
1464: --
1465: -- IN
1466: -- p_item_type - The workflow item type (FEMAPPR)
1467: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1468: -- p_act_id - The function activity
1469: -- p_func_mode - Run/Cancel/Timeout
1470: --
1471: -- OUT

Line 1532: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1528: -- Callback function.
1529: --
1530: -- IN
1531: -- p_item_type - The workflow item type (FEMAPPR)
1532: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1533: -- p_act_id - The function activity
1534: -- p_func_mode - Run/Cancel/Timeout
1535: --
1536: -- OUT

Line 1650: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1646: -- Update the approval request with the responses from the approver.
1647: --
1648: -- IN
1649: -- p_item_type - The workflow item type (FEMAPPR)
1650: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1651: -- p_approval_status - AME Approval Status
1652: --
1653: --------------------------------------------------------------------------------
1654: PROCEDURE UpdateApproval (

Line 1807: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1803: -- Internal implementation for initializing an FEM Approvals Workflow.
1804: --
1805: -- IN
1806: -- p_item_type - The workflow item type (FEMAPPR)
1807: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1808: --
1809: --------------------------------------------------------------------------------
1810: PROCEDURE InitApprovalRequestInternal (
1811: p_item_type in varchar2,

Line 1951: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)

1947: --
1948: -- IN
1949: -- p_api_name - The PL/SQL Procedure or Function name.
1950: -- p_item_type - The workflow item type (FEMAPPR)
1951: -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
1952: -- p_act_id - The function activity
1953: --
1954: --------------------------------------------------------------------------------
1955: PROCEDURE BuildErrorMsg (