eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FORECAST_UTIL_PVT dependencies on FND_DSQL

Line 1045: FND_DSQL.init;

1041:
1042: l_prod_index := 1;
1043: */
1044: FOR i IN c_products LOOP
1045: FND_DSQL.init;
1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');

Line 1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');

1042: l_prod_index := 1;
1043: */
1044: FOR i IN c_products LOOP
1045: FND_DSQL.init;
1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');

Line 1047: FND_DSQL.add_text('forecast_product_id, ');

1043: */
1044: FOR i IN c_products LOOP
1045: FND_DSQL.init;
1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');

Line 1048: FND_DSQL.add_text('obj_type, ');

1044: FOR i IN c_products LOOP
1045: FND_DSQL.init;
1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');

Line 1049: FND_DSQL.add_text('obj_id, ');

1045: FND_DSQL.init;
1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');

Line 1050: FND_DSQL.add_text('product_attribute_context, ');

1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');

Line 1051: FND_DSQL.add_text('product_attribute, ');

1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');

Line 1052: FND_DSQL.add_text('product_attr_value, ');

1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');

Line 1053: FND_DSQL.add_text('product_id, ');

1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');

Line 1054: FND_DSQL.add_text('creation_date, ');

1050: FND_DSQL.add_text('product_attribute_context, ');
1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');

Line 1055: FND_DSQL.add_text('created_by, ');

1051: FND_DSQL.add_text('product_attribute, ');
1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:

Line 1056: FND_DSQL.add_text('last_update_date, ');

1052: FND_DSQL.add_text('product_attr_value, ');
1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');

Line 1057: FND_DSQL.add_text('last_updated_by , ');

1053: FND_DSQL.add_text('product_id, ');
1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');

Line 1058: FND_DSQL.add_text('last_update_login )');

1054: FND_DSQL.add_text('creation_date, ');
1055: FND_DSQL.add_text('created_by, ');
1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);

Line 1060: FND_DSQL.add_text(' SELECT ');

1056: FND_DSQL.add_text('last_update_date, ');
1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);

Line 1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');

1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');

Line 1062: FND_DSQL.add_bind(p_obj_type);

1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);

Line 1063: FND_DSQL.add_text(',');

1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );

Line 1064: FND_DSQL.add_bind(p_obj_id);

1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);

Line 1065: FND_DSQL.add_text(',');

1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );

Line 1066: FND_DSQL.add_bind(i.product_attribute_context);

1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);

Line 1067: FND_DSQL.add_text(',' );

1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );

Line 1068: FND_DSQL.add_bind(i.product_attribute);

1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');

Line 1069: FND_DSQL.add_text(',' );

1065: FND_DSQL.add_text(',');
1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');

Line 1070: FND_DSQL.add_bind(i.product_attr_value);

1066: FND_DSQL.add_bind(i.product_attribute_context);
1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');

Line 1071: FND_DSQL.add_text(',' );

1067: FND_DSQL.add_text(',' );
1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');

Line 1072: FND_DSQL.add_text('a.product_id , ');

1068: FND_DSQL.add_bind(i.product_attribute);
1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');

Line 1073: FND_DSQL.add_text('sysdate , ');

1069: FND_DSQL.add_text(',' );
1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');

Line 1074: FND_DSQL.add_text('fnd_global.user_id ,');

1070: FND_DSQL.add_bind(i.product_attr_value);
1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:

Line 1075: FND_DSQL.add_text('sysdate , ');

1071: FND_DSQL.add_text(',' );
1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:
1079: FND_DSQL.add_text(' FROM (');

Line 1076: FND_DSQL.add_text('fnd_global.user_id, ');

1072: FND_DSQL.add_text('a.product_id , ');
1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:
1079: FND_DSQL.add_text(' FROM (');
1080:

Line 1077: FND_DSQL.add_text('fnd_global.login_id ');

1073: FND_DSQL.add_text('sysdate , ');
1074: FND_DSQL.add_text('fnd_global.user_id ,');
1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:
1079: FND_DSQL.add_text(' FROM (');
1080:
1081: l_stmt_temp := null;

Line 1079: FND_DSQL.add_text(' FROM (');

