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.MSC_M2A_PUSH dependencies on DBMS_SQL

Line 1066: cursor1 := dbms_sql.open_cursor;

1062: lv_sql_stmt := lv_sql_stmt || ' AND trunc(MRO.NEW_SCHEDULE_DATE) BETWEEN (:pHORIZON_START_DATE) and (:pHORIZON_END_DATE)';
1063:
1064:
1065:
1066: cursor1 := dbms_sql.open_cursor;
1067: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1068:
1069: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 1067: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

1063:
1064:
1065:
1066: cursor1 := dbms_sql.open_cursor;
1067: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1068:
1069: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1071: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

Line 1069: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

1065:
1066: cursor1 := dbms_sql.open_cursor;
1067: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1068:
1069: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1071: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1072:
1073: IF pORGANIZATION_ID IS NOT NULL THEN

Line 1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

1066: cursor1 := dbms_sql.open_cursor;
1067: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1068:
1069: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1071: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1072:
1073: IF pORGANIZATION_ID IS NOT NULL THEN
1074: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 1071: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

1067: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1068:
1069: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1071: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1072:
1073: IF pORGANIZATION_ID IS NOT NULL THEN
1074: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1075: END IF;

Line 1074: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

1070: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1071: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1072:
1073: IF pORGANIZATION_ID IS NOT NULL THEN
1074: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1075: END IF;
1076:
1077: IF pPLANNER IS NOT NULL THEN
1078: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 1078: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

1074: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1075: END IF;
1076:
1077: IF pPLANNER IS NOT NULL THEN
1078: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1079: END IF;
1080:
1081: IF pCATEGORY_ID IS NOT NULL THEN
1082: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 1082: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

1078: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1079: END IF;
1080:
1081: IF pCATEGORY_ID IS NOT NULL THEN
1082: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1083: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1084: END IF;
1085:
1086: IF pITEM_ID IS NOT NULL THEN

Line 1083: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);

1079: END IF;
1080:
1081: IF pCATEGORY_ID IS NOT NULL THEN
1082: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1083: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1084: END IF;
1085:
1086: IF pITEM_ID IS NOT NULL THEN
1087: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 1087: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

1083: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1084: END IF;
1085:
1086: IF pITEM_ID IS NOT NULL THEN
1087: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1088: END IF;
1089:
1090: IF pSUPPLIER_ID IS NOT NULL THEN
1091: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', lv_sr_tp_id);

Line 1091: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', lv_sr_tp_id);

1087: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1088: END IF;
1089:
1090: IF pSUPPLIER_ID IS NOT NULL THEN
1091: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', lv_sr_tp_id);
1092: END IF;
1093:
1094: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
1095: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);

Line 1095: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);

1091: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', lv_sr_tp_id);
1092: END IF;
1093:
1094: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
1095: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);
1096: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1097: END IF;
1098:
1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

Line 1096: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

1092: END IF;
1093:
1094: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
1095: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);
1096: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1097: END IF;
1098:
1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1100: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

Line 1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

1095: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);
1096: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1097: END IF;
1098:
1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1100: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1101:
1102: ignore := dbms_sql.execute(cursor1);
1103: dbms_sql.close_cursor(cursor1);

Line 1100: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

1096: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1097: END IF;
1098:
1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1100: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1101:
1102: ignore := dbms_sql.execute(cursor1);
1103: dbms_sql.close_cursor(cursor1);
1104:

Line 1102: ignore := dbms_sql.execute(cursor1);

1098:
1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1100: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1101:
1102: ignore := dbms_sql.execute(cursor1);
1103: dbms_sql.close_cursor(cursor1);
1104:
1105: /* End Delete Recommendations */
1106:

Line 1103: dbms_sql.close_cursor(cursor1);

1099: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1100: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1101:
1102: ignore := dbms_sql.execute(cursor1);
1103: dbms_sql.close_cursor(cursor1);
1104:
1105: /* End Delete Recommendations */
1106:
1107: /* Begin Delete Items */

