6: g_package_name CONSTANT VARCHAR2(30) := 'POS_SPM_WF_PKG1';
7:
8: g_log_module CONSTANT VARCHAR2(30) := 'POSSPM1B';
9:
10: g_supplier_function_name CONSTANT fnd_form_functions.function_name%TYPE := 'POS_HT_SP_S_SUP_DET';
11:
12: g_new_line CONSTANT VARCHAR2(1) := '
13: ';
14:
14:
15: FUNCTION get_function_id (p_function_name IN VARCHAR2) RETURN NUMBER IS
16: CURSOR l_cur IS
17: SELECT function_id
18: FROM fnd_form_functions
19: WHERE function_name = p_function_name;
20: l_function_id NUMBER;
21: BEGIN
22: OPEN l_cur;