1075: FND_DSQL.add_text('sysdate , ');
1076: FND_DSQL.add_text('fnd_global.user_id, ');
1077: FND_DSQL.add_text('fnd_global.login_id ');
1078:
1079: FND_DSQL.add_text(' FROM (');
1080:
1081: l_stmt_temp := null;
1082: l_stmt_product := NULL;
1083: l_stmt_product1 := NULL;

Line 1092: -- FND_DSQL.add_text('(');

1088: i.product_attr_value);
1089: FETCH c_no_excl_products INTO l_no_excl_products;
1090: CLOSE c_no_excl_products;
1091:
1092: -- FND_DSQL.add_text('(');
1093:
1094: l_stmt_temp := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(
1095: p_context => i.product_attribute_context,
1096: p_attribute => i.product_attribute,

Line 1107: FND_DSQL.add_text(' MINUS (');

1103: IF l_stmt_temp IS NULL THEN
1104: GOTO NEXT_PRODUCT;
1105: ELSE
1106: IF l_no_excl_products > 0 THEN
1107: FND_DSQL.add_text(' MINUS (');
1108: END IF;
1109: END IF;
1110:
1111: IF l_stmt_product1 IS NULL THEN

Line 1136: FND_DSQL.add_text(' UNION ');

1132: IF l_stmt_temp IS NULL THEN
1133: EXIT;
1134: ELSE
1135: IF l_excl_index < l_no_excl_products THEN
1136: FND_DSQL.add_text(' UNION ');
1137: l_excl_index := l_excl_index + 1;
1138: ELSE
1139: FND_DSQL.add_text(')');
1140: END IF;

Line 1139: FND_DSQL.add_text(')');

1135: IF l_excl_index < l_no_excl_products THEN
1136: FND_DSQL.add_text(' UNION ');
1137: l_excl_index := l_excl_index + 1;
1138: ELSE
1139: FND_DSQL.add_text(')');
1140: END IF;
1141: END IF;
1142: END LOOP;
1143:

Line 1144: -- FND_DSQL.add_text(')');

1140: END IF;
1141: END IF;
1142: END LOOP;
1143:
1144: -- FND_DSQL.add_text(')');
1145: /*
1146: IF l_prod_index < l_no_products THEN
1147: FND_DSQL.add_text(' UNION ');
1148: l_prod_index := l_prod_index + 1;

Line 1147: FND_DSQL.add_text(' UNION ');

1143:
1144: -- FND_DSQL.add_text(')');
1145: /*
1146: IF l_prod_index < l_no_products THEN
1147: FND_DSQL.add_text(' UNION ');
1148: l_prod_index := l_prod_index + 1;
1149: END IF;
1150: */
1151: FND_DSQL.add_text(') a');

Line 1151: FND_DSQL.add_text(') a');

1147: FND_DSQL.add_text(' UNION ');
1148: l_prod_index := l_prod_index + 1;
1149: END IF;
1150: */
1151: FND_DSQL.add_text(') a');
1152:
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);

Line 1154: FND_DSQL.set_cursor(l_denorm_csr);

1150: */
1151: FND_DSQL.add_text(') a');
1152:
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;
1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1151: FND_DSQL.add_text(') a');
1152:
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;
1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1159: dbms_sql.close_cursor(l_denorm_csr);

Line 1157: FND_DSQL.do_binds;

1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;
1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1159: dbms_sql.close_cursor(l_denorm_csr);
1160:
1161: <>

Line 1327: FND_DSQL.init;

1323: AND obj_id = p_obj_id ;
1324:
1325: FOR i IN c_groups LOOP
1326:
1327: FND_DSQL.init;
1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');

Line 1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');

1324:
1325: FOR i IN c_groups LOOP
1326:
1327: FND_DSQL.init;
1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');

Line 1329: FND_DSQL.add_text('forecast_customer_id, ');

1325: FOR i IN c_groups LOOP
1326:
1327: FND_DSQL.init;
1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');

Line 1330: FND_DSQL.add_text('obj_type, ');

1326:
1327: FND_DSQL.init;
1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');

Line 1331: FND_DSQL.add_text('obj_id, ');