Line 1155: cursor1 := dbms_sql.open_cursor;

1151: ||' AND MACSV.DEFAULT_FLAG = 1)';
1152: END IF;
1153:
1154:
1155: cursor1 := dbms_sql.open_cursor;
1156: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1157:
1158: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 1156: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

1152: END IF;
1153:
1154:
1155: cursor1 := dbms_sql.open_cursor;
1156: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1157:
1158: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1160: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

Line 1158: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

1154:
1155: cursor1 := dbms_sql.open_cursor;
1156: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1157:
1158: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1160: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1161:
1162: IF pORGANIZATION_ID IS NOT NULL THEN

Line 1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

1155: cursor1 := dbms_sql.open_cursor;
1156: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1157:
1158: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1160: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1161:
1162: IF pORGANIZATION_ID IS NOT NULL THEN
1163: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 1160: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

1156: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1157:
1158: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1160: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1161:
1162: IF pORGANIZATION_ID IS NOT NULL THEN
1163: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1164: END IF;

Line 1163: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

1159: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1160: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1161:
1162: IF pORGANIZATION_ID IS NOT NULL THEN
1163: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1164: END IF;
1165:
1166: IF pPLANNER IS NOT NULL THEN
1167: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 1167: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

1163: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1164: END IF;
1165:
1166: IF pPLANNER IS NOT NULL THEN
1167: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1168: END IF;
1169:
1170: IF pCATEGORY_ID IS NOT NULL THEN
1171: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 1171: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

1167: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1168: END IF;
1169:
1170: IF pCATEGORY_ID IS NOT NULL THEN
1171: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1172: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1173: END IF;
1174:
1175: IF pITEM_ID IS NOT NULL THEN

Line 1172: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);

1168: END IF;
1169:
1170: IF pCATEGORY_ID IS NOT NULL THEN
1171: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1172: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1173: END IF;
1174:
1175: IF pITEM_ID IS NOT NULL THEN
1176: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 1176: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

1172: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1173: END IF;
1174:
1175: IF pITEM_ID IS NOT NULL THEN
1176: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1177: END IF;
1178:
1179: ignore := dbms_sql.execute(cursor1);
1180: dbms_sql.close_cursor(cursor1);

Line 1179: ignore := dbms_sql.execute(cursor1);

1175: IF pITEM_ID IS NOT NULL THEN
1176: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1177: END IF;
1178:
1179: ignore := dbms_sql.execute(cursor1);
1180: dbms_sql.close_cursor(cursor1);
1181:
1182: /* End Delete Items */
1183:

Line 1180: dbms_sql.close_cursor(cursor1);

1176: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1177: END IF;
1178:
1179: ignore := dbms_sql.execute(cursor1);
1180: dbms_sql.close_cursor(cursor1);
1181:
1182: /* End Delete Items */
1183:
1184: IF pDEMAND = 1 THEN

Line 1236: cursor1 := dbms_sql.open_cursor;

1232:
1233: lv_sql_stmt := lv_sql_stmt ||' AND trunc(MGR.USING_ASSEMBLY_DEMAND_DATE) BETWEEN (:pHORIZON_START_DATE) and (:pHORIZON_END_DATE)';
1234:
1235:
1236: cursor1 := dbms_sql.open_cursor;
1237: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1238:
1239: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 1237: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

1233: lv_sql_stmt := lv_sql_stmt ||' AND trunc(MGR.USING_ASSEMBLY_DEMAND_DATE) BETWEEN (:pHORIZON_START_DATE) and (:pHORIZON_END_DATE)';
1234:
1235:
1236: cursor1 := dbms_sql.open_cursor;
1237: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1238:
1239: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1241: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

Line 1239: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

1235:
1236: cursor1 := dbms_sql.open_cursor;
1237: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1238:
1239: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1241: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1242:
1243: IF pORGANIZATION_ID IS NOT NULL THEN

Line 1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

