APPS.GMDOPLAP_WF_PKG dependencies on FND_PROFILE

Line 20: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));

16: l_itemkey WF_ITEMS.ITEM_KEY%TYPE := to_char(p_operation_id)||'-'||to_char(p_last_update_date,'dd-MON-yyyy HH24:mi:ss');
17: l_runform VARCHAR2(100);
18: l_performer_name FND_USER.USER_NAME%TYPE ;
19: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
20: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
21:
22: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
23: l_oprn_desc GMD_OPERATIONS.OPRN_DESC%TYPE;
24: l_oprn_class GMD_OPERATIONS.OPRN_CLASS%TYPE;

Line 161: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');

157: P_table_name VARCHAR2(32) := 'GMD_OPERATIONS_B'; -- Key Table
158: P_where_clause VARCHAR2(100):= ' GMD_OPERATIONS_B.OPRN_ID='||l_OPERATION_ID; -- Where clause to be appended
159: p_role GMA_ACTDATA_WF.ROLE%TYPE;
160: l_data_string VARCHAR2(2000);
161: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
162: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
163: BEGIN
164:
165: IF (p_funcmode = 'RUN') THEN