1327: FND_DSQL.init;
1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');

Line 1332: FND_DSQL.add_text('qualifier_grouping_no, ');

1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');

Line 1333: FND_DSQL.add_text('cust_account_id, ');

1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');

Line 1334: FND_DSQL.add_text('site_use_id, ');

1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');

Line 1335: FND_DSQL.add_text('site_use_code, ');

1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');
1339: FND_DSQL.add_text('last_updated_by, ');

Line 1336: FND_DSQL.add_text('creation_date, ');

1332: FND_DSQL.add_text('qualifier_grouping_no, ');
1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');
1339: FND_DSQL.add_text('last_updated_by, ');
1340: FND_DSQL.add_text('last_update_login )');

Line 1337: FND_DSQL.add_text('created_by, ');

1333: FND_DSQL.add_text('cust_account_id, ');
1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');
1339: FND_DSQL.add_text('last_updated_by, ');
1340: FND_DSQL.add_text('last_update_login )');
1341:

Line 1338: FND_DSQL.add_text('last_update_date, ');

1334: FND_DSQL.add_text('site_use_id, ');
1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');
1339: FND_DSQL.add_text('last_updated_by, ');
1340: FND_DSQL.add_text('last_update_login )');
1341:
1342: /*

Line 1339: FND_DSQL.add_text('last_updated_by, ');

1335: FND_DSQL.add_text('site_use_code, ');
1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');
1339: FND_DSQL.add_text('last_updated_by, ');
1340: FND_DSQL.add_text('last_update_login )');
1341:
1342: /*
1343: FOR j IN c_qualifiers(i.qualifier_grouping_no) LOOP

Line 1340: FND_DSQL.add_text('last_update_login )');

1336: FND_DSQL.add_text('creation_date, ');
1337: FND_DSQL.add_text('created_by, ');
1338: FND_DSQL.add_text('last_update_date, ');
1339: FND_DSQL.add_text('last_updated_by, ');
1340: FND_DSQL.add_text('last_update_login )');
1341:
1342: /*
1343: FOR j IN c_qualifiers(i.qualifier_grouping_no) LOOP
1344: get_site_type(j.qualifier_context, j.qualifier_attribute, l_site_type);

Line 1361: FND_DSQL.add_text(' SELECT ');

1357: l_site_use_id := NULL;
1358: END IF ;
1359: END LOOP;
1360: */
1361: FND_DSQL.add_text(' SELECT ');
1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);

Line 1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');

1358: END IF ;
1359: END LOOP;
1360: */
1361: FND_DSQL.add_text(' SELECT ');
1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');

Line 1363: FND_DSQL.add_bind(p_obj_type);

1359: END LOOP;
1360: */
1361: FND_DSQL.add_text(' SELECT ');
1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);

Line 1364: FND_DSQL.add_text(',');

1360: */
1361: FND_DSQL.add_text(' SELECT ');
1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');

Line 1365: FND_DSQL.add_bind(p_obj_id);

1361: FND_DSQL.add_text(' SELECT ');
1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');

Line 1366: FND_DSQL.add_text(',');

1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');

Line 1367: FND_DSQL.add_bind(i.qualifier_grouping_no);

1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');

Line 1368: FND_DSQL.add_text(',');

1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);

Line 1369: FND_DSQL.add_text('b.cust_account_id ,');

1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');

Line 1370: FND_DSQL.add_text('b.site_use_id ,');

1366: FND_DSQL.add_text(',');
1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);

Line 1371: FND_DSQL.add_text('b.site_use_code ,');

1367: FND_DSQL.add_bind(i.qualifier_grouping_no);
1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');

Line 1372: -- FND_DSQL.add_bind(l_site_use_id);

1368: FND_DSQL.add_text(',');
1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');

Line 1373: -- FND_DSQL.add_text(',');

1369: FND_DSQL.add_text('b.cust_account_id ,');
1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');

Line 1374: -- FND_DSQL.add_bind(l_site_use_code);

1370: FND_DSQL.add_text('b.site_use_id ,');
1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');

Line 1375: -- FND_DSQL.add_text(',');