1236: cursor1 := dbms_sql.open_cursor;
1237: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1238:
1239: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1241: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1242:
1243: IF pORGANIZATION_ID IS NOT NULL THEN
1244: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 1241: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

1237: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1238:
1239: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1241: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1242:
1243: IF pORGANIZATION_ID IS NOT NULL THEN
1244: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1245: END IF;

Line 1244: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

1240: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1241: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
1242:
1243: IF pORGANIZATION_ID IS NOT NULL THEN
1244: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1245: END IF;
1246:
1247: IF pPLANNER IS NOT NULL THEN
1248: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 1248: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

1244: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1245: END IF;
1246:
1247: IF pPLANNER IS NOT NULL THEN
1248: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1249: END IF;
1250:
1251: IF pCATEGORY_ID IS NOT NULL THEN
1252: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 1252: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

1248: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1249: END IF;
1250:
1251: IF pCATEGORY_ID IS NOT NULL THEN
1252: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1253: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1254: END IF;
1255:
1256: IF pITEM_ID IS NOT NULL THEN

Line 1253: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);

1249: END IF;
1250:
1251: IF pCATEGORY_ID IS NOT NULL THEN
1252: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1253: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1254: END IF;
1255:
1256: IF pITEM_ID IS NOT NULL THEN
1257: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 1257: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

1253: dbms_sql.bind_variable(cursor1, ':pLANG', lv_LANG);
1254: END IF;
1255:
1256: IF pITEM_ID IS NOT NULL THEN
1257: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1258: END IF;
1259:
1260: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1261: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

Line 1260: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

1256: IF pITEM_ID IS NOT NULL THEN
1257: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1258: END IF;
1259:
1260: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1261: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1262:
1263: ignore := dbms_sql.execute(cursor1);
1264: dbms_sql.close_cursor(cursor1);

Line 1261: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

1257: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1258: END IF;
1259:
1260: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1261: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1262:
1263: ignore := dbms_sql.execute(cursor1);
1264: dbms_sql.close_cursor(cursor1);
1265:

Line 1263: ignore := dbms_sql.execute(cursor1);

1259:
1260: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1261: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1262:
1263: ignore := dbms_sql.execute(cursor1);
1264: dbms_sql.close_cursor(cursor1);
1265:
1266:
1267: /* End Delete Gross requirements */

Line 1264: dbms_sql.close_cursor(cursor1);

1260: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1261: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1262:
1263: ignore := dbms_sql.execute(cursor1);
1264: dbms_sql.close_cursor(cursor1);
1265:
1266:
1267: /* End Delete Gross requirements */
1268:

Line 1536: cursor1 := dbms_sql.open_cursor;

1532: END IF;
1533:
1534:
1535:
1536: cursor1 := dbms_sql.open_cursor;
1537: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1538:
1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

Line 1537: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

1533:
1534:
1535:
1536: cursor1 := dbms_sql.open_cursor;
1537: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1538:
1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);

1535:
1536: cursor1 := dbms_sql.open_cursor;
1537: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1538:
1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

Line 1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

1536: cursor1 := dbms_sql.open_cursor;
1537: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1538:
1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1544:

Line 1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

1537: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1538:
1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1544:
1545: IF pORGANIZATION_ID IS NOT NULL THEN

Line 1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

1538:
1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1544:
1545: IF pORGANIZATION_ID IS NOT NULL THEN
1546: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

1539: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1540: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1541: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1544:
1545: IF pORGANIZATION_ID IS NOT NULL THEN
1546: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1547: END IF;

Line 1546: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

1542: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1543: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1544:
1545: IF pORGANIZATION_ID IS NOT NULL THEN
1546: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1547: END IF;
1548:
1549: IF pPLANNER IS NOT NULL THEN
1550: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 1550: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

1546: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1547: END IF;
1548:
1549: IF pPLANNER IS NOT NULL THEN
1550: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1551: END IF;
1552:
1553: IF pCATEGORY_ID IS NOT NULL THEN
1554: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 1554: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

