66: l_TABLEALIAS varchar2(20);
67: l_OUTPUT varchar2(20);
68: l_NumOf_Bind_Vars_Assy Number :=0;
69: l_NumOf_Bind_Vars_Cat Number :=0;
70: l_bind_variables_tab_assy fnd_flex_xml_publisher_apis.bind_variables;
71: l_bind_variables_tab_cat fnd_flex_xml_publisher_apis.bind_variables;
72: l_idFlexNum number ;
73: P_ASSY_WHERE Varchar2(2000) := '';
74: P_CAT_WHERE Varchar2(2000) := '';
67: l_OUTPUT varchar2(20);
68: l_NumOf_Bind_Vars_Assy Number :=0;
69: l_NumOf_Bind_Vars_Cat Number :=0;
70: l_bind_variables_tab_assy fnd_flex_xml_publisher_apis.bind_variables;
71: l_bind_variables_tab_cat fnd_flex_xml_publisher_apis.bind_variables;
72: l_idFlexNum number ;
73: P_ASSY_WHERE Varchar2(2000) := '';
74: P_CAT_WHERE Varchar2(2000) := '';
75:
122: l_OUTPUT := 'P_ASS_BETWEEN';
123: l_TABLEALIAS := 'MSI';
124: END IF;
125:
126: FND_FLEX_XML_PUBLISHER_APIS.KFF_WHERE
127: (P_LEXICAL_NAME => l_OUTPUT
128: ,P_APPLICATION_SHORT_NAME => l_APPL_SHORT_NAME
129: ,P_ID_FLEX_CODE => l_CODE
130: ,P_ID_FLEX_NUM => l_idFlexNuM
174: l_TABLEALIAS := 'MC';
175: END IF;
176:
177:
178: FND_FLEX_XML_PUBLISHER_APIS.KFF_WHERE
179: (P_LEXICAL_NAME => l_OUTPUT
180: ,P_APPLICATION_SHORT_NAME => l_APPL_SHORT_NAME
181: ,P_ID_FLEX_CODE => l_CODE
182: ,P_ID_FLEX_NUM => l_idFlexNuM