1371: FND_DSQL.add_text('b.site_use_code ,');
1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');

Line 1376: FND_DSQL.add_text('sysdate , ');

1372: -- FND_DSQL.add_bind(l_site_use_id);
1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');

Line 1377: FND_DSQL.add_text('fnd_global.user_id ,');

1373: -- FND_DSQL.add_text(',');
1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:

Line 1378: FND_DSQL.add_text('sysdate , ');

1374: -- FND_DSQL.add_bind(l_site_use_code);
1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:
1382: FND_DSQL.add_text(' FROM (');

Line 1379: FND_DSQL.add_text('fnd_global.user_id, ');

1375: -- FND_DSQL.add_text(',');
1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:
1382: FND_DSQL.add_text(' FROM (');
1383:

Line 1380: FND_DSQL.add_text('fnd_global.login_id ');

1376: FND_DSQL.add_text('sysdate , ');
1377: FND_DSQL.add_text('fnd_global.user_id ,');
1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:
1382: FND_DSQL.add_text(' FROM (');
1383:
1384: OPEN c_no_qualifiers(i.qualifier_grouping_no);

Line 1382: FND_DSQL.add_text(' FROM (');

1378: FND_DSQL.add_text('sysdate , ');
1379: FND_DSQL.add_text('fnd_global.user_id, ');
1380: FND_DSQL.add_text('fnd_global.login_id ');
1381:
1382: FND_DSQL.add_text(' FROM (');
1383:
1384: OPEN c_no_qualifiers(i.qualifier_grouping_no);
1385: FETCH c_no_qualifiers INTO l_no_qualifiers;
1386: CLOSE c_no_qualifiers;

Line 1414: FND_DSQL.add_text(' INTERSECT ');

1410: GOTO NEXT_CUSTOMER ;
1411: ELSE
1412:
1413: IF l_qualifier_index < l_no_qualifiers THEN
1414: FND_DSQL.add_text(' INTERSECT ');
1415: l_qualifier_index := l_qualifier_index + 1;
1416: END IF;
1417: END IF;
1418:

Line 1422: FND_DSQL.add_text(') b');

1418:
1419: <>
1420: null;
1421: END LOOP;
1422: FND_DSQL.add_text(') b');
1423:
1424: -- FND_DSQL.add_text(' a,hz_cust_accounts b');
1425: -- FND_DSQL.add_text(' WHERE a.party_id = b.party_id ');
1426:

Line 1424: -- FND_DSQL.add_text(' a,hz_cust_accounts b');

1420: null;
1421: END LOOP;
1422: FND_DSQL.add_text(') b');
1423:
1424: -- FND_DSQL.add_text(' a,hz_cust_accounts b');
1425: -- FND_DSQL.add_text(' WHERE a.party_id = b.party_id ');
1426:
1427: IF l_stmt_temp IS NULL
1428: THEN

Line 1425: -- FND_DSQL.add_text(' WHERE a.party_id = b.party_id ');

1421: END LOOP;
1422: FND_DSQL.add_text(') b');
1423:
1424: -- FND_DSQL.add_text(' a,hz_cust_accounts b');
1425: -- FND_DSQL.add_text(' WHERE a.party_id = b.party_id ');
1426:
1427: IF l_stmt_temp IS NULL
1428: THEN
1429: GOTO NEXT_GROUP ;

Line 1433: FND_DSQL.set_cursor(l_denorm_csr);

1429: GOTO NEXT_GROUP ;
1430: END IF;
1431:
1432: l_denorm_csr := DBMS_SQL.open_cursor;
1433: FND_DSQL.set_cursor(l_denorm_csr);
1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1437: FND_DSQL.do_binds;

Line 1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1430: END IF;
1431:
1432: l_denorm_csr := DBMS_SQL.open_cursor;
1433: FND_DSQL.set_cursor(l_denorm_csr);
1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1437: FND_DSQL.do_binds;
1438: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1437: FND_DSQL.do_binds;

1433: FND_DSQL.set_cursor(l_denorm_csr);
1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1437: FND_DSQL.do_binds;
1438: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1439: dbms_sql.close_cursor(l_denorm_csr);
1440:
1441: <>