APPS.FV_GTAS_AGENCY_ID_UPGRADE dependencies on FV_SYSTEM_PARAMETERS

Line 76: l_gtas_cust_attribute fv_system_parameters.gtas_customer_attribute%TYPE;

72: TYPE aid_select_cur IS REF CURSOR;
73: c_aid_select aid_select_cur;
74: l_cust_col_exists varchar2(1) := 'N';
75: l_blank_line VARCHAR2(1) := ' ';
76: l_gtas_cust_attribute fv_system_parameters.gtas_customer_attribute%TYPE;
77: l_facts1_cust_attribute fv_system_parameters.factsI_customer_attribute%TYPE;
78: l_facts1_vend_attribute fv_system_parameters.gtas_customer_attribute%TYPE;
79: NO_GTAS_ATTR_COL_FOUND EXCEPTION;
80: NO_FACTS1_ATTR_COL_FOUND EXCEPTION;

Line 77: l_facts1_cust_attribute fv_system_parameters.factsI_customer_attribute%TYPE;

73: c_aid_select aid_select_cur;
74: l_cust_col_exists varchar2(1) := 'N';
75: l_blank_line VARCHAR2(1) := ' ';
76: l_gtas_cust_attribute fv_system_parameters.gtas_customer_attribute%TYPE;
77: l_facts1_cust_attribute fv_system_parameters.factsI_customer_attribute%TYPE;
78: l_facts1_vend_attribute fv_system_parameters.gtas_customer_attribute%TYPE;
79: NO_GTAS_ATTR_COL_FOUND EXCEPTION;
80: NO_FACTS1_ATTR_COL_FOUND EXCEPTION;
81: l_col_select varchar2(5000);

Line 78: l_facts1_vend_attribute fv_system_parameters.gtas_customer_attribute%TYPE;

74: l_cust_col_exists varchar2(1) := 'N';
75: l_blank_line VARCHAR2(1) := ' ';
76: l_gtas_cust_attribute fv_system_parameters.gtas_customer_attribute%TYPE;
77: l_facts1_cust_attribute fv_system_parameters.factsI_customer_attribute%TYPE;
78: l_facts1_vend_attribute fv_system_parameters.gtas_customer_attribute%TYPE;
79: NO_GTAS_ATTR_COL_FOUND EXCEPTION;
80: NO_FACTS1_ATTR_COL_FOUND EXCEPTION;
81: l_col_select varchar2(5000);
82: l_where_clause varchar2(5000);

Line 129: FROM fv_system_parameters;

125: fnd_file.put_line(fnd_file.log, 'New customer column does not exist.');
126:
127: SELECT gtas_customer_attribute
128: INTO l_gtas_cust_attribute
129: FROM fv_system_parameters;
130: fnd_file.put_line(fnd_file.log, l_blank_line);
131: fnd_file.put_line(fnd_file.log,'gtas_customer_attribute: '||l_gtas_cust_attribute);
132:
133: IF l_gtas_cust_attribute IS NULL THEN

Line 149: FROM fv_system_parameters;

145:
146: BEGIN
147: SELECT factsI_customer_attribute, factsI_vendor_attribute
148: INTO l_facts1_cust_attribute, l_facts1_vend_attribute
149: FROM fv_system_parameters;
150:
151: fnd_file.put_line(fnd_file.log, l_blank_line);
152: fnd_file.put_line(fnd_file.log,'l_facts1_cust_attribute: '||l_facts1_cust_attribute);
153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);