1550: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1551: END IF;
1552:
1553: IF pCATEGORY_ID IS NOT NULL THEN
1554: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1555: END IF;
1556:
1557: IF pITEM_ID IS NOT NULL THEN
1558: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 1558: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

1554: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1555: END IF;
1556:
1557: IF pITEM_ID IS NOT NULL THEN
1558: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1559: END IF;
1560:
1561: IF pSUPPLIER_ID IS NOT NULL THEN
1562: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);

Line 1562: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);

1558: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1559: END IF;
1560:
1561: IF pSUPPLIER_ID IS NOT NULL THEN
1562: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);
1563: END IF;
1564:
1565: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
1566: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);

Line 1566: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);

1562: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);
1563: END IF;
1564:
1565: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
1566: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);
1567: END IF;
1568:
1569: v_total_buy_count := dbms_sql.execute(cursor1);
1570: dbms_sql.close_cursor(cursor1);

Line 1569: v_total_buy_count := dbms_sql.execute(cursor1);

1565: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
1566: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);
1567: END IF;
1568:
1569: v_total_buy_count := dbms_sql.execute(cursor1);
1570: dbms_sql.close_cursor(cursor1);
1571:
1572: v_buff := 'Number of Buy Recommendations with Supplier and Site loaded : '||v_total_buy_count;
1573: LOG_MESSAGE(v_buff);

Line 1570: dbms_sql.close_cursor(cursor1);

1566: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_SITE_ID', pSUPPLIER_SITE_ID);
1567: END IF;
1568:
1569: v_total_buy_count := dbms_sql.execute(cursor1);
1570: dbms_sql.close_cursor(cursor1);
1571:
1572: v_buff := 'Number of Buy Recommendations with Supplier and Site loaded : '||v_total_buy_count;
1573: LOG_MESSAGE(v_buff);
1574:

Line 1790: cursor1 := dbms_sql.open_cursor;

1786: IF pSUPPLIER_ID IS NOT NULL THEN
1787: lv_sql_stmt := lv_sql_stmt || ' AND nvl(ms.source_supplier_id,ms.supplier_id) = :pSUPPLIER_ID';
1788: END IF;
1789:
1790: cursor1 := dbms_sql.open_cursor;
1791: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1792:
1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

Line 1791: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

1787: lv_sql_stmt := lv_sql_stmt || ' AND nvl(ms.source_supplier_id,ms.supplier_id) = :pSUPPLIER_ID';
1788: END IF;
1789:
1790: cursor1 := dbms_sql.open_cursor;
1791: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1792:
1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);

1789:
1790: cursor1 := dbms_sql.open_cursor;
1791: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1792:
1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

Line 1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

1790: cursor1 := dbms_sql.open_cursor;
1791: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1792:
1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1798:

Line 1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

1791: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
1792:
1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1798:
1799: IF pORGANIZATION_ID IS NOT NULL THEN

Line 1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

1792:
1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1798:
1799: IF pORGANIZATION_ID IS NOT NULL THEN
1800: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

1793: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
1794: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
1795: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1798:
1799: IF pORGANIZATION_ID IS NOT NULL THEN
1800: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1801: END IF;

Line 1800: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

1796: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
1797: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
1798:
1799: IF pORGANIZATION_ID IS NOT NULL THEN
1800: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1801: END IF;
1802:
1803: IF pPLANNER IS NOT NULL THEN
1804: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 1804: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

1800: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
1801: END IF;
1802:
1803: IF pPLANNER IS NOT NULL THEN
1804: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1805: END IF;
1806:
1807: IF pCATEGORY_ID IS NOT NULL THEN
1808: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 1808: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

1804: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
1805: END IF;
1806:
1807: IF pCATEGORY_ID IS NOT NULL THEN
1808: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1809: END IF;
1810:
1811: IF pITEM_ID IS NOT NULL THEN
1812: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 1812: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

1808: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
1809: END IF;
1810:
1811: IF pITEM_ID IS NOT NULL THEN
1812: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1813: END IF;
1814:
1815: IF pSUPPLIER_ID IS NOT NULL THEN
1816: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);

Line 1816: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);

1812: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
1813: END IF;
1814:
1815: IF pSUPPLIER_ID IS NOT NULL THEN
1816: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);
1817: END IF;
1818:
1819: v_total_buy_count1 := dbms_sql.execute(cursor1);
1820: dbms_sql.close_cursor(cursor1);

Line 1819: v_total_buy_count1 := dbms_sql.execute(cursor1);

1815: IF pSUPPLIER_ID IS NOT NULL THEN
1816: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);
1817: END IF;
1818:
1819: v_total_buy_count1 := dbms_sql.execute(cursor1);
1820: dbms_sql.close_cursor(cursor1);
1821:
1822: v_buff := 'Number of Buy Recommendations with No Site loaded : '||v_total_buy_count1;
1823: LOG_MESSAGE(v_buff);

Line 1820: dbms_sql.close_cursor(cursor1);

1816: dbms_sql.bind_variable(cursor1, ':pSUPPLIER_ID', pSUPPLIER_ID);
1817: END IF;
1818:
1819: v_total_buy_count1 := dbms_sql.execute(cursor1);
1820: dbms_sql.close_cursor(cursor1);
1821:
1822: v_buff := 'Number of Buy Recommendations with No Site loaded : '||v_total_buy_count1;
1823: LOG_MESSAGE(v_buff);
1824:

Line 2046: cursor1 := dbms_sql.open_cursor;

2042: lv_sql_stmt1 := lv_sql_stmt1 || ' AND msi.sr_inventory_item_id = :pITEM_ID';
2043: END IF;
2044:
2045:
2046: cursor1 := dbms_sql.open_cursor;
2047: dbms_sql.parse(cursor1, lv_sql_stmt1, dbms_sql.v7);
2048:
2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

Line 2047: dbms_sql.parse(cursor1, lv_sql_stmt1, dbms_sql.v7);

2043: END IF;
2044:
2045:
2046: cursor1 := dbms_sql.open_cursor;
2047: dbms_sql.parse(cursor1, lv_sql_stmt1, dbms_sql.v7);
2048:
2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);

2045:
2046: cursor1 := dbms_sql.open_cursor;
2047: dbms_sql.parse(cursor1, lv_sql_stmt1, dbms_sql.v7);
2048:
2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

Line 2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

2046: cursor1 := dbms_sql.open_cursor;
2047: dbms_sql.parse(cursor1, lv_sql_stmt1, dbms_sql.v7);
2048:
2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2054:

Line 2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

2047: dbms_sql.parse(cursor1, lv_sql_stmt1, dbms_sql.v7);
2048:
2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2054:
2055: IF pORGANIZATION_ID IS NOT NULL THEN

Line 2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

2048:
2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2054:
2055: IF pORGANIZATION_ID IS NOT NULL THEN
2056: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

2049: dbms_sql.bind_variable(cursor1, ':p_DESIGNATOR', pDESIGNATOR);
2050: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2051: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2054:
2055: IF pORGANIZATION_ID IS NOT NULL THEN
2056: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2057: END IF;

Line 2056: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

2052: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2053: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2054:
2055: IF pORGANIZATION_ID IS NOT NULL THEN
2056: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2057: END IF;
2058:
2059: IF pPLANNER IS NOT NULL THEN
2060: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 2060: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

2056: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2057: END IF;
2058:
2059: IF pPLANNER IS NOT NULL THEN
2060: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
2061: END IF;
2062:
2063: IF pCATEGORY_ID IS NOT NULL THEN
2064: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 2064: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

2060: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
2061: END IF;
2062:
2063: IF pCATEGORY_ID IS NOT NULL THEN
2064: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
2065: END IF;
2066:
2067: IF pITEM_ID IS NOT NULL THEN
2068: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 2068: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

2064: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
2065: END IF;
2066:
2067: IF pITEM_ID IS NOT NULL THEN
2068: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2069: END IF;
2070:
2071: v_total_make_count := dbms_sql.execute(cursor1);
2072: dbms_sql.close_cursor(cursor1);

Line 2071: v_total_make_count := dbms_sql.execute(cursor1);

2067: IF pITEM_ID IS NOT NULL THEN
2068: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2069: END IF;
2070:
2071: v_total_make_count := dbms_sql.execute(cursor1);
2072: dbms_sql.close_cursor(cursor1);
2073:
2074:
2075: END IF;

Line 2072: dbms_sql.close_cursor(cursor1);

2068: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2069: END IF;
2070:
2071: v_total_make_count := dbms_sql.execute(cursor1);
2072: dbms_sql.close_cursor(cursor1);
2073:
2074:
2075: END IF;
2076:

Line 2295: cursor1 := dbms_sql.open_cursor;

2291: IF pITEM_ID IS NOT NULL THEN
2292: lv_sql_stmt := lv_sql_stmt || ' AND msi.sr_inventory_item_id = :pITEM_ID';
2293: END IF;
2294:
2295: cursor1 := dbms_sql.open_cursor;
2296: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2297:
2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

Line 2296: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

2292: lv_sql_stmt := lv_sql_stmt || ' AND msi.sr_inventory_item_id = :pITEM_ID';
2293: END IF;
2294:
2295: cursor1 := dbms_sql.open_cursor;
2296: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2297:
2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

2294:
2295: cursor1 := dbms_sql.open_cursor;
2296: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2297:
2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2301: --bug#7016427 **hbinjola**
2302: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

2295: cursor1 := dbms_sql.open_cursor;
2296: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2297:
2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2301: --bug#7016427 **hbinjola**
2302: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2303: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

Line 2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

2296: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2297:
2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2301: --bug#7016427 **hbinjola**
2302: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2303: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2304:

Line 2302: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

2298: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2301: --bug#7016427 **hbinjola**
2302: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2303: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2304:
2305:
2306: IF pORGANIZATION_ID IS NOT NULL THEN

Line 2303: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

2299: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2300: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2301: --bug#7016427 **hbinjola**
2302: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2303: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2304:
2305:
2306: IF pORGANIZATION_ID IS NOT NULL THEN
2307: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 2307: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

2303: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2304:
2305:
2306: IF pORGANIZATION_ID IS NOT NULL THEN
2307: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2308: END IF;
2309:
2310: IF pPLANNER IS NOT NULL THEN
2311: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 2311: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

2307: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2308: END IF;
2309:
2310: IF pPLANNER IS NOT NULL THEN
2311: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
2312: END IF;
2313:
2314: IF pCATEGORY_ID IS NOT NULL THEN
2315: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 2315: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

2311: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
2312: END IF;
2313:
2314: IF pCATEGORY_ID IS NOT NULL THEN
2315: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
2316: END IF;
2317:
2318: IF pITEM_ID IS NOT NULL THEN
2319: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 2319: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

2315: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
2316: END IF;
2317:
2318: IF pITEM_ID IS NOT NULL THEN
2319: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2320: END IF;
2321:
2322: v_item_count := dbms_sql.execute(cursor1);
2323: dbms_sql.close_cursor(cursor1);

Line 2322: v_item_count := dbms_sql.execute(cursor1);

2318: IF pITEM_ID IS NOT NULL THEN
2319: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2320: END IF;
2321:
2322: v_item_count := dbms_sql.execute(cursor1);
2323: dbms_sql.close_cursor(cursor1);
2324:
2325:
2326: v_buff := 'Number of System items loaded : '||v_item_count;

Line 2323: dbms_sql.close_cursor(cursor1);

2319: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2320: END IF;
2321:
2322: v_item_count := dbms_sql.execute(cursor1);
2323: dbms_sql.close_cursor(cursor1);
2324:
2325:
2326: v_buff := 'Number of System items loaded : '||v_item_count;
2327: LOG_MESSAGE(v_buff);

Line 2452: cursor1 := dbms_sql.open_cursor;

2448: IF pITEM_ID IS NOT NULL THEN
2449: lv_sql_stmt := lv_sql_stmt || ' AND msi.sr_inventory_item_id = :pITEM_ID';
2450: END IF;
2451:
2452: cursor1 := dbms_sql.open_cursor;
2453: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2454:
2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

Line 2453: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);

2449: lv_sql_stmt := lv_sql_stmt || ' AND msi.sr_inventory_item_id = :pITEM_ID';
2450: END IF;
2451:
2452: cursor1 := dbms_sql.open_cursor;
2453: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2454:
2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

Line 2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);

2451:
2452: cursor1 := dbms_sql.open_cursor;
2453: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2454:
2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

Line 2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);

2452: cursor1 := dbms_sql.open_cursor;
2453: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2454:
2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2460:

Line 2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);

2453: dbms_sql.parse(cursor1, lv_sql_stmt, dbms_sql.v7);
2454:
2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2460:
2461: IF pORGANIZATION_ID IS NOT NULL THEN

Line 2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);

2454:
2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2460:
2461: IF pORGANIZATION_ID IS NOT NULL THEN
2462: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

Line 2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);

2455: dbms_sql.bind_variable(cursor1, ':pDESIGNATOR', pDESIGNATOR);
2456: dbms_sql.bind_variable(cursor1, ':PLAN_ID', c_rec.plan_id);
2457: dbms_sql.bind_variable(cursor1, ':pINSTANCE_ID', pINSTANCE_ID);
2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2460:
2461: IF pORGANIZATION_ID IS NOT NULL THEN
2462: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2463: END IF;

Line 2462: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);

2458: dbms_sql.bind_variable(cursor1, ':pHORIZON_START_DATE', lv_start_date);
2459: dbms_sql.bind_variable(cursor1, ':pHORIZON_END_DATE', lv_end_date);
2460:
2461: IF pORGANIZATION_ID IS NOT NULL THEN
2462: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2463: END IF;
2464:
2465: IF pPLANNER IS NOT NULL THEN
2466: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

Line 2466: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);

2462: dbms_sql.bind_variable(cursor1, ':pORGANIZATION_ID', pORGANIZATION_ID);
2463: END IF;
2464:
2465: IF pPLANNER IS NOT NULL THEN
2466: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
2467: END IF;
2468:
2469: IF pCATEGORY_ID IS NOT NULL THEN
2470: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

Line 2470: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);

2466: dbms_sql.bind_variable(cursor1, ':pPLANNER', pPLANNER);
2467: END IF;
2468:
2469: IF pCATEGORY_ID IS NOT NULL THEN
2470: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
2471: END IF;
2472:
2473: IF pITEM_ID IS NOT NULL THEN
2474: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

Line 2474: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);

2470: dbms_sql.bind_variable(cursor1, ':pCATEGORY_ID', pCATEGORY_ID);
2471: END IF;
2472:
2473: IF pITEM_ID IS NOT NULL THEN
2474: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2475: END IF;
2476:
2477: v_total_mgr_count := dbms_sql.execute(cursor1);
2478: dbms_sql.close_cursor(cursor1);

Line 2477: v_total_mgr_count := dbms_sql.execute(cursor1);

2473: IF pITEM_ID IS NOT NULL THEN
2474: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2475: END IF;
2476:
2477: v_total_mgr_count := dbms_sql.execute(cursor1);
2478: dbms_sql.close_cursor(cursor1);
2479:
2480:
2481: v_buff := 'Number of Gross Requirements loaded : '||v_total_mgr_count;

Line 2478: dbms_sql.close_cursor(cursor1);

2474: dbms_sql.bind_variable(cursor1, ':pITEM_ID', pITEM_ID);
2475: END IF;
2476:
2477: v_total_mgr_count := dbms_sql.execute(cursor1);
2478: dbms_sql.close_cursor(cursor1);
2479:
2480:
2481: v_buff := 'Number of Gross Requirements loaded : '||v_total_mgr_count;
2482: LOG_MESSAGE(v_buff);